Microsoft Excel Advanced 308

ADMNEXC308101 Excel Training - Learn how to use 3D Formulas between sheets

ADMNEXC308102 Excel Training - How to create worksheets using 3D formulas

ADMNEXC308103 Excel Training - How to use String functions to extract information

ADMNEXC308201 Excel Training - Learn how to Insert a Pivot Table

ADMNEXC308202 Excel Training - How to Filter data in a Pivot Table

ADMNEXC308203 Excel Training - How to Sort Dates by Month

ADMNEXC308204 Excel Training - Learn how to Change Value Field Settings

ADMNEXC308205 Excel Training - How to Refresh Pivot Table data

ADMNEXC308206 Excel Training - How to Change Source Data of a Pivot Table

ADMNEXC308207 Excel Training - How to insert PivotCharts

ADMNEXC308301 Excel Training - Learn to get month values using the CHOOSE function

ADMNEXC308302 Excel Training - Learn how to Automatically produce ratings

ADMNEXC308303 Excel Training - Choose the calculation you want to occur

ADMNEXC308401 Excel Training - How to insert a VLOOKUP function

ADMNEXC308402 Excel Training - Learn to perform VLOOKUP using Named Ranges

ADMNEXC308403 Excel Training - How to Transpose data and Insert HLOOKUP functions

ADMNEXC308501 Excel Training - How to Find a match

ADMNEXC308502 Excel Training - Incorporate cell information in text

ADMNEXC308503 Excel Training - How to use INDEX to find the value in a matched row

ADMNEXC308601 Excel Training - Learn to perform a nested MATCH and INDEX function

ADMNEXC308602 Excel Training - Combine MATCH with IFERROR functions

ADMNEXC308701 Excel Training - Understanding cell protection

ADMNEXC308702 Excel Training - How to Find Cells which contain calculations

• Microsoft Excel Beginners 301
  • ADMNEXC301101 Excel Training – Identifying the Excel Environment
  • ADMNEXC301102 Excel Training – Understanding the Menu Ribbon
  • ADMNEXC301103 Excel Training – How to use Specific Menu Options and Quick Commands
  • ADMNEXC301104 Excel Training – Learn how to use Zoom and View
  • ADMNEXC301105 Excel Training – Learn the Other Parts of the Excel Screen
  • ADMNEXC301106 Excel Training – How to Work with Sheets in Excel
• Microsoft Excel Beginners 302
  • ADMNEXC302101 Excel Training – Selecting Cells and Ranges
  • ADMNEXC302102 Excel Training – Learn to Copy, Cut and Paste Cells
  • ADMNEXC302103 Excel Training – Learn to Edit Cell Contents
  • ADMNEXC302104 Excel Training – How to Resize Columns and Rows
  • ADMNEXC302105 Excel Training – How to AutoFit and AutoComplete
  • ADMNEXC302106 Excel Training – Learn how to Insert and Delete Rows
  • ADMNEXC302107 Excel Training – Learn to AutoFill Data and Series
  • AMDNEXC302108 Excel Training – Learn how to use the AutoFill Shortcut menu
• Microsoft Excel Beginners 303
  • ADMNEXC303101 Excel Training – Learn to Enter Formulas
  • ADMNEXC303102 Excel Training – Learn how to use the AutoSum Function
  • ADMNEXC303103 Excel Training – Learn to Use AutoCalculate
  • ADMNEXC303104 Excel Training – How to Format an Excel File
  • ADMNEXC303105 Excel Training – Learn how to Format Numbers
  • ADMNEXC303106 Excel Training – How to Format Font and use the Format Painter
  • ADMNEXC303107 Excel Training – Learn how to Align Text
• Microsoft Excel Intermediate 304
  • ADMNEXC304101 Excel Training – Learn to use Print Preview
  • ADMNEXC304102 Excel Training – How to use View Options
  • ADMNEXC304103 Excel Training – How to change Page Orientation and Scaling
  • ADMNEXC304104 Excel Training – How to Change Margins and Centring
  • ADMNEXC304105 Excel Training – Learn to use a Header and Footer
  • ADMNEXC304106 Excel Training – Learn how to use a Custom Header and Footer
  • ADMNEXC304107 Excel Training – Learn to Change Sheet Setup
  • ADMNEXC304108 Excel Training – Learn to set the Print Area
  • ADMNEXC304109 Excel Training – How to Print Titles
  • ADMNEXC304110 Excel Training – How to set Page Breaks
  • ADMNEXC304111 Excel Training – Learn how to Set Horizontal and Vertical Page Breaks
  • ADMNEXC304112 Excel Training – Learn to Freeze Panes
  • ADMNEXC304113 Excel Training – Learn how to Print a spreadsheet
