This one-day course teaches the basic functions and
features of Excel. 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
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
Topics covered will vary slightly depending upon the version you are using, e.g. 2010, 2013, 2016, 2019 or 365.
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 Foundation, Excel Intermediate, Excel Advanced and Excel Power User.
Topics covered will vary slightly depending upon the version of Excel you are using, e.g 2007, 2010, 2013, 2016, 2019 or 365.
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function
Also new in Excel 365: Create a diagram in Excel 365 with the Visio Data Visualizer add-in
Excel 2016 for Windows has all the functionality and features you're used to with some added features and enhancements and the best new features from Office 2016. Here are some of the top new and improved features for Excel 2016:
Six new chart types
Get and transform (Query)
New Functions
One click forecasting
3D Maps
PivotTable enhancements
Publish and share your analysis with Power BI
Quick Shape Formatting
Insert pictures with the correct orientation
Do things quickly with Tell Me
Insights into what you're working on
Ink Equations
Simpler sharing
Improved version history
New themes
Data Loss Protection (DLP) in Excel
New Financial Templates
Take an Excel course to discover more!
Contact us for further information, to check available dates or to book a course.