Microsoft Office Excel 2016: Part 1 Beginner Level Course

This comprehensive excel beginner level course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course.

Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.

This excel beginner level course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.

This excel beginner level course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.

Getting Started With Excel 2016

• Navigate the Excel User Interface – Introduction
• Navigate the Excel User Interface
• Use Excel Commands – Introduction
• Use Excel Commands
• Create and Save a Basic Workbook – Introduction
• Create and Save a Basic Workbook
• Enter Cell Data – Introduction
• Enter Cell Data
• Flash Fill and Auto Fill
• Use Excel Help – Introduction
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas – Introduction
• Create Worksheet Formulas
• Insert Functions – Introduction
• Insert Functions
• Reuse Formulas and Functions – Introduction
• Reuse Formulas and Functions

Modifying a Worksheet

• Insert, Delete and Adjust Cells, Columns and Rows
• Search for and Replace Data
• Insert, Delete and Adjust Cells, Columns and Rows – Introduction
• Use Proofing and Research Tools
• Check the Spelling in a Worksheet
• Search for and Replace Data – Introduction
• Insights Task Pane

Formatting a Worksheet

• Apply Text Formats – Introduction
• Apply Text Formats
• Apply Number Formats – Introduction
• Apply Number Formats
• Align Cell Contents – Introduction
• Align Cell Contents
• Apply Cell Styles and Themes
• Apply Cell Styles and Themes – Introduction
• Create and Use Templates – Introduction
• Apply Basic Conditional Formatting – Introduction
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks

• Preview and Print a Workbook
• Configure and Preview a Print Job
• Set Up the Page Layout – Introduction
• Set Up the Page Layout
• Configure Headers and Footers – Introduction
• Configure Headers and Footers

Managing Workbooks

• Manage Worksheets – Introduction
• Manage Worksheets
• Manage Workbook and Worksheet Views – Introduction
• Manage Workbook and Worksheet Views
• Manage Workbook Properties – Introduction
• Manage Workbook Properties