Your Comprehensive Street Smart Toolkit for Life.
This course provides a comprehensive street smart toolkit to construct effective and valuable models for your professional life.
If you are looking to vastly expand your Excel knowledge, build strong analytical and business modeling skills, or enhance and monitor productivity, this course will set you up with the correct managerial skillset to stand out in a competitive market.
This course provides resources and equips you with:
* Provide a ‘shortcut approach’ to building models that are useful within everyday activities.
* An in-depth understanding on how to build and utilize sophisticated models.
* Efficiently construct flexible yet robust databases.
* Quickly write powerful Excel formulas to analyze data and text fields.
Whilst most Excel courses converge on what each formula does, this course will also provide you with the practical application of these formulas. It is compiled from 20+ years of international business experience, focusing on hands-on practical scenarios, cases and knowledge. Knowledge that you won’t find anywhere else.
This course will educate you to approach and apply Excel formulas in a logical and easy to use way, and will master distinctive tips and tools to truly take your reporting and analytical skills to the next level and beyond.
Recent Student Review
“Leon’s explanation of Excel and video tutorials are fantastic, his knowledge is obvious and it flows through into the course. I’m an experienced Excel user and this course was able to teach me beginner tricks I didn’t know, as well as much more advanced formulas and functions to assist in a Financial Planning setting.”
Connor B.
Why is this course the right course for you?
Do you have a genuine appetite for flexible business scenario modeling and process automation? Would you like to be more efficient in your career? Would you like to be able to possess excellent technical problem solving skills, and have an in-depth understanding that data needs to be accurate? Does your business or career need to apply and ensure that models needs to be robust, powerful and flexible?
The coursework is to the point and easy to follow and understand. Having over 20 years experience designing and preparing models for large international corporations, I will enable you to formalize the knowledge for you to OWN! This course focus on practical application to enhance your productivity and vastly expand your knowledge base.
As a highly skilled and experienced Chartered Accountant with over 20 years’ international experience across a wide variety of industries, I encounter and solve business challenges on a daily basis. The contents in this course contains real-life problems that I have encountered over the last 20+ years, problems I had to solve the hard way. The beauty of this course is that training material is not limited to your work environment. It can also be applied to your personal circumstances, such as family budgeting, home loan repayment calculations and retirement planning. The only thing that limits you is your imagination!
By the end of this course, you’ll be “street smart” and able to compile and analyze robust data bases, formulas and business models empowering you to:
* Have a thorough understanding of what Excel is capable of and how to approach tasks in a logical, quick and easy manner.
* Approach challenges from different and more efficient angles getting to the same result.
* Use DATA VALIDATION LISTS to create vibrant yet flexible drop-down lists in cells and practically apply these in combination with LOOKUP, MATCH and INDEX functions.
* Return values from a list using a given position or index using the CHOOSE formula in combination with SUMIF and LOOKUP functions.
* Learn how to split and combine text into different columns using TEXT TO COLUMNS and CONCATENATE functions, and how to practically apply these in combination with other formulas.
* Return aggregate results for supplied values with SUBTOTAL functions in combination with the SUMPRODUCT and OFFSET functions.
* Filter, analyze and display data using PIVOT TABLES and other tools.
* Convert and manipulate DATE and TIME functions (with payroll time sheets in mind) and apply multiple CONDITIONAL FORMATTING rules.
* Automate time consuming tasks using MACROS (including linking multiple MACROS) and other street smart formulas.
* Construct powerful IF and NESTED IF statements using multiple conditional criteria, including but not limited to check if there is an error in the formula using IFISERROR, and IF AND OR statements.
* Work effectively with 100+ Excel SHORT CUT KEYS and customizing your ribbon / toolbar to work more proficiently.
* Apply DATA FILTERS and ADVANCED FILTERS using SINGLE and MULTIPLE criteria.
* Write TO THE POWER formulas and apply these in NPV (Net Present Value) calculations.
* Replicate worksheets quickly, efficiently and apply HYPERLINKS.
* Build powerful LOOKUP formulas that are flexible yet robust – The Street Smart Way.
* Construct complex SUMIF, SUMIFS formulas that meets MULTIPLE CONDITIONAL criteria and applying these in business modeling.
* Write financial functions with PMT (payment), RATE (interest rate), NPER (period), PV (present value) and FV (future value) and compare that against a loan repayment schedule as an example.
* Apply multiple COUNT functions together with special characters using WILDCARDS, to count specific criteria in a data range.
* Find the correct unknown input where the output is known using the GOAL SEEK and SCENARIO MANAGER functions in a NPV (Net Present Value) business case scenario.
* Write formulas performing calculations on a range of data based on certain criteria, using the D-functions like DGET, DAVERAGE, DMAX and much more.
If you want to stand out in the real world, you have come to the right place!
Enroll now and take the next step in mastering your Excel skills. See you in the course!
