one-day Microsoft Excel Intermediate Training
Course builds on the skills and concepts taught in Excel 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.
and most UK locations.
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
Using special number formats
Working with themes
Other advanced formatting
Outlining and subtotals
Outlining and consolidating data
Cell and range names
Creating and using 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
Documenting and auditing
Comments in cells and workbooks
Application settings and templates
Working with templates
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 the Excel: Foundation
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 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.
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)
One click forecasting
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
Improved version history
Data Loss Protection (DLP) in Excel
New Financial Templates
Take an Excel 2016 course to discover more!