This course introduces delegates to the basic functions of Microsoft Excel and will enable them to create worksheets and perform formatting and functions within the worksheet.
TARGET AUDIENCE:
This course is designed for people who wish to gain the skills necessary to create, edit, format and print basic Microsoft Excel worksheets.
COURSE PREREQUISITES:
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs, navigate to information stored on the computer, and manage files and folders.
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses. Delegates may notice differences in their software if using a MAC.
COURSE CONTENT:
•
Getting started with Excel
•
Selection techniques
•
Manipulating rows and columns
•
Manipulating Worksheets
•
Font formatting
•
Alignment formatting
•
Number formatting
•
Basic Formulas
•
Basic Functions
•
Basic Charts
COURSE OBJECTIVE:
By actively participating in this course, you will learn about the following:
•
Navigate the Excel programme.
•
Perform selection, manipulation and formatting techniques.
•
Understand and create basic formulas and functions.
•
Understand and create basic charts.
FOLLOW ON COURSES:
MSEXL2 – Microsoft Excel Level 2MSEXL3 – Microsoft Excel Level 3MSEXL4 – Microsoft Excel Level 4MSEXVBAP1 – Microsoft Excel VBA Part 1MSEXVBAP2 – Microsoft Excel VBA Part 2