In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel’s data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Duration: 3 Months
- Details
- Master charting, PivotTables, Slicers, Sparklines, and other advance features of Microsoft Excel 2016
- Learn to create useful and eye-catching charts
- Discover how to manipulate data with the push of a button
- Add the time-saving functions of advanced Excel users to your repertoire
- Course Outline
Excel Charts and Graphs
More Excel Charts
AutoFilter and Sorting
Goal Seeking
PivotTables
Advanced PivotTables
Solver
Sparklines
Macros
Introduction to Functions
Math/Trig Functions
VLOOKUP, INDEX, and MATCH Functions - 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 7 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