custom code gtranslate code

Microsoft Office Excel Level 2

Learn how to create custom formulas and explore more functions in Level 2! In this course, you will know how to organize data with the use of the sorting and filtering functions. Convert data into visual representations by using charts.

Course Outlines

  • Cell Styles
  • Conditional Formatting
  • Sorting and Filtering Data
  • Working with Tables
  • Working with Sparklines
  • Working with Charts
  • More Formulas and Functions
  • Working with Range Names
  • Multiple Workbooks and Worksheets

What you'll learn

  • Organize, protect, and display data, using various tools.
  • Create linking formulas and use the IF function.
  • Set up multiple worksheets, linking information from other sources to combine information into one worksheet.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create and apply styles to format consistently; use conditional formatting, comments, text boxes, and Sparkline’s.

Course Content

  • Organize, protect, and display data, using various tools.
  • Create linking formulas and use the IF function.
  • Set up multiple worksheets, linking information from other sources to combine information into one worksheet.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create and apply styles to format consistently; use conditional formatting, comments, text boxes, and Sparkline’s.

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:

Rachael McPherson, Director of Sales

☎(250)882-9549

📧rachael@qacademy.tech

Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada

☎(514)771-3206

📧caroline.santos@qacademy.tech

Student Ratings & Reviews

Course Info

Prerequisites
This course does not require any prerequisites but to ensure that the participant can enjoy the course, they are expected to have basic knowledge of Level 1.
Duration
6 Hours

Enroll Now

1:1 Price
$425.00
For Group Class Options

Enroll Now

For Corporate and Funding Agencies
popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Tanvir Qureshi
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number
0(0)

Microsoft Office Excel Level 2

  • Course level: Intermediate

Description

Learn how to create custom formulas and explore more functions in Level 2! In this course, you will know how to organize data with the use of the sorting and filtering functions. Convert data into visual representations by using charts.

About the instructor

5.00 (1 ratings)

67 Courses

5 students

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

Phone Number

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup