Call: +44 (0) 20 8992 4506

Email: info@kbmtr.com

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

Advanced Excel

  • Advanced ExcelOpen or Close
    A comprehensive training course with up to date material to practice at home and during your class. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. There is a way to make it an even more powerful tool in the management of your business. The benefit of additional Microsoft Excel training will give you a more efficient vision of your operation as well as improve your analytical and reporting skills.Whether you're looking for a beginner, intermediate or advanced Excel training program, you won't be disappointed in the end result. You will learn valuable tips and tricks to improve your excel skills. Course contents:
    • Summing Techniques
    • IF, Cell References, Formula Linking,etc
    • New Formulas of Excel 2007 Sumifs, Countifs, Iferror
    • Database Formulas
    • Subtotal (Formulae & Procedure)
    • Tables
    • Macros
    • Look up References (Vlookup, Hlookup,etc)
    • Data Validation
    • Conditional Formatting
    • Date & Time Formulas
    • Charts & Graphs
    • Protection & Security
    • Goal Seek
    • Groupings
    • Pivot Table
    • Pivot Table Charts
    • Hyperlinks
    • Scenario
    • Hlook ups
    • Vlookups
    • Web workbooks
    • Sharing Workbooks

Practical Accountancy Training and Work Expereince

Apply now

All Reserved © KBM Training & Recruitment 2018

Designed & Developed By: KBM Media Solutions