100 megs data gift for every genuine quote requested
Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment.
In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.
This hands-on training course is available now Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
The Excel beginner training course is tailored to students wanting to gain a solid understanding of creating spreadsheets from scratch utilising real-world, practical examples.
Participants may be new to Excel or self-taught users wanting to enhance their current knowledge and skill sets.
We start by examining the Excel environment and then move on to data entry, selection techniques, creating formulas, managing data in a spreadsheet, formatting and finish with page setup and printing techniques.
This training course provides an excellent foundation of all the essential Excel functionality people may be required to utilise on a day to day basis.
Learning Outcomes - Microsoft Excel 2016 Beginner Training Course
The Microsoft Excel 2016 Beginner Training Course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.
After completing this course, participants will have learned to:
- Get started with Microsoft Office Excel 2016.
- Perform calculations.
- Modify a worksheet.
- Format a worksheet.
- Print workbooks.
- Manage workbooks.
Course Content - Microsoft Excel 2016 Beginner Training Course
Lesson 1: Getting Started with Microsoft Office Excel 2016
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties