Канал: A2 Excel, Stats and Finance

The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 1

The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 1

Part 2 The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 2

Part 2 The Full Guide to Pivot Tables, Charts and Dashboards in Excel - Part 2

Full Excel Tutorial – 11/12 – Excel Macros and VBA – Automate your job away!

Full Excel Tutorial – 11/12 – Excel Macros and VBA – Automate your job away!

Full Excel Tutorial – 4/12 – Pivot Tables: All you need to know

Full Excel Tutorial – 4/12 – Pivot Tables: All you need to know

Full Excel Tutorial – 9/12 – Sumif And Sumifs: Formulas for true advanced

Full Excel Tutorial – 9/12 – Sumif And Sumifs: Formulas for true advanced

Full Excel Tutorial – 6/12 – Excel Tables: Excel’s most underrated tool

Full Excel Tutorial – 6/12 – Excel Tables: Excel’s most underrated tool

Full Excel Tutorial – 2/12 -Formula References in Excel – Absolute and Relative

Full Excel Tutorial – 2/12 -Formula References in Excel – Absolute and Relative

Full Excel Tutorial – 1/12 – Excel for Absolute Beginners

Full Excel Tutorial – 1/12 – Excel for Absolute Beginners

Full Excel Tutorial – 5/12 – Pivot Charts: Make Awesome presentations

Full Excel Tutorial – 5/12 – Pivot Charts: Make Awesome presentations

4 of Excel's Best Kept Secrets

4 of Excel's Best Kept Secrets

Difference between SUM vs SUMX in Power BI and Power Pivot

Difference between SUM vs SUMX in Power BI and Power Pivot

Full Excel Tutorial – 8/12 -The Definitive guide to Vlookup! Learn Vlookup, and Approximate Matches

Full Excel Tutorial – 8/12 -The Definitive guide to Vlookup! Learn Vlookup, and Approximate Matches

Full Excel Tutorial – 7/12 - The complete Guide to IF function, nested if and IFS function in Excel

Full Excel Tutorial – 7/12 - The complete Guide to IF function, nested if and IFS function in Excel

Conditional Formatting with Power BI and DAX

Conditional Formatting with Power BI and DAX

Ace the Excel Technical Interview Get the job you want

Ace the Excel Technical Interview Get the job you want

Excel Scenario Manager: Forecast the future!

Excel Scenario Manager: Forecast the future!

The Complete Guide to Printing in Excel without losing your mind

The Complete Guide to Printing in Excel without losing your mind

Compare Columns with Vlookup and Excel

Compare Columns with Vlookup and Excel

3 Different types of Drop Down lists in Excel! Essential for your job!

3 Different types of Drop Down lists in Excel! Essential for your job!

Solver in Excel is easy! You need to master it if you are an engineer!

Solver in Excel is easy! You need to master it if you are an engineer!

Learn how to program practical UserForms with Excel and VBA, Fast!

Learn how to program practical UserForms with Excel and VBA, Fast!

Create amazing Dashboards with Power BI and Excel

Create amazing Dashboards with Power BI and Excel

5 Must-Know Formulas in Excel (These will get you a job!)

5 Must-Know Formulas in Excel (These will get you a job!)

Full Excel Tutorial – 3/12 - Impress your boss with these 7 Essential Excel Tricks

Full Excel Tutorial – 3/12 - Impress your boss with these 7 Essential Excel Tricks

DistinctCount in Excel

DistinctCount in Excel

Essential Skill with Excel: Expiration Alerts with Conditional Formatting

Essential Skill with Excel: Expiration Alerts with Conditional Formatting

Full Excel Tutorial – 10/12 - Index and Match with Excel ¿The Vlookup Killer?

Full Excel Tutorial – 10/12 - Index and Match with Excel ¿The Vlookup Killer?

Create Stunning 3D maps in Excel (really simple to use)

Create Stunning 3D maps in Excel (really simple to use)

Excel Date tricks you NEED to know.

Excel Date tricks you NEED to know.

Easy Intro to Financial Math with Excel - Pt 2 Investment Math

Easy Intro to Financial Math with Excel - Pt 2 Investment Math

Easy Intro to Basic Statistics with Excel

Easy Intro to Basic Statistics with Excel

Easy Intro to Financial Math in Excel - Pt 1 Home Mortgage example

Easy Intro to Financial Math in Excel - Pt 1 Home Mortgage example

Dates not grouping in pivot tables in Excel - Fix those mistakes and more

Dates not grouping in pivot tables in Excel - Fix those mistakes and more

Mix Vlookup with conditional formatting in excel to get awesome results

Mix Vlookup with conditional formatting in excel to get awesome results

Foolproof Vlookup with Dropdown lists - Quick and simple Excel trick

Foolproof Vlookup with Dropdown lists - Quick and simple Excel trick