Complete Excel Course - Bner to ExpertDuration: 20h23m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 11.1 GB
Genre: eLearning | Language: English
Become an Excel expert in just 20 hours and 130 videos
What you'll learn:
Analyse large data sets in a few clicks using Pivot Tables & Pivot Charts
Visualise data using Graphs & Dashboards
Create dynamic Graphs which automatically capture new data
Format data to highlight key points
Solve problems using Formulas and Functions
Monitor unkwown factors using 'What If Analysis'
Sort, Filter, manipulate & summarise data to draw quick conclusions
Increase productivity using Array Formulas
Customise reports in a professional and presentable way
Add security & protection to improve data integrity
Learn tips and tricks in the case of system crashes
Save with keyboard shortcuts
Apply built-in templates and add-ins for thousands of applications
Master basics of Excel spreadsheets-navigating, saving, printing, math
Connect to data from external sources including text, websites, databases, stocks and geographical sources
Requirements:
Require a computer with excel installed (2013 version or later reccomended)
Description:
I have learned Excel from many different sources including books, websites, Youtube, online courses & analyst employment.