Excel Level 1
What does the course cover?
This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open and close files, how to enter formulae into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel.
Why take this course?
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 learn. By completing this course, you’ll save yourself a lot of time when using Excel.
Who should attend?
Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes but new to Microsoft Excel, or anyone who has not used the product for a period of time. If you’re about to start a new role, or are looking for a new position, this course is ideal.
Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.
Course detail and sample lessons
Section 1: Introduction to Excel
Lesson 4: Entering and Editing Data
Lesson 5: Saving a Wordbook as an .XLSX
Lesson 6: Saving a Workbook in a different file format
Lesson 7: Closing a Workbook
Lesson 8: Setting Excel File Defaults
Section 2: Selecting Cells and Ranges
Lesson 2: Selecting Cells, Rows and Columns
Lesson 3: Moving, Copying and Deleting Cells
Lesson 4: Using Undo and Redo
Lesson 5: Finding and Replacing Values
Lesson 6: Spell checking a spreadsheet
Section 3: Modifying a Worksheet
Lesson 2: Inserting, Deleting and Renaming a worksheet
Lesson 3: Worksheet Views
Lesson 4: Clearing and Deleting Cells
Lesson 5: Inserting and Deleting Rows and Columns
Lesson 6: Modifying Column and Row Size
Lesson 7: Freezing and Unfreezing Rows and Columns
Section 4: Formatting Cells and their Contents
Lesson 2: Formatting cells using the font group
Lesson 3: Changing cell alignments
Lesson 4: Formatting numbers and dates
Lesson 5: Cell Borders and Patterns
Lesson 6: The Format Painter
Section 5: Building Simple Formula
Lesson 2: Basic Operators
Lesson 3: Using the SUM function
Lesson 5: Using the AVERAGE function
Lesson 6: Using the COUNT function
Lesson 7: Using the MAX function
Lesson 8: Using the MIN function
Lesson 9: Using the ROUND function
Lesson 10: Using the IF function
Lesson 11: Common formula errors
Section 6: Absolute and Relative Referencing
Lesson 2: Using the AutoFill Tool
Lesson 3: Relative Referencing
Lesson 4: Absolute Referencing
Section 7: Sorting Data
Section 8: Charts and Graphs
Lesson 2: Inserting and Deleting a chart
Lesson 3: Moving and Resizing a Chart
Lesson 4: Editing the Chart type
Lesson 5: Chart Layouts and Labels
Lesson 6: Editing the Axes and Gridlines
Lesson 7: Formatting Selected Items in a chart
Lesson 8: Printing a Chart
Lesson 9: Special Features for Pie Charts
Section 9: Importing Text and Graphics
Lesson 2: Inserting Images onto an Excel Sheet
Lesson 3: Importing Text Files (*.TXT)
Section 10: Printing and Page Setup
Lesson 2: Excel Sheet Views and Inserting Headers & Footers
Lesson 3: Settings in Page Setup
Lesson 4: Scaling our Data for Printing
Section 11: Using help in Excel
Lesson 2: Using the HELP function in Excel
Skills you’ll learn
What you’ll be able to do after the course
- Start Excel and understand key terminology
- Navigate your way around a spreadsheet
- Open, Save and Close workbooks
- Select cells, rows and columns
- Build simple formulas
- Sort and organise data
- Import data from other applications
- Perform “what-if” analysis
How you can apply these skills
What you’ll be able to use these skills for
- Create a wide range of powerful spreadsheets
- Calculate expenses
- Design budgets
- Create invoices
- Perform sales analysis
- Create and enhance interesting charts
- Print and export into presentations
- Use Excel to complete previously manual tasks
When you pass you will receive an internationally recognised accreditation certificate like this:
Upon completion, you can move onto Excel Level 2
, then Excel Level 3
. After you have completed the three levels you will be ready to take iactonline’s Expert and Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.
Careers that require these skills at this level?
Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee.