Excel - Data Analysis and Clean Up Data

Excel - Data Analysis and Clean-Up Data. Excel makes data analysis easy. Frequently, our data needs to be cleaned up before doing the analysis. In this detailed video, we will look at Auto Calculate, changing text to number, working with Filters and spaces, using the UNIQUE and TRIM functions, using calculated columns, and working with PivotTables.
Chapters/Bookmarks
0:00 Intro
0:40 Check data and create a table
1:40 AutoCalculate
2:57 Change text to number
3:39 Change General to Dates
4:18 Filters and Spaces
4:55 UNIQUE Function
5:20 Remove Duplicates
6:18 TRIM Function
7:16 Move columns with SHIFT
7:55 Data Analysis
9:59 Calculated Column in a Table
10:40 PivotTable
Turn on Data Analysis
File, Options, Add-in, turn on Analysis Toolpak
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips • Excel PivotTable - Per...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Condition...
Teams Online Course Promotion • Teams Online Course Pr...
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Perc...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting • Excel - Turn on Multip...
Excel - Filter a PivotTable with a Timeline • Excel - Filter a Pivot...
PivotTables - 3 Annoying Things FIXED! • PivotTables - 3 Annoyi...
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines o...
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used ...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text...
Tasks by Planner in Teams - Recurring Tasks - New Feature • Tasks by Planner in Te...
Excel - Insert a blank row after every row or every Nth row • Excel - Insert a blank...
CTRL + A - select the current range
CTRL + . - jump around your range
#chrismenardtraining #exceltraining
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZbin keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@NoSrubs]

Thank you so much Chris Menard. ❤

[@NoSrubs]

Chris Menard is amazing. 😊

[@ChrisMenardTraining]

TY!

[@kevinspraggett7096]

Great and so simply explained!

[@Robert_512]

Great video Chris but you are giving away all the trade secrets that make my boss think I'm an Excel genius 😉

[@ChrisMenardTraining]

Thank you! Don't tell your boss. :-)

[@johnborg5419]

Thanks Chis. :) :)

[@usmaniqbal1836]

Amazing Chris! Please also share data file for better practice.

[@abbott100]

Hi Chris, great video. I was just wondering if you could help. I have the latest version of 365 but the data by picture option isn't available to me? I was just wondering if this was an add on that I needed to activate or not. Any help would be much appreciated. Cheers Dan.

[@KristinaAinsworthRealtorAustin]

Nerds rule the world! I mean this with affection.