About the course

Getting Started:

Interface: Familiarize yourself with Excel's interface, which includes the Ribbon (containing tabs and commands), worksheets, columns, rows, and cells.
Entering Data: Learn how to enter data into cells and format it using font styles, sizes, colors, and alignments.
Basic Formulas: Begin with simple formulas, such as addition, subtraction, multiplication, and division. Experiment with cell references (e.g., A1, B2) to perform calculations.
Functions: Explore common functions like SUM, AVERAGE, COUNT, and IF. These will help you perform more complex calculations.
Charts: Create basic charts to represent data visually. Learn how to select data, choose chart types, and customize the appearance of charts.
Sorting and Filtering: Practice sorting data in ascending or descending order and applying filters to display specific data subsets.
Conditional Formatting: Experiment with conditional formatting to highlight cells based on certain conditions.
PivotTables: Begin exploring PivotTables to analyze and summarize data. This is particularly useful for managing large datasets.
Data Validation: Set up data validation rules to control the type of data that can be entered into cells.
And many more daily tasks

Syllabus

Chartered accountant committed to provide the tech knowledge in simple terms along with usecases

Learn live with top educators, chat with teachers and other attendees, and get your doubts cleared.

Our curriculum is designed by experts to make sure you get the best learning experience.

Interact and network with like-minded folks from various backgrounds in exclusive chat groups.

Stuck on something? Discuss it with your peers and the instructors in the inbuilt chat groups.

With the quizzes and live tests practice what you learned, and track your class performance.

Flaunt your skills with course certificates. You can showcase the certificates on LinkedIn with a click.