Course Information
Course Overview
All you need to know to unleash the power of Excel spreadsheets
This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will 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, managing large worksheets and printing.
With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.
Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.
This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Course Content
- 9 section(s)
- 57 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started
- Section 3 Basic Worksheet Skills
- Section 4 Creating Formulas
- Section 5 Formatting the Worksheet
- Section 6 Working with Large Worksheets
- Section 7 Using Protection and Comment Boxes
- Section 8 Using Page Setup and Printing
- Section 9 Conclusion
What You’ll Learn
- Understand the concepts of worksheet development and formula creation
- Enter, edit and select data
- Enter and edit formulas and functions
- Understand relative v. absolute cell addressing
- Format worksheet structure and cell contents
- Manage large worksheets with zoom, freeze pane, and tiling and splitting windows
- Add protection and comment boxes
- Use print preview and page setup to prepare a workbook for printing
Skills covered in this course
Reviews
-
NNigel Nairn
Really good starter or refresher course for excel. Well structured, paced, and clear.
-
MManu Kapoor
Nice Introductory Course which highlighted several interesting and useful features of Excel 2007. Looking forward to joining the intermediate course.
-
PPatty Drinnin
Easy to follow and understand the presentation of Excel.
-
HHelen Bennett
sometimes moves too quickly, but overall very thorough