Why book this course?
Spreadsheets are the backbone of many a workplace, and Microsoft Excel is the spreadsheet software of choice. Whether you’re making timetables, logging contact details, creating reports or tracking expenditure, Microsoft Excel has a myriad of different uses, and is essential for anyone performing office work.
Our highly practical Microsoft Excel for Beginners course introduces you to this integral part of the Microsoft Office suite. Coordinating with our expert tutors, you’ll familiarise yourself with Excel’s software environment, and learn the essential skills you’ll need to create and format spreadsheets with confidence.
Who is the course for?
While it is preferable that you have some keyboard and mouse skills, there are no real prerequisites for this course. It is designed to introduce anyone who is unfamiliar with Excel to how the software functions, and impart basic skills that will be valuable to almost any office or digital media role.
Learners on our Microsoft Excel for Beginners course will learn to produce simple spreadsheets with basic formulae, produce basic charts, and structure and layout their spreadsheets in a neat and visually pleasing way. The course is ideal for anyone who uses Excel sporadically, or as a preamble to a more advanced course.
What content will the course cover?
-
Screen Elements
-
Customising the Quick Access Toolbar
-
Use mouse shortcut menus and keyboard shortcuts
-
Understanding worksheets, columns, rows and cell referencing
-
The formula bar, status bar and name box
-
Using the New Help Feature
Editing
-
Entering different data types, text, values, dates
-
Editing cell contents and simple corrections, spell checking
-
Deleting cell contents and undo/redo
-
Using AutoFill and Auto Calculate and FlashFill
-
Cut/copy and paste – understanding the clipboard
-
Save, close and open workbooks
Calculations – Formula and Functions
-
BODMAS – The order of calculation
-
Relative, absolute cell referencing, fixing cell references
-
Arithmetic calculations and operators
-
Simple functions – sum, average etc.
-
Create and use range names
Formatting
-
Moving/copying rows and columns
-
Adjusting/deleting column and row dimensions
-
Aligning cell content and text and number formatting
Printing
-
Set up page breaks and use print preview and page break preview
-
Page set-up options, headers and footers
**Introduction to Charting
What will I get out of the training?
Learners on our Microsoft Excel for Beginners course will gain an understanding of the functions of Microsoft Excel, and be able to work more effectively in the software. You’ll learn how to create, edit, format and print professional spreadsheets quickly and easily, as well as using some basic formulae and understanding the principles of calculation.
At Kent Trainers, we’re proud to tailor our training to the needs of businesses across the region. By working closely with our trainers and undertaking practical exercises, you’ll be able to ask questions and get answers that pertain to your work. By the end of your course, you should have an understanding of Excel that addresses everything you need from the software.
What is the duration of this course?
This is a 1-day course.
The timings and format for our courses are as follows:
- In-house & bespoke courses, held virtually or at a venue of your choice
For all in-house training courses, we will adapt the timings and format for each day around the needs of your organisation and team. Please get in touch with us to discuss your requirements.
- Scheduled training courses held at one of our venues
Courses commence at 9:30am and finish at approximately 4:30pm. A hot and cold buffet lunch is included on all our scheduled courses, and refreshments are provided throughout the day.
- Scheduled training courses held virtually
Unless specified, courses commence at 9:30am and finish at approximately 4:00pm. The day is broken up into modules, both online and offline to ensure engagement and interaction. We also ensure that there are plenty of comfort breaks throughout the day.
