Course description
Microsoft Excel training for beginners, teaching key techniques to get you up and running.
Hosted by highly experienced Microsoft instructors,this course provides a thorough grounding in the application, showing you how to turn disorganised data into useful information and quickly make spreadsheets your friends. Sessions include:
- Program fundamentals.
- Opening, saving and closing a spreadsheet.
- Basic formulae.
- Editing worksheets.
- Formatting worksheets.
Course delegates receive:
- A practical Excel training guide, to refer to during the course and use as a refresher after.
- An e-certificate confirming successful completion of a Excel training course.
Upcoming start dates
Course Content
Program Fundamentals
- Starting Excel
- Understanding the Excel Program Screen
- Giving Commands
- Using Command Shortcuts
- Creating a New Workbook
- Opening a Workbook
- Previewing and Printing a Worksheet
- Saving a Workbook
- Closing a Workbook
- Using Help
- Exiting Excel
Getting Started with Worksheets
- Navigating a Worksheet
- Entering Labels and Values
- Selecting a Cell Range and Entering Data in a Cell Range
- Overview of Formulas and Cell References
- Entering Formulas
- Entering Content Automatically
- Referencing External Data
Editing Worksheets
- Editing Cell Contents
- Copying and Moving Cells
- Controlling How Cells Are Moved or Copied
- Collecting Items to Move or Copy
- Checking Your Spelling
- Inserting Cells, Rows, and Columns
- Deleting Cells, Rows, and Columns
- Using Undo and Redo
- Finding and Replacing Content
- Adding Comments to Cells
- Tracking Changes
Formatting Worksheets
- Formatting Text
- Formatting Values
- Adjusting Row Height and Column Width
- Working with Cell Alignment
- Adding Cell Borders and Background Colours
- Copying Formatting
- Applying and Removing Cell Styles
- Creating and Modifying Cell Styles
- Using Document Themes
- Applying Conditional Formatting
- Creating and Managing Conditional Formatting Rules
- Finding and Replacing Formatting
Training venue
We offer this course at our centres in Bromsgrove and Reading.
Our Bromsgrove venues are easily accessible by car from the M5 and M42 motorways and there is ample free parking. A free taxi service is available from Bromsgrove train station.
Our Reading venue is in the town centre, a short walk from the central train station.
At both centres, we offer excellent facilities and a comfortable environment to learn your new skills. Lunch and refreshments are also provided.
Suitability - Who should attend?
This course is ideal for anyone who needs to use Excel in their day-to-day work.
Outcome / Qualification etc.
Delegates receive an e-certificate confirming successful completion of a Excel training course.
Course delivery details
Excel training is hands-on and practical.
Our trainers teach the necessary theory then demonstrate techniques step-by-step. You then practice the techniques taught on a computer running Excel.
There is plenty of time to ask questions, and you can keep all the files you create.
Why choose Armada
4.9 stars Google Review rating
Over 96% delegate experience rating on our Autodesk courses in 2021
5 locations across UK and live online courses
Customer Outreach Award 2019
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Continuing Studies
Following this course, we also offer a 1-day Intermediate Excel and 1-day Advanced Excel courses.
We specialise in: CAD design training. Our expert trainers cover the most popular CAD applications including AutoCAD, Revit, Fusion, SketchUp, 3ds Max, used across all industries - architecture, engineering, interior design and others. Creative, video and animation training - Adobe...