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.
Duration: 3 Months
- Details
- Learn shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently
- Discover how to quickly and automatically calculate statistics, loan payments, future value, and more
- Learn how to best sort and analyze date, create charts and graphs, and automate often repeated tasks
- Course Outline
Excel Basics
Creating a Worksheet
Time-Savers
Relative and Absolute References
Three-Dimensional Workbooks
Sorting and Subtotaling
Charting
Advanced Graphing Techniques
The Function Wizard
Financial Functions
Worksheet Automation
Decision-Making - Requirements
Prerequisites:
There are no prerequisites to take this course.
Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Mac users.
Software Requirements:
- Windows XP or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Excel 2010 or Microsoft Office 2010 (the Home and Student Edition, Home and Business Edition, or Professional Edition of Microsoft Office 2010 are all acceptable). Note that the “Starter Version” and “Web App” versions of Microsoft Excel 2010 will not work with the full version of Excel taught in this course (not included in enrollment).
- Adobe Flash Player. Click here to download the Flash Player.
- Adobe Acrobat Reader. Click here to download the Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Course Fee: USD 120Now available at Afghanistan, Bangladesh, Bhutan, India, Maldives, Nepal, Pakstan and Sri Lanka