Excel Intermediate Training

Class Price: $250

What’s included – a $1,180 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Workshop – get 1on1 help from an instructor on your own work projects to help you apply what you learned, up to 6 months after the class
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Quick Tip sheet – color reference card with the top tips from class
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

excel_tip

Are you ready to go beyond the basics in Excel? Our intermediate Excel training in Denver & Phoenix course covers more complex Excel functions, charting, and data tools. Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level.

Training Class Goal

In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.

PreRequisites

Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.

Topics Covered

Formulas & Functions

Moving and Copying Data in Excel

  • Cut, copy, and paste data
  • The Fill Handle
  • Absolute and relative references
  • AutoFill and custom Lists

Working with More Functions

  • Date and Time Functions
  • Calculating dates in years
  • IF Statements in Date Functions
  • The Proper Function
  • The Roundup Function

Working with Multiple Worksheets

  • Renaming worksheets
  • Color coding tabs
  • Moving and copying worksheets
  • 3D reference formulas
  • Hyperlinks
  • ScreenTips

Formatting Cells and Appearance

Viewing Worksheets

Introduction to Basic Charts

  • Creating and defining a chart
  • Positioning, rotating, and resizing charts
  • WordArt in charts
  • Editing charts in Excel
  • Changing types
  • Formatting a data series
  • Multiple series charts
  • Sparkline charts
  • Other classes covering Excel Charts

Intermediate Excel training covers things beyond the basics, to give you more developed skills in building your spreadsheets, creating formulas to automate them, and adding visual impact with formatting and charts. Mission Critical Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application. Our courses are designed specifically for companies and their employees.

Request More Information

  • Class Retakes

    If you need to retake a class you've already attended, you're welcome to take it for free up to 6 months later......Read more

  • Hands-on Learning

    We take pride in making our classes engaging and interactive because we feel hands-on learning......Read more

  • Customized Training

    When we train privately, materials may be developed to fit better the company, organization, or students......Read more

  • Individual Attention

    Because we limit our computer training classes to only 12 students and average around half......Read more

  • Live Training

    Get the most from your training investment by working with a live training instructor......Read more

  • Small Class Sizes

    Our computer training center holds only 12 students, and that’s how we like it......Read more