- SSG Skill Level Definition : Excel for Business - Basic Skill Level Version 1.1 8th August 2012
-
Understanding / Managing the working Environment
- Understanding the Ribbon
- Workbook and Worksheet
- Minimizing Ribbon
- Context specific Tab
- Renaming WorkSheet
-
Working with Data
- Entering Data
- Using the fill handle
-
Formatting
- Font
-
Alignment
- Centering a heading over a range of cell
- orientation
- Text Wrapping
- Format Painter
- Numbers
- Borders
-
Using in-built Functions
- Getting help with Functions
-
Categories of functions
-
Mathematical
- Sum
- Round
-
Statistical
- Average
- Min
- Max
- Count
- CountA
- Rank
-
Time and Date
- Today
- Now
- Day
- Month
- Year
-
Text
- Left
- Right
- Mid
-
Logical
- IF
- AND
- OR
-
Financial
- NPV
- IRR
- PMT
- Nested Functions
-
Creating and Using Formulas
- Absolute and Relative Reference
- Date formulas
- Concatenation of Text
- Common errors in entering formulas
- Using Operators
-
Manipulation of Data and Formulas
- Copy and Paste
- Hiding Rows and Columns
- Sorting
- Filtering basics
-
Basics of Charting
- Chart types in Excel
- Creating a Chart
-
Tools for Efficiency
- Keyboard shortcuts
- Freeze Panes
- Find and Replace
- range name
- Copying and moving worksheets
-
Page Set Up and Printing
- Worksheet Margin
- Headers and Footers
- Title Row and Columns
- Print Preview