Excel Training - Beginner Course (2024)

Auckland

Wellington

Christchurch

Remote NZ

Upcoming Courses:

There are no requirements for the Excel Beginner course. The course is suitable for people who have never worked with Excel or have just had very limited exposure to it. We will walk you through it, right from the start.

• Your First Workbook
• Understanding Workbooks
• Using the Blank Workbook Template
• Typing Text
• Typing Numbers
• Typing Dates
• Understanding the Fill Handle
• Typing Formulas
• Easy Formulas
• Saving a New Workbook on Your Computer
• Checking the Spelling
• Making Basic Changes
• Safely Closing a Workbook

• Working WithWorkbooks
• Opening an Existing Workbook
• Navigating a Workbook
• Navigating Using the Keyboard
• Using Go To
• Recent Files and Folders
• Understanding Data Editing
• Overwriting Cell Contents
• Editing Longer Cells
• Editing Formulas
• Clearing Cells
• Deleting Data
• Using Undo and Redo

• Cells and Ranges
• Understanding Cells and Ranges
• Selecting Contiguous Ranges
• SelectingNon ContiguousRanges
• Using Special Selection Techniques
• Selecting Larger Ranges
• Selecting Rows
• Selecting Columns
• Understanding Copying in Excel
• Using Fill for Quick Copying
• CopyingFromOne Cell to Another

• Cells and Ranges (cont'd)
• CopyingFromOne Cell to a Range
• CopyingFromOne Range to Another
• Understanding Filling
• Filling a Series
• Filling a Growth Series
• ExtractingWithFlash Fill
• More Complex Flash Fill Extractions
• Understanding Moving in Excel
• Moving Cells and Ranges
• Moving by Dragging

• Formulas and Functions
• Understanding Formulas
• Creating Formulas That Add
• Creating Formulas That Subtract
• Formulas That Multiply and Divide
• Understanding Functions
• Using the SUM Function to Add
• Summing Non-Contiguous Ranges
• Calculating an Average
• Finding a Maximum Value
• Finding a Minimum Value

• Formulas and Functions (cont'd)
• Creating More Complex Formulas
• What if Formulas
• Absolute Versus Relative Referencing
• Relative Formulas
• ProblemsWithRelative Formulas
• Creating Absolute References
• Creating Mixed References
• Common Error Messages

• Worksheet Appearance
• Understanding Font Formatting
• WorkingWithLive Preview
• Changing Fonts
• Changing Font Size
• Growing and Shrinking Fonts
• Making Cells Bold
• Italicising Text
• Underlining Text
• Changing Font Colours
• Changing Background Colours

• Worksheet Appearance (cont'd)
• Using the Format Painter
• Applying Strikethrough
• Subscripting Text
• Superscripting Text
• Understanding Cell Alignment
• Horizontal Cell Alignment
• Vertical Cell Alignment
• Indenting Cells
• Understanding Number Formatting
• Applying General Formatting
• Formatting for Money

• Worksheet Appearance (cont'd)
• Formatting Percentages
• Formatting as Fractions
• Formatting as Dates
• Using the Thousands Separator
• Increasing and Decreasing Decimals
• Understanding Borders
• Applying a Border to a Cell
• Applying a Border to a Range
• Applying a Bottom Border
• Applying Top and Bottom Borders
• Removing Borders

• Worksheet Layout
• Approximating Column Widths
• Setting Precise Columns Widths
• Setting the Default Column Width
• Approximating Row Height
• Setting Precise Row Heights
• Hiding Rows and Columns
• Unhiding Rows and Columns
• Understanding Worksheets
• Changing the Worksheet View
• Worksheet Zooming
• Viewing the Formula Bar
• Viewing Worksheet Gridlines
• Inserting CellsIntoa Worksheet

• Worksheet Layout (cont'd)
• Deleting CellsFroma Worksheet
• Inserting ColumnsIntoa Worksheet
• Inserting RowsIntoa Worksheet
• Deleting Rows and Columns
• More Than One Worksheet
• Worksheet Wisdom

• Worksheet Techniques
• Inserting and Deleting Worksheets
• Copying a Worksheet
• Renaming a Worksheet
• Moving a Worksheet
• Hiding a Worksheet
• Unhiding a Worksheet
• Copying a Sheet to Another Workbook
• Moving a Sheet to Another Workbook
• Changing Worksheet Tab Colours

• Worksheet Techniques (cont'd)
• Grouping Worksheets
• Hiding Rows and Columns
• Unhiding Rows and Columns
• Freezing Rows and Columns
• Splitting Windows
• New Windows

• Sorting and Filtering Data
• Understanding Lists
• Performing an Alphabetical Sort
• Performing a Numerical Sort
• Sorting on More Than One Column
• Understanding Filtering
• Applying and Using a Filter
• Clearing a Filter
• Creating Compound Filters
• Multiple Value Filters
• Creating Custom Filters
• Using Wildcards

• Creating Charts
• Understanding the Charting Process
• Choosing the Right Chart
• Using a Recommended Chart
• Creating a New ChartFromScratch
• WorkingWithan Embedded Chart
• Resizing a Chart
• Repositioning a Chart
• Printing an Embedded Chart
• Creating a Chart Sheet

• Creating Charts (cont'd)
• Changing the Chart Type
• Changing the Chart Layout
• Changing the Chart Style
• Printing a Chart Sheet
• Embedding a ChartIntoa Worksheet
• Deleting a Chart

• Page Setup
• Strategies for Printing Worksheets
• Understanding Page Layout
• Using Built in Margins
• Setting Custom Margins
• Changing Margins by Dragging
• Centring on a Page
• Changing Orientation
• Specifying the Paper Size
• Setting the Print Area
• Clearing the Print Area
• Inserting Page Breaks

• Page Setup (cont'd)
• Using Page Break Preview
• Removing Page Breaks
• Setting a Background
• Clearing the Background
• Settings Rows as Repeating Print Titles
• Clearing Print Titles
• Printing Gridlines
• Printing Headings
• Scaling to a Percentage
• Fit to a Specific Number of Pages

• Printing
• Understanding Printing
• Previewing Before You Print
• Selecting a Printer
• Printing a Range
• Printing an Entire Workbook
• Specifying the Number of Copies
• The Print Options

• Supplementary Content
• Applying Borders
• Using brackets in excel formulas
• The Quick Analysis Tools
• Starting With Excel Online
• Working With Excel Online