Microsoft Excel & PowerPoint 2019/365 Essential Training

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

Take your Microsoft Office presentations and spreadsheets to the next level with this Excel + PowerPoint combined course

1. Excel 2019 Beginner Intro to Excel

1. Intro to Excel

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Excel 2019 Beginner Course Exercise Files.zip

3. Course Exercise Files.html

4.1 Microsoft Excel 2019 Course by Simon Sez IT.pdf

4. Downloadable Course Transcripts.html

5. Whats New In Excel 2019

6. Course Overview

7. Overview of the Excel window

8. Mouse-Features

9. Back Stage View

10. Section 1 - Quiz.html

2. Excel 2019 Beginner Creating Workbooks

1. Entering Text and Numbers

2. Creating Basic Formulas

3. Relative References

4. Order of Operations

5. Working with Ranges

6. Module 2 - Practice Exercise

7. Section 2 Quiz.html

3. Excel 2019 Beginner Saving Workbooks

1. Working with the Save and Save As Commands

2. File Extensions, Share, Export and Publish Files

3. Module 3 - Practice Exercise

4. Section 3 Quiz.html

4. Excel 2019 Beginner Navigating Workbooks

1. Opening a File

2. Working with Larger Files

3. Freeze Panes Option

4. Split Screen Option

5. Module 4 - Practice Exercise

6. Section 4 Quiz.html

5. Excel 2019 Beginner Page Setup & Print Options

1. Headers and Footers

2. Print Titles

3. Comments

4. Page Setup Options

5. Fit to Print on One Page

6. Printing Workbooks

7. Module 5 - Practice Exercise

8. Section 5 Quiz.html

6. Excel 2019 Beginners Working with Rows, Columns and Cells

1. Adding and deleting rows columns and cells

2. Changing Column and-Row Widths

3. Module 6 - Practice Exercise

4. Section 6 Quiz.html

7. Excel 2019 Beginners Moving Data

1. Cut, Copy and Paste

2. Copying Formulas

3. Module 7 - Practice Exercise

4. Section 7 Quiz.html

8. Excel 2019 Beginners Formulas & Functions

1. Overview of Formulas

2. Create Formulas Using Functions Part 1

3. Create Formulas Using Functions Part 2

4. Absolute Values

5. Module 8 - Practice Exercise

6. Section 8 Quiz.html

9. Excel 2019 Beginner Working with Sheets

1. Adding Deleting and Renaming Sheets

2. Additional Sheet Tab Options

3. 3 Dimensional Formulas

4. Module 9 - Practice Exercise

5. Section 9 Quiz.html

10. Excel 2019 Beginner Formatting Worksheets

1. Formatting Cells Part 1

2. Formatting Cells Part 2

3. Formatting Numbers

4. Borders and Shading

5. Format as Table

6. Using Styles

7. Using Format Painter

8. Protecting Sheets

9. Fill Handle and Custom Lists

10. Module 10 - Practice Exercise

11. Section 10 Quiz.html

11. Excel 2019 Beginner Charts

1. Creating Charts

2. Types of Charts

3. Editing Charts Part 1

4. Editing Charts Part 2

5. Using Graphics to Enhance Charts

6. Linking Chart Titles

7. Module 11 - Practice Exercise

8. Section 11 Quiz.html

12. Excel 2019 Beginner Working with Names

1. Creating Range Names

2. Managing Names

3. Using Names in Formulas

4. Module 12 - Practice Exercise

5. Section 12 Quiz.html

13. Excel 2019 Beginner Sorting and Filtering

1. Remove Duplicates

2. Sort Data

3. Filter Data

4. Advanced Filters

5. Module 13 - Practice Exercise

6. Section 13 Quiz.html

14. Excel 2019 Beginner Outlining and Subtotaling

1. Creating an Outline

2. Subtotals

3. Module 14 - Practice Exercise

4. Section 14 Quiz.html

15. Excel 2019 Beginner Working with Views

1. Arranging Files

2. New Window Option

3. Custom Views

4. Module 15 - Practice Exercise

5. Section 15 Quiz.html

16. Excel 2019 Beginner Linking Files

1. Creating Formulas Between File

2. Working with Links

3. Consolidating Data

4. Module 16 - Practice Exercise

5. Section 16 Quiz.html

17. Excel 2019 Beginner Advanced Formula Creation

1. If Statements

2. VLookups

3. Data Validation

4. Formula Auditing

5. Module 17 - Practice Exercise

6. Section 17 Quiz.html

18. Excel 2019 Beginner Pivot Tables

1. Pivot Tables

2. Pivot Charts

3. Module 18 - Practice Exercise

4. Section 18 Quiz.html

19. Excel 2019 Beginner Additional Excel Features

1. Slicers

2. Goal Seeker

3. Text to Columns

4. Watch Window

5. Customizing Ribbons and Tabs

