Ms Excel Advance Level Training (One Day Training for £200 Only)

Location
London (Central), London (Greater)
Salary
For further information please book an appointment..
Posted
13 Dec 2017
Closes
11 Feb 2018
Sector
Accountancy
Contract Type
Contract
Hours
Part Time
Job Level
Internship

Contact Details

Excel is perhaps the most important computer software program used in the workplace today. That is why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace.

Whether you are just starting out on your Excel journey or have been using it for a while, there are a few skills that you should know about Excel to learn best way of doing things, improve your productivity, bringing data together to prepare complex financial reports and to impress others especially your boss.

In this training, we aim to teach you with skills, tips and hints which can be very useful at your work place. These skills will include;
1. Making use of Auto-fill
2. Copying and Pasting information
3. Using basic mathematical functions (Sum, Subtraction, Multiplication, Division, Percentage etc.)
4. Linking information
5. Filters and Sort Functions
6. IF and Nested Ifs
7. SumIF(s) and CountIF(s)
8. VLOOKUP and HLOOKUP
9. Pivot Tables
10. Index & Match Function
11. Conditional Formatting
12. Validation and Restricting Access
13. Graphs & Charts
14. Grouping and Outlining
15. Dashboards
16. Macros

During this training you will be working on building Charts, Conditional Formatting, VLOOKUP, IF Formulas, Pivot Tables, bringing data together from different sources e.g. Sage Accounts, Statements downloaded from Bank or other financial institutions, multiple Excel files etc and will be ask to work on some complex workbooks to manipulate data in order to prepare required results.

Feel free to drop us an email or call us to book your appointment or to discuss further in details about this program or scope of training. Our qualified trainers will response to your query within 24 hours.

Office/Training facility 1;
Super Financial Limited/Training ON Limited
275 High Road Leyton
London
United Kingdom
E10 5QN
Telephone: 02089250070/ 07949898201

Office/Training facility 2;
Super Financial Limited/Training ON Limited
93 Watling Avenue
Burnt Oak, Middlesex
United Kingdom
HA8 0LA
Telephone: 02089250070/ 07949898201

 

Similar jobs