Edward McCrae

INSTRUCTOR

4.9 (105 ratings)

"

I try my best to make my classes an experience. I want students to not only learn new things to improve their job performance, but to also leave the class feeling good. I want them to enjoy learning. I love knowing that I just taught someone something that is going to make their everyday work life easier.

"

Ed is a training and learning management professional with over 20 years of experience. He joined the New Horizons training team in 2006. He teaches both applications and soft skills, specializing in Microsoft Office, SharePoint, and Project Management programs. Ed takes a real-world, problem-solving approach to his training. He has a true passion for helping individuals and organizations learn technology solutions that enable them to be more efficient and productive in their daily work. Some of the organizations that have benefited from Ed’s talents over the years includes; The American Red Cross, Children’s Hospitals of Philadelphia, Horizon Blue Cross Blue Shield, Prudential and JP Morgan Chase.

CREDENTIALS

Microsoft Office Master Certification Microsoft Office Specialist: Word, Excel, PowerPoint, Access Microsoft SharePoint Microsoft Office 365, Skype for Business, OneDrive, and Teams Project Management CompTIA A+, Network+, and Project+

courses with Edward McCrae

Beginner 02 Hrs 34 Min Edward McCrae

This course covers the basic functions and features of Project 365. Students will learn how to create, and enter task information into Project plans. They will learn how to manage project resources and assign them to tasks. They will also create custom project elements such as calendars, tables and views that can be used to monitor and manage important project information.

Last Release: 09/27/19
Advanced 03 Hrs 56 Min Edward McCrae

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Last Release: 05/28/19
Advanced 01 Hrs 24 Min Edward McCrae

Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.

Last Release: 03/04/19
Advanced 01 Hrs 43 Min Edward McCrae

Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.

Last Release: 03/04/19
Advanced 04 Hrs 20 Min Edward McCrae

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Last Release: 01/28/19
Beginner 02 Hrs 03 Min Edward McCrae

This course is designed to help students become comfortable with the tools of Microsoft Publisher, a desktop publishing application, and allow them to create professional-looking flyers, posters, catalogs, newsletters, and more. The course will focus on structuring documents, modifying text, working with shapes and images, and formatting and finalizing documents.

Last Release: 08/21/18
Beginner 58 Min Edward McCrae

This course teaches the basic functions and features of Visio Online 2016. The primary focus is to get acquainted with creating the different diagrams using the stencils and templates. You will learn how to draw basic shapes and arrange objects. You will also learn how to create diagrams, work with text, and apply formatting. Finally, you will create Flow charts, connect shapes, and work with themes and pages.

Last Release: 05/01/18
Intermediate 02 Hrs 03 Min Edward McCrae

This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2016 Advanced course.

Last Release: 05/01/18
Beginner 02 Hrs 57 Min Edward McCrae

This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.

Last Release: 05/01/18
Advanced 01 Hrs 40 Min Edward McCrae

Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.

Last Release: 05/01/18