Microsoft MS Excel 2013, 2016, 2019 and 365 (Basic to Intermediate)

The reasons why our courses MS Office,is  the most popular course

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