Become a data expert with our Excel courses
You have used Excel to perform tasks such as running calculations on data, sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel, by automating some common tasks, applying advanced analysis techniques to more complex data sets such as Pivot Tables, collaborating on worksheets with others, importing and exporting data using Power Views.
Why is it crucial to train your employees?
Delegates should already have a good working knowledge of Excel (one way to achieve this would be to attend our one-day Excel Core course).
By the end of this course, delegates will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.
Attending delegates will be presented with a Certificate of Attendance upon completion of training.
We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our attendees and can be applied directly in the training. Therefore, our training methodology is to customize our courses using our effective and efficient proprietary customizing process and tools. We incorporate participants’ real-world challenges, sales tools, and processes into developing cases/exercises.
- Manage and Share Workbooks
- Modifying workbook templates
- Tracking Changes
- Properties VS Metadata
- Merging Workbooks
- Apply Custom Formats and Layouts
- Using Advanced Fill Series options
- Creating Advanced Filters
- Creating Themes
- Creating Form Fields
- Creating Custom Templates
- Create Advanced Formulas
- Creating dual-axis charts
- Creating Slicers
- Using PowerPivot
- Manipulating options in exiting Pivot Charts
Holistic Technologies runs scheduled courses during the year, which are open to the general public, this could be the perfect training and development solution for companies and firms which have only individuals to train and not a whole team or department.
On-Site training is a flexible, cost-effective option that allows you to train as many or as few employees as you need from a single team or department to everyone in your organisation. On-Site training courses can be delivered “off-the-shelf”, slightly modified or completely customized to your learning needs. They’re designed to meet your most important goals and produce immediate, measurable results.
The most effective way to achieve instant productivity is undoubtedly One to One training. Sessions are individually planned and prepared by an expert trainer who will have considerable experience of your industry. Whether you are starting from scratch, or merely looking to master the more advanced features of one of the Microsoft Office Applications, individual training is the answer for users who want to be more productive.