Upper Menu

Intermediate Excel 2010 for PC


Learn Intermediate to Advanced Microsoft Excel with this video course.

Once you’re familiar with Excel, learning the more advanced tools will help you analyze your numbers for solid business decisions. We’ll create pivot tables. We’ll demystify dozens of handy formulas: vlookup, date, text and logic formulas. We’ll sort and filter data tables, name ranges for easy understanding, and protect worksheets to keep them perfect. We’ll also explore more tools that you can use as soon as you get back to work.

By the end of this course, you will be able to create a spreadsheet from scratch, format it for at-a-glance understanding, and use advanced tools for data analysis. Kiss your calculator goodbye!

Take this 3-hr class as a guided learning experience to take control of Microsoft Excel 2010 and get real work done for your company. Refer back to it a few months later when you need a reminder.

Use it as a handy on-demand reference to answer real-life questions as they come up during day-to-day work.

Click here to access the class recording.


Class Description

Now that we’ve covered the basics in our 3-hour Learn Excel in 3 Hours Flat class, let’s go the extra mile. In this Intermediate/Advanced course we’ll explore Data Tables, Pivot Tables, and an array of practical functions including date & time, logical functions, HLookup, and Alicia’s favorite worldview-shattering Text Functions.

This class was taught using Excel 2010 for PC, but it doesn’t matter what version of the PC or Mac operating system you’re using: the tools all function the same way.

Instructional Level

Intermediate through Advanced

Course Length

3 hours

Who should take this class?

  • Business owners and employees looking to manipulate and analyze Excel spreadsheet data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Advanced students looking to fill in gaps in their knowledge. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

What You’ll Learn

  • AutoFill Handle
  • Relative and Absolute Cell References
  • Named ranges
  • Data Tables for working with Lists
  • Pivot Tables
  • IF function
  • AND/OR/NOT functions
  • Nested functions
  • DATE functions
  • TEXT formulas including CONCATENATE and splitting text into columns
  • Tracing formulas
  • Protecting worksheets
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

Click here to access the class recording.


There are no reviews yet.

Be the first to review “Intermediate Excel 2010 for PC”

You may also like…