This course covers Excel Worksheet features at a basic level and will
benefit those who are beginning to use Excel. Participants will learn
how to design worksheets, enter data and formulas to build worksheets,
format cells and print worksheets. The content of this presentation
applies to Excel 2007 or 2010.
Learning Objectives
Learn proven techniques for designing, editing and printing worksheets
Use time-saving data entry techniques
Create a variety of formulas
Create relative and absolute formula references
Move and copy data by
using shortcut menus, mouse pointer shapes and many tips
Restructure
worksheets to accommodate new data, columns and rows
Use the
time-saving ribbon tools and the quick access toolbar
Change the
appearance of worksheet data by using business formatting techniques
Major Topics
Use data entry and formula building techniques
Compare relative and
absolute formula references
Learn how to save time with Excel keyboard
shortcuts and new Ribbon features
Understand formatting techniques to
enhance the presentation of worksheet data
Understand time-saving
printing features for single or multiple page worksheets
Complete the
course having learned many Excel tips
Take away templates and tutorial
references for after class use
