Excel 2016 Advanced
Leverage the magic of Excel 2016! Super-charge your productivity & recession-proof your job by becoming a master user.
4.13 (70 reviews)
401
students
4 hours
content
Aug 2017
last update
$19.99
regular price
What you will learn
How to use intermediate to advanced Excel functions from various categories (counting/summing/averaging, math, text, date/time, statistical, financial, reference, and logical) to solve practical problems
More advanced tips for working with formulas, including formula auditing and formula evaluation
How to use Excel’s many powerful tools for data analysis, including tables, pivot tables, data tables, Goal Seek, and Solver
How to use Excel’s tools for importing external data from databases, text files, and the Web
How to use a number of intermediate to advanced tools for adding professional touches to your spreadsheets, including data validation, workbook/worksheet protection, scenarios, form controls, and recording macros
An introduction to several tools new to Excel 2016, including Flash Fill for text pattern recognition and several data analysis tools (Quick Analysis, the Excel Data Model, and the PowerPivot and Power View add-ins)
Related Topics
655837
udemy ID
10/30/2015
course created date
3/22/2020
course indexed date
Bot
course submited by