Microsoft Excel Gurus – Level 3

15 Aug
  • 15th August 2017
    9:30 am - 4:30 pm
Shropshire Chamber of Commerce

Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You’ll cut down on data entry errors with Advanced Data Management and work out amazing “What If” scenarios with Goal Seek and Solver. On this course you’ll learn how to use Logical functions […]

Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You’ll cut down on data entry errors with Advanced Data Management and work out amazing “What If” scenarios with Goal Seek and Solver. On this course you’ll learn how to use Logical functions to work out “What IF” questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Financial, Date and Time Functions and Array Formulae, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; cover Importing and Exporting Data into Excel, how to use built in Analytical Tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own Macros. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively. Who should attend? This course is specifically designed for office workers, managers, accountants and data analysts. Delegates on this course should have existing Intermediate knowledge of Excel, and we will turn you into Excel Guru’s. We will cover some of Excel’s best kept secrets and will look in detail at:- Logical and Statistical Function Become an Excel Expert using Logical Functions to work out “What IF” questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer! Financial and Date Functions If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course! Lookups and Data Tables Need to know the fundamentals of VLOOKUPs? We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover using MATCH and INDEX and creati