BEGIN:VCALENDAR
                        VERSION:2.0
                        PRODID:-//hacksw/handcal//NONSGML v1.0//EN
                        BEGIN:VEVENT
                        UID:c1c405de0de525fedc361a4e9be96356https://www.prioritymanagement.com.au
                        DTSTAMP:20260407T024833
                        DTSTART:TZID=20260407T024833
                        DTEND:TZID=20260407T024833
                        SUMMARY:Microsoft Excel - Intermediate (Virtual)
                        DESCRIPTION:[vc_row][vc_column width="1/1"][vc_column_text uncode_shortcode_id="151696"]
Excel intermediate is for people who already work with Excel quite comfortably (are happy modifying worksheets and creating simple formulas) but want to start working more efficiently and using a broader selection of tools. In this course we will get on top of our data, harnessing some important automation tools and looking at a broad range of Excel functions for cleaning, transforming, summarising, categorising and linking data. We will also look at 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-96a91633686407753"][vc_column_text uncode_shortcode_id="452569"]<strong>FILLING DATA</strong>
• Use the fill handle to quickly generate data
• Look at fill options and Flash Fill
• Work with Custom Lists

<strong>TEXT AND DATE FUNCTIONS</strong>
• Functions for joining text
• Functions for changing case
• Functions for splitting text
• Date functions

<strong>NAMED RANGES</strong>
• Creating Named Ranges using the Name Box
• Create from Selection
• Using the Name Manager
• Using Named Ranges in Calculations

<strong>AGGREGATION FUNCTIONS</strong>
• Different COUNT functions
• COUNTIFS, SUMIFS &amp; AVERAGEIFS

<strong>TABLES</strong>
• Converting from a range to a table
• Customising tables and working with the total row
• Sorting and Filtering table data
• Slicers
• Automating processes with tables

<strong>LOOKUP FUNCTIONS</strong>
• VLOOKUP range lookup
• VLOOKUP exact match

<strong>CHARTS</strong>
• Create combination charts
• Customise Charts
• Work with more specialised chart types[/vc_column_text][/vc_tab][vc_tab title="Audience" tab_id="1578020048-2-494290-96a91633686407753"][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.[/vc_column_text][/vc_tab][vc_tab title="Format" tab_id="1578020247795-2-84290-96a91633686407753"][vc_column_text uncode_shortcode_id="207450"]• 2 x 3-hour web-based virtual sessions (MS Teams)
• Attendees <strong>must</strong> attend both days
<div><u></u> <u></u></div>
<div><b>This workshop is not suitable for Mac Users.  </b><span class="ui-provider"><b>Should you have a Microsoft Office for Mac training requirement, please contact us for assistance.</b></span></div>
[/vc_column_text][/vc_tab][vc_tab title="What's Included" tab_id="1578020281851-3-54290-96a91633686407753"][vc_column_text]
<ul>
 	<li>Comprehensive Learning Guide</li>
</ul>
[/vc_column_text][/vc_tab][/vc_tabs][/vc_column][/vc_row]
                        END:VEVENT
                        END:VCALENDAR