Professional Course
4.0 (2 Reviews)

Microsoft® Excel: Level 2

Length
1 day
Price
295 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
Length
1 day
Price
295 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
This provider usually responds within 48 hours 👍

Course description

Microsoft Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells).

This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. This manual will also help more experienced users who have little to no experience with Excel and the ribbon interface.

Upcoming start dates

1 start date available

Contact provider for more information.

  • Classroom
  • Ottawa

Who should attend?

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Training content

Section 1: Advanced File Tasks

  • Using Windows Explorer within Excel
  • Saving your Files
  • Using File Management Tools, Part One
  • Using File Management Tools, Part Two

Section 2: Working with Functions and Formulas

  • Using Formulas in Excel, Part 1
  • Using Formulas in Excel, Part 2
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas

Section 3: Managing Tables

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

Section 4: Adding the Finishing Touches

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

Section 5: Showing Data as a Graphic

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

Why choose BBLN?

In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.

All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.

We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.

Reviews

Average rating 4

Based on 2 reviews.
Write a review!
3/5
Anonymous
11 Jul 2019

The Explanation Of Each Steps And Functions Are Really Easy

5/5
Anonymous
11 Jul 2019

Everything was well done. Looks forward to the next class.

Contact this provider

Contact course provider

Fill out your details to find out more about Microsoft® Excel: Level 2.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Building Blocks Learning Network
170 Laurier Ave. West, Suite 700
K1P 5V5 Ottawa Ontario

Building Blocks Learning Network

Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...

Read more and show all training delivered by this supplier

Ads