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.
Upon completion of this course, attendees will have the knowledge and skills to design effective spreadsheets and work with financial or other business applications in an efficient manner.
Excel VBA 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.
We can offer assistance with all aspects of any skills development project, including analysing skill requirements, assessing existing skills, course planning and preparation and scheduling.
This course is designed for those who need to create a new database, design data tables, design forms and reports and create simple queries
This one-day introductory course assumes no prior programming knowledge, and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should ha...
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy