This course introduces the students to basic spreadsheet features and acquaints them with Excel`s tools by using real-life scenarios and projects. Some topics that will be covered include creating, editing, saving, and printing spreadsheets; using menus and dialog boxes; adjusting cells; autofills and autoformats; and modifying worksheet colors.
Training Avaliability and Delivery
This is primarily online training
This is an online eLearning or CBT training program
This course may be available for home-study
Courseware may be available for purchase
Self Directed
Contact Online Training Directory for more information
PIN code provided for this course allows unlimited on-line access for 90 days. This course introduces the students to basic spreadsheet features and acquaints them with Excel`s tools by using real-life scenarios and projects. Some topics that will be covered include creating, editing, saving, and printing spreadsheets; working with Excel menus and dialog boxes; adjusting column widths and moving cells; formatting numbers, text, and cells; automatically filling a series of numbers; understanding formulas and functions; formula construction, including relative and absolute cell references; using AutoSum and AutoCalculate; modifying the appearance of worksheets with colors, borders, and shading; previewing and printing worksheets; adjusting page setup options; and creating and modifying charts made from worksheets.
Outcomes:
Upon completion of this course, students will be able to: --Use formulas and functions --Relocate and reuse data --Explore formula construction --Format worksheet appearance --Print worksheets
Assessment:
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
Contact Hours: 24
About Online Training Directory - Training Provider
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
More Excel Training from Online Training Directory
