Course Methodology
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. This course aims to teach individuals how to easily monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. In addition, hands-on practical would be carried out to solidify participants’ training.

Course Objectives
By the end of this course, participants should be able to:

• Create and manage worksheets and workbooks
• Manage data cells and ranges
• Create tables
• Perform operations with formulas and functions
• Create charts and objects

Target Audience
Managers, Senior Supervisors and Professionals who want to learn the basic to intermediate excel skills.

Target Competencies

• Managing performance
• Multi-tasking skill
• Analytical skill
• Coaching skill

Course Outline

Exploring Excel

• Finding and using commands
• Moving around a worksheet
• Navigating the workbook

Basic Workbook Skills

• Creating a workbook
• Selecting cells and ranges
• Opening, closing and saving workbooks

Creating Simple Formulas

• Writing formulas in cells
• Using the formula bar
• AutoSum and other basic functions

Managing Worksheets

• Naming worksheets
• Copying and moving worksheets
• Grouping worksheets
• Moving data between sheets

Formatting Data and Cells

• Formatting numbers
• Formatting texts
• Colouring data and cells
• Wrapping and shrinking texts
• Merging cells
• Using indents

Working with Columns and Rows

• Selecting columns and rows
• Changing column width and row height
• Hiding and unhiding
• Inserting and deleting

Using Large Spreadsheets

• Changing the magnification
• Full screen view
• Splitting the window
• Using freeze panes

Working with Data Series

• Creating a linear series
• Working with date series
• Using Autofill

Customize Your Training
This training solution and other training topics from Nosak Group are currently available as a residential/in-house option. It can be customized for your team/organisation at your preferred location.