Private Training — Microsoft Office Excel Course

Private Training — 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

Category: Tag:

OVERVIEW

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.

WHAT YOU GET

  • Live Instruction
  • Hands-On Learning
  • Interaction With All Students In-Class & Online
  • 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.