1 - Introduction (23.96 MB) 66 - Map charts in Excel (70.8 MB) 67 - Map charts in Google Sheet (26.01 MB) 68 - Stock charts in Excel (94.66 MB) 69 - Stock charts in Google Sheet (20.31 MB) 70 - Radar charts in Excel (34.78 MB) 71 - Radar charts in Google Sheet (24.46 MB) 72 - Heatmaps in Excel (32.39 MB) 73 - Heatmaps in Google Sheet (32.39 MB) 74 - Named Ranges in Excel (69.68 MB) 75 - Named Ranges in Google Sheet (27.54 MB) 76 - Indirect Functions in Excel (39.4 MB) 77 - Indirect Functions in Google Sheet (18.83 MB) 78 - Shortcuts in Excel (117.5 MB) 79 - Shortcuts in Google Sheet (74.32 MB) 80 - Macros in Excel (73.51 MB) 81 - Macros in Google Sheet (77 MB) 82 - Importing tables from PDF Excel 2021 and office 365 (114.44 MB) 83 - Importing tables from PDF Google Sheet (28.13 MB) 84 - Importing data from Website Excel 2019 and above (100.84 MB) 85 - Importing data from Websites Google Sheet (38.74 MB) 86 - Advanced Excel Analytics in Excel (113.79 MB) 87 - Solving a transportation problem using Excel (72.62 MB) 88 - Addons in Google Sheet (97.38 MB) 89 - Sharing in Google Sheet (22.45 MB) 90 - The final milestone (12.75 MB) 10 - Data Formats in Google sheet (25.78 MB) 11 - Data Handling Basics Cut Copy and Paste in Excel (89.73 MB) 12 - Data Handling Basics Cut Copy and Paste in Google Sheet (32.1 MB) 13 - Saving and Printing in Excel (52.22 MB) 14 - Saving and Printing in Google Sheet (27.59 MB) 2 - Getting started with Excel (52.12 MB) 3 - Getting started with Google Sheet (24.74 MB) 5 - Worksheet Basics in Excel (93.58 MB) 6 - Worksheet Basics in Google Sheet (35.7 MB) 7 - Entering values and Formulas in Excel (38.27 MB) 8 - Entering values and Formulas in Google Sheet (26.65 MB) 9 - Data Formats in Excel (48.74 MB) 15 - Basic Formula Operations in Excel (134.7 MB) 16 - Basic Formula Operations in Google Sheet (39.14 MB) 17 - Mathematical Functions in Excel Part 1 (79.02 MB) 18 - Mathematical Functions in Excel Part 2 (64.62 MB) 19 - Mathematical Functions in Google Sheet Part 1 (34.82 MB) 20 - Mathematical Functions in Google Sheet Part 2 (29.24 MB) 21 - Textual Functions in Excel Part 1 (77.23 MB) 22 - Textual Functions in Excel Part 2 (73.34 MB) 23 - Textual Functions in Google Sheet Part 1 (38.54 MB) 24 - Textual Functions in Google Sheet Part 2 (31.69 MB) 25 - Logical Functions in Excel (87.75 MB) 26 - Logical Functions in Google Sheet (89.18 MB) 27 - DateTime Functions in Excel (46.78 MB) 28 - DateTime Functions in Google Sheet (39.08 MB) 29 - Lookup Functions V Lookup Hlookup IndexMatch (62.49 MB) 30 - Lookup Functions in Google Sheet (75.85 MB) 31 - XLookup as a replacement of Vlookup (82.42 MB) 32 - Handling NA and Approximates match in Xlookup (130.34 MB) 33 - Wildcard matching in XLookup (38.42 MB) 34 - Search modes in XLookup (64.05 MB) 35 - Data Tools in Excel part 1 (90.21 MB) 36 - Data Tools in Excel part 2 (48.73 MB) 37 - Data Tools in Google Sheet (76.74 MB) 38 - Formatting data and tables in Excel (166.57 MB) 39 - Formatting data and tables in Google Sheet (60.29 MB) 40 - Pivot Tables in Excel (73.74 MB) 41 - Pivot Tables in Google Sheet (61.56 MB) 42 - Excel Charts Categories of messages that can be conveyed (8.39 MB) 43 - Elements of charts (27.54 MB) 44 - The easy way of creating charts in Excel (23.49 MB) 45 - The easy way of creating charts in Google Sheet (20.12 MB) 46 - Bar and column charts in Excel (91.53 MB) 47 - Bar and column charts in Google Sheet (46.03 MB) 48 - Formatting charts in Excel part 1 (69.78 MB) 49 - Formatting charts in Excel part 2 (31.97 MB) 50 - Formatting charts in Google sheet (58.41 MB) 51 - Line Charts in Excel (87.2 MB) 52 - Line Charts in Google Sheet (38.55 MB) 53 - Area Charts in Excel (48.33 MB) 54 - Area Charts in Google Sheet (42.69 MB) 55 - Pie and Doughnut Charts in Excel (104.51 MB) 56 - Pie and Doughnut Charts in Google Sheet (44.13 MB) 57 - Why we should avoid Pie charts (18.24 MB) 58 - Scatter plot or XY charts in Excel (133.57 MB) 59 - Scatter plot or XY charts in Google Sheet (38.94 MB) 60 - Frequency Distribution and Histograms in Excel (84.76 MB) 61 - Frequency Distribution and Histograms in Google Sheet (4.68 MB) 62 - Sparklines in Excel (46.8 MB) 63 - Sparklines in Google Sheet (23.16 MB) 64 - Pivot Charts in Excel (47.12 MB) 65 - Pivot Charts in Google Sheet (40.35 MB)