Complete Excel Tutorial
Complete Excel Tutorial
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | Lec: 34 | 459 MB
Genre: eLearning | Language: English
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | Lec: 34 | 459 MB
Genre: eLearning | Language: English
Learn to use excel and go from a beginner to pro in no time
Why this course is for you
You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You want to learn how to setup clean spreadsheets and use Excel's functions to work much more efficiently and with less effort.
The functions and formulas you will learn will teach you how to use Excel from beginner to and intermediate level. Along the way I will teach you shortcuts and tips that will impress any employer or teacher.
What you will learn:
The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
Advance functions to analyze your data
Setups that will help automate your work
Graphs and charts
Create multiple scenarios
Vlookup, hlookup, index & match functions
How to build dynamic queries
Financial functions
How to create a macro
How to create debt schedules and pp&e schedules
Forecasting
How to create pivot tables
What you will need:
A computer, laptop, or tablet
Microsoft Excel
Hunger to learn
Complete Excel Tutorial
