Microsoft Excel Introduction Course – Classroom
Begin with the basics of Microsoft Excel by creating spreadsheets and workbooks to organise, calculate, analyse, revise, update, and present data.
- All Courses
- Microsoft Office
- Microsoft Excel
- Microsoft Excel Introduction Course – Classroom
Course Overview
Excel can help you organise, calculate, analyse, revise, update, and present your data in ways that will help the decision making in your organisation. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.
You will use Microsoft Office Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
1 Day
Training Options
Classroom
Microsoft Excel Introduction Course Content:
Lesson 1: Getting Started with Excel
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
Lesson 2: Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Styles and Themes
- Topic E: Apply Basic Conditional Formatting
- Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
Upon successful completion of this course, students will be able to:
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbook contents
- Manage large workbooks
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to use Windows to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Gerard Cahill Commercial Accountant from Capital One
Khalid Tai Ecotricity (Stroud)
Steve Large Director from Large Creative
Lisa Dunstan Payroll Manager from Decathlon UK
Michael Sexton
John Clarke
Sarah Harvey Assistant Accountant from QD Commercial Group Holdings
Harry Frost Marketing Assistant from Babcock International Group
Emily North
Sam Fletcher
Take Yourself Further With Infero
Top Microsoft Excel FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm