Microsoft Excel Level 1
Overview
This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open, close and save files, how to enter a simple formula into a cell, and format a spreadsheet. You’ll learn how to use the most important features of Excel.
Course Objectives
If you’re new to Excel or are going to be using Excel in the future, you’ll need to understand the fundamentals. This course will provide you with a solid platform from which you can start. By completing this course, you’ll save yourself a lot of time when using Excel.
Content
INTRODUCTION
- Creating a blank Workbook
- Looking at the Interface
- Quick Access Toolbar
- Using Help
NAVAGATION AND DATA ENTRY
- Moving through Cells and Sheets
- Selecting a Range of Cells
- Inserting, Renaming and Deleting Worksheets
- Entering constant values
- Using Autofill
- Saving a Workbook
- Opening and closing existing files
- Editing Cell content
- Working with Undo and Redo
- Copy, Cut and Paste
- Inserting and deleting Rows and Columns
FORMATTING
- Formatting Numbers, Dates and Text
- Applying Cell Borders
- Changing Alignments, Font Size, Type And Colour
- Merge and Wrap features
FORMULA
- Calculations using Operators: + – */
- Simple daily Functions: SUM, AVERAGE, COUNT, MAX, MIN
- Absolute and Relative References
LISTS
- Sorting Lists
- Filtering Lists
- SUBTOTAL Function
PAGE SETUP
- Headers and Footers
- Printer setup
Course summary video
You will learn how to
- Open, save and close workbooks
- Work with multiple sheets
- Enter and edit data in cells
- Change format types of cells
- Create simple formula using operators and cell references
- Create more advanced formula using daily functions such as SUM
- Work with long lists of data with sort and filter features
- … and much more
Audience
No prior knowledge is needed. Complete beginner. Software is provided for use in the Classroom and Live Virtual options.
Duration
1 Day or 2 x 3 Hour Sessions
Contact Us
We’ll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.