Microsoft Office 2013 skills are important skills to have in any profession or workplace. Developing skills and experience working with Microsoft Word, Excel, PowerPoint, and Outlook will allow you to work independently and solve problems. The Microsoft Office 2013 Master training course prepares you numerous Microsoft Office Specialist (MOS) Certification Exams.
The material is presented in a step-by-step manner, and you will learn by completing readings and hands-on exercises, in addition to watching video presentations. The course also includes quizzes and exams, so your skills will be assessed at regular intervals. Through these methods, you will learn essential introductory and advanced Office skills across Microsoft Office's Word, Excel, PowerPoint, and Outlook courses.
Instructor(s):
Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She 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, and reporting/productivity applications. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft 2013 Office Suite (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.
Hide Syllabus
Lesson 1
- Introduction to Microsoft Excel 2013
- Creating a Microsoft Excel Workbook
- The Ribbon
- The Backstage View (The File Menu)
- The Quick Access Toolbar
- Entering Data in Microsoft Excel Worksheets
- Formatting Microsoft Excel Worksheets
- Using Formulas in Microsoft Excel
- Working with Rows and Columns
- Editing Worksheets
- Finalizing Microsoft Excel Worksheets
- Microsoft Excel (2013) New Features
- Introduction to Microsoft Excel 2013 Exam
- Intermediate Microsoft Excel 2013
- Advanced Formulas
- Working with Lists
- Working with Illustrations
- Visualizing Your Data
- Working with Tables
- Advanced Formatting
- Microsoft Excel (2013) New Features
- Intermediate Microsoft Excel 2013 Exam
- Advanced Microsoft Excel 2013
- Using Pivot Tables
- Auditing Worksheets
- Data Tools
- Working with Others
- Recording and Using Macros
- Random Useful Items
- Microsoft Excel (2013) New Features
- Advanced Microsoft Excel 2013 Exam
- Microsoft Excel 2013 Final Exam
- Introduction to Microsoft Word 2013
- Creating a Microsoft Word Document
- The Ribbon
- The File Tab
- The Quick Access Toolbar
- Formatting Microsoft Word Documents
- Editing Documents
- Finalizing Microsoft Word Documents
- Introduction to Microsoft Word 2013 Exam
- Intermediate Microsoft Word 2013
- Advanced Formatting
- Working with Tables
- Working with Images
- Page Layout
- Working with Illustrations
- Viewing Your Document(s)
- Intermediate Microsoft Word 2013 Exam
- Advanced Microsoft Word 2013
- Working with Long Documents
- Reviewing and Collaborating on Documents
- Comparing and Combining Documents
- Managing Mailings
- Protecting Documents
- Random Useful Items
- Advanced Microsoft Word 2013 Exam
- Microsoft Word 2013 Final Exam
- Introduction to Microsoft PowerPoint 2013
- Creating a PowerPoint Presentation
- The Ribbon
- The Quick Access Toolbar
- The File Tab
- Formatting Microsoft PowerPoint Presentations
- Working with Images
- Working with Tables and Charts
- Finalizing Microsoft PowerPoint Presentations
- Introduction to PowerPoint 2013 Exam
- Advanced Microsoft PowerPoint 2013
- Customizing Presentations
- Presentation Masters
- Working with Special Effects
- Using SmartArt
- Multimedia
- Setting up the Slide Show
- Outlines and Slides
- Sharing and Securing a Presentation
- Advanced PowerPoint 2013 Exam
- PowerPoint 2013 (MOS) Final Exam
- Introduction to Microsoft Outlook 2013
- The Outlook Interface
- Performing Popular Tasks in Outlook
- Working with Messages
- Working with the Calendar
- Organizing Contacts
- Introduction to Microsoft Outlook 2013 Exam
- Advanced Microsoft Outlook 2013
- Working with Tasks and Notes
- Using Signature and Themes
- Managing Your Inbox
- Working with Multiple Email Accounts
- Advanced Microsoft Outlook 2013 Exam
- Microsoft Outlook 2013 Final Exam
Hide Syllabus
|