Excel 2013 – 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 2013 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 2013 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 2013 Level 1 - Intro
Simple interface
Excel 2013 Level 1 - Demo
Video lessons
Excel 2013 Level 1 - Download
Downloadable content

Course detail and sample lessons

Section 1: Introduction To Excel

Lesson 1: Introduction
View Demo
Lesson 2: Starting Microsoft Excel
View Demo
Lesson 3: Starting From A Blank Workbook
Demo Not Available
Lesson 4: Exploring The Interface
Demo Not Available
Lesson 5: The Quick Access Toolbar
Demo Not Available
Lesson 6: Saving A Workbook
Demo Not Available
Lesson 7: Closing And Reopening A Saved Workbook
Demo Not Available
Lesson 7: Start Using A Built In Template
Demo Not Available
Lesson 8: Exiting Excel
Demo Not Available

Section 2: Inserting Data

Lesson 1: Introduction
View Demo
Lesson 2: Inserting Text Into A Cell
View Demo
Lesson 3: Formatting The Font
Demo Not Available
Lesson 4: The Alignment Of Your Text
Demo Not Available
Lesson 5: Merging And Wrapping Cells
Demo Not Available
Lesson 6: Inserting And Formatting Numbers
Demo Not Available
Lesson 7: Inserting And Formatting Dates
Demo Not Available
Lesson 8: Currency Options
Demo Not Available
Lesson 9: Clear Options
Demo Not Available
Lesson 10: Inserting A Picture
Demo Not Available

Section 3: Rows, Columns & Sheets

Lesson 1: Introduction
Demo Not Available
Lesson 2: Insert & Delete Rows/Columns
Demo Not Available
Lesson 3: Change The Widths And Heights
Demo Not Available
Lesson 4: Hide And Unhide Rows/Columns
Demo Not Available
Lesson 5: Inserting & Deleting Sheets
Demo Not Available
Lesson 6: Rename & Move Sheets
Demo Not Available
Lesson 7: Hide And Unhide Sheets
Demo Not Available

Section 4: Autofill

Lesson 1: Introduction
Demo Not Available
Lesson 2: Using Autofill With Text
Demo Not Available
Lesson 3: Using Autofill With Numbers
Demo Not Available
Lesson 4: Using Autofill With Dates
Demo Not Available
Lesson 5: Flash Fill
Demo Not Available

Section 5: Sorts & Filters

Lesson 1: Introduction
Demo Not Available
Lesson 2: Sorting Data By One Column
Demo Not Available
Lesson 3: Sorting Using Multiple Columns
Demo Not Available
Lesson 4: Table Style
Demo Not Available
Lesson 5: Filters
Demo Not Available

Section 6: Introduction To Formula

Lesson 1: Introduction
Demo Not Available
Lesson 2: Operators
Demo Not Available
Lesson 3: The Sum Function
Demo Not Available
Lesson 4: The Average Function
Demo Not Available
Lesson 5: The Max Function
Demo Not Available
Lesson 6: The Min Function
Demo Not Available
Lesson 7: The Count Function
Demo Not Available
Lesson 8: The Status Bar And Formula Summary
Demo Not Available

Section 7: Page Layout And Printing

Lesson 1: Introduction
Demo Not Available
Lesson 2: Scale To Fit
Demo Not Available
Lesson 3: Margins
Demo Not Available
Lesson 4: Orientation
Demo Not Available
Lesson 5: Print Titles
Demo Not Available
Lesson 6: Print Area
Demo Not Available
Lesson 7: Print Grid & Headings
Demo Not Available

Section 8: Basic File Options

Lesson 1: Introduction
Demo Not Available
Lesson 2: What Is Onedrive
Demo Not Available
Lesson 3: Saving To Onedrive
Demo Not Available
Lesson 4: Saving A File As A PDF File
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 2013 – Level 2. After you have completed the two 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.