Intermediate Excel 2010

Duration: 1 Day

Who should attend?
This course is designed for Microsoft Excel users who have basic skill levels and understanding of Excel and who wish to extend their knowledge and skills beyond building simple workbooks. This course is suitable for people who use or who will use Excel in their daily role.

Course Aims and Objectives:
This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data and worksheets, and use the tables and filtering features to manage and analyse data.

Assumed Knowledge
It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction course or have obtained comparable knowledge from the workplace.

 

Course Outline Summary

Section One: Advanced File Tasks

  • Using Windows Explorer within Excel
  • Saving your Files
  • Using File Management Tools

Section Four: Adding the Finishing Touches

  • Research Tools
  • Using Themes
  • Adding Text Boxes
  • Inserting Pictures and ClipArt
  • Using Screenshot tool

Section Two: Working with Functions and Formulas

  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas
Section Five: Showing Data as a Graphic

  • Inserting SmartArt
  • Formatting SmartArt
  • Adding Symbols, Equations, and Shapes
  • Adding Sparklines
  • Editing Sparklines

Section Three: Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Working with Tables and Filters
  • Using Excel as a Database