Learn Excel in 3 Hours Flat

The essential spreadsheet skills needed to succeed at work, from basics to charts to pivot tables.

Created by: Alicia Katz Pollock
QuickBooks ProAdvisor & Top 50 Women in Accounting

What Will I Learn?

• 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.
• Enter data
• Create formulas and functions
• Use Absolute Cell Formatting to copy formulas anywhere
• Use AutoFill to replicate values and formulas
• Format appearance for quick understanding
• Create Charts of several types
• Use Data Tables to manage lists
• Use Pivot Tables to analyze data
• Take control of your Printing

Requirements

• No prerequisite knowledge needed.
• This course is recorded in Excel 2013 on a PC
• The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way.
• Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar
• It doesn't matter what version of the PC or Mac operating system you're using.
• Practice files are included with the course so that you can follow along.

Target audience

• No previous knowledge or experience is necessary!
• Effective, efficient on-the-job training for employees
• Solid foundation for students in classes that use Excel
• Perfect for beginners who want to start from scratch
• Great for seasoned users looking to fill in gaps in their knowledge
• Full of tips and tricks to shave time off your daily tasks
• We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before