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
How long is this course?
What do I need to know before attending?
Delegates should have attended the Microsoft Excel Intermediate course or have the equivalent skills and knowledge to that level.
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
- Use more Excel functions.
- Utilise Excel's database functions.
- Control and enhance Excel graphs.
- Create simple macros.
- Customise your Excel environment.
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.
Protecting Files, Cells, Worksheets and Workbooks.
Creating & editing templates.
Goal Seek and Solver.
Changing Microsoft Excel's default settings.
Customising menus and toolbars and assigning macros to new buttons.