Course Outline
Lessons
Course Length: 6 hours (1 day) or 3 hours (2 days)
Excel is a powerful program, beautifully designed so that you can simplify your use and analysis of large amounts of data.
Learning Objectives:
In this course, you will create, edit, display and print Excel workbooks using new features and custom interface tools. You will:
- 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:
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
Cancellation Policy
Compuease Cancellation Policy
CompuEase works hard to schedule our training and other services around your convenience. With that in mind we have the following cancellation policy for all booked training. Notice of cancellation must be received by CompuEase 10 working days prior to the confirmed date for a no financial penalty to be incurred. Registrants who wish to reschedule their course may do so at least 10 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course.
Training Location
Virtual
using RingCentral (Zoom platform) or Teams
.,
.
.
