This one-day Microsoft Excel 2013 Intermediate
Training Course builds on the skills and concepts taught
in Excel 2013: Basic. Students will learn how to use
multiple worksheets and workbooks efficiently, and they
will start working with more advanced formatting options
including styles, themes, backgrounds, and watermarks.
They will also learn how to create outlines and
subtotals, how to create and apply cell names, and how
to work with lists and tables. Students will save
workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers
worksheet auditing and
protection, file sharing and merging, and workbook templates.
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:
Managing workbooks and worksheets
Viewing large worksheets
Printing large
worksheets
Working with multiple
worksheets
Linking worksheets with 3-D
formulas
Using multiple workbooks
Linking workbooks
Advanced formatting
Using special number formats
Working with themes
Other advanced
formatting
Outlining and subtotals
Outlining and consolidating data
Creating
subtotals
Cell and range names
Creating and using names
Managing names
Data structure and tables
Sorting and
filtering data
Working with tables
Introduction to PivotTables and PivotCharts
Creating a PivotTable
Creating a PivotChart
Web and sharing features
Saving workbooks
as Web pages
Using hyperlinks
Documenting and auditing
Auditing features
Comments in
cells and workbooks
Protection
Workgroup collaboration
Application settings
and templates
Application settings
Working with templates
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 the Excel 2013: Basic
course or have equivalent experience.
Beforetaking this course, you should be comfortable using a personal computer and Microsoft Windows. You should have some experience using Microsoft Excel. You will get the most out of this course if your goal is to become proficient in such tasks as consolidating data, sorting and filtering lists, using special formatting options, using templates, using error tracing features, protecting worksheets, and linking worksheets and workbooks.
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.
Contact us for further information, to check available dates or to book a course.