| Files: |
-
Get Bonus Downloads Here.url
180 bytes
-
1 - Exploring the Excel Start Screen and Key Features.mp4
51.2 MB
-
2 - Understanding Worksheets, Cells, Rows, and Columns.mp4
55.1 MB
-
3 - Formatting Tables and Using Conditional Formatting.mp4
42.8 MB
-
4 - Essential Excel Formulas, Functions, and Data Sorting.mp4
46.1 MB
-
5 - Creating Charts and Sharing Workbooks with Collaborators.mp4
25.7 MB
-
1 - Data Types in Excel Text, Num, Dates, Times, Boolean, Errors, Const vs. Formula.mp4
79.3 MB
-
2 - Data Entry - Manual, AutoFill, Flash Fill Use Fill handle, Keyboard shortcuts.mp4
29.1 MB
-
3 - Data Validation for Entry Control Restrict data types, Drop-down, Error alert.mp4
57.3 MB
-
4 - Project Build an Employee Tracker with Data Validation in Excel - Resources_lec4_Project.xlsx
10.4 KB
-
4 - Project Build an Employee Tracker with Data Validation in Excel.mp4
64.6 MB
-
5 - Assignment Practice - Q_A module3.pdf
173.6 KB
-
5 - Assignment Practice - Z_M2Assignment_Solution.xlsx
9.1 KB
-
5 - Assignment Practice.mp4
13.8 MB
-
1 - Basic TextCell Formatting - ResourcesM3.xlsx
14.3 KB
-
1 - Basic TextCell Formatting.mp4
25.1 MB
-
2 - InsertDelete RowsColumns - ResourcesM3.xlsx
14.3 KB
-
2 - InsertDelete RowsColumns.mp4
29.1 MB
-
3 - Merge, Wrap & Align Content in Excel, convert to Table - ResourcesM3.xlsx
14.3 KB
-
3 - Merge, Wrap & Align Content in Excel, convert to Table.mp4
23.5 MB
-
4 - Orient Text in cell, Diagonal orientations and shortcut to adjust column width - M3Lec3_1_Resources.xlsx
10.7 KB
-
4 - Orient Text in cell, Diagonal orientations and shortcut to adjust column width - ResourcesM3.xlsx
14.3 KB
-
4 - Orient Text in cell, Diagonal orientations and shortcut to adjust column width.mp4
7.9 MB
-
5 - Conditional Formatting, HideUnhide Rows Columns, Find, Replace, Freeze Header - ResourcesM3.xlsx
14.3 KB
-
5 - Conditional Formatting, HideUnhide Rows Columns, Find, Replace, Freeze Header.mp4
45.8 MB
-
1 - Intro to Formula Bar, with FormulasFunctions Add, Subtract, Multiply, Divide - resourcesModule4lec1_and_Module4lec2_and_Module4lec3.xlsx
11.4 KB
-
1 - Intro to Formula Bar, with FormulasFunctions Add, Subtract, Multiply, Divide.mp4
38.3 MB
-
2 - Excel Formulas and Functions Sum, Min, Max, Count, Counta - resourcesModule4lec1_and_Module4lec2_and_Module4lec3.xlsx
11.4 KB
-
2 - Excel Formulas and Functions Sum, Min, Max, Count, Counta.mp4
41.4 MB
-
3 - Shortcut to find Sum in table - Resources_M4Lec2_1.xlsx
9.7 KB
-
3 - Shortcut to find Sum in table.mp4
7.2 MB
-
4 - Excel Formulas and Functions Average, Median, Concatenate - resourcesModule4lec1_and_Module4lec2_and_Module4lec3.xlsx
11.4 KB
-
4 - Excel Formulas and Functions Average, Median, Concatenate.mp4
82.1 MB
-
5 - Excel Conditional IF, Countif Statements, and Vlookup.mp4
90.4 MB
-
6 - Three Important Farmulas Proper(), Upper(), Lower().mp4
6.0 MB
-
7 - What is IF and Nested IF in Excel Nested IFs with Examples - M4Lec6_Resources.xlsx
9.2 KB
-
7 - What is IF and Nested IF in Excel Nested IFs with Examples.mp4
50.8 MB
-
8 - Multi-column Vlookup in Excel Vlookup() - M4Lec7_Resources.xlsx
10.9 KB
-
8 - Multi-column Vlookup in Excel Vlookup().mp4
8.7 MB
-
9 - Excel HLookup function with Examples - M4Lec8_resources.xlsx
9.4 KB
-
9 - Excel HLookup function with Examples.mp4
37.8 MB
-
Bonus Resources.txt
70 bytes
|
Discussion