The Business Guide to Microsoft Office

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

The Business Guide to Microsoft Office

If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with detailed instructions
  • Sample documents and images
  • Practice, Quizzes and Skill Tests

All materials for this program are available online. The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Word 2013
  • Intermediate Guide to Microsoft® Word 2013
  • Advanced Guide to Microsoft® Word 2013
  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft® Excel 2013
  • Advanced Guide to Microsoft® Excel 2013
  • Beginning Guide to Microsoft® PowerPoint 2013
  • Advanced Guide to Microsoft® PowerPoint 2013

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

In Microsoft Word, you will cover important topics, including how to:

  • Format Text and Paragraphs
  • Get skilled at working with Text and Pictures
  • Learn how to create and format SmartArt
  • Understand how to use and edit Templates to create documents and resumes
  • Create a Mail Merge that sends a personalized invitation to each recipient
  • Learn how to select the Mail Merge recipients and troubleshoot errors
  • Create a Web Page that uses a Table for consistent layout

In Microsoft Excel, you will cover business topics, including how to:

  • Create formulas that use Relative and Absolute values and audit the formulas
  • Use and modify TEXT, DATES and FINANCIAL data with formulas
  • 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

In Microsoft PowerPoint, you will learn how to:

  • Know how to work with Text Boxes, Format Shapes and apply Themes
  • Insert, format and adjust Pictures with the Picture Tools
  • Insert and format Shapes and SmartArt to create an effective presentation
  • Use Tables and Spreadsheets to display data in a presentation
  • Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  • Learn how to design Slide Masters and apply slide Transitions
  • Apply Animations to images in a slide show and edit the timing


Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need.

This course teaches the objectives for the following certification tests:
Core Certification: Pass any 1 test:
Word 2013 Core: Exam 77-418
Excel® 2013 Core: Exam 77-420
PowerPoint® 2013: Exam 77-422

Who this course is for:

  • This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately.
  • This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.