• Microsoft Excel Intermediate 305
  • ADMNEXC305101 Excel Training – How to Format Data in Worksheets
  • ADMNEXC305102 Excel Training – Learn how to use Mulitple Formulas
  • ADMNEXC305201 Excel Training – Learn to Create a basic Chart
  • ADMNEXC305202 Excel Training – How to Change Chart Type
  • ADMNEXC305203 Excel Training – Learn to Change Chart location
  • ADMNEXC305204 Excel Training – How to Change Data Source of a Chart
  • ADMNEXC305301 Excel Training – Identify elements of a chart
  • ADMNEXC305302 Excel Training – How to Customise Elements of Chart Design
  • ADMNEXC305303 Excel Training- Learn to Create a Chart from Individual records
  • ADMNEXC305304 Excel Training – Learn to Create a Chart with Two chart types
  • ADMNEXC305305 Excel Training – How to Format Chart Elements
  • ADMNEXC305306 Excel Training – Learn to Insert a Shape into a Chart
  • ADMNEXC305307 Excel Training – Learn how to Format your chart
  • ADMNEXC305308 Excel Training – How to Create a pie chart with data labels
  • ADMNEXC305309 Excel Training – Learn how to Format a pie chart
  • ADMNEXC305401 Excel Training – Learn to Copy and paste a chart into a word document
  • ADMNEXC305402 Excel Training – Learn how to use paste-link
• Microsoft Excel Intermediate 306
  • ADMNEXC306101 Excel Training – Review Exercise
  • ADMNEXC306102 Excel Training – How to Identify Cell Formatting
  • ADMNEXC306103 Excel Training – Effects of Formatting a cell first or last
  • ADMNEXC306104 Excel Training – How to use Percentage in formulas
  • ADMNEXC306105 Excel Training – Learn to enter Formulas using relative cell references
  • ADMNEXC306106 Excel Training – Putting a Variable in one cell
  • ADMNEXC306107 Excel Training – Learn how to use absolute cell references
  • ADMNEXC306108 Excel Training – Learn how to Forecast using Calculations
  • ADMNEXC306109 Excel Training – How to use Varied Formulas
  • ADMNEXC306110 Excel Training – Entering Sum in a different cell
  • ADMNEXC306111 Excel Training – Learn to use Maximum and Average functions
  • ADMNEXC306112 Excel Training – Learn to Hide and unhide Columns
  • ADMNEXC306113 Excel Training – How to Hide and unhide Worksheets
  • ADMNEXC306114 Excel Training – How to Format, Edit Comments and Change the shape of the Comment box
  • ADMNEXC306115 Excel Training – Learn to use the Function Arguments dialog box
  • ADMNEXC306116 Excel Training – Learn to use the IF function to display text
  • ADMNEXC306117 Excel Training – Learn to use the IFERROR and ISNUMBER Functions
  • ADMNEXC306118 Excel Training – How to use AND,OR and NOT Functions
  • ADMNEXC306119 Excel Training – Learn how to create Named Ranges
  • ADMNEXC306120 Excel Training – How to use Named Ranges and Name Box Drop down
  • ADMNEXC306121 Excel Training – Naming Constants and Applying Named Ranges
  • ADMNEXC306122 Excel Training – How to apply Conditional Formatting
  • ADMNEXC306123 Excel Training – Learn to apply Colour Scale Conditional Formatting and Data Bars
