Intermediate Microsoft Excel 2010
This hands-on course will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons.
This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2010 tool like a pro.
There are no prerequisites to take this course.
Lesson 1 – Excel Basics
Lesson 2 – Creating a Worksheet
Lesson 3 – Time-Savers
Lesson 4 – Relative and Absolute References
Lesson 5 – Three-Dimensional Workbooks
Lesson 6 – Sorting and Subtotaling
Lesson 7 – Charting
Lesson 8 – Advanced Graphing Techniques
Lesson 9 – The Function Wizard
Lesson 10 – Financial Functions
Lesson 11 – Worksheet Automation
Lesson 12 – Decision-Making
Complete the form and learn about:
- Pricing and payment options
- Start dates
- Study Method
- How to get help and contact information
- Everthing you need to know before enrolling!
Want to Know More About This Course?
Get your free course guide now! Complete this easy form and you'll receive a course guide consultation from ed2go.