Microsoft Excel Zero to Advanced: Data Analysis & Dashboards
4.8 /5- Offered byUDEMY
Microsoft Excel Zero to Advanced: Data Analysis & Dashboards at UDEMY Overview
Duration | 6 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel Zero to Advanced: Data Analysis & Dashboards at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Learn from 25 downloadable resources and 2 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Microsoft Excel Zero to Advanced: Data Analysis & Dashboards at UDEMY Course details
- For Beginner level users of Excel who are looking for a solid foundation
- For Students, business owners, entrepreneurs and professionals
- For Students with Zero knowledge of Excel
- Basics like cells, rows, and columns
- Adding/deleting rows and columns
- Cell formats
- Basic Mathematical functions
- Keyboard shortcuts
- Data cleaning
- Data analysis
- Dashboards
- This course enables students to start using Excel in an effective manner
- It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features
- Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data
Microsoft Excel Zero to Advanced: Data Analysis & Dashboards at UDEMY Curriculum
Getting to know Excel
Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows
Understanding cell format
Autofill
Basic Mathamatical functions
Resources files for the lectures
Practice on real data
Entering data in Excel - Best Practices
Cleaning Data
Removing Duplicates
Removing spaces
Spell check
Find
Find & Replace
Replacing blank cells
Using proper fonts
Extracting Substring or part of data
Transforming Data
Merging data in cells
Text to Columns
Data Sorting
Transpose Data
Flash Fill
Compiling Data
Vlookup
Hlookup
Index and match
Consolidate
Append data with Power Query
Getting ready for Data Analysis
Manipulating dates - Date
Month
Year
Manipulate dates - Name of the Day
Name of the Month
Manipulating dates - Day of the week
Week of the year
Day of the Year
Quarter of the Year
Dynamic TODAY
Tomorrow
Yesterday
Calculating Age
Adding conditional columns based on IF
NESTED IF
IF OR
IF OR Multiple Column
IF OR OR OR Practice
IF AND
IF AND AND AND Practice
Basic Data Analysis (Ad hoc Data Analysis)
Freeze Panes
Filters and advance filters
Conditional Formatting
Subtotals
COUNTIF
COUNTIFS
SUMIF
SUMIFS
Microsoft Excel Zero to Advanced: Data Analysis & Dashboards at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?