TLG Learning
Search
  • Home
  • Course Catalog
    • AWS
    • CompTIA
    • F5 Networks
    • Microsoft Technical
    • Office 365 & Other End-user
    • Power BI
    • Specialty Courses
      • Cisco
      • Citrix
      • Juniper Networks
      • Open Source
      • Palo Alto Networks
      • Service/Project Management
      • Security
      • VMware
  • Solutions
    • Public/Open Enrollment Training
    • Private/Custom Training
    • Government Solutions
    • IT Career Services
    • Classroom Rentals
    • Consulting Services
  • About Us
    • Careers
    • Locations
      • Bellevue, WA
      • Seattle, WA
      • Your Home or Office
    • Our Guarantees
    • Terms and Conditions
    • Privacy Policy
  • Blog
  • My account
0
Your cart is empty. Go to Shop.
Home / Office 365/Desktop / Excel – Level 2

Excel – Level 2

= Guaranteed to run date

Dates are listed in Pacific Time Zone

Dates Locations
Feb 22 8:00 AM - Feb 22 4:00 PM Bellevue WA + Remote

$295.00

Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts.

SKU: ExcelL2 Categories: 30, Office 365/Desktop Topic: Excel
  • Description
  • Additional information
  • Reviews (0)

Description

Print Friendly, PDF & Email

Overview:

The course builds on the basic concepts and skills of the Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel. Lessons including how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

Prerequisite(s):

Excel Level 1

Audience:

Outline:

Lesson 1: Managing workbooks

  • Managing worksheets
  • Customizing Excel

Lesson 2: Named ranges

  • Using names in formulas

Lesson 3: Tables

  • Sorting
  • Filtering tables
  • Structured references
  • Validation
  • Transposing data

Lesson 4: Summarizing data

  • Consolidation
  • Subtotals

Lesson 5: PivotTables

  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts

Lesson 6: Presentation features

  • Conditional formats
  • Custom Format
  • Graphics

Lesson 7: Advanced charts

  • Special chart types
  • Sparklines
  • Quick Analysis

Lesson 8: Collaboration

  • Permissions
  • Comments

Additional information

Length

1 day

Guaranteed to run

Yes

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products

  • Introduction to DAX for Power BI Desktop Users – Level 3

    $1,190.00
    Add to cart
  • Excel – Level 1

    $295.00
    Add to cart
  • Excel – Level 3

    $295.00
    Add to cart

(425) 460-2200

Contact Us

Search Courses

Top TLG Courses

  • AWS
  • CompTIA
  • F5 Networks
  • Microsoft Technical
  • Office 365 & End-user
  • Power BI

Specialty Courses

  • Cisco
  • Citrix
  • Juniper Networks
  • Open Source
  • Palo Alto Networks
  • Project/Service Managment
  • Security
  • VMware

Recent Posts

  • New Year, New Deals!
  • Cyber Week Steals
  • Training and Development Manager of PCC Markets Recommends TLG Learning
  • I’m Interested in Knowledge Work
  • I’m Interested in IT Related Information
TLG Learning

Popular Links

Guaranteed to Run Classes
APN Partner Training

Client Resources

Exercise Files
Class Survey
© TLG Learning 2021
Print Friendly, PDF & Email

Contact Us (425) 460-2200

Print Friendly, PDF & Email

Thank you for using
Themify Popup

This is a sample pop up. A Themify theme or Builder Plugin (free) is recommended to design the pop up layouts.

Get Builder Watch Video