Microsoft Excel 2010: Beyond the Basics

If you already have a basic understanding of Microsoft® Excel 2010 and are looking to delve deeper into its features, this is the class for you! Interacting with Microsoft® Excel 2010 can be a very intimidating task, but it doesn’t need to be. Let our energetic faculty walk you through how to take advantage of some of this versatile software’s most useful features. You’ll learn about file management tools you didn’t know existed, understand how to use formulas and functions, explore some of Excel’s most useful data analysis tools and pick up tips and tricks for working with tables-- including PivotTables. You’ll also learn how to use macros; create custom Auto Fill lists; and link, consolidate and combine data.

If you’re looking to build on the knowledge you gained in our “Expanding Your Understanding of Microsoft® 2010 Office Suite” training, this is your next step! Perfect for anyone who would like to build their Microsoft Excel proficiencies.


T O P I C S   I N C L U D E
Review of the Basics
  • Refresher on the Excel Interface:
    • Quick Access Toolbar
    • File menu
    • Tabs
  • Creating new workbooks from scratch, existing workbooks or templates
  • AutoSum
  • Auto Fill functioning
  • Sort feature and button
  • Inserting comments
  • Conditional formatting
  • Filter and AutoFilter
  • Using subtotals
  • Printing
  • Creating charts
  • Useful keyboard shortcuts
Outlining/Grouping Data
  • Creating an outline of rows
  • Creating an outline of columns
  • Showing or hiding outlined data
  • Customizing an outline with styles
  • Copying outlined data
  • Hiding or removing an outline
  • Creating a summary report with a chart
Managing Data with Tables
  • Sorting and filtering
  • Formatting data
  • Inserting and deleting rows and columns
  • Using a calculated column
  • Displaying and calculating table data totals
  • Entering the PivotTable data
  • Creating the PivotTable
  • Adding data to the PivotTable
  • Filtering the PivotTable data
  • Changing the PivotTable data
  • Working with PivotTable reports
  • Designing the layout and format of a PivotTable report
Pivot Charts
  • Creating a PivotChart
  • PivotChart Filter Pane
  • Comparing a PivotTable report and PivotChart report
  • Differences between PivotChart reports and standard charts
  • Working with source data
Custom Auto Fill Lists
  • Automatically repeating values that are already found in the column
  • Fill handle
  • Fill command
  • Filling formulas into adjacent cells
  • Filling in a series of numbers, dates or other built-in series items
  • Filling data by using a custom fill series
Combining Data from Multiple Data Sources
  • Importing data
  • Combining data
  • Performing queries
Consolidating Data in Multiple Worksheets
  • Consolidating by position
  • Consolidating by category
  • Consolidating by formula
  • Using Pivot Table reports
Getting the Most from Macros
  • Adding the Developer tab
  • Automating daily tasks with micros
  • Recording macros
  • Creating macros with Visual Basic Editor
  • Creating startup macros
  • Macros shortcuts
Adding Bookmarks and Hyperlinks
  • Creating quick and easy access to other workbooks
  • Linking to other areas in the current workbook
  • Using shortcuts to insert hyperlinks
File Management in Excel
  • Searching for files
  • Recently and frequently opened files
  • Available disks and folders
  • Renaming files
Working with Formulas in Excel
  • Writing formulas
  • Cell references
  • Array formulas
  • Updating formulas
  • Mathematical operations
Using Excel Functions
  • Text functions
  • IF functions
  • Date and time functions
  • Math and statistical functions
  • Names and ranges
  • Logical functions
  • Lookup functions
  • Rounding numbers
Presenting Your Data with Style
  • Selecting themes
  • Using text boxes
  • Pictures and Clip Art
Using Graphics to Present Data
  • Working with SmartArt:
    • Choosing a layout
    • Adding text
    • Style, color and effects
    • Using animation
    • Creating your own SmartArt graphic
  • Using Sparklines to show data trends:
    • What are Sparklines?
    • When to use them
    • Creating Sparklines
    • Customizing Sparklines

    *Topics subject to change.

Click here to find out how you can bring a Falmouth Institute seminar to your location!
© Copyright 2012 | Terms of Use | Privacy Policy