Mo-210: Microsoft Excel (Microsoft 365 Apps)
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.17 GB | Duration: 8h 24m
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.17 GB | Duration: 8h 24m
Learn the skills for the new MO-210 Excel certification. Create tables, formulas, charts and manage workbooks.
What you'll learn
Create, configure and save Excel worksheets and workbooks.
Navigate through and format worksheets and workbooks.
Customise options and views for worksheets and workbooks.
Configure Excel worksheets and workbooks to print (e.g. page setup).
Insert data into and format cells and ranges, and create and modify tables.
Highlight, filter, sort and group cells, ranges and tables.
Create and format Excel charts.
Create formulas in Excel, including using conditional logic and modifying text.
Requirements
Before beginning, you will need to know how to use a Windows computer, including a mouse.
It would be good if you have used Microsoft Excel before, but this is not essential.
You should have MS Excel (or Office) from 2022 or later installed on your PC computer. This program is also known as a Microsoft 365 App.
Description
The MO-210 certification is the new certification for Excel. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.This course has been created using Udemy's Accessibility guidelines.In this MO-210 course:We’ll start with create and manage worksheets and workbooks. We’ll import data into workbooks, navigate and format workbooks, and prepare them for collaboration and distribution.We’ll then look at managing data cells and ranges and create tables. We’ll insert data into and format workbooks, summarise and organize data, manage table styles and options, and filter and sort table data.We’ll then perform operations with Excel formulas and functions. We’ll use functions for summarising data, performing conditional operations, formatting and modifying text, sorting and generating numeric data.Finally, we’ll look at creating charts and sparklines. We’ll use different chart types, such as line, bar, area and pie charts, we’ll add legends and apply layouts and styles, and insert sparklines.No prior knowledge is required. And there are 15 Practice Activities, 15 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-210 exam, which gives you the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certificate. This would look good on your CV or resume. It is also the first stage to you getting the "Microsoft Office Specialist: Associate (Microsoft 365 Apps)" certification.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Welcome to Udemy
Lecture 3 How to get the best out of your Udemy course
Lecture 4 Do you want auto-translated subtitles in more languages?
Lecture 5 Curriculum
Lecture 6 Resources
Section 2: Import data into workbooks and Navigate within workbooks
Lecture 7 Microsoft Excel - a quick tour
Lecture 8 Inserting text and moving the cursor
Lecture 9 Formatting cells
Lecture 10 Cut, copy and paste, and saving text
Lecture 11 1. Import data from text files (.txt and .csv files)
Lecture 12 2. Import data from online sources
Lecture 13 3. Search for data within a workbook
Lecture 14 5. Insert and remove hyperlinks
Lecture 15 Practice Activity Number 1
Lecture 16 Practice Activity Number 1 - The Solution
Section 3: Format worksheets and workbooks
Lecture 17 9, 13. Change window views and using zoom
Lecture 18 6. Modify page setup
Lecture 19 6. Modify margins setup
Lecture 20 8. Customize headers and footers - text
Lecture 21 8. Customize headers and footers - pictures
Lecture 22 16. Set a print area
Lecture 23 7. Adjust row height and column width
Lecture 24 34. Select multiple items and format multiple worksheets by grouping
Lecture 25 Practice Activity Number 2
Lecture 26 Practice Activity Number 2 - The Solution
Section 4: Customize options and views
Lecture 27 10. Customize the Quick Access toolbar
Lecture 28 9, 11. Display and modify workbook content in different views
Lecture 29 12. Freeze worksheet rows and columns
Lecture 30 14. Modify basic workbook properties
Section 5: Configure content for collaboration
Lecture 31 17. Save workbooks in alternative file formats
Lecture 32 20. Manage comments and notes
Lecture 33 18. Configure print settings
Lecture 34 19. Inspect workbooks for issues
Lecture 35 Practice Activity Number 3
Lecture 36 Practice Activity Number 3 - The Solution
Section 6: Manipulate data in worksheets
Lecture 37 21. Paste data by using special paste options
Lecture 38 22. Fill cells by using Auto Fill
Lecture 39 23. Insert and delete multiple columns or rows
Lecture 40 24. Insert and delete cells
Lecture 41 Practice Activity Number 4
Lecture 42 Practice Activity Number 4 - The Solution
Section 7: Format cells and ranges
Lecture 43 28. Format cells by using Format Painter
Lecture 44 29. Wrap text within cells
Lecture 45 27. Modify cell alignment, orientation, and indentation
Lecture 46 26. Merge and unmerge cells
Lecture 47 30. Apply number formats - commonly used number formats
Lecture 48 30. Apply number formats - less-commonly used number formats
Lecture 49 31, 33. Apply cell formats from the Format Cells dialog box, clear formatting
Lecture 50 32. Apply cell styles
Lecture 51 Practice Activity Number 5
Lecture 52 Practice Activity Number 5 - The Solution
Section 8: Summarize data visually
Lecture 53 38. Applying conditional formatting - highlighting
Lecture 54 38, 39. Applying and removing conditional formatting - top/bottom
Lecture 55 38, 39. Applying and removing conditional formatting - Bars, Scales and Sets
Lecture 56 Practice Activity Number 6
Lecture 57 Practice Activity Number 6 - The Solution
Section 9: Create and format tables
Lecture 58 40, 42. Create Excel tables from cell ranges & back, and name a table
Lecture 59 43. Add or remove table rows and columns
Lecture 60 41, 44. Apply table styles and configure table style options
Lecture 61 45. Insert and configure total rows
Lecture 62 Practice Activity Number 7
Lecture 63 Practice Activity Number 7 - The Solution
Section 10: Filter and sort table data
Lecture 64 46. Filter records - numbers
Lecture 65 46. Filter records - text
Lecture 66 46. Filter records - dates, and setting up your own filter
Lecture 67 47. Sort data by multiple columns
Lecture 68 Practice Activity Number 8
Lecture 69 Practice Activity Number 8 - The Solution
Section 11: Creating formulas
Lecture 70 Using basic operators
Lecture 71 Order of operations
Lecture 72 Referencing cell ranges in formulas and Practice Activity Number 9
Lecture 73 Practice Activity Number 9 - The Solution
Lecture 74 15, 48. Insert relative, absolute, and mixed references & display formulas
Lecture 75 Practice Activity Number 10
Lecture 76 Practice Activity Number 10 - The Solution
Section 12: Calculate and transform data
Lecture 77 50. Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions
Lecture 78 50. More about the SUM() function
Lecture 79 51. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
Lecture 80 52. Perform conditional operations by using the IF() function
Lecture 81 52. More conditional operations using the IF() function
Lecture 82 Practice Activity Number 11
Lecture 83 Practice Activity Number 11 - The Solution
Section 13: Define and reference named ranges
Lecture 84 35, 36. Define a named range and reference named ranges in formulas
Lecture 85 49. Reference named tables in formulas
Lecture 86 4. Navigate to named cells - Reminder
Lecture 87 Practice Activity Number 12
Lecture 88 Practice Activity Number 12 - The Solution
Section 14: Format and modify text, and other formulas
Lecture 89 55. Format text by using RIGHT(), LEFT(), and MID() functions
Lecture 90 56. Format text by using UPPER(), LOWER(), and LEN() functions
Lecture 91 57. Format text by using the CONCAT and TEXTJOIN functions
Lecture 92 53, 54. Sort data and get unique values by using the SORT and UNIQUE functions
Lecture 93 25. Generate numeric data by using RANDBETWEEN() and SEQUENCE()
Lecture 94 Practice Activity Number 13
Lecture 95 Practice Activity Number 13 - The Solution
Section 15: Create and modify charts
Lecture 96 58, 59. Create charts, create chart sheets, and moving charts
Lecture 97 58, 59. The most commonly-used chart types
Lecture 98 60. Add data series to charts
Lecture 99 61. Switch between rows and columns in source data
Lecture 100 Practice Activity Number 14
Lecture 101 Practice Activity Number 14 - The Solution
Section 16: Format charts and create sparklines
Lecture 102 62. Add chart elements
Lecture 103 62. Modifying chart elements
Lecture 104 63, 64, 65. Apply chart layouts and styles, and add alternative text
Lecture 105 37. Insert Sparklines
Lecture 106 Practice Activity Number 15
Lecture 107 Practice Activity Number 15 - The Solution
Section 17: Well done for finishing the Excel course
Lecture 108 What's Next?
Lecture 109 Congratulations for finishing the Excel course
This course is for you if you want to develop your Microsoft Excel skills.,This course will use the latest version of Excel, but is also for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 2019.,This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.,You will cover the content tested in Microsoft Office Specialist Exams MO-210 (for Excel 2022 and later),This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.