SydneyMelbourneBrisbane

BOOK NOW

Course Details
Price: $825dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
team
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Mon 09-Jul-18 Excel Beginner Sydney Course confirmed to run. Limited number of seats available.
Tue 24-Jul-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Sydney Course confirmed to run. Limited number of seats available.
Mon 17-Sep-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Thu 18-Oct-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Mon 29-Oct-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Wed 21-Nov-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Tue 27-Nov-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full
TRAFFIC LIGHTS EXPLAINED

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $825dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Wed 27-Jun-18 Excel Beginner Melbourne No more seats are available for this course.
Mon 09-Jul-18 Excel Beginner Melbourne Course confirmed to run. Limited number of seats available.
Tue 24-Jul-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Tue 16-Oct-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Mon 29-Oct-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Wed 14-Nov-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Thu 22-Nov-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full
TRAFFIC LIGHTS EXPLAINED

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $825dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Wed 27-Jun-18 Excel Beginner Brisbane Course confirmed to run. Limited number of seats available.
Wed 04-Jul-18 Excel Beginner Brisbane Course confirmed to run. Limited number of seats available.
Mon 09-Jul-18 Excel Beginner Brisbane Course confirmed to run. Limited number of seats available.
Tue 24-Jul-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Thu 18-Oct-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 29-Oct-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full
TRAFFIC LIGHTS EXPLAINED

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

Are you looking to understand the basics of Excel?

Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our One-day course. Our Excel Training Beginner course, includes creating and formatting spreadsheets and charts, learning to sort and filter and gaining an understanding of Excel’s advanced formulas and functions. You can build on this course with the Intermediate and Advanced levels when it suits.

What do I need to know to attend?

There is no requirement for the Basic 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, right from the start.

Learning Outcomes – Excel Basics

On completion of this course you should be able to:

      • navigate your way around Microsoft Excel
      • create and work with a new workbook
      • open and navigate within workbooks and worksheets
      • understand and work with ranges in a worksheet
      • understand, create and work with formulas and functions used to perform calculations
      • understand points to consider to avoid problems in your worksheets
    • use font formatting techniques to greatly enhance the look of a worksheet
    • alter the layout of a worksheet
    • sort and filter data in a worksheet
    • print your workbook data
    • create effective charts in Microsoft Excel
    • obtain help for Excel whenever you need it
Course Details
  • Courses will run from 9am – 4pm (approx.)
  • Classes limited to approx 10 people
  • Excel Beginner Course costs $330
  • Reference Manuals provided
  • Central city locations
Each Student receives
  • Excel Cheat Sheet
  • Reference Workbooks
  • e-Certificate of attendance
  • Complimentary post course training e-support
  • Trained by a Microsoft Certified Excel Expert
  • Satisfaction guarantee or repeat FREE within 8mths
Related courses
InfoExcel Course Intermediate
InfoExcel Course Advanced
InfoExcel VBA Course
Course Content
Basics
  • Starting Excel from the Desktop
  • Understanding the Excel Start Screen
  • The Excel Workbook Screen
  • How Excel Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
  • Exiting Safely From Excel
Workbooks
  • Understanding Workbooks
  • Using the Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving a New Workbook
  • Checking the Spelling
  • Making Basic Changes
  • Safely Closing a Workbook
Navigating
  • 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
Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Understanding Copying in Excel
  • Using Fill for Quick Copying
  • Copying from One Cell to Another
  • Copying from One Cell to A Range
  • Copying from One Range to Another
  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Extracting with Flash Fill
  • Understanding Moving in Excel
  • Moving Cells and Ranges
Formulas/Functions
  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using The SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • Creating More Complex Formulas
  • What If Formulas
  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems with Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Common Error Messages
Formatting
  • Understanding Font Formatting
  • Working with Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Making Cells Bold
  • Italicising Text
  • Underlining Text
  • Changing Font Colours
  • Changing Background Colours
  • Using the Format Painter
  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • Using the Thousands Separator
  • Increasing and Decreasing Decimals
Layout
  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Understanding Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells into a Worksheet
  • Deleting Cells from a Worksheet
  • Inserting Columns into a Worksheet
  • Inserting Rows into a Worksheet
  • Deleting Rows and Columns
  • More than One Worksheet
  • Worksheet Wisdom
Sorting/Filtering
  • Understanding Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on Multiple Columns
  • Understanding Filtering
  • Applying and Using A Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
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
Charts
  • Understanding the Charting Process
  • Choosing the Right Chart
  • Using a Recommended Chart
  • Creating a New Chart From Scratch
  • Working with an Embedded Chart
  • Resizing a Chart
  • Repositioning a Chart
  • Printing an Embedded Chart
  • Creating a Chart Sheet
  • Changing the Chart Type
  • Changing the Chart Layout
  • Changing the Chart Style
  • Printing a Chart Sheet
  • Embedding a Chart into a Worksheet
  • Deleting a Chart
Help
  • Understanding How Help Works
  • Accessing the Help Window
  • Navigating the Help Window
  • Using the Office Website for Help
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance
Guidelines
  • Nothing Beats Good Planning
  • Organisation and Design
  • Spot On Formulas
  • Documented and Easy to Use
  • The Appropriateness of Spreadsheets
Excel Consulting - Training Courses
Average rating:  
 6421 reviews
by Sue Hadwen on Excel Consulting - Training Courses

Good. A lot of information to absorb in one day.- Excel Intermediate Melbourne - Excel Intermediate Melbourne

Page 1 of 6421:
«
 
‹
 
1
2
3
›
 
»
 
Download Course Content Here

PDFExcel Beginner
PDFExcel Intermediate
PDFExcel Advanced
PDFExcel VBA