Loading...

Course Description

    Creating Professional Spreadsheets - BASICS

PASCEP0003-023 |  | (5 Weeks) 

In this course students will receive a grounding in understanding the fundamental concepts of Microsoft Excel such as

learning the Excel Interactive Development Environment (IDE), cell formatting, entering formulas, using named ranges,

using functions, creating charts and print setup as they complete two spreadsheets: Payroll Foundations and Trade Discount.

Session 2

Creating Professional Spreadsheets - INTERMEDIATE TO ADVANCED

PASCEP0003-024 |  (5 Weeks) 

In this course, students will complete two spreadsheets: Amortization Schedule and Sales Analysis as they build on their Basic skill set

and learn to utilize complex Excel features such as nested formulas, relative and absolute reference, comments, import files, Pivot Tables, 

Macros and Visual Basic for Applications (VBA).

Instructor: Maurice E. Kennedy, Jr. MOS has been developing software, teaching, and tutoring as a Senior Programmer Analyst for over 35 years. His extensive experience allows him to assist his students in maximizing their potential in working with MS Office tools and other applications, to be better prepared to compete for opportunities in the IT industry. 

 

Loading...
Enroll Now - Select a section to enroll in
Section Title
Creating Professional Spreadsheets: Basic Excel
Type
Discussion
Days
W
Time
5:30AM to 7:00PM
Dates
Sep 11, 2024 to Oct 09, 2024
Schedule and Location
View Details
Contact Hours
67.5
Location
Delivery Options
Classroom  
Course Fee(s)
Course Fee $35.00
Section Notes

In this course students will receive a grounding in understanding the fundamental concepts of Microsoft Excel such as learning the Excel Interactive Development Environment (IDE), cell formatting, entering formulas, using named ranges, using functions, creating charts and print setup as they complete two spreadsheets: Payroll Foundations and Trade Discount.

Instructor: Maurice E. Kennedy Jr. MOS has been developing software, teaching, and tutoring as a Senior Programmer Analyst for more than thirty-five years. He assists his students in maximizing their potential in working with MS Office tools and other applications so that they are better prepared to compete for opportunities in the IT industry.

 

Section Title
Creating Professional Spreadsheets: Excel Intermediate Advance
Type
Discussion
Days
W
Time
5:30PM to 7:00PM
Dates
Oct 16, 2024 to Nov 13, 2024
Schedule and Location
View Details
Contact Hours
7.5
Location
Delivery Options
Classroom  
Course Fee(s)
Course Fee $35.00
Instructors
  • Maurice E. Kennedy, Jr.
Section Notes

Creating Professional Spreadsheets - INTERMEDIATE TO ADVANCED

In this course, students will complete two spreadsheets: Amortization Schedule and Sales Analysis as they build on their Basic skill set

and learn to utilize complex Excel features such as nested formulas, relative and absolute reference, comments, import files, Pivot Tables, 

Macros and Visual Basic for Applications (VBA).

Instructor: Maurice E. Kennedy, Jr. MOS has been developing software, teaching and tutoring as a Senior Programmer Analyst for over 35 years. His

extensive experience allows him to assist his students in maximizing their potential in working with MS Office tools and other applications,

to be better prepared to compete for opportunities in the IT industry.