Course Overview
2 Courses and 17+ hours of tutorials on the Excel Comprehensive Training Course
Core Coverage
You will learn Excel Functions, Formula, Charts, and Graphs, formatting, pivot tables, power pivot, power excel, excel dashboard creation, simulations, statistical tools, financial functions in excel
Eligibility
Anyone who is serious about mastering Microsoft Excel
Anytime, Anywhere Access: Learn at your own pace, wherever you are
Verifiable Certificates: Earn certificates for course completion
Excel Comprehensive Course Curriculum
Basic Excel Training
Available in
days
days
after you enroll
- accessing MS Excel new (2:41)
- MS Excel Startup Screen (2:27)
- Understanding the Ribbon (3:03)
- Cells in Excel (1:18)
- Worksheet Essentials (3:10)
- Saving the File (1:14)
- Custom Cell Styles (6:12)
- Custom Number Formatting in Excel (11:39)
- More on Custom Number Formatting (10:59)
- Custom Formats of Data (13:33)
- The BEDMAS Order of Mathematical Operations (9:04)
- Mathematical Operations without Functions (9:43)
- Mathematical Operations without Functions Continued (11:38)
- IF Function (10:32)
- More on IF Function (8:25)
- Importing Data and Calculations (10:46)
- Working with the Count Function (4:57)
- Conditional Counts - CountIF Function (4:58)
- Working with the Sum Function (14:02)
- Finding the Average (11:17)
- Conditional Average - Average IFS Function (8:31)
- Finding the Maximum Value Using the MAX Function (8:36)
- Finding the Minimum Value Using the MINFS Function (8:04)
- Determining Proportions and Updating a Calculation (10:06)
- Conditional Formatting new1 (18:24)
- More on Conditional Formatting (7:47)
- Working with Tables (13:03)
- Formatting Table (13:31)
- Filtering and Sorting of Data (9:40)
- Freeze and Split (11:18)
- Printing and Layouts in Excel (9:51)
- Pivot Tables (7:50)
- Creating Custom Tables (8:58)
- Organizing Pivot Tables (8:35)
- Column Chart (10:32)
- Bar Chart (8:03)
- Line Chart (14:24)
- Pie Chart (10:27)
- Map Chart (6:46)
- Common Errors in Excel (11:12)
- More on Common Errors (13:42)
- Accessing MS Excel (2:41)
- Formatting Cells (14:23)
Advanced Excel Training
Available in
days
days
after you enroll
- Logical Function - IF new (8:21)
- AND OR and XOR Functions (8:48)
- IFS Function - Example 1 (6:25)
- IFS Function - Example 2 (9:02)
- SWITCH Function (10:17)
- Other Logical Functions (8:20)
- Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
- Date Functions - TODAY DAY (9:36)
- MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
- EDATE and EOMONTH Functions (8:38)
- YEARFRAC Function (7:19)
- Joining Data using CONCAT and TEXTJOIN (9:59)
- LEN FIND LEFT RIGHT TRIM (10:26)
- Using UNIQUE and TRANSPOSE (11:27)
- TEXT Function (10:00)
- CHOOSE Function (10:46)
- More on CHOOSE Function (6:34)
- VLookUp Function (12:47)
- HLOOKUP Function (5:12)
- Index Function (10:31)
- Match Function (9:24)
- XLOOKUP and XMATCH Functions (8:43)
- Using the OFFSET Function (8:49)
- OFFSET Function - Total and Average Score (9:29)
- OFFSET Function - Highest and Lowest Score (8:57)
- OFFSET Function - Year to Month Sales (11:01)
- OFFSET Function - Quarterly and Half-Month Sales (6:39)
- Naming of Cell (12:30)
- Naming a Range (10:01)
- Text to Columns (6:35)
- Grouping Tabs and Subtotal Function (12:47)
- Working with Hyperlinks (11:17)
- Data Validation (11:00)
- Data Validation Continued (11:14)
- Custom Data Validation (12:17)
- Generating Random Numbers (6:10)
- Custom Views (10:34)
- Protecting Worksheet and Workbook (17:36)
- PivotTable - Advanced Features (10:02)
- More on Advanced Features (6:50)
- Slicers and Timelines (6:43)
- Solver (11:37)
- Data Tables (10:42)
- More on Data Tables (9:53)
- Goal Seek (8:43)
- Combo Charts (13:51)
- More on Combo Charts (12:11)
- Sparklines (8:10)
- Waterfall Chart (9:37)
- Box Chart (12:48)
- Whisker Chart (11:29)
- TreeMap and Sun Burst Charts (11:53)
- Radar Chart (7:55)
- Scroll Bar (10:00)
- Spin Button and Radio Button (10:52)
- Form Control Application (10:01)
- Form Control Application Continued (5:32)
- Data Entry Form (3:44)
Check your inbox to confirm your subscription