Expected Outcomes

  1. Learn how to navigate online and submit assignments Format Text and Paragraphs in Microsoft Word Work with Text and Pictures in Microsoft Word Learn how to create and format SmartArt Use Quick parts to create professional documents Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  2. Format Text and Paragraphs in Microsoft Word Work with Text and Pictures in Microsoft Word Learn how to create and format SmartArt Use Quick parts to create professional documents Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  3. Work with Text and Pictures in Microsoft Word Learn how to create and format SmartArt Use Quick parts to create professional documents Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  4. Learn how to create and format SmartArt Use Quick parts to create professional documents Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  5. Use Quick parts to create professional documents Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  6. Create a professional newsletter that includes graphics and charts Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d61c28c1ce7f',m:'80bec4259961863b2be66ed0491a4e93231ccacf-1627849953-1800-AVCKZt/LfLDfDsT3Shw2PUooY8+nrbHV4bQxGDUmy9+iecp809HMneyj72JzDkV140FcmBiHgatTM4HbZ4Uj+jCCqQK21DQqU7BQ4dgQ9CKwtUcfGYX7vP9vRvvL9J2NvAbhCJ681AHv3kA7LvD0kdxlYDuIOsEswwzZNr5OPTpP',s:[0x46d6ff5073,0x42bc98c5df],}})();
  7. Create a Mail Merge that sends a personalized invitation to each recipient Create a Web Page that uses a Table for consistent layout Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel 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 Learn PowerPoint basics: Entering text in presentations Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Add videos to a PowerPoint presentation and trim the media Add videos to a PowerPoint presentation and trim the media Show more Show less Requirements 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. Description The Business Guide to Microsoft Office If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with detailed instructions Sample documents and images Practice, Quizzes and Skill Tests All materials for this program are available online. The following textbooks are available to download throughout the lessons: Beginning Guide to Microsoft® Word 2013 Intermediate Guide to Microsoft® Word 2013 Advanced Guide to Microsoft® Word 2013 Beginning Guide to Microsoft® Excel 2013 Intermediate Guide to Microsoft® Excel 2013 Advanced Guide to Microsoft® Excel 2013 Beginning Guide to Microsoft® PowerPoint 2013 Advanced Guide to Microsoft® PowerPoint 2013 With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. In Microsoft Word, you will cover important topics, including how to: Format Text and Paragraphs Get skilled at working with Text and Pictures Learn how to create and format SmartArt Understand how to use and edit Templates to create documents and resumes Create a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errors Create a Web Page that uses a Table for consistent layout In Microsoft Excel, you will cover business topics, including how to: Create formulas that use Relative and Absolute values and audit the formulas Use and modify TEXT, DATES and FINANCIAL data with formulas 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 In Microsoft PowerPoint, you will learn how to: Know how to work with Text Boxes, Format Shapes and apply Themes Insert, format and adjust Pictures with the Picture Tools Insert and format Shapes and SmartArt to create an effective presentation Use Tables and Spreadsheets to display data in a presentation Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks Learn how to design Slide Masters and apply slide Transitions Apply Animations to images in a slide show and edit the timing Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418 Excel® 2013 Core: Exam 77-420 PowerPoint® 2013: Exam 77-422 Who this course is for: This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities. Show more Show less Course content 10 sections • 44 lectures • 7h 6m total length Expand all sections Getting Started 2 lectures • 10min Introduction Preview 02:44 Getting Started with Microsoft Word: Go Blue! Preview 06:48 Hello, Microsoft Word! 4 lectures • 38min Fancy Colors (Optional lesson Picture Tools) 08:45 First Impressions 09:42 First Prize 09:21 Rain Washes Out Hamburg Preview 09:55 Microsoft Word: Creating Business Documents 4 lectures • 50min Table for Two 11:53 The Table is Set 11:31 Open for Business 11:55 Charlotte's Website 14:54 Microsoft Word: Advanced Business Topics 5 lectures • 50min Mail Merge: The Guests Are Invited, Part 1 Preview 11:40 Mail Merge: The Guest Are Invited, Part 2 05:15 Mail Merge: Add Me to the List 10:41 Online, All the Time 09:14 Prepare to Share 13:35 Microsoft Excel: Hello, Excel! 5 lectures • 41min Hello, Excel Preview 05:58 It All Adds Up 08:49 A Question of Balance 10:27 Charts and Chart Tools 08:56 Picture the Data (Optional) 07:12 Microsoft Excel: Business Spreadsheets 5 lectures • 45min Legs, Eggs and Pigs Preview 14:08 Piggy Goes to Market: Text Formulas 06:28 Piggy Goes to Market: DATE Formulas 07:51 Piggy Goes to MArket: FINANCIAL Formulas Preview 07:28 Excel: In Print 08:51 Microsoft Excel: Advanced Business Spreadsheets 5 lectures • 50min Tables and Lists: It Works for Me 09:48 Excel Totals and Subtotals 06:55 Using Named Ranges 10:47 Sound Advice: Using Look Up Tables Preview 12:36 Prepare to Share 10:13 Microsoft PowerPoint: Hello, PowerPoint! 5 lectures • 53min Hello, PowerPoint Preview 11:04 P is for Paragraph 12:57 Text Boxes and Themes 09:45 Every Picture Tells a Story Preview 10:54 Shapes and SmartArt 08:40 Microsoft PowerPoint: Business Presentations 4 lectures • 47min Presenting Data: Tables and Spreadsheets 10:54 Counting Chickens: Charts and Chart Tools 12:21 Reach for the Stars: Create a Slide Master 14:21 Top 10 Reasons to Hire Me! 09:17 Microsoft PowerPoint: Advanced Business Presentations 5 lectures • 42min Videos and Multimedia: The Pierre Marquette Preview 09:10 Show Time: Delivering Presentations 10:24 Prepare to Share 12:02 PowerPoint: Online and in Print 10:05 BONUS LECTURE 00:25 Instructor Elizabeth Nofs The Computer Mama 4.5 Instructor Rating 3,836 Reviews 51,040 Students 10 Courses Expert in Instructional Technology and Online Learning Incredible ability to teach technology Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. I enjoy teaching Microsoft Office and look forward to working with you. eBeth Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var inp