Microsoft Excel 2010 - Level 3 / Advanced

This course will teach you how to create outlines and subtotals, pivot tables and reports, and create and use macros and forms.

    Oct 30 2020

    October 30 - 30, 2020 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live

    Date: 10/30/2020 - 10/30/2020 (Friday - Friday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Microsoft Excel 2010 - Level 3 / Advanced

    October 30 - 30, 2020 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 20 2020

    November 20 - 20, 2020 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live

    Date: 11/20/2020 - 11/20/2020 (Friday - Friday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Microsoft Excel 2010 - Level 3 / Advanced

    November 20 - 20, 2020 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

Explore the User Interface (If Required for Upgrade Students)

  • Backstage View
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Options

  • Change Excel Options

Manipulate Data

  • Use Automatic Outlining
  • Display and Collapse Levels
  • Manually Group Data
  • Create Subtotals

Pivot Tables

  • Create a Pivot Table
  • Change and Rearrange Pivot Table Data
  • Modify Pivot Table Format and Structure
  • Chart a Pivot Table
  • Create a Pivot Table from External Data
  • Use Slicer to Filter Pivot Table Data
  • Use Sparklines
  • Use the PowerPivot Add In

Using Excel with Other Programs

  • Link to an Access Database
  • Transform Excel into an Access Database
  • Import and Export Data to and from Text and CSV files
  • Import Data from External Sources
  • Link and Embed from Other Sources

Using Goal Seek, Solver and VLookup

  • Create and Use Scenarios
  • Create a Scenario Summary Report
  • Save Multiple Scenarios
  • Use a One and Two Input Data Table
  • Use Goal Seek
  • Use the Solver
  • Use VLOOKUP

Excel and the Internet

  • Add, Modify and Remove Hyperlinks
  • Save Workbooks, Sheets, Charts and Ranges as Webpages
  • Create, Save and Refresh a Web Query
  • Publish to a Document Server
  • Saving to Sharepoint

Advanced Tasks

  • Create, Open and Edit a Shared Workbook
  • Track Changes in a Shared Workbook
  • Review Changes
  • Set Options for Tracking Changes
  • Create, Use and Modify Custom Lists
  • Consolidate Workbooks
  • Link Workbooks
  • Combine Worksheets

Macros

  • Macro Security
  • Record and Play a Macro
  • Record and Run a Relative Reference Macro
  • Assign a Macro to a Keystroke or Quick Access Toolbar

Upon completion of the course, participants will be able to create use macros, create and use Scenarios, use Goal Seek, and link Excel to an Access Database.

The prerequisites for this course is an intermediate Excel course or equivalent working knowledge of the software.

This course is intended for students who are experienced Excel 2010 users who have a desire or need to advance their skills in working with some of the more advanced Excel features.

Ready to Advance Your Career?

CONTACT US NOW!