• Microsoft Excel Advanced 307
  • ADMNEXC307101 Excel Training – Microsoft Excel Options
  • ADMNEXC307201 Excel Training – Parts of the Excel Structure
  • ADMNEXC307202 Excel Training – Learn to create a database
  • ADMNEXC307203 Excel Training – How to use Forms in Excel
  • ADMNEXC307204 Excel Training – Learn to find information using a form
  • ADMNEXC307205 Excel Training – How to find information using the Find command
  • ADMNEXC307206 Excel Training – Learn to search an entire workbook for text
  • ADMNEXC307207 Excel Training – Search an entire workbook a cell reference
  • ADMNEXC307208 Excel Training – Learn to find text in comments
  • ADMNEXC307301 Excel Training – How to Paste formulas
  • ADMNEXC307302 Excel Training – Learn to Paste formatting
  • ADMNEXC307303 Excel Training – How to Paste values
  • ADMNEXC307401 Excel Training – Different database file types
  • ADMNEXC307402 Excel Training – Learn to use the Text Import Wizard
  • ADMNEXC307501 Excel Training – How to Load Data from Text Files
  • ADMNEXC307502 Excel Training – How to Transform Data from Tables
  • ADMNEXC307503 Excel Training – Learn to Append to Combine Data
  • ADMNEXC307504 Excel Training – How to Merge Data from related sources
  • ADMNEXC307601 Excel Training – How to Perform Array Functions
  • ADMNEXC307602 Excel Training – Learn to use Arrays within formulas
  • ADMNEXC307603 Excel Training – How to use the Intersection Operator
  • ADMNEXC307604 Excel Training – How to use the Intersection Operator in formulas
  • ADMNEXC307701 Excel Training – How to Sort data
  • ADMNEXC307702 Excel Training – Learn to Filter data
  • ADMNEXC307703 Excel Training – How to use Advanced Filter using Wildcards
  • ADMNEXC307704 Excel Training – Use Advanced Filter for multiple search criteria
  • ADMNEXC307705 Excel Training – How to arrow the results using Advanced Filter
  • ADMNEXC307801 Excel Training – How to use Data Validation, Drop-down lists and Named ranges
  • ADMNEXC307802 Excel Training – How to use COUNTA and COUNTIF Functions
  • ADMNEXC307803 Excel Training – How to Combine the contents of cells
• Microsoft Excel Advanced 308
  • ADMNEXC308101 Excel Training – Learn how to use 3D Formulas between sheets
  • ADMNEXC308102 Excel Training – How to create worksheets using 3D formulas
  • ADMNEXC308103 Excel Training – How to use String functions to extract information
  • ADMNEXC308201 Excel Training – Learn how to Insert a Pivot Table
  • ADMNEXC308202 Excel Training – How to Filter data in a Pivot Table
  • ADMNEXC308203 Excel Training – How to Sort Dates by Month
  • ADMNEXC308204 Excel Training – Learn how to Change Value Field Settings
  • ADMNEXC308205 Excel Training – How to Refresh Pivot Table data
  • ADMNEXC308206 Excel Training – How to Change Source Data of a Pivot Table
  • ADMNEXC308207 Excel Training – How to insert PivotCharts
  • ADMNEXC308301 Excel Training – Learn to get month values using the CHOOSE function
  • ADMNEXC308302 Excel Training – Learn how to Automatically produce ratings
  • ADMNEXC308303 Excel Training – Choose the calculation you want to occur
  • ADMNEXC308401 Excel Training – How to insert a VLOOKUP function
  • ADMNEXC308402 Excel Training – Learn to perform VLOOKUP using Named Ranges
  • ADMNEXC308403 Excel Training – How to Transpose data and Insert HLOOKUP functions
  • ADMNEXC308501 Excel Training – How to Find a match
  • ADMNEXC308502 Excel Training – Incorporate cell information in text
  • ADMNEXC308503 Excel Training – How to use INDEX to find the value in a matched row
  • ADMNEXC308601 Excel Training – Learn to perform a nested MATCH and INDEX function
  • ADMNEXC308602 Excel Training – Combine MATCH with IFERROR functions
  • ADMNEXC308701 Excel Training – Understanding cell protection
  • ADMNEXC308702 Excel Training – How to Find Cells which contain calculations
• Microsoft Excel Advanced 309
  • ADMNEXC309101 Excel Training – Learn how to use Goal Seek
  • ADMNEXC309102 Excel Training – How to Consolidate contents from several sheets
  • ADMNEXC309103 Excel Training – Data consolidation with Named Ranges
  • ADMNEXC309104 Excel Training – Learn to Group Data
  • ADMNEXC309105 Excel Training – Learn to manually Group data
  • ADMNEXC309106 Excel Training – Turn on the Solver Add-in
  • ADMNEXC309107 Excel Training – Learn to Solve a problem
  • ADMNEXC309108 Excel Training – How to Calculate NPV of an investment
  • ADMNEXC309109 Excel Training – How to Compare projects using NPV and IRR
  • ADMNEXC309110 Excel Training – Learn how to use the PMT Function
  • ADMNEXC309111 Excel Training – How to use the PV Function
  • ADMNEXC309201 Excel Training – How to Record a Macro to Analyse Data
  • ADMNEXC309202 Excel Training – Learn to Record Macro to Format Data
  • ADMNEXC309203 Excel Training – How to Edit a Macro

Back to Excel Training Summary Page