Excel Essentials I (Virtual) | Eastern Time

Everything you need to know about Excel to work efficiently and effectively TODAY!
About this Event

Day One

9:00 AM - 12:00 PM Eastern

Day Two

9:00 AM - 12:00 PM Eastern

Day Three

9:00 AM - 12:00 PM Eastern

Excel is an incredibly powerful tool that allows us to clean and sort data, analyse, visualise, and automate our data processes. Knowing where to start your learning can be intimidating, but with Excel Essentials I, we'll cover all the areas of this powerful product to set you up to work in Excel with confidence and skill.

Topics we will explore include:

Introduction to Excel

What is Excel?
What file types can I work with?

Worksheet Formatting

Filtering and Sorting
Freeze Rows/Columns
Field-Based Formatting
Insert, Delet, and Hide Rows/Columns
Removing Duplicates
Conditional Formatting
Duplicating Worksheets
Building Tables
Themes
Find and Replace

Shortcuts and Tips

Copy and Paste
Select All
Autofill
Adjust All Rows/Columns At Once
Copy Visible Cells Only
Cross-Workbook References
Named Ranges
Input Data From PDF

Intro to Functions and Formulas

Math and Operators
Aggregations (SUM, AVG, COUNTD)

Logic Functions

IF
Nested IF
SUMIF
COUNTIF
AVERAGEIFS
IFERROR

String Functions

Text to Columns
CONCAT
TEXTJOIN
SEARCH
LEFT
RIGHT
MID

Case Functions

UPPER
LOWER
PROPER
TRIM

Date Functions

DATE and TIME
DATEVALUE
VALUE
DATEDIF
DATEADD options
NOW
TODAY
NETWORKDAYS
Arrays
VLOOKUP
XLOOKUP
XLOOKUP vs VLOOKUP
FILTER

Macros

Intro to Macros

Structuring Data

Ideal Data Formatting
Red Flags for Formatting
Pivot Tables
UNIQUE
Transposing Rows and Columns
INDEX
MATCH
LOOKUP
Anchoring References
OFFSET & Dynamic Arrays
Grouping Data

Building Visuals

Bar Charts
Line Graphs
Highlight Tables
Scatterplots
Pie Charts

Best Practices

Using Colour
Formatting Options
Merged Cells
Error-Handling

Collaboration and Sharing

Office 365 vs Desktop
Sharepoint/OneDrive

Requirements:

A Personal Computer
An External Monitor (strongly recommended)
Excel 365 or Desktop

Prerequisites:

There are no prerequisites to doing this class! If you have a laptop and Excel, you're welcome!

What will you get?

In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual, data files to revisit the concepts on their own later, and access to class recordings for two weeks.

Where will this be hosted?

This training will be hosted virtually. Details will be sent after registration.

Questions?

[email protected]

onenumber.biz