EXCEL

LEVEL 1 COURSE

Efficiently manage and analyze data with Microsoft Office Excel.  Learn how to enter and organize data, perform calculations with simple formulas & functions, create and format tables & charts, format the appearance of rows, columns, cells, and data.

Excel Versions That Can Attend: Excel 365, 2019, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Version Excel for Microsoft 365  Software and Courseware

Choose The Most Convenient Way For You To Learn

Attend Online

From The Comfort Of You Your Home/Office

Classroom Training

Join us at our Edmonton training location

Training Length

1 day

Price

$350/person (CAD)

Corporate Price

Request Quote

Course Category

Accounting/Bookkeeping

Overview

Efficiently manage and analyze data with Microsoft Offices Excel.  Learn how to enter and organize data, perform calculations with simple formulas & functions, create and format tables & charts, format the appearance of rows, columns, cells, and data.

What You Get

N

Live Instruction

N

Hands-On Learning

N

Interaction With All Students In Class & Online

N

Access To All Software For Class

Course Topics

\

Intro to Excel

Topics: Create a new workbook, Insert or delete a worksheet, Move or copy worksheets or worksheet data, Print a worksheet or workbook, Use Excel as your calculator & Fill data automatically in worksheet cells.

\

Row & columns

Topics: Insert or delete rows, and columns, Select cell contents in Excel, Freeze panes to lock rows and columns, Hide or show rows or columns, Filter for unique values or remove duplicate values, Split text into different columns with the Convert Text to Columns Wizard & Create a list of sequential dates.

\

Cells

Topics:  Move or copy cells and cell contents, Change the column width or row height in Excel, Find or replace text and numbers on a worksheet, Merge and unmerge cells, Apply data validation to cells & Import or export text (.txt or .csv) files.

\

Formatting

Topics:  Available number formats in Excel, Conditional formatting, Align or rotate text in a cell, Change the format of a cell, Copy cell formatting, Add a watermark in Excel, Display or hide zero values & Create a custom number format

\

Formulas & Functions

Topics:  Overview of formulas in Excel, VLOOKUP, SUM function, COUNTIF function, IF function, IFS, SUMIF, SUMIFS, Automatically number rows, Calculate the difference between two dates, Define and use names in formulas & Combine text from two or more cells into one cell.

\

Tables

Topics:  Create and format tables, Sort data in a table, Filter data in a range or table, Total the data in an Excel table & Use slicers to filter data.

\

Charts

Topics:  Create a chart from start to finish, Add or remove titles in a chart, Show or hide a chart legend or data table, Add or remove a secondary axis in a chart in Excel, Add a trend or moving average line to a chart, Analyze your data instantly, Update the data in an existing chart & Use sparklines to show data trends.

Learn More

6 + 9 =

N

Live, Instructor Led Training (online or in person options)

N

Learn Account Setup, Payroll, Inventory, Reconciliation & More

N

Manage Your Accounting Much More Confidently & Efficiently

N

Suitable For Those Starting Out Or Experienced

Sign Up Today. Satisfaction Guaranteed

Register Today