Fundamentals of Excel for the Workplace
Learn the basics or brush up on your MS Excel skillset.
Course overview
This full-day beginners’ course is for those who want to learn the fundamentals of Microsoft Excel. This short course covers everything from navigating the Excel interface to adding, editing and formatting data. You'll also learn how to import data to use in tables, charts and basic formulas.
This short course is ideal for getting started and gaining confidence with Microsoft Excel.
Course details
What you'll learn
- Explore the Interface: Get comfortable with Excel's layout and features
- Workbooks and Worksheets: Learn to navigate and manage your files efficiently
- Adding and Editing Data: Master the essential skills of data entry and modification
- Formatting and Conditional Formatting: Discover how to make your data visually appealing and easier to understand
- Simple Formulas: Start calculating with basic formulas to streamline your tasks
- Importing Data: Seamlessly bring in data from various sources
- Text-Based Formulas: Manipulate text within your cells for better insights
- The 'If' Formula: Introduce logic into your spreadsheets for smarter data management
- Creating Tables, Filtering, Sorting, and Searching: Leverage slicers for more intuitive data exploration
- References: Understand how to reference data across your workbooks
- Creating and Modifying Charts: Visualise your data with professional-quality charts
How you'll learn
Our online short courses are delivered through Microsoft Teams, ensuring a seamless learning experience. Each session starts with a live broadcast from the tutor to introduce the topic and guide you through the resources. Our short courses include various learning methods such as videos, quizzes and exercises. The tutor remains available online for real-time support, making learning effective and enjoyable. Our blended teaching approach combines live and pre-recorded content, providing flexibility to learn at your own pace.
Matthew Abbott - Course Lead
Matthew is a Digital Skills Trainer at Falmouth, specialising in Microsoft Office 365 and Adobe Premiere Pro. He delivers a range of Adobe and Microsoft courses, including Microsoft Office Specialist (MOS) and Adobe Certified Professional (ACP) qualifications. He holds a degree in Sustainable Product Design and a PCET teaching certificate, and has served as a Senior Technician at Falmouth University for over 20 years.
Find out moreRead our short course terms & conditions
- Engaging content
- A variety of different ways to learn
- Clear guidelines to work through the practice exercises
- Constructive feedback from tutors on your submitted work
- Technical assistance from your tutors
Access to full working subscription of Office 365. The desktop application of Excel will be required.
Similar courses
WordPress: Create Websites & Blogs
Learn how to create a website or blog in WordPress
SketchUp for Web
Step into the world of 3D modelling with SketchUp, the ultimate user-friendly tool for modelli...
Premiere Rush - Quick and easy Video editing
Learn the essentials of editing clips, adding audio, titles and more.
PowerPoint: create presentations with professionalism and impact
Join our engaging short course to learn the fundamentals of PowerPoint.
Photoshop Visualisation Skills
During this course, we will provide you with the right tools to help you to present your archi...
Photoshop for Social Media
Learn how to compose eye-catching banners, design stunning social media graphics and more.
Photoshop for Photographers
Optimise your images for professional results.
Photoshop for Interior Design
This course introduces step-by-step techniques for interior designers to successfully use Adob...
Photoshop for absolute beginners
Develop essential skills in image editing on this Adobe Photoshop course for beginners.
Make Essay & Dissertation writing Easier using MS Word
Master Microsoft Word for writing dissertations and essays with this comprehensive course! Learn to ...
Introduction to Blender for 3D Modelling, Animation and Visualisation
Discover the basics of Blender.
Getting started with Adobe Photoshop
Take your first steps into the world of image editing and creation.
Getting started with Adobe InDesign
Learn all the basics on our Adobe InDesign Level 1 course.
Getting started with Adobe Illustrator
Explore the basic concepts and functions of Adobe Illustrator
Getting started with Adobe
Discover Adobe and explore which applications you want to master.
Get designing with Adobe Photoshop, InDesign and Illustrator
Creatively use Photoshop, Illustrator and InDesign together.
From Beginner to Master: Premiere Pro
This series of Premiere Pro courses will enhance your digital skills in the competitive jo...
From Beginner to Master: Photoshop
This series of Photoshop courses will enhance your digital skills in the competitive job m...
From Beginner to Master: InDesign
This series of InDesign courses will enhance your digital skills in the competitive job ma...
From Beginner to Master: Illustrator
This series of Illustrator courses will enhance your digital skills in the competitive job...
From Beginner to Master: After Effects
This series of After Effects courses will enhance your digital skills in the competitive j...
Figma for UI and UX Design
This beginner-friendly course offers a concise introduction to Figma, a leading collaborative ...
Excel Data Analysis and Visualisation in Excel
Elevate your Excel skills with this course, designed for those eager to master data analysis and vis...
Creating Motion Graphics with Adobe After Effects
Create and manipulate motion graphics, visual effects and more.
Create compelling Social media content with Canva
Learn how to professionally design and easily prepare images in Canva
Adobe Premiere Pro: Introduction to Video Editing
Learn the basics of video editing.
Adobe Express for Portfolios
Build an online portfolio with ease with this Adobe Express short course.
Adobe Express for CVs
This short course will show you how to create and build a CV and then customise it using professiona...
Adobe After Effects for Instagram
Do you want your Instagram posts to stand out from the crowd? In this course, you’ll learn how to ...