Pro EXCEL for Finance professionals

Video 1.1 Excel formula, Calculation order, name box, forumula bar (ex 1.1 to 1.8)

Video 1.2 References in a formula, Introduction to functions, AutoSum functions (Ex 2.1 to 2.9)

Video 1.3 Relative Vs Absolute References Ex 3.1 to 3.5)

Video 1.4 Absolute References with Excercise 3.5 and 3.6

Video 2.1 Navigation and selection of bigger data

Video 2.2 Naming a Range and using in formula

Video 2.3 giving names to the ranges collectively and countblank function

Video 2.4 Counta and different count functions and their difference

Video 2.5 Zero Vs empty cell and the importance of tiny things in excel

Video 2.6 Formula Vs Functions, operators, Ampersnad and use

Video 2.7 A practical usage of ampersand operator

Video 3.1 Some Functions on Text String(len, trim, upper, proper, lower, left, right and Mid)

Video 3.2 Practice 1 of Left Right and mid function with a glimpse of text to column option

Video 3.3 Exercise 2 of Text Function (Trim, Len, left, right, mid and concatinate)

Video 3.4 Find Search and replace functions

Video 3.5 Find and concatinate function practice example

Video 3.6 Rounding Functions (Ceiling, Floor, Int, Mod, round, Trunc)

Video 3.7 Exercise 4.2 A basic Budgeting model

Video 3.8 Exercise 4.3 Budgeting model with 2 variation

Video 4.1 Entring date and time in Excel, how Excel handles date and time and changing format of inp

Video 4.2 Basic Functions for Date and time (today,now, year, month, day, date, Hour, Minute, Second

Video 4.3 Adding or subtracting datetime from a datetime Exercise 1

Video 4.4 Adding or subtracting datetime from a datetime Exercise 2 and introduction to nested form

Video 4.5 Working days and enlisting these days ( days, networkdays, networkdays.intl , workday, wor

Video 4.6 Working days and enlisting these days Exercise

Video 4.7 Fixing date issues in data imported from external sources Type 1 Data done

Video 4.8 Fixing date issues in data imported from external sources Type 2 Data (done)

Video 5.1 Formula auditing( show formula, trace precedents and dependents, remove arrows etc)

Video 5.2 Evaluate formula and calculation options

Video 5.3 Various errors in excle and how to solve them ( ####### , # Div0! #NAME #VALUE!, #REF!, #

Video 5.4 Name manager defining and using names of ranges in excel

Video 1 Concept, Interpretation and syntax of NPV function

Video 2 Concept interpretation and syntax of IRR

Video 7.1 V Lookup Function basics with naming cells and range

Video 7.2 Hlookup and keyboard selection tools

Video 7.3 Ture and false arguments of vlookup function

Video 8.1 introduction to conditional functions(condition operations = gt than, low than, exact, is

Video 8.2 iserr, iserror isna isref islogical and complex logic operations (and, or, not)

Video 8.3 Your first If function and how it works

Video 8.4 applying IF function Practice 2 and intorduction to nested IF function practice 1

Video 8.5 Nested IF function complex example 2

Video 9.1 Conidtional Counts (Count, Counta, Countblank, countif and Countifs)

Video 9.2 Count, Countif, sum, sum if with complex condition and data dropdowns

Video 9.3 Recall practice of dropdowns, sumifs & reletive absolute references

Video 11.1 Pivot table part 1 basics, applying pivot making diffrent reports using row colum and values

Video 11.2 Pivot Table part 2 using filters and Variation in Value field setting

Video 11.3 Pivot Table part 3 using slicers and Timeline in data filter

Video 2 Pivot Charts with slicers and timelines

Video 1 Pivot Charts Intorduction and Chart options

Video 3 Multiple pivot charts and Excel Dashboard

Video 4 Editing and linking more components in Dashboard

Video 1 Power BI a brief introduction adding data and AI driven charts

Video 2 Adding Visual cards, Multi row cards with permanent Filter, Tables and text boxes with varia

Video 3 Ordering and presenting visual and charts to make a dashboard in BI

Video 14.1 Data selection shortcuts and basic single level sorting

Video 14.2 Custom sort lists sorting on basis of Cell colour and font colour

Video 14.3 Multiple level sorting(adding levels, Deleting levels and moving levels up and down)

Video 14.4 Filters and Multiple filters

Video 14.5 Subtotal Function with filters with criteria

Video 14.6 Filters relating to date (and pivot table for dates)

Video 1 Conditional Formatting Basics and multiple conditions

Video 2 Conditional formatting text based and top bottom rules

Video 3 Conditional Formatting on dates setting condition on the basis of another cell

Video 4 Finding Duplicate data, rand & randbetween, round to 100s and pivot table recap

Video 5 Databars, colour scales and icon sets

Video 6 Function based conditions (single and multiple)

Video 7 Goal Seek and some presentation techniques

V1 Subtotal Functionality

V2 Group and ungroup function

Video 17.1 Formula Auditing ( trace precedents,dependents,show formula, evaluate formula)

Video 19.2 Protection of Workbook (Protect current sheet and protect workbook structure)

Video 19.1 Protection of Workbook(Mark as Final and Encrypt with password)

Video 1 Sheet Views and zooming the screen

Video 2 page break preview and print dialog box

Video 3 windows, Screen splits, Freeze Pane, Workbook windows