BEGIN:VCALENDAR VERSION:2.0 PRODID:Imitheme.com BEGIN:VEVENT UID:20240328T223205-1661022555 DTSTAMP;TZID=UTC:1711665125 DTSTART:20221124T100000Z DTEND:20221125T130000Z SUMMARY:Microsoft Excel - Advanced (Virtual) LOCATION:VIRTUAL (AEST) DESCRIPTION: [vc_row][vc_column width="1/1"][vc_column_text]Excel Advanced is for people who need to create sophisticated user-friendly spreadsheets, solve more complex problems, perform data analysis, work with different scenarios or create more automated solutions in Excel. In this course we will look at how we can ensure accuracy using data validation and protection functionality, we will automate procedures using a range of lookup functions and macros, model different scenarios using what-if analysis tools and analyse and visualise data using PivotTables and Pivot Charts. [/vc_column_text][vc_tabs][vc_tab title="Units" tab_id="1578020048-1-744290-96a91633685995331"][vc_column_text]DATA VALIDATION • Add simple validation • Add validation that uses calculations • Create automated drop-down lists LOOKUP FUNCTIONS • VLOOKUP • INDEX • MATCH • XLOOKUP (version permitting) PROTECTING DATA • Protecting access to a spreadsheet • Protecting the structure of a workbook CHARTS • Create Pivot table reports • Modify calculations within pivots • Change the formatting of PivotTables • Sort and Filter PivotTables • Add Pivot Charts • Create interactive dashboards with Pivot • Charts and Slicers ADDING DIFFERENT TYPES OF PROTECTION TO SPECIFIC CELLS MACROS • Understand macros and macro security • Record and run macros • Edit macros • Create buttons for running macros PIVOT TABLES • VLOOKUP range lookup • VLOOKUP exact match WHAT IF SCENARIOS • Goal Seek • Scenario Manager • Solver [/vc_column_text][/vc_tab][vc_tab title="Audience" tab_id="1578020048-2-494290-96a91633685995331"][vc_column_text]Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs. PREQUALIFICATIONS Advanced Excel training is for people who can already create moderately complex spreadsheets and want to add more sophistication and automation. Candidates should have completed the Intermediate level, or feel competent they have an intermediate knowledge of Excel.[/vc_column_text][/vc_tab][vc_tab title="Format" tab_id="1578020247795-2-84290-96a91633685995331"][vc_column_text uncode_shortcode_id="480633"]• 1-day Face to Face instructor-led program • 2 x 3-hour web-based virtual sessions