EXCEL & ACCESS TRAINING
MICROSOFT OFFICE TRAINING
Adapt will help you to gain the skills you need to feel confident using Excel. I have found that many people don’t like to use it as they don’t understand it, but after some training realise it is not as complicated as they thought. The training will be tailored to your needs and will allow time for you to put into practice what you have been taught.
I also can provide training in Excel VBA, which is a programming tool that enables regular processes to be automated, and Excel Powerpivot, which is a database add-on in Excel. Before any training starts we would discuss your requirements and what you want to achieve, so that it is tailored to your needs. Word and Powerpoint training can also be provided.
EXCEL TRAINING
Adapt training and consultancy will provide an Excel spreadsheet training that will be tailored for your needs, right from beginners to expert. Examples of typical areas covered:
- Formulas Absolute References
- Pivot Tables
- Charts
- Named Ranges
- Conditional Formatting
- Database Functions
- Importing Data
MICROSOFT ACCESS TRAINING
Microsoft Access ia a database tool which is better at processing large amounts of data than Excel. You can use it to gather, navigate, filter and report on your data. The training course will explain how to create your tables, link them together and ask questions of your data (write queries). The course will be tailored to your needs. Examples of typical areas covered:
- Planning your database
- Creating Tables
- Data Enrty Rules
- Creating Relationships
- Creating Queries
- Calculated Fields
- Creating Lookups
- Forms and Reports
- Importing and Exporting Data
BUILDING SPREADSHEETS
Building Spreadsheets Adapt training and consultancy will provide assistance in creating or improving your spreadsheets so that they are easy to update/maintain.
If you are struggling to update and maintain your spreadsheets, or just struggling to make changes to one, then I can help you to do this, to end your frustration and make it less of a chore.
I can help you do more with your spreadsheets. If you have data and would like to have charts or KPI’s or summary pages that help you can monitor your business, then I can work with you to help you achieve this and make sure that you know how to update or change it yourselves in the future. I can also help with adding Macros to your spreadsheet to automate processes (known as Excel VBA).
No job is too big or small. If you would like to know more please contact me for a quote. I charge £40 per hour.
(This can be broken down to £10 per 15 mins for smaller jobs.)
EXCEL VBA TRAINING
Excel VBA (Visual Basic for Applications) is a programming language that works alongside Excel. If you have regular monthly, weekly, daily processes that follow similar steps, you could write VBA code to automate and speed up these processes.
Adapt Training and Consultancy will provide you with training to help you speed up your spreadsheets and processes. Examples of areas covered:
- Recording a macro
- Assigning buttons to macros
- Editing Macros
- Input and Message boxes
- Understanding Variables
- Functions
- Loops
- Forms
- Error Handling
Price of this training is £40 per hour.
EXCEL POWERPIVOT TRAINING
Excel Powerpivot is a new tool in Excel (since Office 2010) which enables you to link data from multiple sources and perform advanced data analysis. It provides you with self-service business inteligence.
Adapt Training and Consultancy will provide you with training to help you do more with your data. Examples of areas covered:
- Importing and linking data
- Creating calculated columns
- Grouping data
- Adding slicers
- Filtering data
- Functions
- Powerpivot charts and dashboard
- Creating calculated fields
- Powerpivot sets
Price of this training is £40 per hour
EXCEL CONSULTANCY
In addition to providing Excel training, Adapt can provide expert help in building new spreadsheets, or developing/enhancing existing spreadsheets. For more information, please link on the link or on consultancy in the toolbar at the top.
MATHS TUITION
Adapt also provides Maths tuition right up to GCSE.