Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
Advertisement
The event you are looking at is a past event. Check out this upcoming event Microsoft Excel Advanced Formulas - 1 Day Course - Brisbane happening on Tue Apr 16 2019 at 09:00 am at Odyssey Training (RACQ Building), Level 1, 60 Edward St, Brisbane, Australia

Microsoft Excel Advanced - 2 Day Course - Brisbane

Advertisement

Microsoft Excel Advanced - 2 Day Course - Brisbane




This course is ideal for

This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes.


What you will learn



Build complex calculations with advanced functions.



Link, export and consolidate data.



Limit data entry and build complex models with Lookup functions.



Analyse data with simple PivotTables and PivotCharts.



Create and modify Macros.




Topics covered in this training course


Protecting your data



Workbook protection



Protecting cells



Protecting structure



Circular references



Locating and deleting circular references



When circular references are necessary



Formula error checking



Range names



Defining range names



Using names in formulas



Navigating with names



Using named constants



Documenting range names



Functions



Math and rounding functions



The AND function



The OR function



Nested IF function



The VLOOKUP function



The HLOOKUP function



Transposing data



Concatenating functions



INDEX and MATCH functions



Using help for functions



Data Validation



Limiting cell values



Creating drop-down cell lists



Validation error messages



What-if analysis tools



Using goal seek



Importing data



Importing CSV files



Text import wizard



Workbook linking



Workbook linking



Dealing with broken links



Data consolidation



Consolidation by cell position



Consolidation by headings



Exporting data



Saving as a different file type



Exporting to Word



Pasting data with a link



Copying a graph with a link



PivotTable reports



Create a PivotTable



Rearranging data



Applying filters



Adding fields



Modify field settings



Refreshing data



Formatting a PivotTable



PivotCharts



Creating a PivotChart



Filtering a PivotChart



Macros



Recording a Macro



Editing a Macro



Relative/Absolute Recording



Stepping through a Macro



Macro buttons



Customising the toolbar



Writing a line of code



Deleting a Macro



You may also like the following events from Odyssey Training:

Map Odyssey Training (RACQ Building), Level 1, 60 Edward St, Brisbane, Australia
Loading venue map..
Event details from Report a problem

Are you going to this event?

Organizer

Odyssey Training
Advertisement