Dear Aspiring Excel Wizard,
Are you ready to elevate your Excel skills to new heights?
If you answer YES, I invite you to embark on a learning journey with me into the wonderful world of Excel. If you join this course, I practically guarantee that your skills will jump to a higher orbit almost overnight.
I am so confident because I meticulously designed it for people like you who are serious about their skills and aspire to master Excel as quickly and as deeply as humanly possible.
That’s why I believe this comprehensive course is going to be your gateway to mastery of one of the most sought-after skills in today’s job market.
This is not one of those regular courses, which are a dime a dozen. No way!
It is a transformative learning experience that helps you build your skills step by step, nourishes your mind with fresh knowledge and creative ideas and gently leads you towards mastery. So you can transform yourself into a true Excel wizard.
Here’s what you are getting with this course:
- Lifetime access to the entire training so you can hone your skills anytime you choose.
- Excel-basics crash course: Where it all begins. A smooth journey through the fundamentals, paving the way for mastery. This is where you build a strong understanding of the most important Excel topics. Such as user-interface tools, Flash-fill, Auto-fill, Text-to-columns, cell references, tables, named ranges, dynamic arrays.
- How to create drop-down lists with data validation tools in Excel.
- Formulas and Functions: The backbone of Excel.
- Lookup and reference tutorials: VLOOKUP, INDEX, MATCH, XLOOKUP.
- Concatenation: Formulas to join text strings with CONCAT, TEXTJOIN or the ampersand operator.
- How to transform text values with UPPER, LOWER, PROPER, TRIM functions.
- The basics of professional formatting of spreadsheets.
- Date and Time Mastery: A comprehensive training on how to work with dates and times in Excel. From formatting to calculations. Master date and time functions: DATE, TIME, DATEDIF, WORKDAY, WORKDAY.INTL, YEARFRAC, NETWORKDAYS, NETWORKDAYS.INTL, DAYS, DAYS360.
- How to calculate fiscal years based on dates.
- How to create custom functions with LET and LAMBDA.
- Excel what-if analysis tools: Goal seek, Data Table, Scenario Manager.
- Data Visualization: A picture is worth a thousand numbers. Bring your data to life. Learn to present data with Excel charts that impress, captivate and inform.
- Pivot Tables: Unravel the secrets of summarizing and analyzing large data sets effortlessly. This is where data bows to you, revealing its hidden gems through your newfound mastery.
- Practical homework (Lab) assignments with solution walk-throughs.
