Learn the latest Excel features that are used by Excel Experts to get more done in less time. Discover how Dynamic Array Excel has REVOLUTIONISED how you can write formulas XLOOKUP has killed off VLOOKUP – learn why Power Query is the greatest improvement to Excel productivity ever… if you’re not
What You Get From This Course
Learn the latest Excel features that are used by Excel Experts to get more done in less time.
Discover how Dynamic Array Excel has REVOLUTIONISED how you can write formulas
XLOOKUP has killed off VLOOKUP – learn why
Power Query is the greatest improvement to Excel productivity ever… if you’re not using it you’re probably wasting hours.
Revisit and/or learn about Pivot Tables and discover what the more advanced Power Pivot is all about.
Course Outline
Tips and Tricks a recent new formula
Data Types
Tables
Traffic Lights
SWITCH & TEXTJOIN
Best practices and shortcut techniques
Using Autocorrect to generate formula
Power Query
Automated data import and clean up with the world’s greatest data washing machine
Introduction to Power Query’s capability, that will save hours of manual effort
Replaces a lot of functionality previously only solvable with Macros
Dynamic Array Excel and the Amazing new Functions
“A complete Game Changer” – Writing formulas that now SPILL
FILTER, UNIQUE, SORT, SEQUENCE
TEXTSPLIT, TEXTAFTER, TEXTBEFORE
VSTACK, DROP, CHOOSECOLS
XLOOKUP the VLOOKUP killer
Tables And Databases
Sorting techniques
Using Autofilter to show top 10 or custom views of the database
Flagging and removing duplicate entries
Pivot Tables & Refreshable Dashboards
Create your own dashboard using pivot tables and pivot charts
Value and Date grouping functionality
Top 10 filters
Traps to avoid
Present your summarised data with interactive connected Slicers
A first look at Power Pivot and the Excel Data Model (note we have an entire 2 day course dedicated to Power Query and Power Pivot)
Who Should Attend?
All Excel users. Anyone interested in saving huge amounts of time in their daily use of Excel.
Pre-Requisites
This is one step above a basic user course. Users should already be comfortable with day-to-day Excel use.
Welcome to Access Analytic, the premier provider of amazing Power BI, Microsoft Excel and Solver Budgeting & Forecasting solutions. We believe in empowering your business to flourish in an increasingly data-driven world and have been consistently helping clients do this since 2000.
In this era of fast-paced businesses, your organisation needs robust, accurate reporting and modelling tools. As data volumes surge, you need more than just manual management and analysis because these are painstakingly slow and constantly susceptible to errors.
That’s where we come in! We specialise in delivering top-notch training and consultancy services, helping you to unlock and harness the full potential of your data using Power BI, Microsoft Excel and Solver Budgeting and Forecasting. These enable you to gain insights and make more informed, data-driven decisions.
Talk to us today about how our unique blend of business and IT expertise will help you access faster growth, reduce your costs and reduce your risks.
This course will introduce the basics of Microsoft Word and as a result, students will therefore learn to build and manage simple documents, while improving their fundamental Word skills
MS PowerPoint course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.
If you have very little knowledge/usage of computers, you may feel better to attend some Basics of Computers classes first. These are offered at libraries and community halls etc.
Microsoft PowerPoint (PowerPoint and PowerPoint 2019) training is offered by TAFE SA.
Corporate Training Solutions Australia is an independent, Australian owned training provider, highly respected for the delivery of corporate training in desktop software and soft skills development.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy