Training Needs Analysis
- MS Excel Introductory
Please enter your name
and your e-mail
MS Excel Introductory
Competent
Some Knowledge
No Knowledge
Access the package
Add header/footers
Application Software i.e. Word
Apply currency symbols
Centre text
Change colours in a chart
Change column width
Create Borders around Data Entries
Creating a Template
Creating and Designing a New Worksheet
Creating Charts
Deleting and Inserting Row/Columns
Drag & Drop/Copy & Paste
Edit a Chart
Editing and Formatting Data
E-mail Attachment to Send Excel Files
Enter Data/Cursor Movement/Shortcuts
Find & Replace Text/Numbers/Cells
Insert headers/footers
Moving and Copying Sheets
Naming a Worksheet
Organising Data/Data Sorting
Print a spreadsheet/complete workbook
Relative & Absolute Cell Addressing
Saving workbooks
Selecting Relevant Data
Undo Function
Use Print Preview to View Headers
Use Shading Functions to Shade Areas of Data
Use Shortcut Icons for a Chart
Use Keyboard Shortcuts
Use slides for charts
Use the Autofill Function
Use the Autosum
Using and recognizing Icons on Toolbar
Using Formulae
Using the Format Cell Box Properties
Work with several sheets at the one time
Working with Multiple Worksheets
For more information:
tel
028 7136 1696
fax
028 7136 1696
email
info@zenithlearning.com