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.
After completing this course, students will know how to:
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
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.
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 with supporting exercise files
will be provided and delegates will find this valuable for further study, revision and reference.
For comprehensive training,
you should complete all of the following courses: Excel
2013: Basic, Excel 2013: Intermediate, and Excel 2013:
Advanced.
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.