Website

MS Office

Word

Powerpoint

Excel

Excel Adv

Japanese

3D Printing

Microsoft MS Excel 2013, 2016, 2019 and 365 

(Basic to Intermediate)

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!