"
Microsoft Excel Essentials
ENROL NOW

 

Overview

Our Microsoft Excel Essentials program is designed for students who wish to advance their computer skills by learning to work with Microsoft Excel. The course is aimed at those who have no or limited experience with Excel.

Course facilitators are knowledgeable in all levels of Excel and use the software on a daily basis. You will receive hands-on training by our patient, experienced facilitators, and easy to ready printed courseware for future reference.

At the conclusion of the training, you will be issued with a Certificate of Completion.

 

Included Topics

Navigating Excel

  • Basic Excel concepts and uses
  • Ribbon, Status Bar and Quick Access toolbar
  • Create and Save a Workbook
  • Insert, Delete, Copy and Move Worksheets
  • Naming and colouring worksheets tabs

Editing and Formatting in Excel

  • Insert or Delete Cells/Rows/Columns
  • Use AutoComplete and AutoFill
  • Cut, Copy, and Paste text
  • Wrap, Merge and Centre Text
  • Number and text formatting and alignment
  • Borders and Shading

Basic Excel formulas

  • Use Math Operators
  • AutoSum
  • Relative and Absolute references
  • Copying formulas

Work with Rows and Columns

  • Set Row Height and Column Width
  • Hide and Unhide Rows and Columns
  • Freeze Panes

Useful Functions

  • Find and Replace Data
  • Sort Data
  • Create and Use Comments

Print Worksheets

  • Page Orientation
  • Set and Clear Print Area
  • Set Margins
  • Print Scaling
  • Headers and Footers
  • Print to PDF

Basic Charts

  • Create, Format, and Move Charts
  • Print Charts

Using Help

  • Online Help
  • Smart Lookup
  • Tell Me

 

Make It Happen

Dedicated corporate classes may be scheduled, and these may be delivered onsite depending on availability of computers at the client’s premises, or in our training rooms using the laptops available at TMT. Please speak to our friendly staff regarding onsite delivery.

 

ENROL NOW

© Total Management and Training 2024 - RTO #31178

web design by precedence