Who is this course for?
With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work
Working with range names.
Working with and consolidating multiple sheets.
Further use of Excel functions such as conditional IF and Lookup.
Working with Text
Text Functions and Text Import.
Graphs and Charts
Different graph styles, creating, enhancing and editing graph.
Printing independently or as part of the spreadsheet.
Creating Excel databases.
Accessing data by sorting and filtering data.
Producing summary statistics.
Cross tabulation using Pivot tables.
Specific database functions.
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.
Object Linking & Embedding
Embedded Objects and Linking Objects.
Goal Seek and Solver.
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
It is assumed only that you have a skill level equivalent to that gained through attending the Excel Intermediate Course.
This course has been specifically designed for companies training their employees.
Where do you want to study this course?
Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside
During the day or In the evening
Customised to suit your needs
Certificate of Attendance
This course currently has no reviews.Write a review
Ask a question