# Microsoft Excel Masterclass for Business Managers

1
387

## Summary, Description

6 Explanations why this Excel course should be chosen

Carefully crafted programme that teaches you only the most common Excel features in the business world

Concise – within one weekend, you can complete this course

Examples and case studies correlated with industry

Ample practise exercises since practise is required by Excel

The tutor himself will satisfy your questions.
To become proficient in the Excel assignments today, start using Excel to its full potential!

You’re either new to Excel, or you’ve been messing around with it, so you want to get more familiar with the advanced features of Excel. This course would be perfect for you either way.

What makes us able to teach you?

Abhishek and Pukhraj teach the course. For over a decade, the course’s professors have been teaching data science and machine learning.

With over 150,000 registrations and thousands of 5-star ratings like these, we are also the developers of some of the most popular online courses:

I had an amazing time taking this course. It further extends my comprehension of the power use of Excel as an analytical instrument. The instructor’s kudos! —Sikiru

Very descriptive, very nifty tricks taught and enough detail to make it stick in your head. —Armand

The Promise of Our

Teaching our learners is our job and we are dedicated to it. You can still post a question on the course or send us a direct message if you have any questions about the course material, practise sheet or anything relevant to any subject.

There’s a practise sheet added for you to go along with and lesson. To verify your comprehension of concepts, you can also take quizzes. For you to practically execute your studying, each segment includes a practise task. Assignment solutions are also shared so that your performance can be reviewed.

What is covered in the course here?

Introduction – The structure and contents of the course are explored in this video.

Mathematical functions – Mathematical calculations such as Total, AVERAGE, RAND, MIN & MAX, SUMPRODUCT are discussed in this lecture.

Textual Formulas – This lecture in Excel covers texts such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, Volume, LEFT, RIGHT & MIDD

Logical formulas – This lecture discusses AND & OR, IF, COUNTIF, SUMIF, and SUMIF logical formulas

Date-time (Temporary) Formulas – This lecture discusses functions correlated with date-time, such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYSS

Lookup Formulas – Lookup formulas such as VLOOKUP, HLOOKUP, Map, MATCH are protected by this Excel lecture.

Formatting data and tables – This Excel lecture discusses options for data formatting, such as shading, font adjustment, orientation and table formatting, such as inserting boundaries, highlighting table headers, banding rows, etc.

Pivot Tables – This lesson from Excel explores end-to-end pivot tables.

Charts – This lecture in Excel covers charts such as Bar/Column Map, Line Chart, Scatter Chart, Pie & Doughnut charts, Histogram, Waterfall, Sparklines Statistical Chart,

Excel Shortcuts – This lecture will introduce you to some valuable shortcuts and will show you how to find a shortcut for some unique Excel activity.

Macros – This lecture deals with the method of recording a Macro, running a Macro, and generating a Macro button.

Bonus Lectures – Excel 2016 and older iterations of Excel’s Waterfall Map, Infographics 1: Cool Maps, Infographics 2: Cool Charts

And a lot more!

Your confidence in using Excel will skyrocket by the end of this tutorial. You would have a thorough understanding of how to use Microsoft Excel for testing or as an option for a career.

Go ahead and press the register button, and in Lesson 1 I’ll see you!

Cheers Cheers

Act expertly on Microsoft Excel and improve the productivity of your office.

The developers of this course have several years of business experience and have thus curated the content of the course, taking into consideration Excel’s criteria in the corporate world of today.

### For whom this course is intended:

Working professionals starting their journey through data
In a brief amount of time, everyone interested to master excel from beginner to advanced