The Ultimate Microsoft MOS Excel 16 Masterclass

E-Courses4you are here to bring you the Ultimate Microsoft MOS Excel 16 Masterclass!

The Microsoft Office Training and Certification Package provides the foundation of the Microsoft Office Specialist (MOS) qualification which is globally recognised. By you having a MOS certificate on your CV, it shows that you have gained the necessary expertise to competently use Microsoft Office applications at a 'power user' level and it will give you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, efficiency, skills and employability in an office environment.

Level up your skills and gain a thorough understanding of the principles of MS Office 2016!

Sign up now!

• Introduction 21:00

  • 1: Course introduction ? a. Introduction (Part 1) 05:00
  • 2: Course introduction ? a. Introduction (Part 2) 03:00
  • 3: Course introduction ? b. Who this course is for 01:00
  • 4: What's new in Excel 2016 ? a. Introduction 01:00
  • 5: What's new in Excel 2016 ? b. New Features (Part 1) 03:00
  • 6: What's new in Excel 2016 ? b. New Features (Part 2) 03:00
  • 7: Let's talk about Microsoft Office Specialist Excel Exam ? a. Introduction 01:00
  • 8: Let's talk about Microsoft Office Specialist Excel Exam ? b. MOS Certification 01:00
  • 9: Let's talk about Microsoft Office Specialist Excel Exam ? d. Test-taking tips 02:00
  • 10: Let's talk about Microsoft Office Specialist Excel Exam? e. Cert. benefits 01:00

• Chapter 1: Create and manage workbooks and worksheets 1:09:00

  • 11: 1.1 Create workbooks and worksheets ? a. Introduction 01:00
  • 12: 1.1 Create workbooks and worksheets ? b. Creating new blank workbooks 01:00
  • 13: 1.1 Create workbooks and worksheets ? c. Creating new workbooks using templates 01:00
  • 14: 1.1 Create workbooks and worksheets ? d. Opening non-native files 02:00
  • 15: 1.1 Create workbooks and worksheets ? e. Adding worksheets 01:00
  • 16: 1.1 Create workbooks and worksheets ? f. Managing worksheets 03:00
  • 17: 1.1 Create workbooks and worksheets ? g. Grouping and ungrouping worksheets 02:00
  • 18: 1.2 Navigate through worksheets and workbooks ? a. Introduction 01:00
  • 19: 1.2 Navigate through worksheets and workbooks ? b. Find and Replace 03:00
  • 20: 1.2 Navigate through worksheets and workbooks ? c. Inserting hyperlinks 01:00
  • 21: 1.2 Navigate through worksheets and workbooks ? d. Changing worksheet order 01:00
  • 22: 1.2 Navigate through worksheets and workbooks ? e. Using Go To 01:00
  • 23: 1.2 Navigate through worksheets and workbooks ? f. Using Name Box 02:00
  • 24: 1.2 Navigate through worksheets and workbooks ? g. Using Tell Me 03:00
  • 25: 1.3 Format worksheets and workbooks ? a. Introduction 01:00
  • 26: 1.3 Format worksheets and workbooks ? b. Modifying page setup 03:00
  • 27: 1.3 Format worksheets and workbooks ? c. Inserting page elements 03:00
  • 28: 1.3 Format worksheets and workbooks ? d. Changing workbook themes and colors 01:00
  • 29: 1.3 Format worksheets and workbooks ? e. Modifying rows and columns 03:00
  • 30: 1.3 Format worksheets and workbooks? f. Insert, delete and move rows and columns 04:00
  • 31: 1.3 Format worksheets and workbooks ? g. Configuring data validation 02:00
  • 32: 1.4 Customize options and views for worksheets and workbooks ? a. Introduction 01:00
  • 33: 1.4 Customize options and views (...) ? b. Hiding and Showing Worksheets 02:00
  • 34: 1.4 Customize options and views (...) ? c. Hiding columns and rows 01:00
  • 35: 1.4 Customize options and views (...) ? d. Quick Access Toolbar and Ribbon setup 03:00
  • 36: 1.4 Customize options and views (...) ? e. Managing macro security 02:00
  • 37: 1.4 Customize options and views (...) ? f. Recording simple macros 02:00
  • 38: 1.4 Customize options and views (...) ? g. Adding values to workbook properties 01:00
  • 39: 1.4 Customize options and views for worksheets and workbooks ? h. Using zoom 01:00
  • 40: 1.4 Customize options and views (...) ? i. Displaying formulas 01:00
  • 41: 1.4 Customize options and views for worksheets and workbooks ? j. Freezing panes 02:00
  • 42: 1.5 Using MS Excel 2016 on mobile devices ? a. Introduction 01:00
  • 43: 1.5 Using MS Excel 2016 (...)?b. Downloading Office Excel for Mobile (Part 1) 03:00
  • 44: 1.5 Using MS Excel 2016(...)? b. Downloading Office Excel for Mobile (Part 2) 03:00
  • 45: 1.5 Using MS Excel 2016 on mobile devices ? c. The Excel Mobile Interface 04:00
  • 46: 1.5 Using MS Excel 2016 on mobile devices ? e. Saving and Worksheet Properties 02:00

