Course content
Full course content
8 modules, 38 topics. This syllabus is part of 3 courses.
1
Module 1: Getting Started
- Understanding the Excel screen
- Navigating in a spreadsheet
- Understanding worksheets, columns, rows and cells
- Saving, opening, and closing workbooks
2
Module 2: Formatting a Spreadsheet
- Changing column widths and row heights
- Changing alignment of cells
- Undoing and redoing actions
- Formatting numbers
- Clearing formats
- Applying borders to cells
- Merging cells
3
Module 3: Formulas and Functions
- Entering formulas
- Copying data and formulas
- Using AutoSum
- Understanding functions
- Using simple aggregate functions (Sum, Count, Average, Min, Max)
- Copying formulas
- Applying conditions in a formula (The IF function)
- Working with ranges
4
Module 4: Editing Features
- Using cut , copy, and paste operations
- Using paste special with values
- Selection techniques
- Navigation techniques
5
Module 5: Working with Large Worksheets
- Freezing and unfreezing panes
- Splitting windows
- Inserting page breaks for printing
6
Module 6: Working with Charts
- Creating charts using Chart Wizard
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
7
Module 7: Previewing and Printing
- Previewing worksheets
- Page setup
- Printing of worksheets in multiple pages
- Repeating rows and columns for multiple pages
- Printing multiple worksheets
8
Module 8: Simple Database Operations
- Sorting tables
- Filtering data with auto filter
- Referring data from other worksheets
