Excel Course Syllabus

Basic Excel Course

Duration: 4 Weeks

Module 1: Introduction to Excel

• Overview of Excel Interface: Workbook vs. Worksheet, Cells, Rows, Columns, and Ranges, The Ribbon, Quick Access Toolbar, and Formula Bar, Workbook Navigation.
• Exercise: Explore the Excel Interface and identify each component.
• Creating, Saving, and Opening Workbooks: How to create a new workbook, Saving and Opening workbooks, File formats: .xlsx, .xls, .csv.
• Exercise: Create a new workbook and save it in different formats.

Module 2: Working with Data

• Data Entry and Formatting: Entering text, numbers, dates, and currency, Adjusting column width and row height, Number, Text, and Date Formatting.
• Exercise: Enter sample data and apply different formats.
• Using AutoFill and Flash Fill: What is AutoFill? How to use Flash Fill for automatic data entry.
• Exercise: Use Flash Fill to fill in a list of names or dates.

Module 3: Data Management

• Sorting Data: Sorting data alphabetically and numerically, Custom Sort Orders.
• Exercise: Sort a list of products by price.
• Filtering Data: Using AutoFilter to display specific data, Advanced filtering options.
• Exercise: Filter a dataset to display only values greater than 50.

Module 4: Introduction to Formulas and Functions

• Creating Basic Formulas: Writing formulas for basic arithmetic operations, Using the Formula Bar.
• Exercise: Create a formula to calculate the total cost of a list of items.
• Using Basic Functions: SUM, AVERAGE, COUNT.
• Exercise: Use SUM to add a series of numbers and COUNT to count data entries.

Module 5: Visualizing Data with Charts

• Creating Charts: Column, Line, and Pie Charts, Modifying Chart Titles, Legends, and Axes.
• Exercise: Create a column chart for monthly sales data.

Module 6: Working with Multiple Sheets

• Referencing Data Between Sheets: How to link cells between different worksheets.
• Exercise: Create a formula to pull data from another worksheet.