Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

Microsoft Excel Course for Intermediate Users

Build on your basic Excel skills with this intermediate course. Learn how to efficiently manage data, use advanced functions, and enhance your spreadsheets with powerful tools and techniques.

4.9 Rating Intermediate Course 8 Weeks

About this Course

In this intermediate Microsoft Excel course, you'll go beyond the basics and dive into advanced functions, data management, and analysis tools. Learn how to manipulate data, automate tasks, and create more complex charts and reports. This course also covers features such as pivot tables, data validation, and conditional formatting to make your Excel workbooks more powerful and efficient.

Course Objective

This course aims to elevate your Excel skills by teaching you how to work with complex formulas, manage larger datasets, and apply advanced formatting and analysis tools. By the end of this course, you’ll be able to handle more sophisticated tasks and automate workflows using Excel.

Skills you'll gain

Advanced Formulas and Functions Pivot Tables and Data Analysis Conditional Formatting and Data Validation

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

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 ₹ 2999

₹ 1999

ENROLL NOW

Duration

8 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Intermediate

Schedule

Monday to Friday

Certificate

Yes

Share this Course