Course Title: Microsoft Excel Level 1 (Beginners)

Current Status:

Not Enrolled

Price:

$250

Get Started:

Book Your Live Class

Price: $250

You are not yet enrolled in this course.

Course Description:

Unlock the basics of Microsoft Excel with our Level 1 course designed for absolute beginners. Learn how to navigate the interface, create simple spreadsheets, and perform basic calculations. This course is perfect for individuals new to Excel or those looking to refresh their foundational skills.

  • Navigating the Excel Interface
  • Creating and Managing Simple Spreadsheets
  • Performing Basic Calculations

Course Content

Section 1: Creating, Opening and Saving Workbooks

  • What Is Excel?
  • Create a New Blank Workbook
  • Open Excel Files
  • Save Workbooks
  • Navigate a Workbook
  • Selection Types
  • Data Checkers
  • Help

Section 2: Exploring the User Interface

  • Backstage View
  • Ribbon Overview
  • Quick Access Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Section 3: Working with Data

  • Basic Data Types
  • Enter, Edit and Delete Data
  • Use Autocomplete and Autofill
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, Cells
  • Hide and Unhide Columns and Rows
  • Use Undo, Redo and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace and Go To
  • Cut, Copy, Paste and Paste Special
  • Use the Fill Handle

Section 4: Performing Calculations

  • Use Basic Formulas
  • Use Basic Functions
  • Understand Absolute and Relative Cell References

Section 5: Using Time Saving Tools

  • Flash Fill
  • AutoCalculate

Section 6: Formatting A Workbook

  • Work with Fonts and Font Attributes
  • Apply Borders and Shading
  • Use the Format Painter
  • Change Text Alignment
  • Wrap Text
  • Apply Manual Line Breaks
  • Rotate Text
  • Merge and Centre Text
  • Create and Modify Styles
  • Apply Number Formats
  • Clear Formatting

Section 7: Managing Large Workbooks

  • Rename Worksheets
  • Colour-code Worksheet Tab Colours
  • Copy, Move, Delete, and Group Worksheets
  • Work with Freeze Panes

Section 8: Printing and Viewing A Workbook

  • Work with Page Breaks
  • Work with Print Preview and Page Layout View
  • Change Margins and Page Orientation
  • Scale to Fit Worksheets
  • Insert Headers and Footers
  • Print Titles Across All Pages
  • Review Print Options


Enroll Now