# Excel & Power BI Tuts from Chandoo

• ### Top 10 Excel Formulas 2019 - for any situation

7,978 views 8 months ago
So you know SUM & COUNT formulas and want to learn more? Here is my top 10 favourite formulas for 2019.

1) Table & structural referencing
2) IFS() formula
3) SUMIFS , COUNTIFS
4) SWITCH FUNCTION
5) VLOOKUP - Ever green
6) SUBTOTAL
7) MAXIFS, MINIFS & AVERAGEIFS
8) FIND / SEARCH functions
9) TODAY() and NOW() functions, working with date values
10) IFERROR formula

=========

• ### Preview of "Fast Track your Excel Skills" book - Get your FREE Copy - Duration: 4 minutes, 32 seconds.

• 1 week ago
• 639 views
#FastTrackExcelSkills #FREEBooks #ExcelBook #BookReview

I just finished writing my newest book - Fast Track your Excel Skills with 10-10-10-10 principle. In this book, I will teach you 10 most imp...
• ### Convert 20,000 lines of text to 400 lines with Power Query - Group by technique - Duration: 6 minutes, 56 seconds.

• 2 weeks ago
• 462 views
#PowerQuery #GroupBy

Say you have a large list of items and want to combine every 'n' values in to one value. You can use Power Query's Group By feature to do this. In this video, I explain how to...
• ### Convert 20,000 lines of text to 400 lines with Formulas - Excel Tip - Duration: 7 minutes, 21 seconds.

• 2 weeks ago
• 390 views
#TEXTJOIN #ExcelTip
Do you have lots of text and want to combine it all by chunks? You can use TEXTJOIN() formula to do it easily. In this video learn how to apply TEXTJOIN() formula to combine te...
• ### 2019 Introduction to Power BI - What is it, how to use it and create your first report with Power BI - Duration: 37 minutes.

• 4 weeks ago
• 835 views

Power BI is a data analytics & visualization software. It is one of the most popular and powerful way to work with complex business data. In this video, ...
• ### Celebrate Halloween with Creepy Spider Web Chart in Excel - Duration: 11 minutes.

• 1 month ago
• 295 views
Want some Halloween decorations for your TPS reports? I got you covered. Here is an Excel chart to make random spider webs. Watch the video to...
• ### How to make Kids Maths Homework problems with Excel (Parenting + Excel) - Duration: 7 minutes, 32 seconds.

• 1 month ago
• 399 views
#parenting #excel #homework #maths

Ever wanted to make homework problems for your kids to practice maths? You can use Excel to make random problems easily. In this video, I share my experience and...
• ### IRR with Data Tables - Excel Financial Analysis Lesson - Duration: 14 minutes.

• 1 month ago
• 729 views
#FinancialAnalysis #IRR #DataTables #Scenarios

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this video is for you. Learn how to,

* Introduction to I...
• ### How to get web data into Excel (case study with Rugby World Cup 2019 results data) - Duration: 10 minutes.

• 1 month ago
• 620 views
#PowerQueryWebConnection #ExcelPowerQuery #Web2Excel

Ever wanted to get live web data into Excel? You can use Web connection feature of Power Query in Excel (or Power BI) to easily get this. In th...
• ### Impress with Tornado Chart in Excel - Duration: 8 minutes, 38 seconds.

• 1 month ago
• 367 views
It's tornado season. Don't freak out, I am talking about Excel tornado charts. Use them to visualize age and gender-wise KPIs. In this video, let me ...
• ### Mixed numbers and text in a column - 4 ways to convert - Excel Tips - Duration: 10 minutes.

• 2 months ago
• 387 views
#DirtyData #ConvertNumbersExcel #ExcelTips

Ever have both numbers and text (that is numbers) in a column and want a quick way to convert everything to a number? You can use four simple methods to ...
• ### Data validation without duplicates - Excel Tricks - Duration: 9 minutes, 2 seconds.

• 2 months ago
• 939 views
#ExcelDropDownBox #DataValidationExcel

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, Excel has the right tools to do i...
• ### Zelda BOTW style Stamina Wheel Chart in Excel - Duration: 8 minutes, 51 seconds.

• 2 months ago
• 410 views
#BOTW #Zelda #StaminaWheelChart #BudgetVsActualChart #Excel

I have been playing Zelda: Breath of the wild a lot these days and I LOVE the game. Considered one of the BEST video games all time, BOT...
This item has been hidden
• ## Popular uploads Play all

• ### What is Excel and How to use it? - Duration: 9 minutes, 46 seconds.

• 9 years ago
• 741,073 views
Introduction to Microsoft Excel - This is part 01 of 10 in the series - Excel Baby Steps.

• ### Calculating total working hours using Excel - example & discussion - Duration: 14 minutes.

• 4 years ago
• 369,330 views
Learn how to calculate total working hours using Excel formulas.
• ### 10 Things you can do Easily in Excel under 10 Minutes - Duration: 9 minutes, 56 seconds.

• 9 years ago
• 333,259 views
10 things you can do in Excel under one minute each. You can learn how to,
1. Auto sum a bunch of values
2. Save Excel file as PDF
3. Insert Org chart
4. Insert Euro Symbol
5. Change Tab Colors
6. ...
• ### Introduction to Power Pivot for Excel - Duration: 23 minutes.

• 6 years ago
• 323,886 views
http://chandoo.org/wp/2013/01/21/introduction-to-power-pi...
A brief over view of Power Pivot for Excel & why it is the most awesome way to analyze data.
• ### How to Project Dashboard Excel Template - Duration: 9 minutes, 15 seconds.

• 9 years ago
• 293,998 views
Learn how to use the Project Dashboard Excel Template to make your own project status dashboards - Visit http://chandoo.org/pmt/pmt-index-1.html for more information
• ### Dynamic Dashboard using Excel - a Tutorial - Duration: 12 minutes.

• 8 years ago
• 214,511 views
Learn how to use Excel Pivot Tables and Slicers to create dynamic dashboards from your data. A tutorial from Chandoo.org

• ### Entering and Formatting Data in Excel - Duration: 9 minutes, 30 seconds.

• 9 years ago
• 186,279 views
Introduction to Formatting Options in Excel - This is part 02 of 10 in the series - Excel Baby Steps.

• ### Make a Pivot Table in Excel - Duration: 18 seconds.

• 10 years ago
• 181,342 views
This video tutorial by Chandoo.org explains how to make a pivot table in Excel in less than 15 seconds.
• ### Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials - Duration: 13 minutes.

• 5 years ago
• 172,932 views
Matching transactions (reconciling) using Excel Pivot Tables | ExcelTutorials

Learn how to reconcile (or match) transactions using Excel Pivot Tables. Example workbook and more here:

http://chan...
• ### 07 what is a pivot table and how to use it - Duration: 9 minutes, 43 seconds.

• 9 years ago
• 156,813 views
• ### How to combine text values using CONCATENATE & TRANSPOSE functions - Excel Trick - Duration: 11 minutes.

• 5 years ago
• 151,689 views
Ever wondered how to go from a bunch of cells with text to one big combined text?

Visit http://chandoo.org/wp/2014/01/13/combine-text-values-quic... for more.
• ### KPI Dashboard in Excel- Video Tutorial & Demo - Duration: 12 minutes.

• 8 years ago
• 135,330 views
http://chandoo.org/wp/2011/03/24/kpi-dashboard-revisited/

A demo of KPI dashboard made using Excel. For details visit the above URL.

from chandoo.org
This item has been hidden
• ## Featured Topics

This item has been hidden
to add this to Watch Later