• Chapter 2: Manage Cells and Ranges 54:00

  • 47: 2.1 Insert data in cells and ranges ? a. Introduction 01:00
  • 48: 2.1 Insert data in cells and ranges ? b. Appending data to worksheets 01:00
  • 49: 2.1 Insert data in cells and ranges ? c. Finding and replacing data 03:00
  • 50: 2.1 Insert data in cells and ranges ? d. Copying and pasting data 01:00
  • 51: 2.1 Insert data in cells and ranges ? e. Cutting and pasting data 01:00
  • 52: 2.1 Insert data in cells and ranges ? f. Paste options 01:00
  • 53: 2.1 Insert data in cells and ranges ? g. Using Auto Fill tools 02:00
  • 54: 2.1 Insert data in cells and ranges ? h. Expanding data across columns 01:00
  • 55: 2.1 Insert data in cells and ranges ? i. Using Flash Fill tools 01:00
  • 56: 2.1 Insert data in cells and ranges ? j. Using Insights 02:00
  • 57: 2.2 Format cells and ranges ? a. Introduction 01:00
  • 58: 2.2 Format cells and ranges ? b. Formatting Cells with Text Wrapping 01:00
  • 59: 2.2 Format cells and ranges ? c. Merging Cells 02:00
  • 60: 2.2 Format cells and ranges ? d. Modify Cell Alignment 02:00
  • 61: * 2.2 Format cells and ranges ? e. Changing Font and Font Styles 03:00
  • 62: 2.2 Format cells and ranges ? f. Using Format Painter 01:00
  • 63: 2.2 Format cells and ranges ? g. Applying Number Format 01:00
  • 64: 2.2 Format cells and ranges ? h. Highlighting Cells 02:00
  • 65: 2.2 Format cells and ranges ? i. Applying Cell Styles 02:00
  • 66: 2.2 Format cells and ranges ? j. Using WordArt 02:00
  • 67: 2.3 Order and group cells and ranges ? a. Introduction 01:00
  • 68: 2.3 Order and group cells and ranges ? b. Conditional Formatting 03:00
  • 69: 2.3 Order and group cells and ranges ? c. Conditional Formatting Presets 02:00
  • 70: 2.3 Order and group cells and ranges ? d. Inserting Sparklines 02:00
  • 71: 2.3 Order and group cells and ranges ? e. Modifying Sparklines 02:00
  • 72: 2.3 Order and group cells and ranges ? f. Transposing Rows and Columns 02:00
  • 73: 2.3 Order and group cells and ranges ? g. Creating Named Ranges 01:00
  • 74: 2.3 Order and group cells and ranges ? h. Sorting Data 02:00
  • 75: 2.3 Order and group cells and ranges ? i. Custom Sorting 03:00
  • 76: 2.3 Order and group cells and ranges ? j. Creating Outline 04:00
  • 77: 2.3 Order and group cells and ranges ? k. Creating Groups 01:00

