Feb 15th 9:30am – 3:30pm
Microsoft Office Excel 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
Length: 1 day
Class Price: $350/person (CAD)
Corporate Price: Request Quote
Course Category: Microsoft
Attend our scheduled class at our Edmonton Computer Lab. Utilize our computers at our live instructor-led classes.
Attend our scheduled class live online, from the convenience of your own home or work. Access to training materials prior to class.
Customized training for your team. Keep up with technological changes, engage learners & improve individual performance.
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
- Live Instruction
- Hands-On Learning
- Interaction With All Students In-Class & Online
- Access To All Software For Class
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.
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.
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.
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.
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.