Excel from Beginner to Pro
What you'll learn
- At the end of this course, students will learn how to work with:
- Basic Functions of Excel
- Pivot Tables & Dashboards
- Charts and Graphs
- Excel Formulas
- Frequently Used keyboard Shortcuts for Excel
- Business Accounting with Excel
- The LookUp Function
- SUMIF
- Forecasting in Excel
- Regression Analysis
- Optimization Analysis
- What-If Analysis
- Financial Analysis
Requirements
- Download any version of Excel between 2010 and 2016 on your computer
Description
Data is an integral part of every business today, whether small, medium or large. That is why the demand for skilled professionals in this field is increasing exponentially. Having Microsoft Excel knowledge today is like having the master key to the engine room of a business.
"Excel from Beginner to Pro" takes you from the scratch to a professional level even if you've never used Excel before.
At the end of this course, you'll be able to use the Excel software to analyze your dataset like a professional and be ready to challenge the status quo.
If you take this course, you'll able to
Use Excel Formulas to work on your dataset
To analyze data using the Pivot Tables
Apply the Excel functions on your day to day task
Run and Interpret Regression Analysis
Forecast and grow your business
Build charts and graphs with your dataset
Build Dashboard and be ready to present your report to the Management
Build a Financial Model and run assumptions
Who this course is for:
- Beginners who want to learn Excel to work smarter
- Young professionals and Business owners
Course content
- Preview01:17
- 01:00Introduction to Excel
Instructor
Mariam Adeyemi is a certified Business Analyst and Author. She is an IBM certified Data Scientist with over 12 years local and International corporate experience in Sales, Marketing, Finance, Research and Information Technology. She earned her Masters Degree in Business Analytics from Texas A&M University-Commerce and got her Bachelors Degree in Communications. She’s written three books currently listed on Amazon.