\
Sage Training courses
sage training program
sage training in London
sage practical training
sage payroll training

Practical Accountancy Training and Work Experience

Advanced Excel Training Courses

Microsoft Excel is widely used spreadsheet software, applied in all types of organisations and used by all types of professionals. MS Excel has a reputation as a powerful tool for data analysis. With intermediate level skills one can easily operate MS Excel for day to day requirements, but so many of us are unaware of the range of the powerful data manipulation and analysis tools which now come as standard with MS Excel. Our advanced excel training courses introduce these, demonstrating how beneficial they can be when fully understood and used effectively.

MS Excel is often used simply for listing data, and maybe as a calculator, but it has huge potential and remarkable functionality enabling the skilled user to do so much more.

Our advanced excel training courses show you how:

  • You can find the top 5 parties from a list of financial transactions, and identify the top 5 or bottom 5 efficient performers in the business.
  • With a smart feature you can highlight any value that is more or less than a specified limit, for example highlight the name, parties and amount for those who use credit of $20,000 per month.
  • Instead of simply sorting your spreadsheet in ascending or descending order, you can customise your sort within department, then giving sales. This is useful in HR, finance, accounting and other areas.
  • Use macros to save time for regular entries. Writing and recording macros gives your spreadsheet shortcuts to automatically run complex calculations.
  • Filter your data to home in on specific data, using various criteria.
  • Present your data using charts, graphs and pivot tables. There are 50 types of chart to choose from. Having completed one of our advanced excel training courses you will be able to use these with versatility and style.
  • Use MS Excel’s “what if analysis” feature for trend analysis, future projections and forecasting.
  • Use MS Excel’s LOOKUP functions and tables to find corresponding values from a reference table prepared by using formulas and function.

Microsoft Excel is an extremely powerful application. Excel 2007, Excel 2010 or Excel 2013, each version is loaded with unique features which can give tremendous results. You just need to take one of our advanced excel training courses to enable you to master many of the useful yet little use features of MS Excel.

Apply now

All Reserved © KBM Training & Recruitment 2024

Designed & Developed By: KBM Media Solutions