Excel Essentials I (Virtual) | Eastern Time

Tue, 18 Feb, 2025 at 09:00 am to Thu, 20 Feb, 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

Breathing for Stress Management
Tue, 18 Feb, 2025 at 08:00 pm Breathing for Stress Management

Online

Lunar Rest + Return: February
Tue, 18 Feb, 2025 at 08:00 pm Lunar Rest + Return: February

Online

Celebrating  "A Healthy Interest in the Lives of Others"
Tue, 18 Feb, 2025 at 08:00 pm Celebrating "A Healthy Interest in the Lives of Others"

Online

Tarot Card or Akashic Reading for One Person
Tue, 18 Feb, 2025 at 09:00 pm Tarot Card or Akashic Reading for One Person

Online

Lana Uncensored
Tue, 18 Feb, 2025 at 09:00 pm Lana Uncensored

Online

Focus Group for PIP replacement consultation
Wed, 19 Feb, 2025 at 02:00 am Focus Group for PIP replacement consultation

Online

Community Organising Training with Citizens UK
Wed, 19 Feb, 2025 at 03:00 am Community Organising Training with Citizens UK

Ruils - Independent Living

The Measurement Academy: Measure for Impact
Wed, 19 Feb, 2025 at 04:30 am The Measurement Academy: Measure for Impact

Online

Scott Dunn | Online | Agile OKRs | AOKRs | February 19th
Wed, 19 Feb, 2025 at 06:00 am Scott Dunn | Online | Agile OKRs | AOKRs | February 19th

Online

Business Networking - BNI Chapter 18
Wed, 19 Feb, 2025 at 07:00 am Business Networking - BNI Chapter 18

Online

Online is Happening!

Never miss your favorite happenings again!

Explore Online Events