BEGIN:VCALENDAR VERSION:2.0 PRODID:-//hacksw/handcal//NONSGML v1.0//EN BEGIN:VEVENT UID:c1cfd67d261553d99df92de49d47edebhttps://www.prioritymanagement.com.au DTSTAMP:20240329T185208 DTSTART:TZID=20230427T100000 DTEND:TZID=20230428T130000 SUMMARY:Microsoft Excel - Fundamentals (Virtual) DESCRIPTION:[vc_row][vc_column width="1/1"][vc_column_text uncode_shortcode_id="719399"] 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. [/vc_column_text][vc_tabs][vc_tab title="Units" tab_id="1578020048-1-744290-96a91633749798304"][vc_column_text] 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[/vc_column_text][/vc_tab][vc_tab title="Audience" tab_id="1578020048-2-494290-96a91633749798304"][vc_column_text]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.[/vc_column_text][/vc_tab][vc_tab title="Format" tab_id="1578020247795-2-84290-96a91633749798304"][vc_column_text uncode_shortcode_id="205923"]• 1-day Face to Face instructor-led program • 2 x 3-hour web-based virtual sessions