What you'll learn:
- Learn common terms used in Excel and spreadsheets
- Learn how to work with cells, columns and rows
- Understand Autofill and Flash Fill options and how to use them
- Learn how to cut, copy and paste
- Learn how to format data
- Learn how to set print options
- Learn how to change views
- Learn how and when to insert tables
- Learn how to insert charts
- Learn how to change chart elements
Excel is the spreadsheet tool of choice for over 750 million people. Originally designed around the red books used by accountants with columns and rows, it was used to store information and carry out basic calculations. Now Excel is used for way more than that. Not only is it a powerful calculation tool and record keeper but it is also a tool for reporting and analysing.
With so many features and functions available getting started with Excel can be daunting to many. However, it doesn’t have to be difficult to learn Excel and this course is designed to take you step by step through the Basics of Excel.
By the end of this course, you will be comfortable navigating an Excel workbook, entering and formatting data, setting print options, inserting objects to a worksheet and much more.
This course is made up of 4 modules
Module 1 – Your First Look at Excel
Getting started with Excel can be daunting for many. There is so much to learn and knowing where to start can be difficult. What is a cell? What is the formula bar? Don’t you use ribbons for your hair? If all this jargon is foreign to you, don’t feel alone. We are here to help. This module is aimed at those looking at Excel for the first time.
By the end of this module you will be able to
· Open and Save Workbooks
· Navigate the Ribbons to find commands you need
· Enter Data and formulas
· Navigate a workbook and select data
· Edit the quick access toolbar
Excel is equipped with many tools to help you work with data. Basic tools, such as autofill can reduce the time you spend entering data, Sort and filter will allows you quickly find and work with contents of a worksheet with ease and formatting will allow you present your report in an easy to understand way. Learning to modify your data with these basic tools
By the end of this module you will be
· Comfortable using Autofill
· Know how to cut, copy and paste
· Have the ability to sort and filter data
· Able to present your data in a formatted Style
Module 3 – Print and View Options
There is nothing worse than receiving a workbook prepared by someone else only to print it and find the print options have not been adjusted. Before you print a workbook or worksheet or before you share the workbook with someone else that may print it, you should always check to ensure print options are set correctly. By the end of this module you will be able to
· Preview and print
· Adjust page, margin and sheet options for printing
· Insert Headers and Footers
· Freeze panes
· Switch between different views available in Excel
Module 4 - Insert Options
Excel gives you the ability to insert picture, shapes, tables, charts, slicers and many other features that enhance the view and user functions of your workbooks and worksheets. Tables are often used to quickly summarize data along with charts, slicers and sparklines. By the end of this module you will be comfortable
· Inserting and format pictures and shapes
· Inserting tables
· Inserting and formatting charts
· Using slicers, timelines and sparklines
