Zero to hero in Microsoft Excel: Complete Excel guide
4.2 /5- Offered byUDEMY
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Overview
Duration | 6 hours |
Total fee | ₹1,920 |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Credential | Certificate |
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Highlights
- The Program comes with 30-Day Money-Back Guarantee
- The Authors of this Microsoft Excel course have several years of corporate experience in learning and teaching technologies like ML & AI
- The concise program covers Business related examples, data analysis and case studies solved using Advanced Excel
- Downloadable resources comprising important MS Excel techniques and functionalities and ample practice exercises on data analysis, MS excel (basic & advanced) have been made available
- Queries will be responded by the Instructor themselves
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Course details
- Anyone curious to master excel from beginner to Advanced in short span of time.
- Introduction
- Excel Basics
- Essential Formulas
- Data Tools
- Formatting data and tables
- Pivot Tables
- Excel Charts
- Pivot Charts
- Named Ranges
- Excel Shortcuts
- Macros
- Advance Excel
- The course has carefully designed curriculum teaching only the most used functionalities of Microsoft Excel in business environment
- This course will help participant learn advanced Excel and various data analysis tools associated with Microsoft excel
- The course is offered through 14 articles and 22 downloadable resources, comes with an Lifetime access to the content through mobile and TV
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Curriculum
Module 1
Basics
Course Resource
This is a milestone
Worksheet Basics
Entering Values and Formulas
Data Formats
Data Handling Basics - Cut, Copy and Paste
Saving and Printing - Basics
Module 2
Basic Formula Operations
Mathematical Functions
Difference between RANK, RANK.AVG and RANK.EQ
Exercise 1: Mathematical Functions
Textual Functions
Exercise 2: Textual Functions
Logical Functions
Exercise 3: Logical Functions
Date-Time Functions
Exercise 4: Date-Time Functions
Lookup Functions ( V Lookup, Hlookup, Index-Match )
Exercise 5: Lookup Functions
Module 3
Mathematical Functions
Quiz
Difference between RANK, RANK.AVG and RANK.EQ
Exercise 1: Mathematical Functions
Textual Functions
Exercise 2: Textual Functions
Quiz
Logical Functions
Exercise 3: Logical Functions
Date-Time Functions
Exercise 4: Date-Time Functions
Lookup Functions ( V Lookup, Hlookup, Index-Match )
Exercise 5: Lookup Functions
Module 4
Data Tools
Exercise 6: Data Tools
Module 5
Formatting data and tables
Exercise 7: Formatting
Module 6
Pivot Tables
Exercise 8: Pivot tables
Module 7
Excel Charts - Categories of messages that can be conveyed
Elements of charts
The Easy way of creating charts
Bar and column charts
Formating charts
Line Charts
Area Charts
Pie and Doughnut Charts
Why we should avoid Pie charts
Scatter plot or XY chart
Frequency Distribution and Histograms
Waterfall Charts
Sparklines
Exercise 9: Charts
Module 8
Pivot Charts
Module 9
Named Ranges
Indirect Function
Module 10
Shortcuts
Exercise 10: Shortcuts
Module 11
Macros
Exercise 11: Macros
Quiz
Module 12
Advanced Excel: Analytics in Excel
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Faculty details
Zero to hero in Microsoft Excel: Complete Excel guide at UDEMY Entry Requirements
- Eligibility: No Eligibility required
- Experience: No Experience required
- Prerequisite: A PC with any version of Excel
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?