Microsoft Excel - Beginner
Microsoft Excel Beginner
This course is designed for users new to Microsoft Excel and spreadsheeting as a
concept. You’ll learn all key basic Excel skills and be ready to put them into practice in the
workplace.
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 Excel
• Apply a variety of page setup techniques
Course Subjects
• What are Spreadsheets, Worksheets and Workbooks?
• What are Columns, Rows, Cells and Ranges?
• The Excel Interface
• The Ribbon
• The Backstage View
• Data Types
• Excel 365 File Formats
• Using the Microsoft Search Box
• Accessing Advanced Help Options
• About Functions
• Creating a Function with AutoComplete
• Using the Insert Function Dialog Box
• Using AutoSum
• Selecting Cells
• Cut, Copy and Paste
• Paste Options, Live Preview, Transpose Option
• Moving Data with Drag and Drop
• Excel Formulas
• The Formula Bar
• Elements of an Excel Formula
• Mathematical Operators
• The Order of Operations
• Inserting, Deleting Rows and Columns
• Clearing Data from Cells
• Changing Column Width and Row Height
• Sorting vs Filtering Data
• Sorting Data
• Enabling Filtering
• Using the Filter Menu
• Fonts, Format Cells Dialog Box
• Format Painter, Live Preview, Mini Toolbar
• Creating Links
• Applying Borders and Fills
• Page Layout Basics
• Print Options in Backstage View
• Page Setup Dialog Box
• Print Preview
• Format Worksheet Tabs
• Renaming and Colouring Tabs
• Grouped Worksheets
• General and Language Options
• Excel Options Dialog Box
• Formula, Proofing, Save Options
• Version Control
• Customising Ribbon and Quick Access Toolbar
The above topics may include additional information and further insight depending
on the audience
John Wayne
7 Hrs + 3 Hrs Self Study
Beginner
English