Intermediate Excel - Data Management & Add-In's
Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information. Excel has more bells and whistles than any version before it, and can be daunting for a novice user.
There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you.
Book your virtual training
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
wherever they are based - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
Book your place
- There are no public, Worcester-based events for this course scheduled at the moment, but you can contact us to request a date or call 0800 018 5597
- Request dates at
Worcester Training Centre
This course will introduce you to Excel and give you the skills to use the program every day as well as the knowledge of advanced functions and features.
Super users that will be responsible for not only using Excel themselves for also training their colleagues on how to make the most of the application.
- Create and customise workbooks in Excel.
- Use Excel as a day to day user.
- Present data graphically.
- Create Pivot tables and graphs.
- Use Excel functions and formulae for mathematical processes and automation.
- Program Excel using Visual Basic.
This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.
An in-depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.
- Managing large datasets
- Grouping
- Outlining
- Subtotalling
- Scenario Manager
- Data analysis ToolPak
- Correlation Analysis
- Predictive modelling
- Solver
There are no prerequisites for this course though a basic knowledge of Microsoft Office would be advantageous.