IIRF Online > Office Productivity > Microsoft > Excel Formulas and Functions > Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT
Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT by Udemy
Starting from Zero, Master Excel, Data Analysis in Excel, leveraging advanced tools like Power Pivot, DAX, & ChatGPT
Course Highlights
- Basics like cells, rows, and columns
- Adding/deleting rows and columns
- Cell formats
- Basic Mathematical functions
- Keyboard shortcuts
- Data cleaning
- Data analysis
- Dashboards
- Learn everything you need to start working on Excel!
Skills you will learn!
Curriculum
11 Topics
Getting started with Excel
Understanding and working with Cell
Understanding and working with Column
Understanding and working with Row
Mastering Copy Paste
Mastering Autofill
Intelligent navigation with Excel data
Basic Mathematical functions
Unlocking Keyboard Shortcuts with Master-key
Homework: Entering 10 records in Excel
Best Practices - Entering data in Excel
7 Topics
Remove duplicates
Removing spaces
Spell check
Find | Find & Replace
Replacing blank cells
Using proper fonts
Extracting Substring or part of data
5 Topics
Merging data in cells
Text to Columns
Data Sorting
Transpose Data
Flash Fill
5 Topics
Vlookup
Hlookup
Index and match
Consolidate
Append data with Power Query
14 Topics
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
3 Topics
Note for upcoming lectures
Getting started - writing basic formulas with AI
Writing complex IF formulas with AI
8 Topics
Freeze Panes
Filters and advance filters
Conditional Formatting
Subtotals
COUNTIF
COUNTIFS
SUMIF
SUMIFS
13 Topics
Introduction to Data Analaysis and Data
Summay by a parameter
Adding parameters with drill down and drill up
Breaking down information by Column
Filtering the data in reports
Understanding Value Field Settings
Working with Dates in rows
Grouping example
Compiling data on one sheet
Slicers
Timeline
Adding Calculated Fields
Calculated Fields - Why this approach is better
6 Topics
Introduction and first chart
Exploring the chart options further
Compiling data on one sheet
Adding timeline (time slicer) on dashboard
Adding and adjusting slicers
Adding trendline charts
5 Topics
Understanding Relational Data
Adding Power Pivot to Excel
Adding data to Data Model
Data Modelling
Power Pivot
Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT
Related Excel Formulas and Functions Courses
Thank You!
Your review has been submitted successfully.