Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

Microsoft Excel Course for Advanced Users

Take your Excel skills to the next level with this advanced course. Learn how to automate tasks, work with complex data models, and use advanced analysis and visualization tools to maximize your productivity.

4.9 Rating Advanced Course 12 Weeks

About this Course

This advanced Microsoft Excel course is designed to teach you expert-level techniques for data analysis, automation, and visualization. You’ll explore complex functions, build sophisticated models, and automate repetitive tasks using macros and VBA. This course is perfect for professionals who want to leverage Excel to its full potential and tackle large datasets efficiently.

Course Objective

The goal of this course is to empower you to use Excel for high-level data analysis, reporting, and automation. By the end of this course, you’ll be proficient in building complex models, performing advanced data analysis, and automating tasks to save time and enhance productivity.

Skills you'll gain

Advanced Data Modeling and Analysis Automation with Macros and VBA Advanced Charting and Data Visualization

Syllabus

  • Overview of Excel Interface
    • Workbook, Worksheet, Rows, Columns, and Cells
    • Ribbon, Tabs, and Groups
    • Quick Access Toolbar and Status Bar
  • Basic Data Entry and Editing
    • Entering Text, Numbers, and Dates
    • AutoFill feature
    • Using Undo and Redo
  • Basic Functions
    • SUM, AVERAGE, MIN, MAX, COUNT
    • Using AutoSum
  • Practice Tasks
    • Create a new Excel file and enter personal details (Name, Age, City, Date of Birth)
    • Use AutoFill to generate a sequence of numbers
    • Modify a few cells and apply basic formatting like font size and color

  • Formatting Cells
    • Font, Size, Color, Bold, Italics, Underline
    • Number Formatting (Currency, Date, Percentage)
    • Merging Cells, Alignment, and Text Wrap
  • Introduction to Formulas
    • SUM, AVERAGE, MIN, MAX, COUNT
    • Basic Arithmetic Operations (Add, Subtract, Multiply, Divide)
  • Practice Tasks
    • Create a simple budget table and calculate totals using the SUM function
    • Use AVERAGE, MIN, and MAX to analyze data
    • Format a date column and adjust number formatting for currency

  • Managing Multiple Worksheets
    • Adding, Renaming, Deleting Sheets
    • Linking Data Across Sheets
  • Advanced Formulas
    • IF Function (Logical Tests)
    • CONCATENATE (Joining Text)
    • COUNTIF, SUMIF
    • Introduction to VLOOKUP
  • Sorting and Filtering Data
    • Sorting Data
    • Using Filters
  • Practice Tasks
    • Create a tracker with linked data across multiple sheets
    • Use IF function to categorize values
    • Sort and filter a dataset based on specific criteria

  • Creating Basic Charts
    • Column, Bar, Line, Pie Charts
    • Changing Chart Types
  • Formatting Charts
    • Adding Titles, Labels, and Legends
    • Adjusting Axis and Data Labels
  • Practice Tasks
    • Create a budget chart using data
    • Modify chart type and layout

  • Nested Functions
    • Combining Functions for Advanced Calculation
    • Examples: Nested IF, VLOOKUP with IF
  • Array Formulas
    • What Are Array Formulas?
    • SUMPRODUCT, TRANSPOSE, and Other Array Functions
  • Advanced Lookup Functions
    • VLOOKUP vs. HLOOKUP
    • INDEX and MATCH Functions
  • Practice Tasks
    • Use nested functions for a multi-condition problem
    • Create an inventory lookup using INDEX and MATCH

  • Data Validation
    • Setting Data Validation Rules
    • Creating Drop-Down Lists
    • Restricting Data Entry (Dates, Numbers, Text Length)
  • Conditional Formatting
    • Applying Formatting Based on Cell Values
    • Highlighting Duplicate Values, Top/Bottom Values
    • Using Color Scales, Icon Sets
  • Practice Tasks
    • Create a data entry form with drop-down lists
    • Apply conditional formatting to highlight sales above a target

  • Introduction to Pivot Tables
    • Creating Pivot Tables
    • Arranging Fields in Rows, Columns, and Values
  • Pivot Table Techniques
    • Grouping Data (By Date, Value, etc.)
    • Filtering and Sorting Pivot Table Data
  • Pivot Charts
    • Creating Pivot Charts from Pivot Tables
    • Formatting Pivot Charts
  • Practice Tasks
    • Create a sales summary report using a Pivot Table
    • Generate a Pivot Chart for data visualization

  • Introduction to Macros
    • What Are Macros and How to Use Them?
    • Recording and Running Macros
  • Automating Excel Tasks
    • Automating Repetitive Tasks Using Macros
    • Assigning Macros to Buttons
  • VBA Programming Basics
    • Introduction to VBA (Visual Basic for Applications)
    • Writing Simple VBA Code for Task Automation
  • Practice Tasks
    • Automate a monthly report generation using Macros
    • Create a VBA script to automate data entry

  • Advanced Statistical Functions
    • AVERAGEIF, COUNTIF, SUMIF
    • STANDARDIZE, NORM.DIST, CORREL
  • Data Analysis with Power Query
    • Importing and Transforming Data Using Power Query
    • Cleaning and Shaping Data
  • Advanced Pivot Table Techniques
    • Calculated Fields and Items
    • Using Multiple Data Sources in a Pivot Table
  • Practice Tasks
    • Perform statistical analysis on a dataset
    • Clean and transform data using Power Query

  • Building Financial Models
    • Creating Income Statements and Balance Sheets
    • Forecasting Financial Data
  • Sensitivity Analysis and Scenarios
    • Creating What-If Scenarios
    • Sensitivity Analysis Using Data Tables
  • Forecasting and Regression Models
    • Using Excel’s FORECAST Function
    • Implementing Linear Regression for Forecasting
  • Practice Tasks
    • Create a financial model for a small business
    • Use data tables to analyze financial scenarios

  • Designing Dashboards
    • Choosing the Right Charts and Visualizations
    • Combining Pivot Tables and Charts for Dashboards
  • Interactive Dashboards
    • Using Slicers and Timelines for Interactivity
    • Adding Dynamic Charts and Data Controls
  • Visualizing Large Data Sets
    • Handling and Visualizing Large Datasets in Excel
    • Using Heatmaps and Sparklines
  • Practice Tasks
    • Create an interactive sales dashboard using slicers
    • Visualize trends in a large dataset using sparklines

  • Advanced VBA Programming Concepts
    • Working with Arrays and Collections in VBA
    • Error Handling and Debugging Techniques
  • Creating User Forms with VBA
    • Designing Interactive User Forms
    • Validating User Inputs and Managing Data
  • Integrating VBA with External Applications
    • Automating Excel with Outlook and Access
    • Interacting with Databases via VBA
  • Practice Tasks
    • Create a user form for data entry in VBA
    • Automate email reports with VBA and Outlook

About the Instructor

Shalini Baskaran

Founder & CEO

4.98 Instructor rating

40 Students

Shalini Baskaran, is the CEO and Curriculum Director at Savvy Axiss. With a deep background in computer science, she has designed numerous courses to build strong foundations for aspiring programmers. Known for her clear, practical teaching style, she excels at making complex topics accessible. She is passionate about empowering students with real-world skills, and she looks forward to guiding you through this foundational journey in programming.

Fee ₹ 3999

₹ 2999

ENROLL NOW

Duration

12 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Advanced

Schedule

Monday to Friday

Certificate

Yes

SoftSkill Trainning

Free

Share this Course