All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityExcel
Microsoft Excel Zero to Advance w/ Data Analysis Masterclass
Starting from zero, master Excel step by step. Learn functions, formulas, tips, tricks, and best practices.
Created by Irfan Sharif ACA ACCA | #1 Best Selling Instructor of Accounting & Bookkeeping
12 hours
Video Content
142
Lectures
145,293
Students
4.6
Rating
4.6
(145,293 students enrolled)What you'll learn
✓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!
Course Content
18 sections • 142 lectures • 11:51:55 total length
Level 1: Getting to know Excel
11 lectures • 01:40:43
Level 1: Getting to know Excel
11 lectures • 01:40:43
Getting started with Excel12:51
Understanding and working with Cell19:49
Understanding and working with Column05:57
Understanding and working with Row05:31
Mastering Copy Paste16:14
+6 more lectures
Level 2: Cleaning data
7 lectures • 45:10
Level 2: Cleaning data
7 lectures • 45:10
Remove duplicates03:55
Removing spaces06:27
Spell check03:23
Find | Find & Replace05:54
Replacing blank cells01:53
+2 more lectures
Level 3: Transforming Data
5 lectures • 21:21
Level 3: Transforming Data
5 lectures • 21:21
Merging data in cells04:27
Text to Columns06:01
Data Sorting05:00
Transpose Data03:14
Flash Fill02:39
Level 4: Compiling data
5 lectures • 43:51
Level 4: Compiling data
5 lectures • 43:51
Vlookup13:55
Hlookup05:30
Index and match13:46
Consolidate04:48
Append data with Power Query05:52
Level 5: Getting ready for Data Analysis
14 lectures • 52:50
Level 5: Getting ready for Data Analysis
14 lectures • 52:50
Manipulating dates - Date | Month | Year04:13
Manipulate dates - Name of the Day | Name of the Month03:30
Manipulating dates - Day of the week | Week of the year04:27
Day of the Year08:15
Quarter of the Year05:48
+9 more lectures
Writing formulas to Clean, transform, Compile, & Analyze Data with AI & ChatGPT
3 lectures • 20:10
Writing formulas to Clean, transform, Compile, & Analyze Data with AI & ChatGPT
3 lectures • 20:10
Note for upcoming lectures00:08
Getting started - writing basic formulas with AI14:51
Writing complex IF formulas with AI05:11
Level 6: Basic Data Analysis (Ad hoc Data Analysis)
8 lectures • 33:36
Level 6: Basic Data Analysis (Ad hoc Data Analysis)
8 lectures • 33:36
Freeze Panes03:24
Filters and advance filters06:41
Conditional Formatting07:49
Subtotals02:26
COUNTIF03:42
+3 more lectures
Level 7: Data Analysis
13 lectures • 01:06:52
Level 7: Data Analysis
13 lectures • 01:06:52
Introduction to Data Analaysis and Data04:57
Summay by a parameter06:02
Adding parameters with drill down and drill up03:03
Breaking down information by Column02:54
Filtering the data in reports02:05
+8 more lectures
Level 8: Preparing Dashboard
6 lectures • 33:04
Level 8: Preparing Dashboard
6 lectures • 33:04
Introduction and first chart04:39
Exploring the chart options further07:09
Compiling data on one sheet06:38
Adding timeline (time slicer) on dashboard03:05
Adding and adjusting slicers04:00
+1 more lectures
Advanced Data Analysis - Introduction and set up
11 lectures • 57:35
Advanced Data Analysis - Introduction and set up
11 lectures • 57:35
Beyond Pivot Tables07:36
A Quick Glimpse into Power Pivot04:50
Installing Power Pivot in Excel02:53
Download section data file00:04
Understanding Relational Data11:57
+6 more lectures
Unlocking Advanced Calculations and Analytics
12 lectures • 56:39
Unlocking Advanced Calculations and Analytics
12 lectures • 56:39
Introduction to DAX03:36
Day | Month | Year07:42
Month Name | WeekDay Name| WeekDay06:14
IF | IF OR | IF AND | IF OR AND12:43
Homework: IF00:07
+7 more lectures
Putting ChatGPT to write DAX
6 lectures • 21:36
Putting ChatGPT to write DAX
6 lectures • 21:36
Firing up the ChatGPT06:49
Intro Prompt01:11
Writing Basic DAX functions with ChatGPT03:07
Just received a ChatGPT update!00:57
Making ChatGPT write Conditional Columns09:14
+1 more lectures
DAX Part 2
5 lectures • 23:56
DAX Part 2
5 lectures • 23:56
Simple Mathematical Calculation Column05:14
Simple Mathematical Column 2 - Calculating Sales01:42
RELATED - the vlookup & xlookup of DAX03:55
RELATED within Calculations08:33
Deleting the unwanted columns04:32
DAX Measures - The Real Deal!
9 lectures • 40:44
DAX Measures - The Real Deal!
9 lectures • 40:44
Our first DAX Measure - SUM07:33
Other Basic functions00:14
SUMX07:29
SUMX with RELATED07:24
Download the new and old section files here00:02
+4 more lectures
Time Intelligence with DAX
11 lectures • 40:00
Time Intelligence with DAX
11 lectures • 40:00
Understanding standard time intelligence and its problems08:16
MIN and MAX02:06
ALL - Bypassing Filters - MIN Date Across Data03:43
Homework: MAX Date Across00:08
YTD - Year to Date Values05:20
+6 more lectures
Time Intelligence with DAX - Part 2 - Comparison over periods
7 lectures • 21:00
Time Intelligence with DAX - Part 2 - Comparison over periods
7 lectures • 21:00
Calculating Previous Month Value05:02
Calculating Previous Period Value dynamically05:55
Presenting growth in percentage03:06
Calculating Previous Corresponding Period value03:28
Homework: PCP Growth00:03
+2 more lectures
Clean & Transform with Power Query
8 lectures • 32:19
Clean & Transform with Power Query
8 lectures • 32:19
Introduction01:52
Navigating to Power Query03:26
Combining Sales from three tables to one03:08
Adding a Unique row identifier for each row - Index Column03:26
Adding new columns06:15
+3 more lectures
Bonus Section
1 lectures • 00:24
Bonus Section
1 lectures • 00:24
Bonus lecture00:24
Description
Are you ready to transform from an Excel novice to a proficient Excel user or data analyst? This course is your gateway to mastering Microsoft Excel—from foundational skills to advanced data manipulation and analysis techniques. Whether you're a beginner eager to grasp the basics or a seasoned professional aiming to refine your data management prowess, this course is designed to empower you every step of the way.
What You Will Learn:
Excel Mastery: Start from scratch and build a solid foundation in Excel. Learn essential functions, formulas, and shortcuts that streamline your workflow and enhance productivity.
Advanced Data Analysis Techniques: Dive deep into Power Pivot and DAX (Data Analysis Expressions). Discover how to efficiently manage large datasets, create dynamic reports, and extract valuable insights that drive business decisions.
Automate with ChatGPT: Experience the future of data analysis with ChatGPT. Learn how to harness AI to automate complex formulas and tasks, revolutionizing your approach to data manipulation.
Real-World Applications: Apply your skills to real-world scenarios, from financial analysis to marketing insights and operational efficiency. Gain hands-on experience that prepares you for practical challenges in any industry.
Why Choose This Course:
Comprehensive Curriculum: Covering everything from basic Excel functions to advanced data modeling, ensuring you're equipped with the skills needed to excel in today's data-driven world.
Expert Guidance: Taught by a seasoned Chartered Accountant with over a decade of professional experience and a passion for empowering learners through practical, engaging instruction.
Flexible Learning: Study at your own pace with lifetime access to course materials. Whether you're a student, professional, or entrepreneur, fit learning into your schedule and advance your career prospects.
Money-Back Guarantee: Join with confidence—Udemy offers a 30-day money-back guarantee. If the course doesn't meet your expectations, receive a full refund—no questions asked.
Who Should Enroll:
Aspiring Data Analysts: Begin your journey into the world of data analysis with a solid foundation in Excel and advanced techniques.
Business Professionals: Enhance your analytical skills and gain a competitive edge in your career by mastering Excel, Power Pivot, and DAX.
Entrepreneurs and Small Business Owners: Optimize your business operations, analyze financial data, and make informed decisions to drive growth and profitability.
Anyone looking for a any job or starting a business... Yes, you need Excel!
Don’t Miss Out!
Join thousands of learners worldwide who have transformed their Excel skills and unlocked new career opportunities. Enroll now and embark on your journey to mastering Excel for data analysis!
Who this course is for:
- Beginner level users of Excel who are looking for a solid foundation
- Students, business owners, entrepreneurs and professionals
- Students with Zero knowledge of Excel
This course includes:
- 12 hours on-demand video
- 16 articles
- 31 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructor
Irfan Sharif ACA ACCA | #1 Best Selling Instructor of Accounting & Bookkeeping
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython