BEGIN:VCALENDAR
VERSION:2.0
PRODID:Imitheme.com
BEGIN:VEVENT
UID:20260415T041554-1042956090
DTSTAMP;TZID=UTC:1776226554
DTSTART:20260415T041554Z
DTEND:19700101T000000Z
SUMMARY:Microsoft Excel - Advanced (Virtual)
LOCATION:VIRTUAL
DESCRIPTION: [vc_row][vc_column width="1/1"][vc_column_text uncode_shortcode_id="177106"]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]

<strong>DATA VALIDATION</strong>
• Add simple validation
• Add validation that uses calculations
• Create automated drop-down lists

<strong>LOOKUP FUNCTIONS</strong>
• VLOOKUP
• INDEX
• MATCH
• XLOOKUP (version permitting)

<strong>PROTECTING DATA</strong>
• Protecting access to a spreadsheet
• Protecting the structure of a workbook

<strong>CHARTS</strong>
• 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

<strong>ADDING DIFFERENT TYPES OF PROTECTION TO SPECIFIC CELLS MACROS</strong>
• Understand macros and macro security
• Record and run macros
• Edit macros
• Create buttons for running macros

<strong>PIVOT TABLES</strong>
• VLOOKUP range lookup
• VLOOKUP exact match

<strong>WHAT IF SCENARIOS</strong>
• 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.

<strong>PREQUALIFICATIONS</strong>
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="558691"]• 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-96a91633685995331"][vc_column_text]
<ul>
 	<li>Extensive Learning &amp; Reference Guides provided on USB</li>
 	<li>Participation in the full day workshop</li>
 	<li>Access to a Microsoft technical expert throughout and post the workshop</li>
</ul>
[/vc_column_text][/vc_tab][/vc_tabs][/vc_column][/vc_row]
END:VEVENT
END:VCALENDAR