Microsoft Excel Advanced - 2 Day Course - Brisbane

Microsoft Excel Advanced - 2 Day Course - Brisbane
Image from everi.events
From Thu 9 April 2020 to Thu 11 June 2020
From Thursday 9 April 2020 to Thursday 11 June 2020
4:42 PM - 0:00 AM
Ended

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 Ticket Information Ticket Price Individual AUD 850

46670 Views - 12/06/2020 Last update
sports courses
edward st 60
odyssey training racq building level 1, brisbane city, 4000, qld, au
Event from
everi.events

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

odyssey training racq building level 1, brisbane city, 4000, qld, au

Browse other venues in Brisbane
Discover now


Discover more events in Brisbane
Discover now


edward st 60
odyssey training racq building level 1, brisbane city, 4000, qld, au
Event from
everi.events


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. Brisbane
  2. edward street 60
  3. Microsoft Excel Advanced - 2 Day Course - Brisbane
 
 
 
 
Your changes have been saved.