Questions? Complete the form below to request FREE information!


I understand that by submitting this form, I consent to be contacted by email, phone, text message or any other form of communication by AIMS Colleges. My consent can be withdrawn at any time.

Request Free Info

Toronto,Canada

Microsoft Excel

Course Highlights

Students will learn use and manage multiple worksheets and workbooks efficiently, eventually extrapolating into more advanced formatting options including styles, themes, backgrounds and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names and how to work with lists and tables. They will learn how to work with Pivot Tables and Pivot Charts, how to import and export data, and how to query external databases.

Overview

After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to will enter and edit text, values, formulae, pictures and they will save workbooks in various formats.

Course Outline

· Getting Started

· Understanding rows and columns Ÿ Using “Excel Help”

· Using Backstage Working with Excel

· Creating Workbooks

· Entering and Editing data

· Saving the Workbook

· Understanding different file formats for Excel Formatting in Excel

· Insert and Delete cells

· Using Format Painter

· Working with Hyperlinks

· Using Conditional Formatting Understanding Worksheet Components

· Using Themes

· Working in different “views”

· Using Headers & Footers

· Using Print Layout and Printing

Managing Worksheets

· Organizing & working with multiple worksheets

· Using “Freeze” function

· Find & Replace data Working with Data

· Ensuring Data’s integrity

· Sorting, Filtering Data

· Setting up Data in tabular format Using Basic Formulae and Functions

· Building Basic Formulae with Cell referencing

· Using Cell ranges Adding Pictures and Shapes to a Worksheet

· Inserting Autoshapes Inserting Pictures

· Formatting, Changing attributes of Graphics

· Using Picture Tools for added enhancements

Creating Charts and Pivot Tables

· Understanding Creating different types of Charts

· Formatting parts of a Chart manually

· Creating Pivot Tables Using Advanced Formulae and Securing Workbooks

· Conditionally summarize Data, Look up Data using Formulae

· Using Conditional Logic Functions to Formulae

· Using Formulae to Format text

· Securing workbook before Sharing

· Emailing Spreadsheets

· Review functions including Tracking Changes and Using comments in Workbook

Close Menu