• Virtual
  • May 5, 2022 - May 6, 2022
  • 10:00 AM to1:00 PM (Everyday)

Contact event manager

Tickets details

  • STANDARD 15 remaining
    $400
View cart
Thank you Kindly

Microsoft Excel – Fundamentals (Virtual)

VIRTUAL (AEST)

Thu, 05 May, 2022 to Fri, 06 May, 2022
May 5, 2022

000000

Microsoft Excel – Fundamentals (Virtual)

VIRTUAL (AEST)

Thu, 05 May, 2022 to Fri, 06 May, 2022
May 5, 2022

PRINT

Excel fundamentals is for everyone who is nervous about using Excel, it may be you have never used it, or you have used it for years, but only to enter data or make minor changes.

This course will give you the confidence to create professional looking spreadsheets, format them to look the way you want and start working with calculations more confidently. You will learn how to print like a pro, visualise data using charts and lots of tips and tricks to help you work more efficiently.

GETTING TO KNOW EXCEL
• Getting to know the User Interface
• Navigating & selecting efficiently
• Creating a new Excel spreadsheet and entering data

CALCULATIONS
• Simple Formulas (subtraction, calculating percentages)
• Working with Functions (SUM, AVERAGE, MAX, MIN)
• Using the Fill Handle to copy calculations
• Relative vs Absolute References

FORMAT
• Fonts & Borders
• Alignment Options
• Number Formats
• Cell Styles & Themes

MODIFYING A WORKSHEET
• Inserting rows and columns
• Adjusting row/column dimensions
• Hiding Rows and Columns

MANAGING LARGE WORKBOOKS
• Working with multiple sheets
• Calculating across sheets
• View Options (split sheet, freeze panes)

PRINTING
• Headers & Footers
• Page Layout
• Page Breaks

CHARTS
• Creating basic charts
• Formatting Charts
• Modifying chart

This course is suitable for beginners – anyone who needs to format spreadsheets or to organise and analyse data. We also cater for more advanced users.

• 1-day Face to Face instructor-led program
• 2 x 3-hour web-based virtual sessions

  • Comprehensive Learning Guide