Basic Excel Training
-
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
-
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)
