Ultimate Excel guide 2021, Learn MS Excel Dashboards, Formulas, Excel Charts, advanced Excel Tips & Tricks, xlsx Skills!

**Continuous Updates**

What you’ll learn

- Master Microsoft Excel Dashboard.
- Building a solid understanding on the Basics, Fundamentals & Advanced features of Microsoft Excel.
- Master Data Analysis using Pivot Tables and all Types of Charts.
- Master working with Formulas & Functions With Examples, like VLOOKUP, INDEX, AVERAGE, SUM and many more ….
- Master Keyboard Shortcuts To Speed Up Your Work and Surprise your Boss..
- Create Macros and understanding VBA.
- Microsoft Excel From Absolute Beginner to Advanced in more than 5 hours.

Course Content

- Introduction –> 2 lectures • 21min.
- Microsoft Excel Home Tab Ribbon Explanation With Examples –> 10 lectures • 2hr 8min.
- Microsoft Excel Insert Tab Ribbon Explanation With Examples –> 4 lectures • 52min.
- Microsoft Excel Page Layout Tab Ribbon Explanation With Examples –> 1 lecture • 6min.
- Microsoft Excel Formulas Tab Ribbon Explanation With Examples –> 3 lectures • 30min.
- Microsoft Excel Data Tab Ribbon Explanation –> 1 lecture • 19min.
- Microsoft Excel Review Tab Ribbon Explanation With Real Examples –> 1 lecture • 3min.
- MS Excel View Tab Ribbon Explanation –> 1 lecture • 3min.
- Microsoft Excel Developer Tab Studying With Real Examples –> 1 lecture • 20min.
- Microsoft Excel Help Tab –> 1 lecture • 17min.
- Microsoft Excel File Tab Explanation With Examples –> 2 lectures • 25min.

Requirements

- No Prior Knowledge Requirements Needed..
- Passion to Learn Microsoft Excel..
- The course is created using Excel 2016. But all features will work in Other Excel versions.

****Continuous Updates****

*********This Course Is For Anyone Who Has a Microsoft Office********

**8 Reasons why you should choose this course**

- The course will teach you
**Complete MS Excel Essentials (Zero to Hero).** - The course is created with perfect care by a computer engineer;
**One-On-One Support;**- The course is not long, so you can complete it in a short time, and then enjoy your new experiences;
- Your inquiries will be answered in a short time with a full explanation of any question;
**Constant updates**.- Simple and easy-to-understand explanation with examples;
- A certificate will be provided upon completion of the course;

In this special course, you will learn & master the most important features of Excel. The version of MS Excel I’m using in the course is **Microsoft Excel 2016** which is similar to **Microsoft Excel 2019 **&** Office 365 Excel**.

I note that the course is compatible at **95%** with **Microsoft Excel 2007, 2010, **and **2013 versions.**

The course is structured into **11 Sections.**

**In Section 1 :**

- We will Introduce
**Microsoft Excel From Absolute Beginner To Advanced User Course**; - We will see ” 25 Essential Shortcuts That Every Excel User Should Know”

**In Section 2, we will see in detail with real examples the following :**

- Microsoft Excel Home Tab Ribbon Explanation;
- Copy, Cut, Paste and Format Data Tools ;
- Font, Font Size, Font Color, Borders & Other Text Formatting Features;
- Text Alignment, Wrap Text, Merge and Center Text, and much more;
- Text Orientation, Increasing & decreasing Indent, Direction and many more;
- Number Formatting, Accounting, Percent Styles, Decimals and other Styles.;
- All Types Of conditional Formatting (data bars, color scales, icon sets, top & bottom rules, etc…) ;
- Insert, Delete and Format Cells;
- Tables and Cell Styles;
- Sorting & Filtering Data, Editing, Finding, Clearing, Replacing Texts and Others;
- Excel rows, columns, cells, and more functions.

**In Section 3, we will see in detail with real examples the following :**

- Microsoft Excel Insert Tab Ribbon Explanation;
- PivotTable Mastering;
- Charts, Pie Charts, Line & Column Charts, Statistic & Combo Charts;
- PivotChart & 3D Map Exploring;
- Hyperlinks, Links Connection, Symbols & Text Models, and much more

**In Section 4, we will talk about the following in detail:**

- Microsoft Excel Page Layout Tab Ribbon Explanation;
- Page Layout Themes;
- Effects & Colors;
- Page Layout Margins;
- Page Layout Backgrounds;
- Gridlines and Headings etc…

**In Section 5, we going to see in detail with real examples the following :**

- Microsoft Excel Formulas Tab Ribbon Explanation;
- Formulas & Functions Groups Explanation with real Examples;
- VLOOKUP Function Mastering ();
- INDEX Function ();
- SUM Function Mastering ();
- AVERAGE Function Mastering etc…

**In Section 6, we will talk about the following in detail :**

- Microsoft Excel Data Tab Ribbon Explanation;
- Get External Data to Microsoft Excel Worksheet;
- Data Validation, and much more.

**In Section 7, we will see in detail with real examples the following :**

- Microsoft Excel Review Tab Ribbon Explanation;
- Learn How to Protect & Set a Password to Sheets/Worksheets;
- Learn How to Protect & Set a Password to the whole Workbook and many more.

**In Section 8, we will talk about the following in detail :**

- Microsoft Excel View Tab Ribbon Explanation
- Views Customizing;
- Zoom function;
- Show Features and Others.

**In Section 9, we will see in detail with real examples the following :**

- Microsoft Excel Developer Tab Studying;
- Master Macros & Developer Tab Controls
- How to record Macros;
- How to execute Macros;
- How to create buttons and controls;
- How to assign Macros to buttons
- Real Examples of Operating Macros
- Introduction to VBA & VBA Source Code etc…

**In Section 10, we will see the following :**

- Microsoft Excel Help Tab Explanation;
- Understand Microsoft Excel Help Options;
- Contact MS support;
- Feedback;
- Excel online Training;
- Excel Community;
- Excel Blog;
- Excel’s Suggestions.

**In Section 11, we going to see in detail the following :**

- Microsoft Excel File Tab Explanation;
- Customizing Excel Ribbons;
- Know how to add & remove commands in the ribbon;
- Know about how to create a new Excel Tab and Group;
- Get familiar with all Excel Advanced Settings.
- MS Excel Templates;
- Understand all about New & Open groups in the File ribbon;
- Understand all about Info group;
- Understand all about Save & Save as groups in the File ribbon;
- Understand all about Print & Share groups;
- Understand all about Export & Publish groups in the File ribbon etc…

I will guide you **step by step with an easy explanation **along this course.

If you are interested in** one of the points** we talked about before, then this course is for you.

**What are you waiting for?**

**Go ahead and join us.**

**I’ll love to see you in the class.**