IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > Microsoft Excel - From Beginner to Expert in 6 Hours
Microsoft Excel - From Beginner to Expert in 6 Hours by Udemy
Excel Made Easy - From Beginner to Expert - Microsoft Certified Master Instructor - MOS Expert - Master Microsoft Excel
Course Highlights
- Learn Microsoft Excel Fast: Excel formulas and functions, Excel shortcuts and tips, Excel charts and graphs, Excel for beginners & intermediate users
- Taught by a best-selling Udemy author, Microsoft Certified Educator, Microsoft Office Specialist Expert, & Tenured College Professor
- Conditional formatting in Excel, Excel date functions and formatting, Excel templates, Excel for Data Management
- Data analysis in Excel, Pivot tables in Excel, Excel for data visualization, Excel data validation, Excel macros
- Excel for business analysis, Excel for finance and accounting, Excel for sales and marketing
- Excel for budgeting and forecasting, Excel for project management, Excel for inventory management
- Excel functions: sum, vlookup, xlookup, if, count, average, concatenate, max, min, round, and more
- Excel documentation: learn how to read Excel's documentation so that you are empowered to find answers
- Hands-on exercises with solutions, Over 400,000 students taught, Lifetime course access
- 100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven
Skills you will learn!
Curriculum
4 Topics
Welcome
Course files
Getting your certificate
Quiz #1
9 Topics
Introduction
Microsoft Excel
Relative references
Absolute references
Calculating a grade
Creating charts
Functions
FCDB
Quiz #2
1 Topic
Hands-on exercises
7 Topics
Introduction
A tour of Excel
Mouse pointer awareness
The power of right clicking
Autosave & autorecover
MS Excel files
Quiz #3
1 Topic
Hands-on exercises
5 Topics
Max min & documentation
Rand & randbetween
Concat & textjoin
Documentation
Quiz #4
1 Topic
Hands-on exercises
10 Topics
Introduction
Top 10 functions
Xlookup vlookup & hlookup
PMT payment function
PMT IPMT loan amortization
FV future value function
FV retirement amortization
IF IFERROR dynamic amortization
Conditional formatting
Quiz #5
1 Topic
Hands-on exercises
6 Topics
Fundamentals of formatting
Formatting tables of data quickly
Font is feeling - font formatting
Exploring the home ribbon
Zebra stripe rows
Quiz #6
1 Topic
Hands-on exercises
7 Topics
Content & form
Creating charts
Formatting charts
Chart trendlines
Combo charts
Sparklines
Quiz #7
1 Topic
Hands-on exercises
4 Topics
Gapminder data
Scraping web data
Outdoor gear coop
Name generator
5 Topics
Sorting data
Freeze panes
Removing duplicates
Filtering data
Quiz #8
1 Topic
Hands-on exercises
5 Topics
Introduction
Creating pivot tables
Slicers - filtering pivot tables
Pivot charts
Quiz #9
1 Topic
Hands-on exercises
3 Topics
Printing your worksheet
Protecting (locking) workbooks sheets and cells
Object linking & embedding (OLE)
2 Topics
Introduction to macros
Quiz #10
1 Topic
Hands-on exercises
2 Topics
Great work!
Bonus lecture
Microsoft Excel - From Beginner to Expert in 6 Hours
Related Excel Courses
Thank You!
Your review has been submitted successfully.