Course Content
EXPLORING THE EXCEL ENVIRONMENT
- Exploring the User Interface
- Explore the ribbon
- Obtain Help
- Customise the quick access toolbar
WORKING WITH AN EXCEL WORKSHEET
- Navigate in Excel
- Select and Enter Data
- Save a workbook
MODIFYING A WORKSHEET
- Manipulate Data
- Insert and Delete Cells, Columns and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
PERFORMING CALCULATIONS
- Create Basic Formulae
- Calculate with Functions
- Compare Formula with Functions
- Create a Mixed Reference
FORMATTING A WORKSHEET
- Convert Text to Columns
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Align Cell Contents
- Find and Replace Formats
- Apply Auto Format
- Apply Cell Styles
- Apply Themes
DEVELOPING A WORKBOOK
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
INSERT and DELETE Worksheets
- Copy and Paste Worksheets
- Function point analysis
- COCOMO model
- Agile Estimation
PRINTING WORKBOOK CONTENTS
- Set Print Titles
- Create a Header and a Footer
- Change Page Orientation
- Set Page Breaks
- Print a Range
CUSTOMIZING LAYOUT
- Split a Worksheet
- Arrange Windows
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide worksheets