About this Event
Day One
9:00 AM - 12:00 PM Eastern
Day Two9:00 AM - 12:00 PM Eastern
Day Three9: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
- A Personal Computer
- An External Monitor (strongly recommended)
- Excel 365 or Desktop
- There are no prerequisites to doing this class! If you have a laptop and Excel, you're welcome!
In addition to two half-days of instruction, attendees will walk away with a 150+ page digital manual and data files to revisit the concepts on their own later.
This training will be hosted virtually. Details will be sent after registration.
Questions?
onenumber.biz
Event Venue
Online
USD 995.00