1 Introduction.mp4 (30.58 MB)
MP4
2 Exercise files and other information.mp4 (32.77 MB)
MP4
2 1 Excel basic level exercise files.zip (1.47 MB)
ZIP
2 2 Excel formula exercise files.zip (938.27 KB)
ZIP
3 Microsoft Office, Office 365 and Microsoft 365.mp4 (16.12 MB)
MP4
4 About Microsoft 365.mp4 (24.86 MB)
MP4
1 Conditional formatting basics.mp4 (96.11 MB)
MP4
2 Conditional custom formatting.mp4 (51.41 MB)
MP4
3 Advanced conditional rules.mp4 (90.44 MB)
MP4
4 Rule stacking.mp4 (44.36 MB)
MP4
5 Conditional formatting with graphics.mp4 (97.46 MB)
MP4
6 Active cell in Excel.mp4 (35.89 MB)
MP4
7 Conditional formatting with formulas.mp4 (101.91 MB)
MP4
1 Basic printing techniques.mp4 (77.23 MB)
MP4
10 Print to PDF and XPS.mp4 (97.64 MB)
MP4
11 Exporting with Insert Object.mp4 (51.45 MB)
MP4
12 Exporting with Copy and Paste.mp4 (52.34 MB)
MP4
2 Selective printing.mp4 (88.63 MB)
MP4
3 Adding a Header or Footer.mp4 (82.82 MB)
MP4
4 Header or Footer content and size.mp4 (86.05 MB)
MP4
5 Managing Headers and Footers.mp4 (24.53 MB)
MP4
6 Scale to fit.mp4 (42.19 MB)
MP4
7 Sheet options.mp4 (86.95 MB)
MP4
8 Locking data in Excel.mp4 (44.87 MB)
MP4
9 Protecting Excel files.mp4 (53.21 MB)
MP4
1 Online references.mp4 (39.47 MB)
MP4
10 Using helper columns or cells.mp4 (100.67 MB)
MP4
11 Avoiding volatile functions.mp4 (72.04 MB)
MP4
2 Understanding the syntax.mp4 (34.31 MB)
MP4
3 Tips on navigation and selection.mp4 (56.9 MB)
MP4
4 Flash Fill.mp4 (58.61 MB)
MP4
5 Extend formats and formulas.mp4 (39.27 MB)
MP4
6 Adding symbols using special fonts.mp4 (89.32 MB)
MP4
7 Emoji and symbol shortcut.mp4 (47.37 MB)
MP4
8 UNICHAR function.mp4 (67.45 MB)
MP4
9 Splitting formula into multiple lines.mp4 (64.12 MB)
MP4
1 Working with Tables.mp4 (61.87 MB)
MP4
2 Table cell reference.mp4 (59.28 MB)
MP4
3 Adding data and AutoFill.mp4 (72.24 MB)
MP4
4 Total reference and conversion to Range.mp4 (47.83 MB)
MP4
5 Resize Table and Slicer (preview).mp4 (58.32 MB)
MP4
6 Introduction to Dynamic Array.mp4 (38.54 MB)
MP4
7 Table and Dynamic Array.mp4 (38.56 MB)
MP4
1 Nested IF versus IFS.mp4 (68.33 MB)
MP4
2 Comparison operators.mp4 (44.05 MB)
MP4
3 AND, OR, and NOT.mp4 (55.65 MB)
MP4
4 AND and OR logic in Criteria.mp4 (57.55 MB)
MP4
5 SUMIF, AVERAGEIF, and COUNTIF.mp4 (49.19 MB)
MP4
6 SUMIFS, AVERAGEIFS, and COUNTIFS.mp4 (74.31 MB)
MP4
7 MAXIFS and MINIFS.mp4 (45.66 MB)
MP4
1 VLOOKUP.mp4 (66.42 MB)
MP4
2 XLOOKUP.mp4 (63.89 MB)
MP4
3 Match Mode.mp4 (60.28 MB)
MP4
4 Search Mode.mp4 (51.04 MB)
MP4
5 2-way lookup.mp4 (66.3 MB)
MP4
6 INDEX, MATCH, and XMATCH.mp4 (78.53 MB)
MP4
7 Wildcards.mp4 (68.64 MB)
MP4
1 Rounding functions.mp4 (42.33 MB)
MP4
2 Rounding to specific multiples.mp4 (42.94 MB)
MP4
3 Using QUOTIENT and MOD.mp4 (64.5 MB)
MP4
1 The true value of date and time.mp4 (64.04 MB)
MP4
2 Date and time extraction.mp4 (49.53 MB)
MP4
3 Time conversion and rounding.mp4 (60.22 MB)
MP4
4 Calculating elapsed days and years.mp4 (52.5 MB)
MP4
5 Calculating deadlines.mp4 (24.25 MB)
MP4
1 Input numbers as text.mp4 (33.21 MB)
MP4
2 Basic text extraction.mp4 (34.72 MB)
MP4
3 Text extraction with delimiter.mp4 (59.57 MB)
MP4
4 UPPER, LOWER, and PROPER.mp4 (12.77 MB)
MP4
5 Combining text.mp4 (57.64 MB)
MP4
6 Splitting text.mp4 (44.75 MB)
MP4
1 Working with Excel files.mp4 (48.74 MB)
MP4
2 Excel UI basics.mp4 (52.42 MB)
MP4
3 Excel UI advanced.mp4 (49.74 MB)
MP4
4 The basics of inputting data.mp4 (32.38 MB)
MP4
5 Data types in Excel.mp4 (50.22 MB)
MP4
6 Data structure.mp4 (37.17 MB)
MP4
7 Navigation.mp4 (88.67 MB)
MP4
1 Searching for values based on rank.mp4 (31.34 MB)
MP4
2 Finding the middle and frequent values.mp4 (31.05 MB)
MP4
3 Calculating variations and combinations.mp4 (35.77 MB)
MP4
4 Forecasting value based on trend.mp4 (36.24 MB)
MP4
1 Editing data and AutoFill.mp4 (40.9 MB)
MP4
2 Creating custom AutoFill.mp4 (45.71 MB)
MP4
3 Undo, Redo, Save, and Save-as.mp4 (48.33 MB)
MP4
4 The basics of Formula.mp4 (48.25 MB)
MP4
5 Introduction to Function, SUM and AVERAGE.mp4 (97.7 MB)
MP4
6 XLOOKUP function.mp4 (54.55 MB)
MP4
7 Cut, Copy, and Paste.mp4 (76.59 MB)
MP4
1 Cell reference range.mp4 (55.24 MB)
MP4
2 Relative vs Absolute References.mp4 (59.39 MB)
MP4
3 Mixed reference and the ROUND function.mp4 (52.81 MB)
MP4
4 External Worksheet reference.mp4 (45.44 MB)
MP4
5 External Workbook Reference.mp4 (63.99 MB)
MP4
6 Named reference.mp4 (73.69 MB)
MP4
1 Formatting basics in Excel.mp4 (57.29 MB)
MP4
10 Border styles and colors.mp4 (45.04 MB)
MP4
11 Column and row sizes.mp4 (73.65 MB)
MP4
12 Text position and orientation.mp4 (29.09 MB)
MP4
13 Cell Styles.mp4 (74.61 MB)
MP4
2 Number formatting and Format Painter.mp4 (73.08 MB)
MP4
3 Custom formatting.mp4 (90.24 MB)
MP4
4 Basic date formatting.mp4 (48.31 MB)
MP4
5 Advanced date formatting.mp4 (79.05 MB)
MP4
6 Text formatting.mp4 (64.3 MB)
MP4
7 Text color.mp4 (81.24 MB)
MP4
8 Fill color.mp4 (83.7 MB)
MP4
9 Border line settings.mp4 (88.35 MB)
MP4
1 Organizing table structure.mp4 (71.52 MB)
MP4
2 Hiding columns and rows.mp4 (54.81 MB)
MP4
3 Merging and splitting cells.mp4 (72.01 MB)
MP4
1 Inserting images.mp4 (72.15 MB)
MP4
10 Effects and Styles.mp4 (43.68 MB)
MP4
11 Grouping.mp4 (26.1 MB)
MP4
12 SmartArt in Excel.mp4 (66.84 MB)
MP4
13 Creating Charts in Excel.mp4 (60.25 MB)
MP4
14 Managing chart objects and data.mp4 (72.65 MB)
MP4
15 Chart design customization.mp4 (55.03 MB)
MP4
16 Sparkline.mp4 (56.75 MB)
MP4
2 Insert versus Link.mp4 (48.82 MB)
MP4
3 Transformation and snapping.mp4 (55.99 MB)
MP4
4 Managing visual objects in Excel.mp4 (80.02 MB)
MP4
5 Transparency and Cropping.mp4 (91.28 MB)
MP4
6 Shape objects basics.mp4 (51.27 MB)
MP4
7 Lock Drawing, Modifiers and Alignment.mp4 (55.03 MB)
MP4
8 Editing Shapes.mp4 (50.93 MB)
MP4
9 Text box.mp4 (74.92 MB)
MP4
1 Paste types.mp4 (111.33 MB)
MP4
2 Notes and Comments.mp4 (73.28 MB)
MP4
3 Find.mp4 (80.95 MB)
MP4
4 Replace.mp4 (61.81 MB)
MP4
5 Sorting data.mp4 (70.8 MB)
MP4
6 Filters.mp4 (76.15 MB)
MP4
7 Freeze panes.mp4 (40.81 MB)
MP4
1 Excel table basics.mp4 (80.21 MB)
MP4
2 Advanced Excel table.mp4 (98.53 MB)
MP4
3 PivotTable basics.mp4 (78.4 MB)
MP4
4 PivotTable Field, Filter, and Slicer.mp4 (57.83 MB)
MP4
5 PivotTable design.mp4 (56.76 MB)
MP4
6 Connecting Excel table to PivotTable.mp4 (59.41 MB)
MP4