Copied to clipboard

Excel 2 - Intermediate

In this Intermediate Excel course, students learn how to use formulas, advanced functions, macros and tables

About the program

Examples of functions covered include sorting, and filtering, formatting graphics, as well as protecting and finalizing a workbook. This course is for individuals who have completed the Excel Introduction course and/or possess a basic knowledge of Excel, and wish to learn about higher-level functionalities in Excel.

Objectives

What you will learn:
• Formulas and Functions
• Formulas that Manipulate Text
• Working with Dates and Times
• Formulas that Look Up Values
• Introducing Pivot Tables
• Introduction to Macros

Prerequisites

Who should attend:
This course is for individual who has a basic understanding of Excel and wish to learn more about the various Excel functions, macros and tables.

Enroll today to learn how to use formulas and functions, including sorting, filtering, formatting graphics, as well as protecting and finalizing a workbook.

Required materials:

It is to be noted that an additional fee of $118.00+tx is applicable for course materials. This e-book is used in the second and third courses of the excel series.

A week or less

Course Attestation and Professional Development