Learn the basic functions and features of Excel. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, printing, and how to manage large workbooks.
Pre-requisite(s): At least one year experience using Windows 10, 8, or 7
Course OutlineLesson 1 : Getting started
- Spreadsheet terminology
- The Excel environment
- Getting help
- Navigating a worksheet
Lesson 2 : Entering and editing data
- Entering and editing text and values
- Entering and editing formulas
- Working with pictures
- Saving and updating workbooks
Lesson 3 : Modifying a worksheet
- Moving and copying data
- Moving and copying formulas
- Absolute and relative references
- Inserting and deleting ranges, rows, and columns
Lesson 4 : Using functions
- Entering functions
- AutoSum
- Other common functions
Lesson 5 : Formatting
- Text formatting
- Row and column formatting
- Number formatting
- Conditional formatting
- Additional formatting options
Lesson 6 : Printing
- Preparing to print
- Page Setup options
- Printing worksheets
Lesson 7 : Managing large workbooks
- Viewing large worksheets
- Printing large worksheets
- Working with multiple worksheets
Lesson 8 : Appendix - Templates and settings
----note: appendix content is not covered in the one day course
- Changing application settings
- Using built-in templates
- Creating and managing templates
Lesson 9 : Appendix - Graphics and screenshots
----note: appendix content is not covered in the one day course
- Conditional formatting with graphics
- SmartArt graphics
- Screenshots
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.