Learn to use Excel 2016 to create, modify, and format Excel worksheets, perform calculations and print Excel workbooks.
You then learn to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques.
You will also learn the more advanced features of Excel and learn to work with pivot tables, audit worksheets, work with data tools, protect documents for collaboration with others, and work with macros.
In this program, you will learn to use all of the features in Microsoft Excel 2016 and be prepared to take the Microsoft Office Certification exams 77-727 and 77-728 (Excel). There is a core exam and an expert exam for Excel. Being a MOS Certified Excel user proves to employers you are ready to work in Excel.
According to Microsoft Learning’s site, individuals with a MOS certification in a specific program can earn higher salaries than their non-certified peers.
The registration fee for these exams are included with this program.
This program is entirely online and is completed at your own pace. When you register, you receive six (6) months to complete this program.
|Course type||Online - Self Paced|
This online program can only be taken on a PC; it is not Mac compatible. It is compatible with Windows XP and later operating systems and you will need the latest version of Internet Explorer, Firefox, Chrome, or Safari.
We highly recommend that you use Firefox or Chrome in place of other web browsers.
Adobe Acrobat Reader or an alternative software application to open and read PDF files is required. You will also need the Microsoft Office 2016 Suite for this program as there are no free trials.
Manuals are included as downloadable PDFs throughout the program.
Students should be familiar with using a personal computer, mouse, and keyboard. They should be comfortable in a Windows environment, and have the ability to launch and close activities and navigate to information stored on the computer. They should also have an ability to manage files and folders.
Tracy Berry has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, reporting/productivity applications, Microsoft Office, as well as the creation of online courses with software from leading vendors.
Tracy has been a senior graphic designer/programmer, instructor, and consultant since 1993. She has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide, including involvement in large corporate software rollouts. Tracy is also an expert in all Microsoft Office programs.
Note: This course is supported by multiple instructors at Webucator, a national training and courseware development company, all of whom are experts in their fields.