Excel is Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.
This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.
Getting Started
In this lesson, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.
Working with Data
This lesson covers using formulas and functions in a worksheet, working with data, rows and columns and, how to sort and filter data.
Modifying a Worksheet
Next, students will learn how to format text and cells and, how to align cell contents. Using Find & Select tools and, how to spell check a worksheet are also discussed.
Printing Workbook Contents
In this lesson, students will learn how to define the basic page layout for a workbook, refine the page layout and, apply print options.
Managing Large Workbooks
This lesson will teach students how to format worksheet tabs, manage worksheets and, manage the view of worksheets and workbooks.
Customizing the Excel Environment
In this final lesson, students will learn how to customize general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customize the ribbon and the Quick Access toolbar, enable add-ins and, customize advanced and Trust Center options.
Anyone who has an interest in learning how to use excel to help you organize, calculate, analyze, revise, update, and present your data in ways that will help steer your organization in the right direction.
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is so essential for creating and working with electronic spreadsheets, so you can make these spreadsheet tasks much easier to accomplish, and in much less time, than methods you may be using now. This course starts you on the path from foundational Excel knowledge and skills to expertise in data manipulation with Excel.
This course is delivered by a live instructor using the Zoom application. We believe that attendees learn by performing the tasks that the instructor demonstrates on their screen. They can also communicate with fellow attendees and the Instructor via live audio and video.
With Hands-on Train (HOT) delivery, we suggest that attendees work with two application windows on their local computer. The first window is their own work area and the second window displays the instructor’s work area via the Zoom video conferencing application.
To get the best from this online training, the following computer setup is required:
- It is recommended that an attendee have two monitor screens attached to their computer. With two monitors, the work areas of the attendee and the instructor can be displayed on separate screens in a normal manner.
- A high-speed Internet connection is required.
- The attendee’s computer must have the software that the attendee wants to learn. For example, if you have signed up for an Excel course, Excel must be installed on your PC.
- An attendee will need to install the Zoom Video Conferencing app to join the training session. It can be downloaded for free from www.zoom.us. Please familiarize yourself with the application.
- A PDF reader is required to view the course materials that will be sent to you as a PDF file. PDF readers are available for free on the net.
- Our courses are interactive. An attendee must keep the mic and the video camera on at least 60 percent of the time so that they are audible and visible to other participants and the instructor (just as they would be in a physical classroom).
- Please do not register for a course if you do not agree to keep the mic and the video camera on at least 60 percent of the time. A certificate of course attendance is issued only after 100% attendance is observed and the assessment passed.
