Канал: BI Excel

How to create pivot charts in Excel

How to create pivot charts in Excel

Conditional formatting in Excel

Conditional formatting in Excel

Data formatting shortcuts in Excel

Data formatting shortcuts in Excel

CountIf, SumIf, AverageIf

CountIf, SumIf, AverageIf

Use dynamic named ranges so your charts update automatically

Use dynamic named ranges so your charts update automatically

Make Excel spreadsheet more professional with drop-down menus

Make Excel spreadsheet more professional with drop-down menus

How to use Excel sparklines

How to use Excel sparklines

How to use 3-D references in Excel

How to use 3-D references in Excel

Excel data hack: text to columns

Excel data hack: text to columns

How to use Excel data tables

How to use Excel data tables

Before Excel there was VisiCalc: An interview with its creators

Before Excel there was VisiCalc: An interview with its creators

5,000!

5,000!

Multiple Regression Analysis

Multiple Regression Analysis

Basic Excel shortcuts

Basic Excel shortcuts

How to use flash fill feature to recognize data sets

How to use flash fill feature to recognize data sets

How to create an Excel add-in

How to create an Excel add-in

How to use Excel pivot tables to analyze massive data sets

How to use Excel pivot tables to analyze massive data sets

Lesser-Known Excel Shortcuts

Lesser-Known Excel Shortcuts

Array functions

Array functions

Utilizing the F5 key

Utilizing the F5 key

Index Match

Index Match

How to use VLOOKUP

How to use VLOOKUP

Monte Carlo Simulations: Run 10,000 Simulations At Once

Monte Carlo Simulations: Run 10,000 Simulations At Once

How To Create Custom Functions

How To Create Custom Functions

Welcome To BI: Excel

Welcome To BI: Excel

How To Make Custom Chart Templates

How To Make Custom Chart Templates

How To Link To Charts In Word And PowerPoint

How To Link To Charts In Word And PowerPoint

How To Use Paste Special

How To Use Paste Special