Contact Us:
+44 1244 940047

To apply for this course please use the button on the right or email us at info@win-training.co.uk or give us a call on 01244 940047

Course Information

This one-day course is designed to build on the skills gained from attending Excel Level 1.

Delegates will learn to control their worksheets through navigation techniques, calculate using more-advanced functions and increase presentation impact using charts, graphics and data tables.

Pre-Requisites

Delegates should have previously attended the Excel Level 1 course or have equivalent knowledge through their own usage of the product.

What you will learn:

  • Work with Tables
  • Use named ranges in formulae
  • Work with Comments
  • Using logical, text, date and data analysis functions
  • Using graphs to analyse data
  • Working with graphics
  • Sort and filter data
  • Use statistical functions to filter data tables
  • Create outlines and subtotals
  • Create 3D referencing between worksheets and workbooks

Course Content

Unit 1: Working with Excel Tables

  • Using Excel Tables
  • Formatting a Table
  • Add a Totals Row
  • Create a Calculated Column
  • Using Table Splitters

Unit 2: Using Named Ranges

  • Creating Named Ranges
  • Using Range Names Within Formulae
  • Using Named Ranges with the Goto Command

Unit 3: Adding Comments

  • Creating, Editing and Deleting Cell Comments
  • Displaying Comments Permanently On Screen
  • Printing and Formatting Cell Comment

Unit 4: Building Formulae and Using Functions

  • Create Formulae Containing the Function, SUMIF(S), IF, COUNTIF(S)
  • Create Formulae Using Nested IF Statements
  • Create Formulae Using the AND and OR Functions
  • Create a Table and Use the HLOOKUP and VLOOKUP to Find Additional Information

Unit 5: Using Text and Date Functions

  • Use the Concatenate Function to Join Text from Multiple Columns Into a Single Column
  • Use the Text to Columns Feature to Separate Text Into Columns
  • Use the Date Function to Calculate the Time Between Two Dates

Unit 6: Working with Graphs

  • Create a Bar Chart from Data Within Your Spreadsheet
  • Create a Pie Chart from Data Within Your Spreadsheet
  • Change the Type of Chart Within Your Workbook
  • Change the Look and Colours Within the Chart
  • Apply a Gradient to the Shading
  • Add a Trendline
  • Using Sparklines

Unit 7: Working with Graphics

  • Add a Picture Into a Worksheet
  • Using SmartArt
  • Grouping Objects
  • Object Ordering

Unit 8: Sorting and Filtering

  • Sorting by Icon and By Menu
  • Sorting Using Custom Lists
  • Auto Filtering
  • Advanced Filtering
  • Use DSUM, DMAX, DMIN, DAVERAGE and DCOUNT Functions

Unit 9: Outlining and Subtotals

  • Using AutoOutline
  • Applying and Removing Automatic Subtotals

Unit 10: Linking and Grouping

  • Group Worksheets
  • Create Formula Links to Cells on Different Worksheets
  • Create Formula Links to Cells on Different Workbooks

Course Curriculum

No curriculum found !

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

0 STUDENTS ENROLLED

    About Win Training

    Win Training specialise in a variety of training courses being offered both online and on-premise. Call us today to find out more about how we can help you achieve your training goals +44 1244 940047.

    Who’s Online

    There are no users currently online
    top
    © Win Training.All rights reserved
    Loading...