Loading...

Course Description

This course will cover the concepts, terminology and techniques required to become proficient in building spreadsheets using Microsoft Excel. This powerful spreadsheet application has been widely used since 1985 for data organization, analysis, and stunning visualizations. Features explored in-depth include formulas, functions, named ranges, external data, hyperlinks, Pivot Tables and much more. Learning Excel is crucial for enhancing productivity, improving data analysis skills, and boosting job prospects across various industries.

Bring:  USB Drives (4 gig capacity)

Instructor: Maurice E. Kennedy, Jr. MOS has a 40+ year career in information technology, and holds several industry level IT certifications. His expertise is in business software development and computer science instruction. As a senior programmer analyst, his goal has been to always produce comprehensive, intuitive application solutions that are powerful, flexible, and efficient that exceed client expectations. As an instructor, he endeavors to empower his students to not only master the theory and technical skills behind the utilization of a computer application, but to develop the confidence and ability to successfully compete for job opportunities on the open market.

Course Outline

•              Creating, naming, saving and opening Excel workbook files

•              Enter data into cells with formatting

•              Mastering the Ribbon and the Excel worksheet window

•              Performing calculations using formulas and functions

•              Establishing, modifying and deleting named ranges

•              Using merge & center, cell reference and auto-fill

•              Importing data from external sources

•              Creating tables and filters for sorting

•              Setting-up complete data ranges for Pivot Tables and Charts

•              Working with hyperlinks and graphics

•              Inserting text boxes and cell comments

•              Preparing reports with page layout and page setup

•              Inserting worksheets from outside spreadsheets

Loading...

Enroll Now - Select a section to enroll in

Section Title
Creating Professional Spreadsheets - Microsoft Excel
Type
Discussion
Days
W
Time
5:00PM to 7:00PM
Dates
Feb 04, 2026 to Apr 08, 2026
Schedule and Location
View Details
Contact Hours
20.0
Location
Delivery Options
Classroom  
Course Fee(s)
Course Fee $60.00
Instructors
  • Maurice E. Kennedy, Jr.

Section Notes

This course will cover the concepts, terminology and techniques required to become proficient in building spreadsheets using Microsoft Excel. This powerful spreadsheet application has been widely used since 1985 for data organization, analysis, and stunning visualizations. Features explore in-depth include formulas, functions, named ranges, external data, hyperlinks, Pivot Tables and much more. Learning Excel is crucial for enhancing productivity, improving data analysis skills, and boosting job prospects across various industries.

Bring:  USB Drives (at least 4 gig capacity)

Instructor: Maurice E. Kennedy, Jr. MOS has a 40+ year career in information technology and holds several industry level IT certifications. His expertise is in business software development and computer science instruction. As a senior programmer analyst, his goal has been to always produce comprehensive, intuitive application solutions that are powerful, flexible, and efficient that exceed client expectations. As an instructor, he endeavors to empower his students to not only master the theory and technical skills behind the utilization of a computer application, but to develop the confidence and ability to successfully compete for job opportunities on the open market.