Excel - Excel Essentials and Formulas

Trained 50k+ People

Over 100+ Countries

By Specialist Trainers

With Over 20 Years' Experience

Enquire Now
Book Now
Download Overview

By the end of this course, learners will be able to navigate Excel efficiently, apply cell formatting, use basic and intermediate formulas, create and manipulate tables and charts, analyze data with functions such as SUM, AVERAGE, IF, and VLOOKUP, and apply best practices for spreadsheet organization and data validation. The course equips learners with the foundational Excel skills needed for day-to-day productivity and data analysis tasks.

Getting Started with Excel

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter and Edit Cell Data
Fill Cells with Series of Data (AutoFill and Flash Fill)
Use Excel Help

Performing Calculations

Create Worksheet Formulas
Insert Functions and use Autocomplete
Reuse Formulas and Functions
Create an Absolute Reference

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Move and Copy Data between Cells
Search for and Replace Data
Use Spellcheck and Proofing

Formatting a Worksheet

Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply and Copy Cell Styles
Apply Basic Conditional Formatting

Printing Workbooks

Preview and Print a Workbook
Controlling Page Layout
Adding Headers and Footers
Set Print Titles and Print Ranges

Managing Workbooks

Manage Worksheets
Insert and Delete Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Beginners to Excel, business professionals, students, and anyone looking to improve their spreadsheet and formula skills

Instructor-led training, course materials

Basic computer skills; no prior Excel experience required

Microsoft Excel documentation, Excel formula guides, online tutorials from Microsoft Learn

There is no formal certification exam for this course. Learners may complete a practical assessment or exercises to demonstrate mastery of Excel essentials and formulas.

No Exam

Excel Essentials and Formulas Completion Certificate

After completing this course, learners can progress to Excel Advanced Features, Excel VBA/Automation, or other data analysis courses such as Introduction to DAX for Power BI.After completing this course, learners can progress to Excel Advanced Features, Excel VBA/Automation, or other data analysis courses such as Introduction to DAX for Power BI.

This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager

Reviews

Purple Griffon recently delivered 2 service management courses for the MOD and we all found it to be a very positive experience. The Company is very professional, with extremely knowledgeable and experienced trainers, who have real world skills.

Garry Jones - Procurement Manager, MOD

It was a beast of a course but very rewarding. Thanks for the assistance around the booking - the customer service was excellent. I no longer have to hide behind my project management team and can say loud and proud I am a PRINCE2® practitioner!

Matthew Slater - Service Delivery Manager, InTechnology

The training was organised well, administrative help was quick and relevant which made the information gathering and training preparations fast & easy. The trainer was knowledgeable and experienced. We’ve received very good feedback.

Karolina Manka - Training Specialist, Accenture

I passed! which I must admit was 100% down to your trainer Bob. He gave us enough stories and tips to get me through it and sometimes the stories sink in better than anything else. Thanks again, I'd definitely use your company again because of him.

Tracy Iqbal - IT Assistant, MacRoberts

Feedback from staff has been positive and you have helped us to effectively embed the ITIL® framework into our working processes and achieve key organisational goals. We look forward to continuing with rest of our ITIL® courses throughout the year.

Max Khalid - ITSM Specialist, London Programme for IT

I have self-funded several courses with Purple Griffon, and passed all of my exams to gain ITIL® Expert accreditation. This wouldn't have been possible without the help from the team and tutors. This makes Purple Griffon my first choice of training provider.

Sarah Jamieson - Individual , Self-Funded

Excellent course material and exercises and discussion facilitate learning in the classroom. Managed to pass all exams of courses taken with Purple Griffon! And I believe on this latest course a 100% pass rate from all delegates on the course!

Rob James - Individual, Self-Funded

Great company and Steve is a really knowledgeable guy as well!

Maurits Van Der Plas - Director, Van Haren Learning Solutions

I could not find any other training exclusively focused on the IT SDM roles and responsibilities elsewhere, making this course possibly the best IT SDM training in the world! I consider this course among the top courses I've had the pleasure of attending.

Michael Hilliker - IT Branch, Gouvernement Du Canada

The free "Introduction To The World Of The Service Desk" provided a great insight into the world of IT Service Management. Excellent slides.

Chinonyerem Mpamah - Learner, Self-Funded

I have been using Purple Griffon since 2013 after taking a course with another company and didn't receive the best experience. Since 2013 I haven't used anyone else. Excellent courses and very personable trainers and high pass rates.

Terry Wilder - Learner, Self-Funded

The Purple Griffon E-Learning study material is very complete, and prepared me for the exam in an excellent way. I am happy to have used the Purple Griffon material and I am planning to do so again in the near future.

Louis Rademaker - Learner, Self-Funded

I've taken classroom training via Purple Griffon and their exceptional team on several occasions. In my case it has been ITIL® based and I can only recommend their services.

David Barrow - Learner, Self-Funded

From what I see the course for CDS is well organised and staff that prepared the materials are really looking for their students to pass the exam with good marks. I wish that whenever I need extra help the staff will help me immediately

Fawaz Yelda - Professional, Control Risks

I got studying material from Purple Griffon and the quality is more than good. Good work!

Sergio Enriquez - Learner, Self-Funded

Very good training provider and the instructor was very knowledgeable

Nigel Rooms - Professional, CDW

Great training - passed my ITIL® exam!

Luca Bakshi - Technical Analyst, Trayport

I found the ITIL® 4 Foundation online training course very good and easy to follow. I think good values.

Keith Brain - Individual, Self-Funded

The Digital Twins Basics Online Workshop (60 Minutes) was simple and the content was easy to understand.

Titilayo Iya Y - Individual, Self-Funded

INFORMATION