| 00 Before Start Message.mp4 | 22.38 MB |
| 01 Opening first Excel worksheet, intoduction of every eleme.mp4 | 35.47 MB |
| 02 Navigation, Data Entry, Formatting and basic calculation.mp4 | 39.53 MB |
| 03 Copying formulas, Relative and Absolute Referencing.mp4 | 27.92 MB |
| 04 Comprehensive practice of Relative and absolute referenci.mp4 | 13.43 MB |
| 05 Referencing further practice.mp4 | 10.51 MB |
| 06 Quick revision, explaining ribbon and excel shortcuts.mp4 | 41.01 MB |
| 07 Backstage of excel ie File Tab and introducing the operat.mp4 | 55.23 MB |
| 08 Backstage of excel ie File Tab and introducing the operat.mp4 | 29.09 MB |
| 09 Customizing the ribbon intro to formula tab.mp4 | 35.70 MB |
| 10 TRUE, FALSE, IF, AND, OR function.mp4 | 31.01 MB |
| 11 IF Function together with AND, OR function.mp4 | 24.36 MB |
| 12 Nested if function.mp4 | 10.27 MB |
| 13 Autosum functions and mathematical exercises.mp4 | 38.80 MB |
| 14Paste special function.mp4 | 35.43 MB |
| 15Paste link, transpose, insert,delete and format cells func.mp4 | 50.78 MB |
| 16Linking data between the sheets and its benefit.mp4 | 16.75 MB |
| 17Conditional formatting.mp4 | 31.53 MB |
| 18Count Function.mp4 | 23.43 MB |
| 19Rank function, minimum, MAX, Large and Small Function.mp4 | 22.44 MB |
| 20Sumif, SumIFS.mp4 | 36.96 MB |
| 21CountIF, AverageIf Function.mp4 | 39.64 MB |
| 22Mround, Ceiling, Floor.mp4 | 25.38 MB |
| 23Rounddown, RoundUp functions.mp4 | 18.70 MB |
| 24Integer and Trunc functions.mp4 | 16.75 MB |
| 25Trim and Proper Function.mp4 | 27.91 MB |
| 26Find and Search Function.mp4 | 44.30 MB |
| 27Upper, Lower and Proper Function.mp4 | 17.69 MB |
| 28 AND FUNCTION.mp4 | 31.99 MB |
| 29Concatenate Function.mp4 | 21.56 MB |
| 30Repeat and Substitute Function.mp4 | 31.73 MB |
| 31Substitute function practice.mp4 | 29.18 MB |
| 32Substitute and repeat Function.mp4 | 17.00 MB |
| 33Replace Function.mp4 | 21.97 MB |
| 34Date and Time Function Introduction.mp4 | 35.12 MB |
| 35Customise your own date format.mp4 | 22.24 MB |
| 36Today Function and addition, substraction to dates.mp4 | 24.68 MB |
| 37EDATE Function.mp4 | 26.92 MB |
| 38EOM Function.mp4 | 14.83 MB |
| 39 Introduction to chart and different ways of inserting a .mp4 | 41.91 MB |
| 40Introducing all the chart elements and formatting each ele.mp4 | 47.01 MB |
| 41Improving your chart by using various charts layouts, colo.mp4 | 16.30 MB |
| 42Data series editing, saving a template and other basic cha.mp4 | 11.76 MB |
| 43When to use which chart type-an intro and winding up sessi.mp4 | 32.11 MB |
| 44 VLOOKUP Function.mp4 | 34.09 MB |
| 45 MATCH and HLOOKUP Function.mp4 | 29.85 MB |
| 46 Tell me what do you want option in excel.mp4 | 11.24 MB |
| 47 Protecting, freeze panes,show and customize the ribbon.mp4 | 15.36 MB |
| 48 Undo last step vs Undo many steps at one go.mp4 | 13.40 MB |
| 49 Table making, designng, Sort and Filter in table mode and.mp4 | 32.88 MB |
| 50 AutoCorrect function for short hand wriring, Automatic de.mp4 | 30.18 MB |
| 51 Intro to advance course,solution of error in answers when.mp4 | 41.40 MB |
| 52 Advance Date Function, YEARFRAC, DATEDIF, combined uses o.mp4 | 46.21 MB |
| 53 DATEVALUE, VALUE Function, Custom Formatting to solve man.mp4 | 39.92 MB |
| 54 Combined use of DATEVALUE and Function.mp4 | 7.97 MB |
| 55 Revision of all date time functions, DAY function, DAYS F.mp4 | 49.13 MB |
| 56 Lets do some finance on excel Beginning with NPV.mp4 | 32.06 MB |
| 57 IRR and XIRR Function.mp4 | 35.51 MB |
| 58 Modified IRR.mp4 | 12.87 MB |
| 59 Its easy to create a loan amortisation schedule on excelU.mp4 | 25.13 MB |
| 60 PMT and IPMT Function.mp4 | 24.25 MB |
| 61 Effective annual rate of interest EFFECT Function.mp4 | 16.43 MB |
| 62 Depreciation schedule made easy DB Function.mp4 | 21.99 MB |
| 63 Future Value Function.mp4 | 9.78 MB |
| 64 Perform Net Present Value on Excel [Finance Function].mp4 | 37.46 MB |
| 65 Concept of Beta in Finance and its calculation on Excel.mp4 | 19.06 MB |
| 66 Address Function.mp4 | 31.42 MB |
| 67 Area Function.mp4 | 20.68 MB |
| 68 Row, Column Function and FormulaText Function.mp4 | 36.08 MB |
| 69 FormulaText Function practice and Hyperlink creation.mp4 | 22.31 MB |
| 70 Index and Match Function.mp4 | 29.16 MB |
| 71 Some Practice.mp4 | 11.49 MB |
| 72 Transpose Function Vs Paste Special.mp4 | 12.41 MB |
| 73 Offset Function.mp4 | 23.77 MB |
| 74 Offset as an array function.mp4 | 13.60 MB |
| 82 Goal Seek Analysis.mp4 | 15.40 MB |
| 75 Minute and Month Function.mp4 | 18.28 MB |
| 76 Month Function additional exercises.mp4 | 18.96 MB |
| 77 Network Days Function.mp4 | 18.99 MB |
| 78 Array Function help save time.mp4 | 39.35 MB |
| 79 Databse Function.mp4 | 25.99 MB |
| 80 Validation.mp4 | 15.39 MB |
| 81 Protection and Hiding.mp4 | 13.80 MB |
| 82 Goal Seek Analysis.mp4 | 15.40 MB |
| 83 Subtotal Function.mp4 | 18.16 MB |
| 84 What if analysis Data Table.mp4 | 25.57 MB |
| 85 Scenario manager.mp4 | 21.61 MB |
| 86 Summary of scenario manager.mp4 | 3.86 MB |
| 87 Shortcut revision and more advance shortcuts.mp4 | 48.31 MB |
| 88 Advance shortcut continued L1.mp4 | 45.52 MB |
| 89 Adv shortcut continue L2.mp4 | 10.35 MB |
| 90 Add or create a PPT or WORD within your Excel sheet90 Ad.mp4 | 21.53 MB |
| 91 Advance fill sequence.mp4 | 39.53 MB |
| 92 Audit tools in excel, evaluate formula.mp4 | 35.41 MB |
| 93 3D and consolidate data function.mp4 | 19.67 MB |
| 94 Let excel speak to you.mp4 | 10.12 MB |
| 95 Easy to view the same excel sheet side by side for easy a.mp4 | 10.17 MB |
| 96Make your excel sheet print ready Print and page setup.mp4 | 29.14 MB |
| 97 Pivot L1.mp4 | 28.17 MB |
| 99 Pivot L3.mp4 | 25.64 MB |
| 100 Pivot L4.mp4 | 6.96 MB |
| 101 Macro VBA introduction L1.mp4 | 40.41 MB |
| 102 Macro VBA introduction L2.mp4 | 33.97 MB |
| sticker.webm | 240.29 KB |
