Microsoft Excel 2019 Level 1 – Beginner Excel 2019

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

Learn Microsoft Excel skills that will give you a solid foundation (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

1. Introduction

1. Introduction

2. Practice Activities and Instructor Notes

1.1 Excel 2019 L1-Exercises Instructor Notes.zip

1. Practice Activities and Instructor Notes

3. Basics

1. Excel 2019 First Look! Overview

2. Themes, Save Location, Back Stage And Fonts

3. Quick Access Toolbar

4. Ribbon

5. Cell Selection, Navigating Shortcuts, Tips And Tricks

6. Data Entry And Creating a Basic Worksheet

7. Save, Save As And Backup Copy

8. Convert To 2019

9. Compatibility Checker

10. Tell Me What You Want To Do - Help Feature

11. Excel Basics Quiz.html

4. Functions And Formulas

1. Basic Formulas

2. Introduction to Functions with SUM And AVERAGE Functions

3. MIN And MAX

4. COUNT And COUNTA

5. Move, Copy, Cut, And Paste Data into Cells

6. Absolute And Relative References

7. Mixed References

8. AutoFill

9. FlashFill

10. Converting Text into Columns

11. Functions And Formulas Quiz.html

5. Editing Worksheets

1. Editing Cell Data

2. Insert And Delete Cells, Columns and Rows

3. Find And Replace Data

4. GoTo

5. TRANSPOSE

6. Change Height, Width and Hide Rows and Columns

7. Check Worksheet or Workbook Spelling with Spell Check

8. Smart Lookup And Thesaurus

9. Editing Worksheets Quiz.html

6. Formatting

1. Formatting Text

2. Basic Number Formats

3. Basic Custom Number Format

4. Adding Borders And Colors to Cells

5. Formatting Shortcuts

6. Adding Background

7. Align, Merge And Wrap Cell Data

8. Cell Styles

9. AutoFormat

10. Basic Conditional Formatting

11. Conditional Formatting Manager

12. Formatting Quiz.html

7. Print

1. Print Page Breaks, Grildines And Headlines

2. Page Orientation

3. Print Rows at the Top of Each Page - Repeat Column Headers

4. Headers And Footers

5. Editing Page Margins And Center on Page

6. Page Breaks

7. Setting Print Range And Scaling

8. Print Quiz.html

8. Modifying Worksheet Appearance

1. Name, Move, Copy, Color, Link Worksheets in Workbook

2. Hide Worksheets And Workbooks

3. Split Worksheet

4. Freeze Panes

5. New Windows - Multiple Workbook Views

6. Customize Formula Options

7. Speak Cells

8. Sound Feedback (New to 2019!)

9. Accessibility Checker - One Click Fix! (New to 2019!)

10. Translate (New to 2019!)

11. Modifying Worksheet Appearance Quiz.html

12. BONUS! - Special Offer! Discount on ANY of my Courses!.html

189,000 تومان

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

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

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

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