The Complete Excel, ChatGPT, AI Online Course Mega Bundle
Unleash Unprecedented Growth! Skyrocket Your Career and Business Success to New Heights! 🚀
Created by James Dabalus
01
Skill level
All levels
02
Sections
9
03
Lectures
52
04
Instructor
James Dabalus
What's inside
This course includes.
✓
9
Sections
✓
52
Lectures
✓
48
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ LEVEL 1 🚀👨💻 Excel for Beginners 3 lectures
Source Files
Locked
02 Make Your Expense Tracker More Readable
Locked
01 Quick Win - Track Spendings And Savings In Excel
Locked
+ 01. Introduction to the Course 5 lectures
1.1 Introduction to the Course
Locked
1.2 Introduction of the instructor
Locked
1.3 Course requirements
Locked
1.4 How to get Excel
Locked
Source Files
Locked
+ 02. Excel Logic and Lookup Functions Projects 7 lectures
2.1 What will we learn in this section
Locked
2.2 Create An If() Function
Locked
2.3 Nest And() Andor Or() Functions Within Reference Functions
Locked
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions
Locked
2.5 Create A Vlookup() Function
Locked
2.6 Section Summary
Locked
Source Files
Locked
+ 03. Excel Math and Finance Functions Projects 7 lectures
3.1 What will we learn in this section
Locked
3.2 Aggregate Data Using Both The Sum And Subtotal Functions
Locked
3.3 Calculate minimums, maximums and averages from data sets
Locked
3.4 Use the Forecast function to forecast numbers along a trend
Locked
3.5 Generate a net present value using a formula
Locked
3.6 Section Summary
Locked
Source Files
Locked
+ 04. Excel Date and Time Functions Projects 5 lectures
4.1 What will we learn in this section
Locked
4.2 Work with Excel’s date manipulation functions
Locked
4.3 Build a holiday date calculator
Locked
4.4 Section Summary
Locked
Source Files
Locked
+ 05. Excel Text and Information Functions Projects 9 lectures
5.1 What will we learn in this section
Locked
5.2 Split textual data apart
Locked
5.3 Manipulate textual data
Locked
5.4 Replace portions of textual data
Locked
5.5 Put textual data back together with formulae
Locked
5.6 Work with key informational functions for evaluating and responding correctly to errors in routi
Locked
5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet
Locked
5.8 Section Summary
Locked
Source Files
Locked
+ 06. Excel Lists 7 lectures
6.1 What will we learn in this section
Locked
6.2 How to filter items in a list
Locked
6.3 Sorting List without messing up the data
Locked
6.4 How to freeze rows or columns
Locked
6.5 Remove duplicates from a list
Locked
6.6 Section Summary
Locked
Source Files
Locked
+ 07. Other Excel useful functions 8 lectures
7.1 What will we learn in this section
Locked
7.2 COUNT, COUNTA and COUNTIF Functions
Locked
7.3 Create a drop down list
Locked
7.4 Work with ISNUMBER and SEARCH functions within text functions
Locked
7.5 Format row based on a cell value
Locked
7.6 Create an invoice template in Excel
Locked
7.7 Section Summary
Locked
Source Files
Locked
+ 08. Summary 1 lecture
8.1 Course Summary and Next Steps
Locked
Instructors
Taught by people who ship.
James Dabalus
Instructor
James is a versatile IT Technician specializing in Prompt Engineering, Generative AI, Graphic Design, Web Development, Video Editing, and E-learning. With a passion for automation, he continually seeks innovative ways to streamline digital workflows.
Ready to start building?
Unleash Unprecedented Growth! Skyrocket Your Career and Business Success to New Heights! 🚀