Excel
Program Aim:
This aim of this programme is to provide students with the essential concepts of Microsoft Excel. Students will concentrate on understanding the basic skills required to use the Excel interface and create and work with workbooks and spreadsheets.
Program Outcome:
This program will provide you with the essential concepts required to create and edit basic Microsoft Excel spreadsheets and workbooks.
Program outline
LESSON 1: EXPLORING THE EXCEL ENVIRONMENT
Explore the User Interface
Explore the Ribbon
Using the Quick Access Toolbar
Customising the Quick Access Toolbar
LESSON 2: WORKING WITH AN EXCEL WORKSHEET
Navigate in Excel
Select and Enter Data
Save a Workbook
LESSON 3: MODIFYING A WORKSHEET
Manipulate Data
Insert and Delete Cells, Columns and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
LESSON 4: PERFORMING CALCULATIONS
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
LESSON 5: FORMATTING A WORKSHEET
Convert Text to Columns
Modify Fonts
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Align Cell Contents
Find and Replace Formats
Apply AutoFormat
Apply Cell Styles
Apply Themes
LESSON 6: DEVELOPING A WORKBOOK
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Program Aim:
This aim of this program is to provide students with more complex tasks and components within Microsoft Excel. In this program you will use Excel to streamline and enhance your spreadsheets with templates, charts, graphics and formula.
Program Outcome:
On successful completion of this programme. You will know how to apply visual elements and advanced formulas to a worksheet to display data in various formats.
Program Outcome:
LESSON 1: CALCULATING DATA WITH ADVANCED FORMULAS
Manage Cell and Range Names
Calculate Data across Worksheets
Use Specialized Functions
Analyse Data with Logical and VLookup & HLookup Functions
Logical Functions IF, SumIf, CountIf, AverageIf
LESSON 2: ORGANISING WORKSHEET AND TABLE DATA
Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet
LESSON 3: PRESENTING DATA USINE CHARTS
Create a Chart – Column, Bar, Pie, Line
Modify Charts
Format Charts
Sparklines
LESSON 4: ANALYSING DATA USING PIVOT TABLES AND PIVOT CHARTS
Create and Working with Pivot Tables
Formatting Pivot Tables
Drilling Up or Down
Using the Slicer
Creating and working with Pivot Charts
LESSON 5: INSERTING GRAPHIC OBJECTS
Insert and Modify Pictures and Graphic Objects
Draw and Modify Shapes
Illustrate Workslow using SmartArt Graphics
Layer and Group Graphic Objects
LESSON 6: CUSTOMISING AND ENHANCING WORKBOOKS AND THE EXCEL ENVIRONMENT
Customise the Excel Environment
Customise Workbooks Customise Workbooks
Manage Themes
Create and Use Templates
Program Aim:
This aim of this programme is to extend your knowledge into some of the more specialised and advanced capabilities of Microsoft Excel.
Program Outcome:
On successful completion of this programme, you will know how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others and share Excel data with other applications.
