Excel Basic
Description
Excel 2016 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2016: 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 2016. Objective coverage is marked throughout the course. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel 2016, 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.Course 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
-
Feb 21, 2019
-
Feb 28, 2019
-
Mar 04, 2019
-
Mar 06, 2019
-
Apr 09, 2019
-
Apr 12, 2019
-
May 06, 2019
-
May 10, 2019
-
Jun 04, 2019
-
Jun 10, 2019
-
Jul 16, 2019
-
Jul 18, 2019
-
Aug 06, 2019
-
Aug 08, 2019
-
Sep 12, 2019
-
Sep 16, 2019
-
Oct 02, 2019
-
Oct 07, 2019
-
Nov 05, 2019
-
Nov 06, 2019
-
Dec 02, 2019
-
Dec 04, 2019
Need to request 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 submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.