Excel 2016 – Level 1

Foundation skills


Overview

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 formula into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel.

Aims

Why take this course?

If you’re new to Excel 2016 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.

Audience

Who would benefit?

Anyone needing to learn how to use Excel 2016 or those familiar with other spreadsheet programs 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.


Course preview

Each course contains high quality, professional video lessons, downloadable exercise files and real-world templates for you to use.

Excel 2016 Level 1 - Intro
Simple interface
Excel 2016 Level 1 - Demo
Video lessons
Excel 2016 Level 1 - Download
Downloadable content

Course detail and sample lessons

Section 1: Start Up and Interface

Lesson 1: Opening Microsoft Excel
View Demo
Lesson 2: The Interface
View Demo
Lesson 3: Quick Access Toolbar
Demo Not Available
Lesson 4: Tabs and Ribbons
Demo Not Available
Lesson 5: Formula Bar
Demo Not Available
Lesson 6: The Workbook
Demo Not Available
Lesson 7: Status Bar
Demo Not Available
Lesson 8: Saving and Closing Excel
Demo Not Available

Section 2: Formatting a Worksheet

Lesson 1: Inserting and Editing Cell Contents
View Demo
Lesson 2: Editing Height and Width
View Demo
Lesson 3: Inserting and Deleting Rows/Columns/Cells
Demo Not Available
Lesson 4: Organise Sheets
Demo Not Available
Lesson 5: Hiding and Unhiding
Demo Not Available

Section 3: Formatting Cell Contents

Lesson 1: Formatting Font
View Demo
Lesson 2: Alignment of Contents
View Demo
Lesson 3: Merge and Centre
Demo Not Available
Lesson 4: Cell Styles
Demo Not Available
Lesson 5: Formatting Numbers
Demo Not Available
Lesson 6: Formatting Currency
Demo Not Available
Lesson 7: Formatting Dates
Demo Not Available
Lesson 8: Formatting Percentages
Demo Not Available
Lesson 9: Clear All Formatting
Demo Not Available

Section 4: Editing a Cell

Lesson 1: In Cell Editing
View Demo
Lesson 2: Formula Bar Editing
View Demo
Lesson 3: Cut, Copy and Paste
Demo Not Available
Lesson 4: Format Painter
Demo Not Available
Lesson 5: Find & Select
Demo Not Available
Lesson 6: AutoFill with Text
Demo Not Available
Lesson 7: AutoFill with Numbers
Demo Not Available
Lesson 8: AutoFill with Dates
Demo Not Available

Section 5: Basic Formula

Lesson 1: Operators
View Demo
Lesson 2: Sum
View Demo
Lesson 3: Average
Demo Not Available
Lesson 4: Max
Demo Not Available
Lesson 5: Min
Demo Not Available
Lesson 6: Count Functions
Demo Not Available
Lesson 7: Round
Demo Not Available
Lesson 8: Use of AutoSum
Demo Not Available

Section 6: Working with Lists

Lesson 1: Applying a Sort
View Demo
Lesson 2: Applying a Filter
Demo Not Available
Lesson 3: Flash Fill
Demo Not Available
Lesson 4: Text to Column
Demo Not Available

Section 7: Inserting Objects

Lesson 1: Pictures
View Demo
Lesson 2: Text Boxes
Demo Not Available
Lesson 3: Creating a Chart
Demo Not Available
Lesson 4: Basic Editing of a Chart
Demo Not Available
Lesson 5: Hyperlinks
Demo Not Available

Section 8: Printing Options

Lesson 1: Print Preview
View Demo
Lesson 2: Scale to Fit
Demo Not Available
Lesson 3: Editing Margins & Orientation
Demo Not Available
Lesson 4: Print Titles, Gridlines & Headings
Demo Not Available
Lesson 5: Print One Sheet and Multiple Sheets
Demo Not Available


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 organize 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

Certification

When you pass you will receive an internationally recognized accreditation certificate like this:

IACT_Apprentice (1)


What’s next?

Upon completion, you can move onto Excel 2016 – Level 2, then Excel 2016 – 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.