10 EXCEL FORMULAS EVERY DATA ANALYST SHOULD KNOW
In this training video, I covered 10 Excel formulas to boost your Excel and Data Analytics skills. Watch to the end because, by the end of this training video, you’ll understand some important formulas in Excel that will help you in your journey to data analytics. This is one of my give away computer training for beginners.
Timecode:
0:00 Introducing the dataset
10:50 LEN, MIN/MAX FUNCTION
14:38 SUMIF FUNCTION
22:06 DAYS/NETWORKDAYS FUNCTION
27:43 REPLACE/SUBSTITUTE FUNCTION
34:36 MINIFS/MAXIFS FUNCTION
42:32 TRIM FUNCTION
47:06 COUNTIFS FUNCTION
50:55 LEFT/RIGHT FUNCTION
53:32 VLOOKUP FUNCTION
MS Excel Training for Beginners:
• MICROSOFT EXCEL TRAINING FOR BEGINNERS
Data Analytics Training for Beginners:
• DATA ANALYTICS FOR BEGINNERS
For Free Datasets:
https://www.kaggle.com/datasets
To Register for Pro Class, Visit:
https://training.flocomputers.com/
#computertraining
#msexcel
#dataanalyticscourse
#beginners
#dataanalyticstraining
Join this channel to get access to perks:
/ @flourishictacademy