Excel Unlocked: Beginner to Advanced

Discover the full potential of Excel with our comprehensive course designed to take you from a novice to an expert user.

  • Category Microsoft
Excel Unlocked: Beginner to Advanced

What you'll learn

  • Data Management: Organize, sort, and filter large datasets effectively.
  • Powerful Formulas and Functions: Use key formulas like VLOOKUP, INDEX-MATCH, and SUMIFS.
  • Data Visualization: Create professional charts, graphs, and dashboards.
  • Pivot Tables: Summarize and analyze data dynamically with Pivot Tables and slicers.
  • Advanced Excel Tools: Master Conditional Formatting, Data Validation, and Flash Fill.
  • Connecting Data Sources: Power Query.

Course Syllabus

Excel Foundations
  • a:8:{i:0;s:22:"What is a spreadsheet?";i:1;s:20:"Interface and Ribbon";i:2;s:10:"Data Types";i:3;s:10:"Navigation";i:4;s:24:"Introduction to Formulas";i:5;s:19:"Game of Referencing";i:6;s:24:"Practice – Momos Stand";i:7;s:33:"Practice – Momos Stand Solution";}
Data Management
  • Filtering & Unique";i:1;s:22:"Practice Sort & Filter";i:2;s:16:"Horizontal Sortv";i:3;s:19:"Text Cleaning Basic";i:4;s:24:"Practice - Text Cleaning";i:5;s:22:"Text Cleaning Advanced";i:6;s:22:"Conditional Formatting";i:7;s:15:"Data Validation";}
  • a:8:{i:0;s:27:"Sorting
Lookups
  • HLOOKUP
  • and Beyond";i:1;s:32:"VLOOKUP – HLOOKUP (Same Sheet)";i:2;s:21:"VLOOKUP (Inter Sheet)";i:3;s:18:"VLOOKUP with MATCH";i:4;s:23:"INDEX – MATCH - MATCH";i:5;s:7:"XLOOKUP";}
  • a:6:{i:0;s:46:"The Lookup Family VLOOKUP
Conditional Statements
  • a:6:{i:0;s:13:"IF Statements";i:1;s:6:"And/Or";i:2;s:9:"Nested IF";i:3;s:12:"IFS & Switch";i:4;s:53:"Sumif – Countif – Averageif – Maxifs – Minifs";i:5;s:8:"Iferrors";}
Pivot Tables
  • a:4:{i:0;s:37:"Introduction to Pivot Table Interface";i:1;s:55:"Analysis on Pivot Tables – Pivot Grouping – Slicers";i:2;s:17:"Practice Activity";i:3;s:14:"Bonus Analysis";}
Data Visualizations
  • a:4:{i:0;s:22:"Introduction to Charts";i:1;s:32:"Bar – Column – Line – Area";i:2;s:49:"Pie – Treemaps – Sunburst – Maps – Others";i:3;s:15:"Creating Charts";}
Macros
  • a:6:{i:0;s:22:"Introduction to Macros";i:1;s:17:"Recording a Macro";i:2;s:20:"Introduiction to VBA";i:3;s:16:"Editing the Code";i:4;s:23:"Finding a suitable code";i:5;s:8:"Debuggin";}
Power Query
  • a:4:{i:0;s:23:"Connecting Data Sources";i:1;s:13:"Data Cleaning";i:2;s:18:"Data Consolidation";i:3;s:15:"Creating Output";}

Course Syllabus

  • What is a spreadsheet?
  • Interface and Ribbon
  • Data Types
  • Navigation
  • Introduction to Formulas
  • Game of Referencing
  • Practice – Momos Stand
  • Practice – Momos Stand Solution

  • Sorting, Filtering & Unique
  • Practice Sort & Filter
  • Horizontal Sortv
  • Text Cleaning Basic
  • Practice - Text Cleaning
  • Text Cleaning Advanced
  • Conditional Formatting
  • Data Validation

  • The Lookup Family VLOOKUP, HLOOKUP, and Beyond
  • VLOOKUP – HLOOKUP (Same Sheet)
  • VLOOKUP (Inter Sheet)
  • VLOOKUP with MATCH
  • INDEX – MATCH - MATCH
  • XLOOKUP

  • IF Statements
  • And/Or
  • Nested IF
  • IFS & Switch
  • Sumif – Countif – Averageif – Maxifs – Minifs
  • Iferrors

  • Introduction to Pivot Table Interface
  • Analysis on Pivot Tables – Pivot Grouping – Slicers
  • Practice Activity
  • Bonus Analysis

  • Introduction to Charts
  • Bar – Column – Line – Area
  • Pie – Treemaps – Sunburst – Maps – Others
  • Creating Charts

  • Introduction to Macros
  • Recording a Macro
  • Introduiction to VBA
  • Editing the Code
  • Finding a suitable code
  • Debuggin

  • Connecting Data Sources
  • Data Cleaning
  • Data Consolidation
  • Creating Output

Requirements

  • Good wifi
  • Laptop

Description

Excel Unlocked: Beginner to Advanced

Excel Unlocked: Beginner to Advanced is your ultimate guide to mastering Microsoft Excel, designed to cater to both corporate professionals and aspiring students. This course takes a hands-on approach, ensuring that learners gain practical experience with tools and techniques used in real-world scenarios. Whether you’re preparing data reports for your manager, creating dashboards for presentations, or analyzing trends for a project, this course has you covered.

  • Step-by-Step Learning: Start from Excel basics like formatting, shortcuts, and simple formulas, and progress to advanced features like Pivot Tables, Conditional Formatting, and VLOOKUP.
  • Real-Life Applications: Work on practical case studies, such as sales reports, financial analysis, and project tracking.
  • Time-Saving Techniques: Learn how to automate repetitive tasks with macros, Flash Fill, and data validation tools.
  • Error-Free Work: Discover troubleshooting tips to fix common errors, improve accuracy, and ensure professional-grade work.
  • Interactive Exercises: Each module includes hands-on exercises and quizzes to reinforce learning.

Who this course is for:

  • Corporate Employees: Professionals looking to boost productivity, improve reporting skills, and analyze data effectively.
  • College Students: Individuals preparing for internships, projects, or placements.
  • Entrepreneurs and Small Business Owners: Those who want to manage business data efficiently.
  • Beginners and Intermediates: Anyone who wants to build a strong foundation or upgrade their current Excel skills.

Meet your instructors

image

Raunak Singh

View Profile

Raunak Singh is a seasoned instructor with a specialization in PowerPoint, Power BI, and Excel. With extensive experience teaching both corporate professionals and students, he has refined his skills in creating impactful presentations, simplifying data visualization, and enhancing data analysis. ...

GET ACCESS TO CURATED JOBS WITH

Dadicated career support

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board. Its a test

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board.

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board.

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board.

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board.

Exclusive access to Great Learning job board, Exclusive access to Great Learning job board.

Why enroll in this course?

Lead digital transformation in your organization by mastering the core concepts of generative artificial intelligence and its potential impact.

Master and integrate prompt engineering to optimize day-to-day tasks and automate workflows.

Foster an “AI friendly” culture in your organization by understanding the ethical aspects and the risks associated with the implementation of this technology.

Explore tools such as ChatGPT, as well as other emerging technologies, to improve productivity.

Interact with MIT experts, instructors, and peers in live synchronous sessions for a more comprehensive learning experience.

Access to rich supplementary resources provides additional materials and content for a more thorough educational journey.

Related Courses

image
Microsoft
image Rashmi Ranjan Mangaraj

Mastering Data Analytics for Career Excellence

  • 10 students
  • 49 lessons
  • Enquire
image
Microsoft
image Shiva Krishnan

Excel Mastery Pro: Advanced Data Analytics Techniques, and AI Integration Course

  • 10 students
  • 37 lessons
  • Enquire

Course Syllabus

  • What is a spreadsheet?
  • Interface and Ribbon
  • Data Types
  • Navigation
  • Introduction to Formulas
  • Game of Referencing
  • Practice – Momos Stand
  • Practice – Momos Stand Solution

  • Sorting, Filtering & Unique
  • Practice Sort & Filter
  • Horizontal Sortv
  • Text Cleaning Basic
  • Practice - Text Cleaning
  • Text Cleaning Advanced
  • Conditional Formatting
  • Data Validation

  • The Lookup Family VLOOKUP, HLOOKUP, and Beyond
  • VLOOKUP – HLOOKUP (Same Sheet)
  • VLOOKUP (Inter Sheet)
  • VLOOKUP with MATCH
  • INDEX – MATCH - MATCH
  • XLOOKUP

  • IF Statements
  • And/Or
  • Nested IF
  • IFS & Switch
  • Sumif – Countif – Averageif – Maxifs – Minifs
  • Iferrors

  • Introduction to Pivot Table Interface
  • Analysis on Pivot Tables – Pivot Grouping – Slicers
  • Practice Activity
  • Bonus Analysis

  • Introduction to Charts
  • Bar – Column – Line – Area
  • Pie – Treemaps – Sunburst – Maps – Others
  • Creating Charts

  • Introduction to Macros
  • Recording a Macro
  • Introduiction to VBA
  • Editing the Code
  • Finding a suitable code
  • Debuggin

  • Connecting Data Sources
  • Data Cleaning
  • Data Consolidation
  • Creating Output

Subscribe to top courses

get this course, plus 12000+ of our top rated courses, with Personal Plan

Starting at ₹850 per month
Cancel anytime

or
$ 35000/-

30 Day Money-Back Guarantee Full Lifetime Access

or
  • Share
  • Gift this course
  • Apply Coupan

LEARNNOWPLANS is applied

Apply coupan

Workshop Business

Subscribe to this course and 27000+ top-rated courses for your organization.

  • Learn, Innovate and Lead with Expertise
  • 27000+ fresh users & in-demand courses
  • Professional Development Components
  • Discover, Enjoy and Master New Hobbies
  • Prepare, Excel and Thrive in your Career

Course Syllabus

Excel Foundations
  • a:8:{i:0;s:22:"What is a spreadsheet?";i:1;s:20:"Interface and Ribbon";i:2;s:10:"Data Types";i:3;s:10:"Navigation";i:4;s:24:"Introduction to Formulas";i:5;s:19:"Game of Referencing";i:6;s:24:"Practice – Momos Stand";i:7;s:33:"Practice – Momos Stand Solution";}
Data Management
  • Filtering & Unique";i:1;s:22:"Practice Sort & Filter";i:2;s:16:"Horizontal Sortv";i:3;s:19:"Text Cleaning Basic";i:4;s:24:"Practice - Text Cleaning";i:5;s:22:"Text Cleaning Advanced";i:6;s:22:"Conditional Formatting";i:7;s:15:"Data Validation";}
  • a:8:{i:0;s:27:"Sorting
Lookups
  • HLOOKUP
  • and Beyond";i:1;s:32:"VLOOKUP – HLOOKUP (Same Sheet)";i:2;s:21:"VLOOKUP (Inter Sheet)";i:3;s:18:"VLOOKUP with MATCH";i:4;s:23:"INDEX – MATCH - MATCH";i:5;s:7:"XLOOKUP";}
  • a:6:{i:0;s:46:"The Lookup Family VLOOKUP
Conditional Statements
  • a:6:{i:0;s:13:"IF Statements";i:1;s:6:"And/Or";i:2;s:9:"Nested IF";i:3;s:12:"IFS & Switch";i:4;s:53:"Sumif – Countif – Averageif – Maxifs – Minifs";i:5;s:8:"Iferrors";}
Pivot Tables
  • a:4:{i:0;s:37:"Introduction to Pivot Table Interface";i:1;s:55:"Analysis on Pivot Tables – Pivot Grouping – Slicers";i:2;s:17:"Practice Activity";i:3;s:14:"Bonus Analysis";}
Data Visualizations
  • a:4:{i:0;s:22:"Introduction to Charts";i:1;s:32:"Bar – Column – Line – Area";i:2;s:49:"Pie – Treemaps – Sunburst – Maps – Others";i:3;s:15:"Creating Charts";}
Macros
  • a:6:{i:0;s:22:"Introduction to Macros";i:1;s:17:"Recording a Macro";i:2;s:20:"Introduiction to VBA";i:3;s:16:"Editing the Code";i:4;s:23:"Finding a suitable code";i:5;s:8:"Debuggin";}
Power Query
  • a:4:{i:0;s:23:"Connecting Data Sources";i:1;s:13:"Data Cleaning";i:2;s:18:"Data Consolidation";i:3;s:15:"Creating Output";}

Book Your Seat

Interested in this course for your Business or Team?

Train your employees in the most in-demand topics, with edX for Business.

Purchase now Request Information

Excel