This event has passed.

Excel Level 1*

March 20, 2023 @ 6:30 pm - 9:00 pm

|Recurring Event (See all)

$249.00

Getting Started with Excel

Components of the Excel window
Learn about the Ribbon, Quick Access Toolbar, Backstage view, Office terminology, and all the components that make up an Excel screen
Features of Excel’s Ribbon
Quick Access toolbar
Mini toolbar
Status bar
Using the Help menu

Excel Best Practices

Organize folders / files.
Plan worksheet on paper
List of “Always / Never”
How to select contiguous / non-contiguous ranges
Contextual menus

Modifying Worksheet Contents

Understanding Excel cursors
Edit options.
Undo / Redo
Save As versus Save

Different file types that work with Excel

Move / Copy / Paste
Fill cells with series of data.
Insert / Delete entire rows & columns.

Formatting a Worksheet

Format cells

Number (General, Currency, Date, Percentage, Text)

Alignment
Merge cells
Font
Borders
Fill

Format Painter
Change column widths / row heights.

Performing Basic Calculations

Excel formulas
Order of Operations – BEDMAS
AutoSum
Functions – Basic Math

=SUM()
=AVERAGE()
=COUNT()
=MIN(), MAX()

Relative / Absolute/Mixed Cell Addresses

Sort

How to sort effectively

Print Workbook Contents

Add print commands to the Quick Access toolbar.
Set print range.
Page orientation (Portrait / Landscape)
Fit to page(s)

Details

Date:: March 20, 2023
Time:: 6:30 pm - 9:00 pm
Cost:: $249.00
Event Categories:: Computer, Seminars

Organizer

: Horizon Quest
Phone:: 519-787-7641
Email:: Reception@horizonquest.ca; View Organizer Website

Venue

Horizon Quest Fergus; 265 Bridge St.
Fergus, ON N1M 1T7 Canada + Google Map
Phone:: 519-787-7641; View Venue Website

Price Based Country test mode enabled for testing Canada. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari