All courses
Hamburger Icon

Excel Essentials

Course Summary

This course provides a comprehensive journey from fundamental navigation to simple data analysis, equipping participants with essential skills for effective spreadsheet use.

Purpose
Gain a fundamental understanding of essential spreadsheet skills.
Audience
Add in information here
Role
Anyone with basic computer skills looking to advance their understansing of Excel
Skill level
Beginner
Style
Lecture | Hands-0n Activities
Duration
2 days
Related technologies
MS Office | Office 365

 

Learning objectives
  • Navigate within Excel and perform essential operations.
  • Use formulas for efficient data manipulation.
  • Validate data to enhance data accuracy.
  • Sort, filter, and visualize data.
  • Use PivotTables for dynamic data summarization.
  • Use simple macros for basic automation

What you'll learn:

In this course, you'll learn:
  • Introduction to Excel
    • Navigate the Excel interface.
    • Understand workbooks, worksheets, cells, and columns.
  • Data Entry and Formatting
    • Enter data efficiently.
    • Format text, numbers, and cells.
  • Basic Formulas and Functions
    • Understand the basics of formulas.
    • Understand relative, absolute, and mixed cell references.
    • Work with common functions
      • SUM
      • AVERAGE
      • COUNT
      • Others
  • Data Sorting and Filtering
    • Sort and filter data for better organization.
    • Utilize AutoFilter and custom sorting.
  • Advanced Formulas
    • Dive into more complex formulas.
      • VLOOKUP
      • IF
      • CONCATENATE
      • Others
  • Data Validation
    • Implement data validation rules.
    • Ensure data accuracy and consistency.
  • Charts and Graphs
    • Create visually appealing charts.
    • Customize and format charts for effective data representation.
  • PivotTables
    • Introduction to PivotTables for data summarization.
    • PivotTable customization and analysis.
  • Introduction to Macros
    • Understand the concept of macros.
    • Record and run simple macros for automation.

Excel Essentials

real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
fully customized

Tailored Outlines

Once-size-fits-all doesn't apply to training teams. That's where we come in!

Dive in and learn more

When transforming your workforce, it’s important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.