Master Microsoft Excel From The Half Way To The High Way

Convert Ideas to Real projects and be a BOSS

Hello everyone and welcome to this course

What you’ll learn

  • Build a strong expeience in understanding the basics of Microsoft Excel.
  • Understand the most common features and functions used in Microsoft Excel.
  • Understand the most powerful formatting tools to make your tables uniqe in shape.
  • Enable your speed by understanding the power of Excel shortcuts.
  • Convert ideas to real projects in Excel by identifying inputs and desired outputs and link between them.
  • Create your own designed simple to complex data from scratch.
  • Amaze your sorrounding by unlocking major dynamic formulas like: SUMIF, COUNTIF, INDEX, MATCH, OFFSET & More.
  • Enable the power of HLOOKUP formula in dynamic reporting.
  • Create dynamic dashboards by mastering the most powerful tool like PivotTables.
  • Control your dynamic reports by adding slicers.
  • Generate amazing graphs and format them like a BOSS.
  • Design and format your dynamic dashboards with reflective themes to your business.
  • Promote your career or business by enabling the power of using excel dashbaords.
  • Automate your day to day And/Or opertaions activity and be the first to show your results.
  • Be amazed with building 5 real projects from scratch to proffesional that you won’t find in ANY other course.

Course Content

  • Getting Started –> 5 lectures • 41min.
  • Formatting in Excel –> 8 lectures • 9min.
  • The Power of Formulas in Excel –> 14 lectures • 30min.
  • The power of PivotTables –> 7 lectures • 17min.
  • PROJECT. 1: Personal Budget Dashbaord –> 6 lectures • 25min.
  • PROJECT. 2: Human Resources Dashboard –> 7 lectures • 28min.
  • PROJECT. 3: Sales Group Dashboard –> 7 lectures • 29min.
  • PROJECT. 4: Holidays Agency Dashboard –> 7 lectures • 29min.
  • PROJECT. 5: Profit & Loss Dashboard –> 10 lectures • 50min.
  • Conclusion –> 3 lectures • 2min.

Requirements

  • A computer or laptop with any version of Microsoft Excel starting from 2007 (Some features may not be available in earlier versions).
  • Basic understanding of Microsoft Excel formulas writing is recommended but not mandate (We will have fast recap on fundamentals).
  • You are familiar with Microsoft Excel spreadsheet environment.

Hello everyone and welcome to this course
Here you will understand why this course will be one of the TOP RATED Microsoft Excel courses on this great platform:
My name is Sadiq Al Lawati and I am a strategic planning expert worked in many of reputed companies in the Sultanate of Oman along with my earlier rules in Project Management (PMI certified), Contract Management and Budget Management. All these areas require huge understanding and dealing with medium to large data that needs to be converted to frequent reports and I started learning and mastering Microsoft Excel since more than 13 Years ago with everyday learning a new thing that led me to reach to this point and share my skills to all other people willing to gain new skill or promote their career and businesses in short time.
This course will cover a fast recap to the fresh people into Microsoft Excel to allow them understanding main featuresfunctions and formatting before starting to apply them.
The course will cover also critical formulas most widely used over the world and will show them with examples on real examples on Excel.
Then, the amazing part will show up by explaining the power of PivotTables and graphs and how you can create and structure your reports and make them more dynamic and interactive.
At the end of this theoretical part, you will be engaged with the five real life projects that I have prepared them specially for my ambitious students  with step by step showing the way to convert raw data into interactive dashboards using PivotTables and Critical Formulas
I am extremely sure that you are going to like this course and you will learn a lot from it as it will enable your power to work SMART and FAST instead of being a HARD worker.
So. Enroll now and get engaged with the course till end and I can assure you that if you didn’t used what you learned in this course in your work then you can convert it to Freelancing business.
GET THE TUTORIAL

Given Edward, the founder of Jobs in Tanzania, is dedicated to assisting novices, entrepreneurs, and small business owners in starting, managing, and developing their businesses.

Leave a Comment