|
New Era Technology Training ~ Excel, Adobe, Sharepoint training in Calgary Cancellation Policy
Description: This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.
Course Outline
Creating a Basic Worksheet
• Explore the User Interface and the Ribbon
• Navigate and Select in Excel
• Obtain Help
• Enter Data and Save a Workbook
• Customize the Quick Access Toolbar
Performing Calculations
• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
Modifying a Worksheet
• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet
Formatting a Worksheet
• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Apply Number Formats
• Position Cell Contents
• Apply Cell Styles
Printing Workbook Contents
• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks
Managing Large Workbooks
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets
Pre-Requisites: Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:30pm
Facility Location: New Era Technology Centre
#300, 633 - 6th Ave S.W., Ford Tower
Calgary
Alberta
Canada
T2P 2Y5
| 