• Chapter 3: Manage Tables 17:00

  • 78: 3.1 Create tables ? a. Introduction 01:00
  • 79: 3.1 Create tables ? b. Creating Tables 03:00
  • 80: 3.1 Create tables ? c. Naming Tables 01:00
  • 81: 3.1 Create tables ? d. Moving Rows within Tables 01:00
  • 82: 3.1 Create tables ? e. Moving Columns within Tables 01:00
  • 83: 3.1 Create tables ? f. Deleting Table Rows and Columns 01:00
  • 84: 3.1 Create tables ? g. Converting Tables to Data Ranges 01:00
  • 85: 3.2 Modify tables ? a. Introduction 01:00
  • 86: 3.2 Modify tables ? b. Modifying Tables 01:00
  • 87: 3.2 Modify tables ? c. Applying Table Styles 01:00
  • 88: 3.2 Modify tables ? d. Modifying Table Elements 01:00
  • 89: 3.3 Filter and sort tables ? a. Introduction 01:00
  • 90: 3.3 Filter and sort tables ? b. Filtering and Sorting Content in Excel 01:00
  • 91: 3.3 Filter and sort tables ? c. Filtering and Sorting Data Ranges 02:00

• Chapter 4: Apply Formulas and Functions 25:00

  • 92: 4.1 Utilize cell ranges and references in formulas and functions?a. Introduction 01:00
  • 93: 4.1 Utilize cell ranges and references (...)?b. Writing Formulas 01:00
  • 94: 4.1 Utilize cell ranges and references (...) ?c. Defining Operators 01:00
  • 95: 4.1 Utilize cell ranges and references (...) ? d. Cell References in Formulas 01:00
  • 96: 4.1 Utilize cell ranges and references (...) ? e. Order of Operations 01:00
  • 97: 4.1 Utilize cell ranges and references (...) ? f. Entering Formulas 01:00
  • 98: 4.1 Utilize cell ranges and references (...) ? g. Standard Error Values 01:00
  • 99: 4.1 Utilize cell ranges and references (...) ? h. Utilizing Cell References 01:00
  • 100: 4.2 Summarize data by using functions ? a. Introduction 01:00
  • 101: 4.2 Summarize data by using functions ? b. Utilizing Functions - SUM 01:00
  • 102: 4.2 Summarize data by using functions ? c. Utilizing Functions - AVERAGE 01:00
  • 103: 4.2 Summarize data by using functions ? d. Utilizing Functions - MIN & MAX 01:00
  • 104: 4.3 Utilise conditional logic in functions ? a. Introduction 01:00
  • 105: 4.3 Utilise conditional logic in functions ? b. IF Functions 01:00
  • 106: 4.3 Utilise conditional logic in functions ? c. Utilizing the SUMIF Function 01:00
  • 107: 4.3 Utilise conditional logic in functions ? d. Utilising the AVERAGEIF Function 01:00
  • 108: 4.3 Utilise conditional logic in functions ? e. Utilising the COUNTIF Function 01:00
  • 109: 4.4 Format and modify text by using functions ? a. Introduction 01:00
  • 110: 4.4 Format and modify text (...) ? b. Utilizing RIGHT, LEFT and MID Functions 02:00
  • 111: 4.4 Format and modify text by using functions ? c. Utilising the TRIM Function 02:00
  • 112: 4.4 Format and modify text (...) ? d. Utilising the UPPER and LOWER Functions 01:00
  • 113: 4.4 Format and modify text (...) ? e. Utilising the CONCATENATE Function 02:00

