This course aims to provide a foundation for Excel 2016 knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Cost: Price on application
Duration: 1 day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
To ensure success, participants will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to use Windows to manage information on their computers.
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
Get started with Microsoft Office Excel 2016.
Modify a worksheet.
Format a worksheet.
Getting Started with Microsoft Office Excel 2016 :
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations :
Create Worksheet Formulas
Reuse Formulas and Functions
Modifying a Worksheet:
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a Worksheet :
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Printing Workbooks :
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing Workbooks :
Manage Workbook and Worksheet Views
Manage Workbook Properties