Microsoft Excel II Basics & Expert level

Name: Microsoft Excel II Basics & Expert level
Rating: 4.4 (2 reviews)

Comprehensive Microsoft Excel II Basics & Expert level

Created byAtul Singla

Last updated 11/2020

English

English [Auto],

What you'll learn

Navigating the Excel interface and understanding basic commands
Working with worksheets, rows, columns, cells, and ranges
Using formulas and functions, including SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, and more
Applying formatting techniques to present data clearly
Using conditional formatting to highlight important data
Sorting and filtering data for quick analysis
Creating and managing Pivot Tables for summarizing large data sets

Course content

1 section • 5 lectures • 1h 8m total length

Basic Excel : Part 19:58
Learn basic excel concepts and essential formulas, from auto-filling sequences and dates to simple arithmetic, totals, and percentage calculations, with hands-on examples and core features.
Basic Excel : Part 223:38
Master Microsoft Excel formatting basics and options, including date formats, alignment, borders, and merging cells. Explore page layout, freezing panes, comments, and find and replace, plus sheet renaming and coloring.
Advance Excel : Part 17:19
Advance Excel part 1 covers using tables, performing lookups, and validating records against a database. It demonstrates range-based formulas, equality checks, and filtering to identify duplicates and match data.
Advance Excel : Part 215:52
Advance Excel part 2 guides managing isometric data workflows with stages and checks, and using tables, filters, and slicers to create dynamic reports from a database.
Advance Excel : Part 311:19
Learn to use the timeline feature in advanced excel to track stages, view monthly or weekly outputs, and generate reports using grouping and database checks.

Requirements

No software skills are required

Description

This course is designed to transform you from a beginner to an advanced Microsoft Excel user. Whether you are starting from scratch or want to sharpen your Excel skills for professional growth, this course will guide you step by step.

Microsoft Excel is one of the most essential tools for working professionals, students, entrepreneurs, and anyone who deals with data. It is widely used across industries for data organization, calculation, reporting, and analysis. Mastering Excel not only improves your productivity but also enhances your career prospects.

The course starts with foundational concepts, covering basic commands, formatting techniques, and commonly used formulas. As you progress, you will explore advanced features including data validation, conditional formatting, powerful lookup formulas, and data visualization through charts and Pivot Tables.

The lectures are carefully structured to ensure that learners at all levels can follow along easily, with practical demonstrations to help you apply concepts in real-world scenarios.

What you will learn:
• Navigating the Excel interface and understanding basic commands
• Working with worksheets, rows, columns, cells, and ranges
• Using formulas and functions, including SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, and more
• Applying formatting techniques to present data clearly
• Using conditional formatting to highlight important data
• Sorting and filtering data for quick analysis
• Creating and managing Pivot Tables for summarizing large data sets
• Building charts to visualize data effectively
• Introduction to data analysis tools like What-If Analysis and Goal Seek
• Tips and tricks for improving speed and efficiency

Who this course is for:

Students looking to build a strong foundation in Excel
Working professionals aiming to upgrade their Excel skills
Entrepreneurs managing business data
Freelancers working with spreadsheets and reports
Anyone preparing for data-driven roles or interviews