Data Analytics with Microsoft MS Excel 365 Level 1
"Very Helpful, Very Interesting, Very Comfortable Experience!"
"Very well organised, Very Knowledgeable Instructor!"
"Empowering, Very Interesting, Very Patient Instructor!"
"Can Absorb (Learn) Instantly!"
Microsoft Excel Course Plan:
4hrs
-
Purpose of Excel
-
Navigate and Select Cells in Worksheets
-
Create a Basic Worksheet
-
Inputting data
-
Fixed-Width Fonts
-
Inserting, Renaming, Deleting Rows and Columns
-
Add Borders and Colours to Cells
-
Change column width and row height
-
Merge Cells and Wrap Text
-
Apply Number Formatting
-
Apply Font Properties
-
Edit Worksheet Data
-
Find and Replace Data
-
Autofill Data
-
Data Segregation using Text to Column
-
Working with Lists - Sorting and Filtering (> versus >=, < versus <=, AND versus OR).
-
Sort and Filter by Color
-
Deleting Every Other Row
4hrs
-
Create Formulas in a Worksheet
-
Understand commonly used Functions like SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, ROUND, ROUNDUP, ROUNDDOWN.
-
Insert Functions in a Worksheet
-
Reuse Formulas
-
Create Formulas using $ sign
-
IF, SUMIF and COUNTIF
-
Insert Text to Column
-
Transposing Data
-
Inserting Header and Footer
-
Align Content in a Cell
-
Apply Page Break, Split and Freeze Panes
-
Creating 2D and 3D Charts
-
Showing Data Labels, Legend, Titles, Format
-
Moving and copying Worksheet
-
Inserting, Renaming, Deleting, Hiding Worksheet
-
Save and Print a Worksheet
"Powerful! Course covers more advanced topics!"