Target Audience
Anyone that has no prior knowledge of Microsoft Excel and would like to learn it.
Outline
The Quick Start Excel course provided to Carmichael from Anne Walsh (The Excel Lady) is a one-hour course designed to give the learner a good foundation how to start using Microsoft Excel, an increasingly powerful tool in the workplace for day-to-day logging of data as well as production and maintenance of reports. Learning is further enhanced with simple quizzes and training exercises to help the participant to commit their learning to memory.
Course Structure
The course comprises ten topics, with short videos and takes approximately one hour to complete.
Introduction: Meet your trainer
Topic 1: First Things First - Know Your Keyboard
1.1 Identify these keys: Ctrl, Shift, Enter, Backspace, Delete
1.2 Know your F4 key and the Fn key
1.3 Get out of jail keys: Learn ESC and Undo.
1.4 Quiz on knowing your keyboard
Topic 2: Say Hello to Excel
2.1 Open Excel
2.2 Identify rows, columns and cell references
2.3 Try out the ribbon - notice the tool tips
2.4 Quiz on Say Hello to Excel
Topic 3: Working with your Files
3.1 How to save a file
3.2 How to open a file you have already saved
3.3 How to pin a file so you can access it again
3.4 How to save a file with a new name
3.5 Module 3 - Resources
Topic 4: Entering and Breaking
4.1 Practice entering numbers and undo - notice they are on the right
4.2 Practice entering text and undo - notice they are on the left
4.3 Practice entering dates and undo.
4.4 Module 4 - Practice
Topic 5: Know How to Use your Mouse
5.1 Copying down and across (black cross and white cross)
5.2 Help, I don't have a cross
5.3 Module 5 - Practice
Topic 6: Copying and Formatting
6.1 Entering, copying and formatting a day/month
6.2 Entering, copying and formatting numbers
6.3 Entering, copying and formatting dates
6.4 Module 6 - Practice
Topic 7: Cut, Copy and Paste
7.1 Enter some text and move it by cutting and pasting - ribbon and keyboard
7.2 Enter some text and copy it by copy and paste - ribbon and keyboard
7.3 Enter some dates and experiment with moving/copying
7.4 Module 7 - Practice
Topic 8: Meet Some Formulas
8.0a How to download the file
8.0b Download this file first
8.1 Enter two numbers and add them together, then copy them down
8.2 Enter two numbers and subtract from each other, then copy them down
8.3 Enter two numbers and multiply them together, then copy them down
8.4 Enter two numbers and divide them, then copy them down
8.5 Fixing a Cell
8.6 Quiz on Formulas
Topic 9: Data Setup
9.0a How to download the file
9.0b Download this file first
9.1 Rules about data entry
9.2 How to set up a list
9.3 How to do a basic sort
9.4 How to do a basic filter and clear it
9.5 Module 9 - Resources
9.6 Quiz on data entry
Conclusion
Upon completion of the course, the participant can request a Certificate of Completion by emailing ce.training@carmichaelireland.ie.
Note: Once an e-Learning course is booked, participants will receive instructions on how to log on.
Learners from outside the Republic of Ireland are advised to contact training@carmichaelireland.ie before booking, in order to ensure proper access to the course.
Fees
| €50 | Carmichael Resident Organisation |
| €50 | Nonprofit Organisation |
| €50 | Statutory Organisation |
| €50 | Corporate Organisation |