top of page

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!"

© 2025 Intuition International

(brand name of Apps Pte Ltd)

52 Telok Blangah Road, #01-02

Singapore 098829

Tel : 6909-8722 / 9181-9499

Email: contact@intuitioninternational.com

bottom of page