Course description
Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you've been meaning to learn Excel for years but haven't quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you.
The course begins by introducing you to entering numbers and text into Excel, create basic formulas and how relative references and Order of Operations works. You will then learn how to work with larger Excel files and utilize split-screen and freeze panes, as well as how to insert headers and Footers in Excel. The course also teaches you how to add rows and columns and change column widths, how to use copy, cut and paste to save time, and how to print the correct part of your spreadsheet!
Simon Sez IT has been helping students master Excel for more than ten years. With a simple to follow approach and instructors that explain everything thoroughly, you can rest assured you are in safe hands. This course was recorded using Excel 2019 but is suitable for Excel 2013, 2016, and 365 users. Start this course today and you will gain a solid grounding in the basics of Excel 2019, and become more confident with spreadsheets.
Upcoming start dates
Training content
Introduction to Excel 2019
Description: Learn Microsoft Excel 2019 and conquer your spreadsheet demons with this free online Excel video course. You will be confident in your knowledge about Excel terminology, tools, mouse features and creating workbooks after you successfully complete this course.
- Introduction to Excel 2019
- What's New In Excel 2019
- Course Overview
- Overview of the Excel window
- Mouse Features
- Back Stage View
Creating Workbooks
Description: In this module you will learn how to create workbooks. This section's topics are: entering text and numbers, creating basic formulas, relative references, order of operations and working with ranges. At the end of the module you will also undertake a practical exercise.
- Entering Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Module 2 - Practice Exercise
Saving Workbooks
Description: The third module focuses on Saving Workbooks. You will learn about the following topics: Working with Save and Save As Commands and File Extensions (sharing, exporting and publishing). The module concludes with another Practice Exercise which allows you to showcase your new skills.
- Working with the Save and Save As Commands
- File Extensions, Share, Export and Publish Files
- Module 3 - Practice Exercise
Navigating Workbooks
Description: In this module you will learn how to navigate workbooks. The topics outline how to open a file, how to work with larger files, how to use the freeze panes option and how to operate the split screen option. The module concludes with another practical exercise.
- Opening a File
- Working with Larger Files
- Freeze Panes Option
- Split Screen Option
- Module 4 - Practice Exercise
Page Setup & Print Options
Description: In this module you will learn about Page Setup and Print Options, including topics such as inserting Headers and Footers, using the Page Setup Options, how to Fit to Print on One Page, and print entire workbooks. You will also learn how to print titles and use comments.
- Headers and Footers
- Print Titles
- Comments
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Module 5 - Practice Exercise
Working with Rows, Columns and Cells
Description: In this module you will learn about working with Rows, Columns and Cells. This section includes topics on adding and deleting rows, columns and cells, and how to change column and row widths. It concludes with a practical exercise in which you will use all the new skills you have learned.
- Adding and Deleting Rows, Columns and Cells
- Changing Column and Row Widths
- Module 6 - Practice Exercise
Moving Data
Description: In this module you will learn about moving data. The topics will show you how to use Cut, Copy and Paste commands, which will ensure you have the tools to work efficiently. You will also learn how to copy formulas.
- Cut, Copy and Paste
- Copying Formulas
- Module 7 - Practice Exercise
Formulas & Functions
Description: In this module you will learn about formulas and functions in Excel. Topics include creating formulas using functions, and how to use absolute values. The module will conclude with a practical exercise.
- Overview of Formulas
- Create Formulas Using Functions Part 1
- Create Formulas Using Functions Part 2
- Absolute Values
- Module 8 - Practice Exercise
Working with Sheets
Description: In this final module you will learn about working with sheets. The topics covered are Adding, Deleting and Renaming Sheets, how to use the Additional Sheet Tab Options, and using 3 Dimensional Formulas. The module will conclude with another practical exercise.
- Adding, Deleting and Renaming Sheets
- Additional Sheet Tab Options
- 3 Dimensional Formulas
- Module 9 - Practice Exercise
Course assessment
- Assessment: Excel 2019 - Course Assessment
Certification / Credits
By the end of this course, you will be able to:
- Describe how to create basic formulas in Excel
- Explain how Relative References and Order of Operations works in Excel
- Explain how to save your work and use file extensions
- Explain how to insert headers and footers in Excel
- Explain how to print the correct part of your spreadsheet
- Describe how to add rows and columns and how to change column widths
- Describe how to use copy, cut and paste commands to save time
- Explain how formulas in Excel work and how to use essential functions
Quick stats about Alison?
Providing Free Online Learning since 2007
Over 45 Million Learners across 193 Countries have studied with us
Over 5 Million people use the Alison Learning App, where you can study anywhere and anytime
Contact this provider
Alison Free Learning
Alison is the world’s largest free online empowerment platform for education and skills training, offering thousands of CPD-accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone,...