Practical Excel 2013 – Intermediate & Advanced
Take your skills to the next level. Save time and headache and recession-proof your job by becoming a master user.
4.20 (22 reviews)
133
students
5.5 hours
content
Feb 2016
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 2013, 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
531518
udemy ID
6/18/2015
course created date
3/22/2020
course indexed date
Bot
course submited by