Event details
- Virtual
- October 17, 2024 - October 18, 2024
- 9:30 AM to 12:45 PM (Everyday)
Contact event manager
Tickets details
- Sorry, Event passed
Microsoft Excel – Fundamentals (Virtual)Passed
VIRTUAL (AEST)
Thu, 17 October, 2024 to Fri, 18 October, 2024
October 17, 2024
000000
Microsoft Excel – Fundamentals (Virtual)Passed
VIRTUAL (AEST)
Thu, 17 October, 2024 to Fri, 18 October, 2024
October 17, 2024
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 hours and 15 Minutes web-based virtual sessions
- Comprehensive Learning Guide