• Chapter 5: Create Charts and Objects 29:00

  • 114: 5.1 Create charts ? a. Introduction 01:00
  • 115: 5.1 Create charts ? b. Creating Charts and Graphs 04:00
  • 116: 5.1 Create charts ? c. Adding Additional Data Series 02:00
  • 117: 5.1 Create charts ? d. Switching between Rows and Columns 01:00
  • 118: 5.1 Create charts ? e. Using Quick Analysis 02:00
  • 119: 5.2 Format charts ? a. Introduction 01:00
  • 120: 5.2 Format charts ? b. Adding Legends 01:00
  • 121: 5.2 Format charts ? c. Adjusting Charts and Graphs 01:00
  • 122: 5.2 Format charts ? d. Changing Chart Parameters 01:00
  • 123: 5.2 Format charts ? e. Applying Layout to Charts and Graphs 01:00
  • 124: 5.2 Format charts ? f. Applying Styles to Charts and Graphs 01:00
  • 125: 5.3 Insert and format objects ? a. Introduction 01:00
  • 126: 5.3 Insert and format objects ? b. Inserting Text Boxes 01:00
  • 127: 5.3 Insert and format objects ? c. Inserting SmartArt 01:00
  • 128: 5.3 Insert and format objects ? d. Inserting Images 01:00
  • 129: 5.3 Insert and format objects ? e. Adding Borders to Objects 02:00
  • 130: 5.3 Insert and format objects ? f. Adding Styles and Effects to Objects 03:00
  • 131: 5.3 Insert and format objects ? g. Changing Object Colors 01:00
  • 132: 5.3 Insert and format objects ? h. Modifying Object Properties 02:00
  • 133: 5.3 Insert and format objects ? i. Positioning Objects 01:00

The Ultimate Microsoft MOS Excel 16 Masterclass will give you the necessary expertise that you need to competently use Microsoft Office applications at a ‘power user’ level and give you a competitive advantage when job hunting/in your workplace.

This course will significantly increase your confidence, skills, efficiency, and employability and serves to objectively validate your IT skills and, naturally it will assist in your advancement and promotion in your chosen career.

As a certified candidate, you will be able to create and manage entire worksheets and workbooks, identify and change cells and cell ranges, produce tabular data and manipulate them by using filtering methods, identify formulas and functions by applying logic and formatting for your data and build beautiful and professional charts and objects to compliment the data that you’ve produced.

Upon completion of this programme, you will have gained a thorough understanding of the principles of Microsoft Office 2016 and achieved a Microsoft Office Specialist (MOS) qualification.

How do I study?

You study online around your own schedule with our easy to use interactive student interface which is designed to make the learning experience as enjoyable as possible. Our content is delivered via a mixture of easy to follow video's, question and answer sections and interactive test prep. When in your account you will work from your own personalised learning platform, that will log and track your course progress.

Why choose us?

• Study job specific industry recognised courses
• Student support
• Job finder service
• Progress reports
• Exam booking support
• Over 90% first time pass rate
• 14 day no quibble money back guarantee

Career Support

Every student has access to our soft skills training pack that includes career support courses such as Interviewing Techniques and C.V building. These courses will give you the skills you need to head into the job market and boost your employability.

On completion of your training course, you will have the skills and confidence to jump straight into a role that suits you.

Our careers advisors have their ears to the ground and are on hand to offer you industry and job specific advice on any career path you decide to follow and ask about our job search service we offer to our students.

This course is for anyone working within roles associated with business and administration and is particularly relevant for professionals within a range of industry sectors.

It can also be useful to students who need to use MS Office!

There are no requirements for studying this course and no previous qualifications are necessary, it's designed for anyone looking to improve their computer skills.

The MOS is a widely recognised office qualification and has become the computer literacy standard for many organisations.

These are just some of the industries and types of jobs you could find yourself in.

• Office Admin/Data Entry
• Healthcare
• European IT Trainer
• IT Trainer Microsoft Office
• Secretarial
• Bookkeeper
• IT Support Administrator
• Financial Auditor

Reed courses certificate of completion

Digital certificate - Included