6. Module 19 - Practice Exercise

7. Section 19 Quiz.html

20. Excel 2019 Beginner Shortcuts

1. Excel Shortcuts Every User Should Know

21. Excel 2019 Beginner Closing

1. Closing Video

22. PowerPoint 2019 Course Introduction

1. Welcome and Overview

2. WATCHE ME Essential Information for a Successful Training Experience

3.1 PowerPoint 2019 Exercise Files.zip

3. Course Exercise Files.html

4.1 Microsoft PowerPoint 2019 Course by Simon Sez IT .pdf

4. Downloadable Course Transcript.html

23. PowerPoint 2019 Overview

1. Navigate a PowerPoint Presentation

2. Overview of the Screen and Views

3. Exercise 1

24. PowerPoint 2019 Getting Started

1. Presentation Tips and Guidelines

2. Creating a New Presentation

3. Working with Slides

4. Saving a Presentation

5. Exercise 02

6. Section 24 Quiz.html

25. PowerPoint 2019 Text and Bullet Editing Options

1. Formatting Text

2. Working with Bullets and Numbered Lists

3. Exercise 03

4. Section 25 Quiz.html

26. PowerPoint 2019 Adding Graphics

1. Inserting Shapes

2. Inserting Graphics

3. Inserting Icons and 3D Models

4. Inserting Pictures

5. Exercise 04

6. Section 26 Quiz.html

27. PowerPoint 2019 Working with objects

1. Selecting Objects

2. Editing Objects

3. Formatting Objects - Part 1

4. Formatting Objects - Part 2

5. Arranging Objects

6. Grouping Objects

7. Exercise 05

8. Section 27 Quiz.html

28. PowerPoint 2019 Editing pictures

1. Picture Options

2. Cropping Pictures

3. Formatting Pictures

4. Things You Can Do with Pictures

5. Exercise 06

6. Section 28 Quiz.html

29. PowerPoint 2019 Working with SmartArt

1. Creating SmartArt

2. Modifying SmartArt

3. Creating a Flowchart using SmartArt

4. Exercise 07

5. Section 29 Quiz.html

30. PowerPoint 2019 Working with Tables

1. Creating Tables

2. Formatting Tables

3. Inserting Tables

4. Exercise 08

5. Section 30 Quiz.html

31. PowerPoint 2019 Working with Charts

1. Adding Charts

2. Formatting Charts

3. Inserting Charts from Microsoft Excel

4. Exercise 09

5. Section 31 Quiz.html

32. PowerPoint 2019 Unlocking the Power of Masters

1. Using Master Slides

2. Modifying Master Slides

3. Creating a New Master Design Template

4. Exercise 10

5. Section 32 Quiz.html

33. PowerPoint 2019 Adding Media

1. Adding Video to a Presentation

2. Adding Audio to a Presentation

3. Exercise 11

4. Section 33 Quiz.html

34. PowerPoint 2019 Working with Transitions

1. Applying Transitions

2. Transition Options

3. Exercise 12

4. Section 34 Quiz.html

35. PowerPoint 2019 Animation

1. Animating an Object

2. Effect Options

3. Working with the Animation Pane

4. Motion Paths

5. Triggers

6. Exercise 13

7. Section 35 Quiz.html

36. PowerPoint 2019 Hyperlinks and Action Buttons

1. Working with Action Buttons

2. Working with Hyperllinks

3. Exercise 14

4. Section 36 Quiz.html

37. PowerPoint 2019 Slideshow Options

1. Onscreen Presentation Options

2. Hiding Slides

3. Changing the order of slides

4. Copying slides

5. Slideshow Options

6. Exercise 15

38. PowerPoint 2019 Preparing a presentation for delivery

1. Rehearse Timings

2. Recording a Presentation

3. Slide Show Settings

4. Creating a Custom Slide Show

5. Exercise 16

39. PowerPoint 2019 Exploring the Backstage Area

1. Exporting options

2. The Backstage Area

3. Printing a Presentation

4. Exercise 17

40. PowerPoint 2019 Course Close

1. Conclusion

41. Extras

1. EXTRA LESSON Designing Better Spreadsheets Webinar Recording

2. EXTRA LESSON Data Cleaning in Excel Webinar Recording

3. EXTRA LESSON Top Ten Excel Functions You HAVE to Know Webinar Recording

4. EXTRA LESSON Creating Engaging PowerPoint Presentations Webinar Recording

5.1 Powerpoint.pdf

5. EXTRA RESOURCE The Most Frequently Used PowerPoint Shortcuts - Infographic.html

6.1 PC Excel Most Used.pdf

6. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html

42. Bonuses

1. Ten Excel Tips and Tricks - Part 1

2. Ten Excel Tips and Tricks - Part 2

3. Ten Excel Tips and Tricks - Part 3

139,000 تومان

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

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

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

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