Microsoft 365 Excel ( Beginner)

If you are new to Excel, this course will teach you the essential skills needed to start using Excel spreadsheets. You will learn to navigate with ease, enter data into spreadsheets, manipulate data, format data and start creating formulas and using functions.

At the end of the course, students will be confident to work with the pre-created spreadsheets or create his own spreadsheet.

Course Outline:

• Navigating Easily In Excel
  • Using the Ribbon – Tabs, Groups and Commands
  • Cells, columns and rows
  • Shortcut Keys combinations
  • Freezing, splitting and zooming the screen
  • Hiding columns and rows
• Entering Data
  • Formatting Dates and Times
  • Check spelling
  • Undo / redo
  • Create and modify tables
  • Sorting and Filtering tables
• Start Creating Formulas
  • Add,
  • Subtract,
  • divide and
  • multiply
  • What is cell reference
• Start Using Built-In Excel Functions
  • Manually type functions
  • Use functions button
  • AutoSum, Average, Count, Min and Max
• Moving And Copying Data
  • Cut, Copy and Paste
  • Fill Handle
  • Autofill
  • Flash Fill
  • Smart Tags
• Organizing And Working With Multiple Worksheets
  • Renaming and coloring tabs
  • Moving, copying and inserting worksheets
  • Margins
  • Headers and Footers
  • Printing Options
• Formatting With Excel
  • Adjusting width/height of column/rows
  • Cell alignments
  • Wrapping and merging
  • Formatting numbers