VIDEO

QUIZ

ASSESSMENT

Understand the different features of the excel interface - navigation, selection of cells, and data entry along with basic calculations.

Kick Start Microsoft Excel

Learn to write the most frequently used excel functions in calculations such as SUM, AVERAGE, MAX, and MIN.

Working with formula

Learn the tools to format datasets using border formatting, alignment, cell, and font formatting. Insert pictures and learn to make them visually appealing in workbooks.

Formatting

Learn the tools, techniques, and tricks to manage and structure the workbook. Conditional formatting will be taught in this chapter too.

Modifying workbooks and worksheets

This chapter will introduce you to some basic functions to work with dates and texts to extract relevant information.

Text and Date functions

Understand techniques to visualize the data in different charts and add little nuances in charts to enhance the visual appeal.

Exploring charts

Named ranges open the doors for automation in excel workbooks. Learn how to create, manage and apply named ranges in a function.

Named Ranges

Learn to perform calculations based on some conditions using advanced formulas such as SUMIF, COUNTIF, and more. Automate boring work with Excel table.

Conditional functions

Learn to use AND, OR, and IF operators to write complex instruction in excel

Operators

Unleash the power of Pivots table and pivot charts to perform complex calculations within seconds and create basic interactive visualizations using slicers.

Pivot tables

Gather details about creating data validation based on formula and interactive conditional formatting that ensures data entry is systematically processed.

Data validation

Become proficient in utilizing the Lookup Function, the most frequently used function of Excel, to solve real-world business problems.

Lookup functions

metaTitle

Title For Open Graph

Test

Course not independently purchasable

Excel: Beginner to intermediate

Learn to manipulate complex data and derive insights through various visualization techniques by using the most popular tool and functions of Excel.

Excel: Beginner to intermediate

Master these skills

Level & pre-requisites

Skills covered

Level & pre-requisites

Level & pre-requisites

Skills covered