Play Video
Preview this course

Microsoft Excel Masterclass

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Trick​

0 / 5
Rating
0 +
Students
0 Hrs
Duration

$16 $8

Price

Microsoft Excel Masterclass

What you'll learn

Functions and Formulas

Knowledge of all the essential Excel formulas such Mathematical, Textual, Date-Time, Logical and Lookup formulas

Excel Charts

Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

Excel data tools

Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing

Formatting options

Coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

Analytics in Excel

Regression, solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

Our Happy Students!

Provided a really descriptive explanation on how to use the basic aspects of Excell and dived into a few of the advanced options. A bit fast at times, but overall the sessions were really good quality!

5/5

Kerena Partridge

Hi. This was really helpful to me in many ways. I just knew only the basics and now I got to expand my knowledge, Which will be an added skill when I apply for my next job. Thank You.

4/5

Amitha Kamath

I am a 16 year old college student and my skills in MS Excel was very low and now after engaging with this very useful course I had generated a professional skill in MS Excel.

5/5

Rishi Kumar Nayak

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate​

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

Excel New- Desc

Course Content

Course Content

Introduction
Prerequisites: Excel formulas and functions
Time Value of Money
Analysis of Profit and Loss Statement
Loan Repayment Calculations
Methods of calculating Depreciation
Financial Ratio Analysis
Financial Charts and Dashboards – Introduction
Charts and Dashboards using Excel
Pivot Tables and Pivot Charts
Case Study – Finance Dashboard
Predictive Analytics – Introduction
Basics of Statistics
Machine Learning -Introduction
Getting Data Ready for Regression Model
Creating Regression Model
Finance Case Study – Linear Regression
Bonus Section