MO-210: Microsoft Excel (from beginner to intermediate)

سرفصل های دوره

Learn the skills for the new MO-210 Excel certification. Create tables, formulas, charts and manage workbooks.

1. Introduction

1. Introduction

2. Welcome to Udemy.html

3. How to get the best out of your Udemy course

4. Do you want auto-translated subtitles in more languages.html

5. Curriculum

6.1 CSVFile.csv

6.2 fixedwidthfile.zip

6.3 MO-210ExamRequirements230124.pdf

6.4 Section 2 Start.xlsx

6.5 textdelimitedfile.zip

6.6 textfile.zip

6. Resources.html

2. Import data into workbooks and Navigate within workbooks

1.1 Section 2 Start.xlsx

1. Microsoft Excel - a quick tour

2. Inserting text and moving the cursor

3. Formatting cells

4. Cut, copy and paste, and saving text

5.1 CSVFile.csv

5.2 fixedwidthfile.zip

5.3 textdelimitedfile.zip

5.4 textfile.zip

5. 1. Import data from text files (.txt and .csv files)

6.1 Link.txt

6. 2. Import data from online sources

7.1 Section 2 Start.xlsx

7. 3. Search for data within a workbook

8. 5. Insert and remove hyperlinks

9. Import data into workbooks and Navigate within workbooks.html

10.1 practiceactivity1.zip

10. Practice Activity Number 1.html

11. Practice Activity Number 1 - The Solution

3. Format worksheets and workbooks

1.1 Section 3 Start.xlsx

1. 9, 13. Change window views and using zoom

2. 6. Modify page setup

3. 6. Modify margins setup

4. 8. Customize headers and footers - text

5. 8. Customize headers and footers - pictures

6. 16. Set a print area

7. 7. Adjust row height and column width

8. 34. Select multiple items and format multiple worksheets by grouping

9. Format worksheets and workbooks.html

10.1 PracticeActivity02.xlsx

10. Practice Activity Number 2.html

11. Practice Activity Number 2 - The Solution

4. Customize options and views

1.1 Section 4 Start.xlsx

1. 10. Customize the Quick Access toolbar

2. 9, 11. Display and modify workbook content in different views

3. 12. Freeze worksheet rows and columns

4. 14. Modify basic workbook properties

5. Customize options and views.html

5. Configure content for collaboration

1.1 Section 5 Start.xlsx

1. 17. Save workbooks in alternative file formats

2. 20. Manage comments and notes

3. 18. Configure print settings

4. 19. Inspect workbooks for issues

5. Configure content for collaboration.html

6.1 PracticeActivity03.xlsx

6. Practice Activity Number 3.html

7. Practice Activity Number 3 - The Solution

6. Manipulate data in worksheets

1.1 Section 6 Start.xlsx

1. 21. Paste data by using special paste options

2. 22. Fill cells by using Auto Fill

3. 23. Insert and delete multiple columns or rows

4. 24. Insert and delete cells

5. Manipulate data in worksheets.html

6.1 PracticeActivity04.xlsx

6. Practice Activity Number 4.html

7. Practice Activity Number 4 - The Solution

7. Format cells and ranges

1.1 Section 7 Start.xlsx

1. 28. Format cells by using Format Painter

2. 29. Wrap text within cells

3. 27. Modify cell alignment, orientation, and indentation

4. 26. Merge and unmerge cells

5. 30. Apply number formats - commonly used number formats

6. 30. Apply number formats - less-commonly used number formats

7. 31, 33. Apply cell formats from the Format Cells dialog box, clear formatting

8. 32. Apply cell styles

9. Format cells and ranges.html

10.1 PracticeActivity05.xlsx

10. Practice Activity Number 5.html

11.1 PracticeActivity05.xlsx

11. Practice Activity Number 5 - The Solution

8. Summarize data visually

1.1 Section 8 Start.xlsx

1. 38. Applying conditional formatting - highlighting

