This one-day course builds on the skills and concepts
taught in Excel 2013: Intermediate.
Students will
work with advanced formulas, as well as lookup functions
such as VLOOKUP, MATCH, and INDEX. In addition, students
will learn about data validation and database functions
such as DSUM. They will learn how to work with
PivotTables and PivotCharts, how to import and export
data, and how to query external databases. Finally,
students will learn about the analytical features of
Excel (such as Goal Seek and Solver), running and
recording macros, and sharing Excel data via the Web.
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:
Advanced functions and formulas
Logical functions
Conditional functions
Financial functions
Text functions
Date and time
functions
Array formulas
Calculation options
Lookups and data tables
Using lookup
functions
Using MATCH and INDEX
Creating data tables
Advanced data management
Validating
cell entries
Advanced filtering
Advanced charting
Chart formatting
options
Combination charts
Graphical objects
PivotTables and PivotCharts
Working with
PivotTables
Modifying PivotTable data
Formatting PivotTables
Using
PivotCharts
PowerPivot
Exporting and importing data
Exporting
and importing text files
Getting external
data
Analytical tools
Goal Seek
Scenarios
Instant data analysis
Macros and Visual Basic
Running and
recording a macro
Working with VBA code
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 following courses or
have equivalent experience: Excel 2013: Basic and Excel
2013: Intermediate.
You should have some experience
with Excel 2013 and should be familiar with
intermediate-level tasks, such as sorting data, linking
worksheets, and outlining and consolidating data. You'll
get the most out of this course if your goal is to
become proficient in performing advanced tasks, such as
creating nested functions, working with data tables,
exporting and importing data, performing what-if
analyses, and recording macros.
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.
Microsoft Excel 2013 Power User
Excel VBA
Contact us for further information, to check available dates or to book a course.