Microsoft Excel Training - Beginner Course
Learn basic Excel skills on our intensive one-day course.
All courses available in-class or remotely.
To attend remotely, select "Remote Online" as your location on book now.
Unlock the power of Excel spreadsheets to effectively analyse, share, and manage your day-to-day data with our comprehensive one-day Excel for beginners course. Gain practical skills and knowledge that can be applied in any professional setting to enhance your productivity and decision-making abilities.
Our course covers the important basics from creating and formatting spreadsheets and charts to sorting and filtering data. Check out our complete Excel Beginner Course Outline below for more details. This course is specifically designed for individuals with little to no prior experience in Excel, providing a solid foundation for you to build upon. Once you're comfortable with the basics, you can explore our Intermediate and Advanced levels at your own pace.
Microsoft Excel Training - Beginner Course
Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our one-day course.
Frequently Asked Questions
Are your courses suitable for an Excel beginner?
Yes, this course will teach excel for beginners. You will learn all key basic excel skills and be ready to put them into practice in the workplace. We also offer Excel Intermediate, Advanced, Expert, and Specialist courses for those looking to take the next step. We want to stress that this is Excel for beginners.
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Course Outlines
-
-
-
-
-
MO-201 Excel Certification
Excel City Pages
Skills Test
Contact Us
What do I need to know to attend?
There is no requirement for the Excel Basics course. The course is suitable for people who have never worked with Excel or have just had very limited exposure to it. We will walk you through, right from the start. This is an excel course for beginners.
Excel Beginner Learning Outcomes
- Create and work with a new workbook
- Open and navigate within workbooks and worksheets
- Understand and work with ranges in a worksheet
- Understand, create and work with formulas and functions
- Use font formatting techniques
- Format rows and columns in a worksheet
- Use a range of techniques to work with worksheets
- Sort data in a list in a worksheet
- Create effective charts in Microsoft Excel
- Apply a variety of page setup techniques
- Print your workbook data
Excel Beginner Course Content
- Getting to Know Excel
- What are Spreadsheets, Worksheets and Workbooks?
- What are Columns, Rows, Cells
and Ranges? - The Excel Interface
- Keyboard Navigation Options
- Creating Workbooks
- The Ribbon
- The Backstage View
- Data Types
- Excel 365 File Formats
- Save and Save As
- Saving to Microsoft OneDrive
- Compatibility Mode
- The Convert Option
- The Compatibility Checker
- Checking for Accessibility Issues
- Creating Workbooks
- Getting Help in Excel 365
- Using the Microsoft Search Box
- Accessing Advanced Help Options
- Using Formulas and Functions
- About Functions
- Creating a Function with
AutoComplete - Using the Insert Function Dialog
Box - Using AutoSum
- Viewing AutoSum Calculations in
the Status Bar - Automatic Workbook Calculations
- Working with Data
- Selecting Cells
- Cut, Copy and Paste
- Paste Options
- Live Preview
- The Transpose Option
- Moving Data with Drag and Drop
- Undo and Redo
- AutoFill
- FlashFill
- A Closer Look at Formulas
- Excel Formulas
- The Formula Bar
- Elements of an Excel Formula
- Mathematical Operators
- The Order of Operations
- Types of References
- Working with Rows and
Columns - Inserting Rows and Columns
- Deleting Rows and Columns
- Clearing Data from Cells
- Changing Column Width and Row
Height - Hide and Unhide
- Sorting and Filtering Data
- Sorting vs Filtering Data
- Sorting Data
- Enabling Filtering
- Using the Filter Menu
- Using Text Filters
- Clearing a Filter
- Formatting Text
- Fonts
- Format Cells Dialog Box
- Format Painter
- Live Preview and Formatting
- The Mini Toolbar
- Creating Links
- Formatting Cells
- Applying a Border
- Applying a Fill
- Changing the Number Format
- Formatted Numbers and Cell
Width - Customising Number Formats
- Aligning Cell Content
- Alignment Options
- The Indent Commands
- Wrap Text
- Merge and Centre Options
- Printing Workbook Contents
- Define the Basic Page Layout for a
Workbook - Print Options in Backstage View
- The Page Setup Dialog Box
- Print Preview
- Workbook Views
- Headers and Footers
- Header and Footer Settings
- Page Margins
- Margins Tab Options
- Page Orientation
- Refine the Page Layout and Apply
- Print Options
- Zoom Options
- Page Breaks
- Page Break Options
- The Print Area
- Print Titles
- Scaling Options
- Managing Large Workbooks
- Format Worksheet Tabs
- Renaming Worksheet Tabs
- Changing Tab Colour
- Manage Worksheets
- Grouped Worksheets
- Repositioning Worksheets
- Inserting or Deleting Worksheets
- Hiding and Unhiding Worksheets
- Worksheet References in Formulas
- Customising the Excel
Environment - Customise General and Language
Options - The Excel Options Dialog Box
- Customise Formula Options
- Customise Proofing and Save
Options - Version Control
- Customise the Ribbon and Quick
Access Toolbar - Understanding and Enabling AddIns
- The Developer Tab
- Customise Advanced and Trust
Centre Options
- Search For and Replace Data
- Cell Names and Range Names
- Find
- Replace
- Go To
- Spell Check a Worksheet
- The Spelling Dialog Box
phone
email
enquiry
