Tutorialspoint

MS Excel by Simon Sez

7 hand-picked video courses to master MS Excel

Description

Hands-on Experience on Microsoft Excel From Beginners to Advance Level, Introduction to Advance Formulas, VBA Training to Excel, Creating and Building Interactive Dashboards, Business Analytics & Much More.

Overview:

7 Modules

378+ Lectures

41+ Hrs HD Videos

Course Designed By Industry Experts

Up-to-Date Curriculum

Full Lifetime Access

30 Days Refund Policy

Certificate on Completion


About Premium Pack:

Welcome to Our MS Excel Premium Pack. It has been designed in such a way that it will grant learning access to Microsoft Office in the 3-course bundle for Office 355 or Office 2019 users from beginner to advance level.  Excel with advanced formulas, macros, and VBA. Creating impressive dashboards from scratch, performing data analysis from Simon Sez IT.


Scope of MS Excel:

MS Excel has many advantages to those who are working with multinational companies utilizing different advanced excel formulas and functions while preparing ready MIS reports for their organizations. 

Learning MS Excel skills will open doors for data analysis, business analysis, MIS, etc.

The career scope of advanced excel is excellent in the job market. Big data and data science are two significant fields with attractive salaries.

With little investment, it is advisable for all professionals in the field to acquire MS Excel certification.


What You Will Get?

Learn the essential Microsoft Office Skills in this three-course bundle: Excel, Word, and PowerPoint.

Discover how to modify a variety of standard behaviors, such as double-clicking, opening files, and saving files through VBA.

Learn to unlock advanced Excel formulas

How to record a complex, multi-step macro and assign it to a button

How to automate tasks and operations that you perform frequently.

How to modify the Excel user interface, including the "Ribbon" and context menus to interact with your VBA code.

About Dashboard architecture and inspiration

How to create a Sales Dashboard from scratch

How to create an HR Dashboard from scratch

How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP

How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis

How to split data using text functions SEARCH, LEFT, RIGHT, MID


Requirements:

A basic understanding of how to use Microsoft Excel

Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

Beginner knowledge of Excel for VBA.

MS Excel by Simon Sez
This Prime Pack Includes :

42.5 hours

7 Video Courses

Lifetime Access