Excel Training Webinar 1: Learning the basics

Webinar 1: Learning the basics

Course Date:

To be determined.

Summary of Course:

This course is for those who have not used Excel at all or have seldom used it. We will walk you through the basics and describe what Excel 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 feel confident when you start working in Excel and will have a basic knowledge of the platform.

Learning Objectives:

Students who attend this course will leave with a beginners level understanding of Excel, including how to utilize basic functions, features and useful formulas within the tool.

General 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.

Group Internet Based instruction with live instructor

8 hours of CPE Credit

Program Level: Basic

Prerequisite Requirements & Preparedness:

None, there is no advance preparedness to attend this course

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:

• Start Excel
• Excel Versions and how to save for specific format
• Why you should use different saved versions of Excel
• How to save and auto recover
• How to open multiple windows in older Excel versions
• Excel mobile app
• Create a new workbook
• How to pin a workbook
• Title bar
• Ribbon bar
• How to use Quick Access Toolbar
• Modify workbook
• Enter Data
• Modify sheets within workbook
• How to zoom in and out
• Move or copy sheets
• How to merge cells
• How to use flash fill
• Move data within a workbook
• Ways to cut/copy and paste within Excel and out of Excel
• Find and replace data
• How to correct data and drag formulas
• How to group data
• How to drag and drop
• How to use formulas
• How to change font and size
• How to use styles
• Adding themes
• How to add images or graphics
• How to make charts
• Customize charts
• How to make shapes
• Finding trends
• How to make dual axis charts
• How to print charts and workbooks
• How to create sparklines
• How to use smart art
• How to add header and footer
• How to get workbook ready for printing
• Printing in sheets
• Printing workbooks
• Printing charts

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.