Excel Essentials I (Virtual) | Eastern Time

Tue Feb 18 2025 at 09:00 am to Thu Feb 20 2025 at 12:00 pm UTC-05:00

Online | Online

OneNumber
Publisher/HostOneNumber
Excel Essentials I (Virtual) | Eastern Time
Advertisement
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


Event Photos
Advertisement

Event Venue

Online

Tickets

USD 995.00

Discover more events by tags:

Workshops in OnlineMicrosoft-excel in Online

Sharing is Caring:

More Events in Online

3 Turtles waterclass video lesson
Mon Feb 17 2025 at 07:00 pm 3 Turtles waterclass video lesson

Online

ASA Football Agent Education - Level 2 (Online)
Mon Feb 17 2025 at 07:00 pm ASA Football Agent Education - Level 2 (Online)

Online

Growing Your Author Platform on Social Media
Mon Feb 17 2025 at 07:00 pm Growing Your Author Platform on Social Media

Online

Holidays and Days Out
Tue Feb 18 2025 at 09:30 am Holidays and Days Out

Online

UNDERSTANDING SELF-HARM FOR KINSHIP CARERS IN SCOTLAND
Tue Feb 18 2025 at 10:00 am UNDERSTANDING SELF-HARM FOR KINSHIP CARERS IN SCOTLAND

Online

5 Essential for your Search Engine Optimisation 2025
Tue Feb 18 2025 at 10:00 am 5 Essential for your Search Engine Optimisation 2025

Online

Are You Coachable Part 2: Impactful Coaching with Teams
Tue Feb 18 2025 at 10:00 am Are You Coachable Part 2: Impactful Coaching with Teams

Online

Online is Happening!

Never miss your favorite happenings again!

Explore Online Events