The Complete Guide to Microsoft Excel 2013

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

Course Description

If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBooks with 800 pages of detailed instructions
    • The Beginning Guide to Excel 2013, 220 pages
    • The Intermediate Guide to Excel 2013, 245 pages
    • The Advanced Guide to Excel 2013, 335 pages
  • Sample spreadsheets
  • Practice, Quizzes and Skill Test

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data
  • Use Data Validation to create interactive forms that prompt users for the right data

The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics.

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

Expert Certification: Pass either test: Excel 2013

  • Expert Part 1: Exam 77-427 Excel 2013
  • Expert Part 2: Exam 77-428

Who this course is for:

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

Course content

18 sections • 23 lectures • 3h 2m total length

Expected Outcomes

  1. 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data Requirements To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files. 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 Excel 2013 already installed. Description If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert , this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBooks with 800 pages of detailed instructions The Beginning Guide to Excel 2013, 220 pages The Intermediate Guide to Excel 2013, 245 pages The Advanced Guide to Excel 2013, 335 pages Sample spreadsheets Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428 Who this course is for: This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities. Show more Show less Course content 18 sections • 23 lectures • 3h 2m total length Expand all sections Getting Started 1 lecture • 3min Introduction to this course Preview 02:44 Hello, Microsoft Excel! 1 lecture • 6min Hello, Excel Preview 05:58 Working with Data: It All Adds Up 1 lecture • 9min It All Adds Up Preview 08:49 Working with Data: A Question of Balance 1 lecture • 10min A Question of Balance 10:27 Presenting the Data Visually: Charts and Chart Tools 1 lecture • 9min Charts and Chart Tools 08:56 Presenting the Data Visually: Picture the Data 1 lecture • 7min Picture the Data 07:12 Presenting the Data Visually: Shapes, SmartArt, Views 1 lecture • 7min Shapes, SmartArt and Views 06:56 Business Spreadsheets: Legs, Eggs and Pigs 1 lecture • 14min Introduction to business spreadsheets 14:08 Business Spreadsheets: Piggy Goes to Market 3 lectures • 22min Working with Text Formulas 06:28 Working the DATE and TIME Formulas 07:51 Working with FINANCIAL Formulas Preview 07:28 Formulas and DataL Using Named Ranges 1 lecture • 11min Name that Tune 10:47 8 more sections 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:'6781d2dbfdfb40b3',m:'88691b6ea539c9a80ca23baa1691df027a76bb4c-1627849820-1800-AeMVNhGyzEBL8upqLv1KeZ7adiqDbCdbJ4eHXLpy6uyMn0Ea88mhLHpfcId15rKLASCdRlODWlvQoVcZ2IpWq9TZZKVt23HL84teVPK06yqgytRvacfcrO/703S6r35xGENJdClg3wQHsF4SG937zkzJpdmQvOaqv+bqqe6+bLGbgzqcaArXYaLY53vQOG+B7A==',s:[0xf0592c3381,0x40a2da9521],}})();
  2. Practice how to create formulas and audit the cell references Learn how to represent data as Charts Use PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data Requirements To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files. 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 Excel 2013 already installed. Description If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert , this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBooks with 800 pages of detailed instructions The Beginning Guide to Excel 2013, 220 pages The Intermediate Guide to Excel 2013, 245 pages The Advanced Guide to Excel 2013, 335 pages Sample spreadsheets Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428 Who this course is for: This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities. Show more Show less Course content 18 sections • 23 lectures • 3h 2m total length Expand all sections Getting Started 1 lecture • 3min Introduction to this course Preview 02:44 Hello, Microsoft Excel! 1 lecture • 6min Hello, Excel Preview 05:58 Working with Data: It All Adds Up 1 lecture • 9min It All Adds Up Preview 08:49 Working with Data: A Question of Balance 1 lecture • 10min A Question of Balance 10:27 Presenting the Data Visually: Charts and Chart Tools 1 lecture • 9min Charts and Chart Tools 08:56 Presenting the Data Visually: Picture the Data 1 lecture • 7min Picture the Data 07:12 Presenting the Data Visually: Shapes, SmartArt, Views 1 lecture • 7min Shapes, SmartArt and Views 06:56 Business Spreadsheets: Legs, Eggs and Pigs 1 lecture • 14min Introduction to business spreadsheets 14:08 Business Spreadsheets: Piggy Goes to Market 3 lectures • 22min Working with Text Formulas 06:28 Working the DATE and TIME Formulas 07:51 Working with FINANCIAL Formulas Preview 07:28 Formulas and DataL Using Named Ranges 1 lecture • 11min Name that Tune 10:47 8 more sections 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:'6781d2dbfdfb40b3',m:'88691b6ea539c9a80ca23baa1691df027a76bb4c-1627849820-1800-AeMVNhGyzEBL8upqLv1KeZ7adiqDbCdbJ4eHXLpy6uyMn0Ea88mhLHpfcId15rKLASCdRlODWlvQoVcZ2IpWq9TZZKVt23HL84teVPK06yqgytRvacfcrO/703S6r35xGENJdClg3wQHsF4SG937zkzJpdmQvOaqv+bqqe6+bLGbgzqcaArXYaLY53vQOG+B7A==',s:[0xf0592c3381,0x40a2da9521],}})();
  3. Learn how to represent data as Charts Use PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data Requirements To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files. 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 Excel 2013 already installed. Description If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert , this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBooks with 800 pages of detailed instructions The Beginning Guide to Excel 2013, 220 pages The Intermediate Guide to Excel 2013, 245 pages The Advanced Guide to Excel 2013, 335 pages Sample spreadsheets Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428 Who this course is for: This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities. Show more Show less Course content 18 sections • 23 lectures • 3h 2m total length Expand all sections Getting Started 1 lecture • 3min Introduction to this course Preview 02:44 Hello, Microsoft Excel! 1 lecture • 6min Hello, Excel Preview 05:58 Working with Data: It All Adds Up 1 lecture • 9min It All Adds Up Preview 08:49 Working with Data: A Question of Balance 1 lecture • 10min A Question of Balance 10:27 Presenting the Data Visually: Charts and Chart Tools 1 lecture • 9min Charts and Chart Tools 08:56 Presenting the Data Visually: Picture the Data 1 lecture • 7min Picture the Data 07:12 Presenting the Data Visually: Shapes, SmartArt, Views 1 lecture • 7min Shapes, SmartArt and Views 06:56 Business Spreadsheets: Legs, Eggs and Pigs 1 lecture • 14min Introduction to business spreadsheets 14:08 Business Spreadsheets: Piggy Goes to Market 3 lectures • 22min Working with Text Formulas 06:28 Working the DATE and TIME Formulas 07:51 Working with FINANCIAL Formulas Preview 07:28 Formulas and DataL Using Named Ranges 1 lecture • 11min Name that Tune 10:47 8 more sections 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:'6781d2dbfdfb40b3',m:'88691b6ea539c9a80ca23baa1691df027a76bb4c-1627849820-1800-AeMVNhGyzEBL8upqLv1KeZ7adiqDbCdbJ4eHXLpy6uyMn0Ea88mhLHpfcId15rKLASCdRlODWlvQoVcZ2IpWq9TZZKVt23HL84teVPK06yqgytRvacfcrO/703S6r35xGENJdClg3wQHsF4SG937zkzJpdmQvOaqv+bqqe6+bLGbgzqcaArXYaLY53vQOG+B7A==',s:[0xf0592c3381,0x40a2da9521],}})();
  4. Use PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data Requirements To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files. 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 Excel 2013 already installed. Description If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert , this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBooks with 800 pages of detailed instructions The Beginning Guide to Excel 2013, 220 pages The Intermediate Guide to Excel 2013, 245 pages The Advanced Guide to Excel 2013, 335 pages Sample spreadsheets Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428 Who this course is for: This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities. Show more Show less Course content 18 sections • 23 lectures • 3h 2m total length Expand all sections Getting Started 1 lecture • 3min Introduction to this course Preview 02:44 Hello, Microsoft Excel! 1 lecture • 6min Hello, Excel Preview 05:58 Working with Data: It All Adds Up 1 lecture • 9min It All Adds Up Preview 08:49 Working with Data: A Question of Balance 1 lecture • 10min A Question of Balance 10:27 Presenting the Data Visually: Charts and Chart Tools 1 lecture • 9min Charts and Chart Tools 08:56 Presenting the Data Visually: Picture the Data 1 lecture • 7min Picture the Data 07:12 Presenting the Data Visually: Shapes, SmartArt, Views 1 lecture • 7min Shapes, SmartArt and Views 06:56 Business Spreadsheets: Legs, Eggs and Pigs 1 lecture • 14min Introduction to business spreadsheets 14:08 Business Spreadsheets: Piggy Goes to Market 3 lectures • 22min Working with Text Formulas 06:28 Working the DATE and TIME Formulas 07:51 Working with FINANCIAL Formulas Preview 07:28 Formulas and DataL Using Named Ranges 1 lecture • 11min Name that Tune 10:47 8 more sections 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:'6781d2dbfdfb40b3',m:'88691b6ea539c9a80ca23baa1691df027a76bb4c-1627849820-1800-AeMVNhGyzEBL8upqLv1KeZ7adiqDbCdbJ4eHXLpy6uyMn0Ea88mhLHpfcId15rKLASCdRlODWlvQoVcZ2IpWq9TZZKVt23HL84teVPK06yqgytRvacfcrO/703S6r35xGENJdClg3wQHsF4SG937zkzJpdmQvOaqv+bqqe6+bLGbgzqcaArXYaLY53vQOG+B7A==',s:[0xf0592c3381,0x40a2da9521],}})();
  5. Use Data Validation to create interactive forms that prompt users for the right data Requirements To enroll in the Microsoft Excel 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files. 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 Excel 2013 already installed. Description If you wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert , this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBooks with 800 pages of detailed instructions The Beginning Guide to Excel 2013, 220 pages The Intermediate Guide to Excel 2013, 245 pages The Advanced Guide to Excel 2013, 335 pages Sample spreadsheets Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 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 Excel, 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 PivotTables and Pivot Charts to analyze data Use Data Validation to create interactive forms that prompt users for the right data The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420:Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420 Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428 Who this course is for: This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities. Show more Show less Course content 18 sections • 23 lectures • 3h 2m total length Expand all sections Getting Started 1 lecture • 3min Introduction to this course Preview 02:44 Hello, Microsoft Excel! 1 lecture • 6min Hello, Excel Preview 05:58 Working with Data: It All Adds Up 1 lecture • 9min It All Adds Up Preview 08:49 Working with Data: A Question of Balance 1 lecture • 10min A Question of Balance 10:27 Presenting the Data Visually: Charts and Chart Tools 1 lecture • 9min Charts and Chart Tools 08:56 Presenting the Data Visually: Picture the Data 1 lecture • 7min Picture the Data 07:12 Presenting the Data Visually: Shapes, SmartArt, Views 1 lecture • 7min Shapes, SmartArt and Views 06:56 Business Spreadsheets: Legs, Eggs and Pigs 1 lecture • 14min Introduction to business spreadsheets 14:08 Business Spreadsheets: Piggy Goes to Market 3 lectures • 22min Working with Text Formulas 06:28 Working the DATE and TIME Formulas 07:51 Working with FINANCIAL Formulas Preview 07:28 Formulas and DataL Using Named Ranges 1 lecture • 11min Name that Tune 10:47 8 more sections 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:'6781d2dbfdfb40b3',m:'88691b6ea539c9a80ca23baa1691df027a76bb4c-1627849820-1800-AeMVNhGyzEBL8upqLv1KeZ7adiqDbCdbJ4eHXLpy6uyMn0Ea88mhLHpfcId15rKLASCdRlODWlvQoVcZ2IpWq9TZZKVt23HL84teVPK06yqgytRvacfcrO/703S6r35xGENJdClg3wQHsF4SG937zkzJpdmQvOaqv+bqqe6+bLGbgzqcaArXYaLY53vQOG+B7A==',s:[0xf0592c3381,0x40a2da9521],}})();