• Virtual
  • April 27, 2023 - April 28, 2023
  • 10:00 AMto1:00 PM (Everyday)

Contact event manager

Tickets details

  • Sorry, Event passed
View cart
Thank you Kindly

Microsoft Excel – Fundamentals (Virtual)Passed

VIRTUAL (AEST)

Thu, 27 April, 2023 to Fri, 28 April, 2023
April 27, 2023

000000

Microsoft Excel – Fundamentals (Virtual)Passed

VIRTUAL (AEST)

Thu, 27 April, 2023 to Fri, 28 April, 2023
April 27, 2023

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

 
This workshop is not suitable for Mac Users.  Should you have a Microsoft Office for Mac training requirement, please contact us for assistance.

  • Comprehensive Learning Guide