Advanced Excel

Advanced Excel Training Course

Our Microsoft Advanced Excel 2010 / 2013 training course will improve efficiency and productivity in the work place with the use of advanced features such as Pivot Tables, Short Cuts, Filters, Macro’s and scenarios. This course is aimed at the everyday user. We will look at functions such as IF, Vlookup and Nested IF’s.

Quality Training – Practical Benefits

Benefits:

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

We have delivered training to clients all over Ireland. Our clients range from multinationals, government bodies and SME’s. We will customise any training course to suit your specific requirements.

We travel onsite anywhere in Ireland

For more information please contact us info@inspiresit.ie

Advanced Excel Training CoursesNavigation & Data input

  • Quick Navigation of spreadsheets
  • Accurate selection of large amounts of data
  • Shortcut Keys
  • Named Ranges, modifying & deleting
  • Custom Lists, creation & deleting
  • Using AutoFill to create numbered sequences

Functions: IF & VLookups

  • Absolute Addressing
  • Using the IF Function – Using the Paste Function
  • Using the Vlookup & Hlookup
  • Count IF and Count A
  • Sum IF
  • Nested IF
  • Shortcut to view all formulas
  • Auditing Toolbar

Advanced Filter

  • Applying an AutoFilter
  • Using the Advanced Filter
  • Filtering Results to another area of spreadsheet

Auditing Tools

  • Auditing Toolbar
  • Tracing Precedents
  • Tracing Errors in Formula

Protection

  • How to protect worksheets
  • Protecting Workbooks
  • Protecting parts of a spreadsheet
  • Placing a password on the file

Pivot Tables

  •    Creating Pivot Tables
  •    Modifying Pivot Tables
  •    Formatting data within Pivot Tables
  •    Refreshing data in a Pivot Table
  •    Using a Slicer
  •    Creating a Pivot Chart
  •    Modifying a Pivot Chart
  •    Grouping Pivot Table
  •    Inserting Calculated Fields into a Pivot Table

Scenarios

  •    Creating Scenarios
  •    Shortcuts to viewing scenarios
  •    Creating Scenario Summary Reports

Macros

  •    Recording a Macro
  •    Running a Macro
  •    Assigning a Macro to a button in Toolbar
  •    Assigning a Macro to a push button on spreadsheet
  •    Editing & Deleting a Macro

Import

  •    Importing Data into Excel
  •    Importing a Text file into Excel

Data Validation

  • Creating Drop Down Menu’s in Excel

Charts

  •  Adding a Second Axis
  •  Formatting Axes

Saving Workspaces

Back to Main Excel Training Page>>

For more information please contact us info@inspiresit.ie

Click here to see profile of trainer>>