Course description
Live online 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
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
Our approach to live online Excel training
We do everything possible to make your experience as close as possible to actually being in the classroom…
- You’ll see and hear your trainer and the other delegates, and be able to view your trainer’s screen. Your trainer and the other delegates will see and hear you.
- You'll receive the same Excel training guide as in-class delegates. Choose from a printed copy that we’ll post to you, or PDF.
- Your training is hands-on: you’ll practice and carry out exercises throughout. We’ll make the course files and resources you’ll use available for you to download.
- If you need assistance, you can share your screen with your trainer, and pass control to them.
- If you don’t have access to Excel, we’ll send you a link to fully-functional Excel trial software to download and install.
Armada uses Zoom as our platform of choice for our live online training.
Training is designed for the busy professional, being fast-paced and intensive. It is hands-on and practical and goes beyond a basic ‘how to’ approach; offering best practice advice and delegates have ample opportunity to discuss their specific requirements and issues with the trainer.
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.
Armada
We specialise in: CAD design training. Our expert trainers cover the most popular CAD applications including AutoCAD, Revit, Fusion, SketchUp, Civil 3D, 3ds Max, used across all industries - architecture, engineering, interior design and others. Creative, video and animation training...