Audience:
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.
Prerequisites:
The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.
Description:
Excel Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel: how to create, save, share, and print worksheets
that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office
Specialist and Expert exams for Excel. Objective coverage is marked throughout the course.
Students will benefit most from this course if they
want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel Expert. If
they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course is a good place to start their preparation, but they will need
to continue on to other courses in the series to be fully prepared for either exam.
Outline:
Chapter 1: Fundamentals
- Module A: Getting around
- Module B: Workbook basics
Chapter 2: Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
Chapter 3: Formatting
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
Chapter 4: Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
Chapter 5: Charts
- Module A: Creating charts
- Module B: Chart types and elements
Chapter 6: Output
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
Chapter 7: Settings and templates
- Module A: Workbook options and properties
- Module B: Templates
Scheduled Courses
May 17, 2024
vILT (Virtual)
May 17, 2024
vILT (Virtual)
May 24, 2024
vILT (Virtual)
Jun 07, 2024
vILT (Virtual)
Jul 01, 2024
vILT (Virtual)
Jul 19, 2024
vILT (Virtual)
Aug 05, 2024
vILT (Virtual)
Aug 16, 2024
vILT (Virtual)
Sep 06, 2024
vILT (Virtual)
Oct 08, 2024
vILT (Virtual)
Nov 12, 2024
vILT (Virtual)
Want to Take this Course on a Different Day?
LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please constact us. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Baton Rouge (225) 293-0656
Lafayette (337) 233-2016
New Orleans (504) 576-1010