Microsoft Excel 2013 Foundation Training Course

This one-day course teaches the basic functions and features of Excel 2013. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Delivered in Dundee,  Aberdeen,  Edinburgh,  Stirling,  Glasgow,  Fife,  London,  Aberdeenshire,  Angus,  Perth and most UK locations.
Contact us for further details.

Course objectives

After completing this course, students will know how to:

1. Recognise spreadsheet terminology; start Microsoft Excel and identify the components of the Excel interface; create a blank workbook; navigate worksheets; and open a downloaded template.
2. Enter and edit text and values; use AutoFill; enter formulas and examine the order of operations; save and update a workbook; and save a workbook in different file formats.
3. Move and copy data; use the Office Clipboard; move and copy formulas; use AutoFill to copy formulas; use Paste Link; view formulas; work with relative and absolute references; and insert and delete ranges, rows, and columns.
4. Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.
5. Format text, cells, rows, and columns; merge cells; apply color and borders; format numbers; create conditional formats; use the Format Painter; and use Find and Replace to update the formatting for specific content.
6. Create, format, modify, and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles.
7. Insert and modify a picture; represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales, and icon sets); and insert and modify SmartArt graphics.
8. Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.

Course contents

Getting started
Spreadsheet terminology 
The Excel environment 
Navigating a worksheet 
Using a template 

Entering and editing data
Entering and editing text and values 
Entering and editing formulas 
Saving and updating workbooks 

Modifying a worksheet
Moving and copying data 
Moving, copying, and viewing formulas 
Absolute and relative references 
Inserting and deleting ranges, rows, and columns 

Functions
Entering functions 
AutoSum 
Other common functions 

Formatting
Text formatting 
Row and column formatting 
Number formatting 
Conditional formatting
Additional formatting options 

Charts
Chart basics 
Formatting charts 

Graphics
Working with pictures 
Conditional formatting with graphics 
SmartArt graphics 

Printing
Preparing to print 
Page Setup options 
Printing worksheets 

Prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed a Windows Basic course or have equivalent experience.

Target Audience

The target student for this course should be comfortable using a personal computer and Microsoft Windows. You should have little or no experience using Microsoft Excel or any other spreadsheet program. You will get the most out of this course if your goal is to become proficient in using Microsoft Excel to create simple worksheets and charts for internal reports and data tracking.

Courseware

Courseware with supporting exercise files will be provided and delegates will find this valuable for further study, revision and reference.

Certification Track

For comprehensive training, you should complete all of the following courses: Excel 2013: Basic, Excel 2013: Intermediate, and Excel 2013: Advanced.

What's New in Excel 2013

The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.

Top features to explore

Get started quickly
Templates do most of the set-up and design work for you, so you can focus on your data. Excel 2013 has new templates for budgets, calendars, forms, and reports, and more are on the way.


Instant data analysis
The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less. Preview data enhancements like conditional formatting, sparklines, or charts, make it stick in just one click.


Fill out an entire column of data in a flash
Flash Fill is like a data assistant that finishes your work for you. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data.


Create a chart that’s right for your data
Find the best way to visualise your data in a chart by using Chart recommendations. Excel 2013 recommends the most suitable charts based on your data. Get a quick peek to see how your data appears in the different charts, and then simply pick the one that shows the insights you want to present. Give this feature a try when you create your first chart.


Filter table data by using slicers
First introduced in Excel 2010 as an interactive way to filter PivotTable data, slicers can now also be used to filter data in Excel tables, query tables, and other data tables. Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at.

Take an Excel 2013 course to discover more!

Contact us for further information, to check available dates or to book a course.