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. You will also learn Excel 2013 features, including Quick Analysis, Flash Fill, and new charting capabilities.
This is not a tutorial, but an in-depth class. By the time you’re done, you will be using this vital Office 2013 application 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, Absolute, Mixed, and Circular References
Three Dimensional Workbooks
Sorting, Subtotaling, and Filtering
Charting Basics
Advanced Charting Techniques
Excel’s Statistical Functions
Financial Functions
Worksheet Automation
Mastering Excel’s IF Function - Requirements
Prerequisites:
There are no prerequisites to take this course.
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
- This course is not suitable for Mac users who are using the Office Mac Home versions.
Software Requirements:
- PC: Windows 7 or later.
- Mac: OS X Snow Leopard 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- Microsoft Excel 2013 or Microsoft Office 2013. Note that the “Starter Version” and “Web App” versions of Microsoft Excel 2013 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