Microsoft Excel Expert Training Programme
Business managers, owners, directors, managers and senior managers, accountants, lawyers, i-gaming analyst, store officers, doctors, insurance analysts, stockbrokers,bankers and other persons needing serious skills in number crunching.
Malta Microsoft Excel Expert Training Programme
See how you can:
- Build MS Excel sheets Analyse Data Professionally
- Creating of forms for ease and security of inputting
- Interaction with MS Word
- Expert formulas
- Creation of time and money saving Expert Excel programmes
Previous people who took this course came from the accounting (form automation), administration (invoicing and data analysis), law (invoicing and time billing forms automation), i-gaming (data analysis), retail (data analysis and stock optimisation and ordering), imports (stock managing and forecasting), insurance (client forms), banking (reporting spreadsheets) and business owners (business modelling and forecasting)
Customised programmes for just two persons can be done depending on specific client needs.
- Maximum 8 attendees
- 30 days of one to one support
- Programme director with at least a Masters Degree in the subject
- Convenient afternoon timings or in-house at any time
- Can be configured to address a number of professions and industry sectors
Price EUR395 ex VAT
Formula Tricks and Techniques
A deep review on how to use expert formulas to check, dissect, concatenate and manage data, numbers and other variables.
Working with Tables and Ranges
How to use tables and ranges to manage data and create functional use with the results.
Data Integrity, Sub-Totals and Validations
How to manage large volumes of data, create sub-totals and validate inputted data for end users to avoid mistakes.
How to use the advance MS Excel features and functions with conditional logical formulas.
Formula Auditing Tools
How to audit formulas and use checks and auditing to ensure data and formula functionality integrity.
Working with Pivot Tables
How to use pivot tables and build reports with them.
Business Intelligence With MS Excel
How to use MS Excel for forecasting and extrapolating trends and forecasts (linear and harmonic).
How to create what-if scenarios using different variables and models.
Security aspects of MS Excel
How to protect worksheets files and create a secure working environment.
Web based Worksheets
How to secure a worksheet as a webpage for user interaction in a secure way (multi-users secure access)