This course is delivered over 1 full-day at our training centre in Twigworth. Building on the regular user’s skills, this course will demonstrate use of macros, merging of data with existing databases, complex questioning styles and data mapping. Designed for the high level user who wants to design custom interfaces and act as an administrator for other colleagues, this course will release the enormous potential of Excel.
Want to run this event in-house? Enquire about running this event in-house
Description
Course Outline:
After this course delegates will be able to:
- Create and utilise custom templates and styles
- Import data from external sources and automate routines to save time
- Fully customise the desktop to display preferred toolbars and pull-down menus
- Record and write VBA macros to automate tasks
- Design complex user interfaces
- Enable and secure worksheets and cells from other users
- Use data maps to add graphical & statistical information across countries and continents
- Create Pivot tables and Pivot Charts
- Use consolidation on data rows and columns
- Design complex queries to select specific data
- Use auditing tools to trace routes of calculations
Why Should You Attend?
Excel is probably the most powerful programme in the Microsoft Office suite. It is also the most flexible and adaptable as its uses range from finance management to process performance to statistical analysis to data presentation and more. Excel really is a great piece of software and beneath the surface lies a whole range of tools, techniques, hints and tips, time-saving devices and ways of being more accurate that you can ever imagine. After this day, you will never look at Excel in the same way again!
Who Should Attend?
If you want to take your understanding of spreadsheets to the very highest levels and make the software do what you want it to do, then this is the course for you. You should be confident with the basic and intermediate functions of Excel, including data entry, working with multiple sheets, and equally as confident with the Windows interface.
Related Courses:
Understanding Organisational Finance
