Aims: Enables users to customise Excel spreadsheets to produce valid and clear reporting of data integrated with macros for faster ways of working
Pre-requisites: Must have attended the Microsoft Excel Introduction & Intermediate courses, or have an extensive working knowledge of the product
Duration: One day
Text and Conditional Functions Common Text Functions Countif and Countifs Sumif and Sumifs Averageif and Averageifs Combining and Nesting functions
Lookup Functions What is a Lookup Function? Using LOOKUP to extract information Looking up with VLOOKUP and HLOOKUP
Pivot Tables What is a Pivot Table? Using Pivot Tables to display Data Lists Creating a Pivot Table Modifying the structure of a Pivot Table
Further Pivot Tables Formatting a Pivot Table Producing Drilldown Reports Grouping and Ungrouping Pivot Table data Showing and Hiding data in a Pivot Table
Goal Seek What is Goal Seek? Using Goal Seek to solve problems
Solver Solver vs. Goal Seek Using Solver to solve problems Specifying Solver constraints and limits
Displaying a View Scenario Manager What is Scenario Manager? Creating a Scenario Showing a Scenario Generating Scenario Reports
Views An introduction to Custom Views Using a View to control the display Using a View to control print settings
Introduction to Macros What is a Macro? Recording a Macro Assigning a Macro to the Quick Access Toolbar Viewing Macro Editor
For further information on our Microsoft Excel Advanced Course, please contact us via the contact page, or alternatively telephone the office on 0113 243 2226
Course Title: Microsoft Excel Visual Basic Applications (VBA) Aims: To illustrate how to use macro programming to speed repetitive tasks when employing Microsoft Excel Pre-requisites: Delegates MUST be familiar with the use and exploitation Read more…
Data Analysis Using ‘Get & Transform’ and Microsoft Excel Power Pivot Description: The topics included in this course provide the user with additionaltools for data analysis. The course covers importing data from avariety of sources, analysing Read more…
