Instructor led Courses << Back to Home
kur

Excel 2010 - Advanced

Microsoft Excel 2010 Advanced - 1 Day

This one day course is designed to enhance existing spreadsheet skills and is particularly valuable to those handling data storage in Excel.

Delegates will learn to manage and summarise data files, perform multi sheet and cross-book calculations and apply security mechanisms to protect data.

  • Delegates should have a
    • Attended our Excel 2010 Introduction & Intermediate course
    • Have an equivalent knowledge through use

    • You do not need
      • To be a mathematician

    If you would like to discuss this course further or wish to enquire if you're at the correct level call us on 08458 62 62 65 we'll be only too pleased to help.

  • By the end of this course you'll be able to
    • Group worksheets together to perform multi-sheet editing
    • Calculate using multi-sheet and cross-book references in formulae
    • Summarise information using data consolidation
    • Sort data in alphabetical, numerical or customised order
    • Search for data using auto filtering and advanced filtering techniques
    • Apply automatic sub-totalling to the worksheet
    • Apply outlining to collapse and expand levels of detail on the worksheet
    • Summarise data using Pivot Tables
    • Share workbooks to enable multi-user simultaneous editing
    • Track and manage changes on shared workbooks
    • Save the worksheet and components as HTML Documents for use on the web
    • Apply protection to secure formulae, graphics and worksheets
  • Lesson 1 - Sorting & Filtering
      • Sorting by icon
      • Multi-level Sort
      • Sort Left-to-Right
      • Sorting using custom lists
      • Auto Filtering
      • Advanced Filtering
      • Data Extraction
    • Lesson 2 - Outlining & Subtotals
        • Applying and removing the auto outline
        • Applying and removing automatic subtotals
        • Grouping & Ungrouping
        • Showing Detail
        • Hiding Detail
      • Lesson 3 - Pivot Table Reports
          • Create and manipulate a pivot table
          • Pivot Table Fields
          • Pivot Table Field List
          • Pivot Charts
          • Pivot Table Design
          • Pivot Table Styles
        • Lesson 4 - Data Consolidation
            • Consolidate data in the same workbook
            • Consolidate data from different workbooks
          • Lesson 5 - File Handling
              • Protect Worksheet
              • Protect Workbook
              • Protecting cells within a workbook
              • Data validation
              • Finding files
            • Lesson 6 - Shared Workbooks
                • Sharing the workbook
                • Checking user status
                • Allowing user to edit ranges
                • Tracking changes
                • Resolving conflicts
                • History Worksheet
              • Lesson 7 - Saving in HTML Format
                  • Whole workbook
                  • Single worksheet
                  • Viewing web page

Similar Courses