Overview
Excel is more than just a grid for numbers—it’s a powerful tool for organizing data, performing calculations, and gaining insights. This course takes you from basic spreadsheet skills to confident Excel proficiency, covering the essential features that make Excel indispensable for business.
You’ll learn to build formulas that calculate automatically, organize and analyze data with sorting and filtering, create charts that visualize trends, and use PivotTables to summarize complex information instantly. Whether you’re tracking budgets, analyzing sales data, or managing project information, you’ll develop the core Excel skills that modern professionals need.
Format: 2 Days | VILT
Who Should Attend
- Administrative professionals managing data and reports
- Anyone wanting to move beyond basic spreadsheet use
- New employees needing foundational Excel skills
- Self-taught users looking to formalize their knowledge
- Professionals who need to analyze and present data
What You’ll Learn
- Create and format professional spreadsheets efficiently
- Build formulas using essential functions like SUM, AVERAGE, IF, and VLOOKUP
- Sort and filter data to find information quickly
- Create charts and graphs to visualize data trends
- Use PivotTables to summarize and analyze large datasets
- Format data as tables for easier management
- Print spreadsheets that fit on the page properly
Course Outline
Module 1: Excel Fundamentals
- Understanding the Excel interface: ribbons, worksheets, and workbooks
- Navigating spreadsheets with mouse and keyboard shortcuts
- Entering and editing data efficiently
- Selecting cells, ranges, rows, and columns
- Using AutoFill to extend data patterns
- Managing worksheets: inserting, deleting, renaming, and moving
Module 2: Formatting and Cell Management
- Applying number formats: currency, percentages, dates
- Adjusting column widths and row heights
- Using fonts, colors, and borders for readability
- Cell alignment and text wrapping
- Copying and moving data with cut, copy, paste
- Using Paste Special for values, formatting, and formulas
- Format Painter for quick formatting
Module 3: Formulas and Basic Functions
- Understanding formula syntax and cell references
- Creating simple calculations: addition, subtraction, multiplication, division
- Using SUM, AVERAGE, MIN, and MAX functions
- COUNT and COUNTA for counting data
- Relative vs. absolute cell references ($)
- Copying formulas and understanding reference behavior
Module 4: Essential Business Functions
- IF function for conditional logic
- SUMIF and COUNTIF for conditional calculations
- VLOOKUP for finding data in tables
- TEXT functions: CONCATENATE, LEFT, RIGHT, MID
- Date calculations and TODAY function
- Troubleshooting common formula errors
Module 5: Working with Data
- Converting ranges to formatted Tables
- Benefits of Table features: structured references and auto-expansion
- Sorting data by single and multiple columns
- Filtering data to show specific records
- Using AutoFilter and custom filters
- Removing duplicates from datasets
- Using Find and Replace for data cleanup
Module 6: Charts and Data Visualization
- Choosing the right chart type: column, bar, line, pie
- Creating charts from your data
- Formatting chart elements: titles, legends, axes
- Changing chart colors and styles
- Moving and resizing charts
- Updating charts when data changes
- Creating combination charts for multiple data series
Module 7: PivotTables for Data Analysis
- What PivotTables are and when to use them
- Creating your first PivotTable from data
- Adding rows, columns, values, and filters
- Summarizing data: sum, count, average, and more
- Grouping data by dates, categories, and ranges
- Formatting PivotTables for presentation
- Refreshing PivotTables when source data changes
- Creating PivotCharts from PivotTable data
Module 8: Printing and Productivity
- Page setup: orientation, margins, and scaling
- Setting print areas and page breaks
- Adding headers and footers with page numbers
- Repeating row and column headings on printed pages
- Print preview and adjusting before printing
- Freezing panes to keep headers visible while scrolling
- Splitting windows for viewing different areas
- Keyboard shortcuts for faster work
Prerequisites & Technical Requirements
- Basic computer skills and comfort with Windows or Mac
- Microsoft Excel 2016 or later (Office 365 recommended)
- No prior Excel experience required
Customization Options
This course can be tailored to your organization’s specific data and analysis needs. We can work with your actual datasets—whether you track sales, budgets, inventory, or project data—and adjust examples to reflect your industry. If your team needs particular functions or chart types emphasized, we can customize the curriculum to match your workflow.