Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

Microsoft Excel Course for Beginners

Get started with Microsoft Excel, a powerful spreadsheet tool widely used for data organization, analysis, and visualization. Learn how to create, format, and analyze data with ease.

4.8 Rating Beginner Course 4 Weeks

About this Course

Microsoft Excel is one of the most widely used tools for managing and analyzing data. In this beginner course, you’ll learn the basics of creating and formatting spreadsheets, performing simple calculations, and visualizing data. This course will guide you through essential tasks such as creating tables, using formulas, and generating basic charts.

Course Objective

The goal of this course is to provide you with the foundational skills necessary to navigate Microsoft Excel, giving you the confidence to manage and analyze data effectively and efficiently.

Skills you'll gain

Create and Format Spreadsheets Use Basic Formulas and Functions Create Simple Charts

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

About the Instructor

Shalini Baskaran

Founder & CEO

4.8 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 ₹ 1999

₹ 999

ENROLL NOW

Duration

4 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Beginner

Schedule

Monday to Friday

Certificate

Yes

Share this Course