What you'll learn
Learn with which tricks I have solved 80 percent of all Excel problems in office life for twenty years.
Learn what data should look like and be structured (and what most colleagues do not know!)
Get the better jobs with the new Excel knowledge!
Learn how to solve the most common tasks in the job super fast and efficient.
With the methods from this course you will no longer have problems with Excel and be able to help others in the future.
Requirements
Microsoft Excel, regardless of the version (the tricks also work with Excel 2003, 2007 and 2010)
Interested in a professional mindset that will solve any problem in Excel
description
ATTENTION: This course is not for everyone! This is not about perfectionism, but about practical solutions in everyday work! I explain exactly why I have been successful for over 20 years with the most important tasks. Once you understand WHY typical problems arise and how to EASILY solve them, you have the key to success in the job.
Those who prefer to discuss the best formula are wrong here! Once you UNDERSTAND the PROBLEM, it's up to your own creativity to exchange the formulas to best suit you.
Because 80% of all problems with Excel have nothing to do with complicated formulas! Most of the time, there is a lack of the right mindset and a handful of formulas that can be used to solve virtually any problem. Mostly it comes down to the efficient comparison of multiple tables or poor data quality. And that's what this course is all about.
You only need:
Understanding the typical problems
Some super-effective Excel formulas
The right mindset to handle such problems sustainably.
Learn the most important excel tricks, especially:
Spaces every Excel spreadsheet, especially in the business environment
Fill in missing information (automatic updates from sent files)
Find very quickly differences between two Excel spreadsheets (eg yours and the update of a colleague)
Learn how to effectively communicate and fix the errors found
What are inconsistencies? Understand, find and eliminate them!
Learn formula alternatives that nobody has shown you yet.
This course contains downloadable excel files! Each lesson will receive exactly the files (before and after) discussed there as an attachment to each lesson.
Works with every Excel version!
Who this course is for:
Anyone who wants to discover the secrets of an excel guru (Hint: It's not about knowing 2,000 formulas by heart)
Anyone who wants to do more work and work faster