137 Office Skills courses in Esher

Microsoft Power BI training courses at Introduction and Intermediate levels. Click on the link below to view full details: Power BI courses

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This excellent Power BI covers the Query Editor and Dax Calculations in detail Online Instructor-led Classroom sessions available on request Practical, Hands-on, Interactive

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

Standard or Custom Excel courses at Introduction, Intermediate, Advanced and Super User level. Click on the link below for full details: Excel 365 courses

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

Pushy boardroom bullies... battling agendas... conflicts of interest. Here are the most common drivers of trouble in the boardroom, and tools for making things right.

professional financial modelling and data analysis courses