Excel Training Webinar 2: Learning how to become more efficient in Excel

Excel Training Webinar 2: Learning how to become more efficient in Excel

Course Date:

To be determined.

Summary of course:

This course is for those who want to increase their Excel knowledge and become more efficient with their time. We will walk you through some commonly used formulas and describe what they can do by demonstrations and learning exercises. We intend to teach as well as have hands on learning for you to work through. Coming out of this course you should be able to use vlookups, hlookups and other common formulas in Excel that will make you much more efficient with tasks.

Learning Objectives:

Students who attend this course will leave with an intermediate level understanding of Excel, including basic knowledge on how to create a data model, utilize more advance Excel functions and have a better understanding of more advanced formulas within the tool.

Requirements:

If you plan to do the hands-on learning by working through examples after demonstrations, you must have a version of Excel installed on your computer. If you don’t have Excel installed on your computer you can watch along for the live demonstrations and explanations. It would be useful to have taken the Level 1 webinar or to have comparable knowledge in Excel to grasp these more advanced concepts.

Group Internet Based instruction with live instructor

8 hours of CPE Credit

Program Level: Intermediate

Prerequiste Requirements & Preparedness:

Completion of Excel Training Webinar 1: Learning The Basics, or a cursory understanding of the basic operations of Excel.

Recommended Fields Of Study:

Computer software and applications

To receive CPE credit completion of course and periodic questions along the way must be answered

Outline of topics discussed:

• Why to use templates
• Functions vs Formula
• Formula overview
• Formula wizard
• Extensive practice on functions
• How to use functions related to Date and Time
• How to use functions related to Statistics
• How to use text functions
• How to use Logical, Math and Trig functions
• How to use lookup functions
• Sorting Data
• Filters and how they impact your formulas
• Why tables
• How to use tables
• How to use table slicers
• How to set formula calculation manual or automatic
• What are ranges
• How to use ranges
• Managing Ranges
• How to use flashfill
• How conditional formatting can work for you

System Requirements Expanded:

• Microsoft Excel 2010 or Later
• Microphone
• Windows 10 or Greater

Attending Our Course:

Students may sign up and purchase this course through the MFSC website at https://masterfinancesolutions.com, or through email at MFSCMain@masterfinancesolutions.com. All fees must be paid at time of course enrollment.

Refund Policy & Complaint Resolution:

If you are not completely satisfied with the course, please let us know within 30 days. We will work to alleviate the issue through additional training or questions you need answered. If you feel there is no resolution regarding additional training, please let us know and we will refund your purchase price. If you have additional questions or would like to speak to a member of our staff please contact us at MFSCMain@masterfinancesolutions.com or our offices at 214-897-3065

Cancellation Policy:

Our no-issue cancellation policy is simple; please notify us at MFSCMain@masterfinancesolutions.com before the start of class and we will refund your entire course fee, no questions asked. In the event of a program cancellation, participants will be notified, by email, no later than 24 hours of that program’s cancellation and offered to either reschedule, or, receive a full refund.

Course Update Policy:

The courses are updated and reviewed no later than 2 years from the date of original course design and ongoing thereafter. Any changes needed to courses are made and revised to ensure the course is updated in a timely manner.

NASBA Disclosure:

Master Finance Solutions is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.