Basic Data Analysis With Excel
The "Basic Data Analysis With Excel" course is a comprehensive and practical guide designed to equip participants with fundamental data analysis skills using Microsoft Excel.
Course details
Duration
Self-Paced Learning
Lectures
39
Video
1 Hour 53 Minutes
Level
All Levels
Category:
- Curriculum
- Reviews
SECTION 1: INTRODUCTION
SECTION 2: HOW TO NAVIGATE QUICKLY IN EXCEL
SECTION 3: HOW TO CLEAN DATA IN PREPARATION FOR ANALYSIS
-
7
Insert Filters, Multiple Sort -
8
Create Tables
-
9
Find And Replace Data
-
10
IFERROR For Calculations
-
11
IFS For Creating Buckets In A New Column
-
12
LEFT RIGHT LEN SEARCH For Manipulating Text
-
13
LEFT RIGHT LEN SEARCH For Manipulating Text (Advanced)
-
14
Cleaning Dates
-
15
Using Excel's Smart Autofill Feature
SECTION 4: HOW TO ANALYZE DATA
SECTION 5: HOW TO FORMAT YOUR OUTPUT
-
24
Format Numbers Quickly, Set Decimal Points
-
25
Using Detailed Formatting Options In Ctr + 1
-
26
Conditional Formatting
-
27
Align Text, Font Color
-
28
Adding Cell Borders
-
29
Cell Highlights
-
30
Use Paste Special To Copy Formats From Another Cell
-
31
Clear Formatting From Cells
-
32
Insert And Delete Comments From Cells
-
33
Set Row Width And Column Height, Use Autofit
-
34
Show And Hide Gridlines
-
35
Color The Tabs In Your Workbook
SECTION 6: BEST PRACTICES FOR STRUCTURING YOUR WORKBOOK
Stars 5
2
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
Google