If you work with numbers, you need to master Microsoft Excel 2016! 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 2016 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 2016 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
Intro to 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 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 Office Home and Student 2016 or Microsoft Office 365 (not included in enrollment).
- Note that the “Starter Version” and “Web App” versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- 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