2. 38, 39. Applying and removing conditional formatting - topbottom

3. 38, 39. Applying and removing conditional formatting - Bars, Scales and Sets

4. Summarize data visually.html

5.1 PracticeActivity06.xlsx

5. Practice Activity Number 6.html

6. Practice Activity Number 6 - The Solution

9. Create and format tables

1.1 Section 9 Start.xlsx

1. 40, 42. Create Excel tables from cell ranges & back, and name a table

2. 43. Add or remove table rows and columns

3. 41, 44. Apply table styles and configure table style options

4. 45. Insert and configure total rows

5. Create and format tables.html

6.1 PracticeActivity07.xlsx

6. Practice Activity Number 7.html

7. Practice Activity Number 7 - The Solution

10. Filter and sort table data

1.1 Section 10 Start.xlsx

1. 46. Filter records - numbers

2. 46. Filter records - text

3. 46. Filter records - dates, and setting up your own filter

4. 47. Sort data by multiple columns

5. Filter and sort table data.html

6.1 Section 10 Start.xlsx

6. Practice Activity Number 8.html

7. Practice Activity Number 8 - The Solution

11. Creating formulas

1.1 Section 11 Start.xlsx

1. Using basic operators

2. Order of operations

3.1 PracticeActivity09.xlsx

3. Referencing cell ranges in formulas and Practice Activity Number 9

4.1 PracticeActivity09.xlsx

4. Practice Activity Number 9 - The Solution

5. 15, 48. Insert relative, absolute, and mixed references & display formulas

6. Creating formulas.html

7.1 PracticeActivity10.xlsx

7. Practice Activity Number 10

8. Practice Activity Number 10 - The Solution

12. Calculate and transform data

1.1 Section 12 Start.xlsx

1. 50. Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions

2. 50. More about the SUM() function

3. 51. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions

4. 52. Perform conditional operations by using the IF() function

5. 52. More conditional operations using the IF() function

6. Calculate and transform data.html

7.1 PracticeActivity11.xlsx

7. Practice Activity Number 11.html

8. Practice Activity Number 11 - The Solution

13. Define and reference named ranges

1.1 Section 13 Start.xlsx

1. 35, 36. Define a named range and reference named ranges in formulas

2. 49. Reference named tables in formulas

3. 4. Navigate to named cells - Reminder

4. Define and reference named ranges.html

5.1 PracticeActivity12.xlsx

5. Practice Activity Number 12.html

6. Practice Activity Number 12 - The Solution

14. Format and modify text, and other formulas

1.1 Section 14 Start.xlsx

1. 55. Format text by using RIGHT(), LEFT(), and MID() functions

2. 56. Format text by using UPPER(), LOWER(), and LEN() functions

3. 57. Format text by using the CONCAT and TEXTJOIN functions

4. 53, 54. Sort data and get unique values by using the SORT and UNIQUE functions

5. 25. Generate numeric data by using RANDBETWEEN() and SEQUENCE()

6. Format and modify text, and other formulas.html

7.1 PracticeActivity13.xlsx

7. Practice Activity Number 13.html

8. Practice Activity Number 13 - The Solution

15. Create and modify charts

1.1 Section 15 Start.xlsx

1. 58, 59. Create charts, create chart sheets, and moving charts

2. 58, 59. The most commonly-used chart types

3. 60. Add data series to charts

4. 61. Switch between rows and columns in source data

5. Create and modify charts.html

6. Practice Activity Number 14.html

7. Practice Activity Number 14 - The Solution

16. Format charts and create sparklines

1. 62. Add chart elements

2. 62. Modifying chart elements

3. 63, 64, 65. Apply chart layouts and styles, and add alternative text

4. 37. Insert Sparklines

5. Format charts and create sparklines.html

6. Practice Activity Number 15.html

7. Practice Activity Number 15 - The Solution

17. Well done for finishing the Excel course

1. Whats Next

2. Excel Practice Test.html

3. Congratulations for finishing the Excel course

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training