: EnglishShort Description
: This course consist of three parts.
In Microsoft Excel Beginning, you’ll cover:
• Formatting cells and creating formulas and audit the cell references
• Representing data as Charts
In Microsoft Excel Intermediate you’ll cover:
• Creating formulas and modifying TEXT formulas
• Creating Ranges and using them in formulas
• Use the IF functions
• Use and modify Sparklines and hyperlinks
In Microsoft Excel Advanced, you’ll learn how to:
• Use PivotChart.
• Create a PivotCharts
• Edit and filter values
• 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.
All required reference materials are provided with this program. Technical requirements:
• Broadband or High-Speed (DSL, Cable, Wireless)
• Processor - 2GHz Processor or Higher
• Memory - 1 GB RAM Minimum Recommended
• Operating Systems - Windows 7, 8 or 10
• Internet Browsers - Google Chrome is highly recommended
• Cookies MUST be enabled
• Pop-ups MUST be allowed (Pop-up Blocker disabled)
NOTE: 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.