Excel - Excel Essentials and Formulas

1 Days

6 CPD hours

To ensure success, students 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 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 analyse the data that is critical to the success of your organisation.

This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.

Getting Started with Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter and Edit Cell Data
• Fill Cells with Series of Data (AutoFill and Flash Fill)
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas
• Insert Functions and use Autocomplete
• Reuse Formulas and Functions
• Create an Absolute Reference

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Move and Copy Data between Cells
• Search for and Replace Data
• Use Spellcheck and Proofing

Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply and Copy Cell Styles
• Apply Basic Conditional Formatting

Printing Workbooks

• Preview and Print a Workbook
• Controlling Page Layout
• Adding Headers and Footers
• Set Print Titles and Print Ranges

Managing Workbooks

• Manage Worksheets
• Insert and Delete Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties