Pocket Guide To Excel Success

Master spreadsheet modeling using Excel with functions, pivots, and macros. Your shortcut to building efficient, automat

What you'll learn

Build dynamic and logic-driven spreadsheets using advanced Excel functions

Summarize and visualize complex data

Automate repetitive tasks

Apply spreadsheet modeling techniques to solve real-world business problems

Requirements

Excel novice level recommended. IT understanding of functions helpful

Description

Let’s Excel in Excel—because Excel is more than just a spreadsheet tool.From data storage and visualization to automation and analytics, Excel empowers end-to-end business processes, making it a must-have skill in every professional’s toolkit.This hands-on course is designed for intermediate users who want to go beyond formulas and formatting to build dynamic, business-ready models. Whether you’re a student, analyst, or working professional, you’ll learn how to use Excel as a powerful tool for analytics, automation, and data storytelling.We begin by mastering essential functions like IFs, VLOOKUP, SUMIFs, INDEX-MATCH, and Pivot Tables. You’ll then explore Macros to automate repetitive tasks and learn how to design dashboards that communicate insights effectively.As an advanced analytics consultant, one must combine technical proficiency with strong storytelling—and that’s exactly what this course helps you build.The course is structured into three focused segments:Building Blocks: Core functions including string math and lookup, formulas, and formattingStorytelling: Charts, dashboards, and impactful presentations, creating dynamic dashboardsBusiness Automation: Macros, task automation, and templates in order to automate business flowsPacked with real-world examples, this course equips you with practical Excel skills to solve business problems with clarity, speed, and confidence. All the best and have fun!

Overview

Section 1: Building Blocks 1 - Let's get started

Lecture 1 Excel Shortcuts

Lecture 2 Freezing of cells

Lecture 3 Conditional formating

Lecture 4 Paste Special

Section 2: Building Blocks 2 - Tips

Lecture 5 Excel Data formats

Lecture 6 Alternate rows in excel

Lecture 7 3 useful excel data processing features

Section 3: Building blocks 3 - Functions in Excel!

Lecture 8 String Functions for pre-processing - Trim, Len, Upper/Lower

Lecture 9 String functions - Left, Mid, Right, Find, Search

Lecture 10 String functions - Substitute and Replace

Lecture 11 Math functions

Lecture 12 Date functions

Lecture 13 Lookup functions

Section 4: Storytelling in Excel - Making them dynamic!

Lecture 14 Creating Drop downs through Data Validation

Lecture 15 Drop down based data refresh

Lecture 16 Drop down based Dynamic Charts

Section 5: Storytelling in Excel - Dashboards

Lecture 17 Dashboard tips - Group, Align and View

Lecture 18 Dashboard in 10 mins

Lecture 19 The 1 min revamp!

Section 6: Automation through Pivots!

Lecture 20 Pivot Table Creation

Lecture 21 Pivot - Creating a slicer

Lecture 22 Pivot - Calculated fields

Section 7: Automation through Macros

Lecture 23 Excel Macros - An Introduction

Lecture 24 Let's implement - Introduction

Lecture 25 The Form

Lecture 26 Initial Macro

Lecture 27 Final Macro

Lecture 28 Case Study for Macros

Business Analysts and Working Professionals looking to sharpen their Excel skills for data-driven decision-making and automation,Students and IT/MBA Candidates aiming to gain hands-on experience in spreadsheet modeling for internships, projects, or placements.,Entrepreneurs and Startup Teams who need to build lean, effective models for planning, reporting, and analysis without expensive tools