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
Date Functions
- DATE and TIME
- DATEVALUE
- VALUE
- DATEDIF
- DATEADD options
- NOW
- TODAY
- NETWORKDAYS
- Arrays
- VLOOKUP
- XLOOKUP
- XLOOKUP vs VLOOKUP
- FILTER
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?
oliver.linley@onenumber.biz
onenumber.biz
