Microsoft Excel Level 1 (Basic)
(2013, 2016, 2019, 2021, 365)
What You'll Learn in Microsoft Excel Level 1 (Basic)
Course Length
Learning Objectives
- Enter, edit, and format data to create workbooks
- Enter data using time-saving tools like Flash Fill and Autocomplete
- Use functions and formulas to calculate data
- Understand Relative and Absolute Cell References
- Format worksheets and cells
- Manage larger workbooks
- Print workbooks
- Customize the interface by changing ribbon display options and customizing the Quick Access Toolbar
Target Student
This course is for those who are new to Microsoft Excel and want to gain confidence navigating the interface, using functions and formulas, and formatting their work in order to present it clearly.
Course Outline
Excel is a powerful program, beautifully designed so that you can simplify your use and analysis of large amounts of data.
In this course, you will create, edit, display and print Excel workbooks using new features and custom interface tools.
Section 1: Creating, Opening and Saving Workbooks
What Is Excel?
Create a New Blank Workbook
Open Excel Files
Save Workbooks
Navigate a Workbook
Selection Types
Data Checkers
Help
Section 2: Exploring the User Interface
Backstage View
Ribbon Overview
Quick Access Toolbar
Status Bar
Shortcut Key Tips
Contextual Tabs
Section 3: Working with Data
Basic Data Types
Enter, Edit and Delete Data
Use Autocomplete and Autofill
Resize Columns and Rows
Insert and Delete Columns, Rows, Cells
Hide and Unhide Columns and Rows
Use Undo, Redo and Repeat
Spellcheck and AutoCorrect
Use Find, Replace and Go To
Cut, Copy, Paste and Paste Special
Use the Fill Handle
Section 4: Performing Calculations
Use Basic Formulas
Use Basic Functions
Understand Absolute and Relative Cell References
Section 5: Using Time Saving Tools
Flash Fill
AutoCalculate
Section 6: Formatting A Workbook
Work with Fonts and Font Attributes
Apply Borders and Shading
Use the Format Painter
Change Text Alignment
Wrap Text
Apply Manual Line Breaks
Rotate Text
Merge and Centre Text
Create and Modify Styles
Apply Number Formats
Clear Formatting
Section 7: Managing Large Workbooks
Rename Worksheets
Colour-code Worksheet Tab Colours
Copy, Move, Delete, and Group Worksheets
Work with Freeze Panes
Section 8: Printing and Viewing A Workbook
Work with Page Breaks
Work with Print Preview and Page Layout View
Change Margins and Page Orientation
Scale to Fit Worksheets
Insert Headers and Footers
Print Titles Across All Pages
Review Print Options
Delivered by Great Canadian Training
Microsoft Excel Level 1 (Basic)
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| December 5-6, 2024 1:00 PM to 4:00 PM ET | $295.00 Online | |
| January 7, 2025 9:00 AM to 4:00 PM ET | $295.00 Online | |
| February 3, 2025 9:00 AM to 4:00 PM ET | $295.00 Online | |
| March 4, 2025 9:00 AM to 4:00 PM ET | $295.00 Online |
Groups of 6 or more? Consider private training
I want a quote for private or customized training
Have questions about this course? See below or reach out to our training coordinators.
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Learn or Come Back Free Policy on Public Classes
- 24/7 After Training Support
All of our courses include
PDF Reference Guide
Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.
24/7 After-Training Support
Receive a 30-day after-training support voucher, offering assistance as you apply your new skills on the job. Need help with a specific step? We’re here to provide extra support and clarity even after you’ve left the class!
Want even more?
Check out our add-ons
Printed Reference Guide
While we love technology, we understand that there is something about having a paper copy. Add a printed reference guide to your training, which we will have shipped to your location.
Extended After-Training Support
Extend your support beyond the standard 30 days for ongoing assistance.
Upskilling
You’ve learned how to effectively and efficiently use Microsoft Excel Level 1 (Basic) - now you can stay up to date! Book your Upskilling Workshop now and save for when you want to fill in the gaps and explore Microsoft’s latest tools and features.
Can I customize my course?
OF COURSE!
Customized to meet your unique needs
We can customize your training to fit your exact needs, whether it's making small adjustments or creating entirely new courses. From setting specific objectives and including your own files to addressing unique challenges, we're here to help. We can even tailor the training to align more closely with how you work and to fit perfectly into your schedule. Our goal is to provide training that's as unique as your goals.
Use your own files instead of our exercise files
You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!
Access to your recorded session for 60 days
You can request your private session be recorded. You can have access for 60 days to revisit what you’ve learned.