: EnglishShort Description
: This course consist of three modules:
In Microsoft Excel Beginning, you’ll cover basic through advanced topics, including:
How to enter data and format cells and apply number formats
Practice how to create formulas and audit the cell references
Learn how to represent data as Charts
Use pictures and graphics
In Microsoft Excel Intermediate you’ll cover basic through advanced topics, including:
Create formulas that use Relative and Absolute values and audit the formulas
Use and modify TEXT formulas to combine cells (Concatenate) and format the data
Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
Understand how to create and use Lookup Tables and use the IF functions
Excel In Print: Use page Layout and Page Set up to modify print settings
Excel Online: Use and modify Sparklines and hyperlinks
In Microsoft Excel Advanced, you’ll learn how to:
Analyze data visually with a PivotChart.
Create a PivotChart and Show the Field List.
Edit the Value Field Settings.
Filter the data in the PivotChart.
Edit the Chart Layouts and Chart Style.
Use SlicersInstructor Description
: Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that Elizabeth wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test resultsCertification
: This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.
This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
All materials for this program are available online.
The following resources are available to download throughout the lessons:
• Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
• Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files.
This program does not require any additional purchases of supplementary materials.