Microsoft Excel: Excel Beginner Basics, Formulas & Functions

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

Microsoft Excel Course: From A-Z, Zero to Hero - Microsoft/Office/Excel 365, Microsoft Excel 2019, Microsoft Excel 2016

1. Getting to know Excel

1. Start Screen

2. Workbooks and Worksheets

3. Exploring the User Interface

4. Navigating around the Worksheet

5. Navigating using your Keyboard

6. Shortcuts for moving the Cell Pointer

7. Scroll & Zoom

8. Backstage View

9. Introducing Your First Assignment

10.1 1) Getting to know Excel - Assignment 1.xlsx

10.2 1) Getting to Know Excel - Notes.pdf

10. Getting to know Excel - Assignment 1.html

11. Getting to know Excel - Assignment 1 (Answer Guide)

12. The Ribbon

13. Ribbon Tabs - Part 1

14. Ribbon Tabs - Part 2

15. Types of Commands on the Ribbon

16. Shortcut Menus

17. The Quick Access toolbar

18. Adding Ribbon Commands to the Quick Access toolbar

19. Adding Non-Ribbon Commands to the Quick Access toolbar

20. The Formula bar

21. Dialog Boxes

22. Tabbed Dialog Boxes

23. Task Panes

24.1 1) Getting to know Excel - Assignment 2.xlsx

24.2 1) Getting to Know Excel - Notes.pdf

24. Getting to know Excel - Assignment 2.html

25. Getting to know Excel - Assignment 2 (Answer Guide)

2. Entering and Editing Data

1. Data Types

2. Entering Numbers

3. Entering Text

4. Using Enter Mode

5. Entering Date values

6. Entering Time values

7. Working with 2-Digit Years

8.1 2) Entering and Editing Data - Assignment 1.xlsx

8.2 2) Entering and Editing Data - Notes.pdf

8. Entering and Editing Data - Assignment 1.html

9. Entering and Editing Data - Assignment 1 (Answer Guide)

10. Data Entry

11. Deleting the Contents of a Cell

12. Replacing the Contents of a Cell

13. Editing the Contents of a Cell

14. Undo and Redo

15. Editing in the Cell versus on the Formula Bar

16. Inserting Cells

17. Displaying Text on Separate Lines within a Cell

18. Using AutoFill to Enter a Series of Values

19. AutoFill Series with Custom Increments

20.1 2) Entering and Editing Data - Assignment 2.xlsx

20.2 2) Entering and Editing Data - Notes.pdf

20. Entering and Editing Data - Assignment 2.html

21. Entering and Editing Data - Assignment 2 (Answer Guide)

22. AutoComplete

23. Entering Fractions

24. Automatic Number Formatting

25. Using the Ribbon to Format Numbers

26. Formatting Numbers by using the Format Cells Dialog Box

27.1 2) Entering and Editing Data - Assignment 3.xlsx

27.2 2) Entering and Editing Data - Notes.pdf

27. Entering and Editing Data - Assignment 3.html

28. Entering and Editing Data - Assignment 3 (Answer Guide)

3. Worksheet Operations

1. Working with Excel Windows

2. Moving and Resizing Windows

3. Switching among Windows

4. Closing Windows

5. Activating a Worksheet

6. Adding Worksheets

7. Deleting Worksheets

8. Renaming a Worksheet

9. Changing a Sheet Tab Color

10. Rearranging your Worksheets

11. Zooming In and Zooming Out

12.1 3) Worksheet Operations - Assignment 1.xlsx

12.2 3) Worksheet Operations - Notes.pdf

12. Worksheet Operations - Assignment 1.html

13. Worksheet Operations - Assignment 1 (Answer Guide)

14. Freezing Window Panes

15. Selecting Rows and Columns

16. Adding New Columns and Rows

17. Deleting Columns and Rows

18. Hiding Rows and Columns

4. Working with Ranges

1. Finding Data

2. Finding and Replacing Data

3. Copying or Moving Ranges

4. Paste Special

5. Paste Special Dialog Box

6.1 4) Working with Ranges - Assignment 1.xlsx

6.2 4) Working with Ranges - Notes.pdf

6. Working with Ranges - Assignment 1.html

7. Working with Ranges - Assignment 1 (Answer Guide)

8. Hyperlinks

9. Editing Links

10. Removing a Link

11. Adding Notes to Cells

12. Sorting and Filtering

13. Custom Sort

14. Copy & Paste - Filter vs Hide

15.1 4) Working with Ranges - Assignment 2.xlsx

15.2 4) Working with Ranges - Notes.pdf

15. Working with Ranges - Assignment 2.html

16. 4) Working with Ranges - Assignment 2 (Answer Guide)

5. Formatting

1. Fonts

2. Text Alignment

3. Colors and Shading

4. Borders and Lines

5. Format Painter

6.1 5) Formatting - Assignment 1.xlsx

6.2 5) Formatting - Notes.pdf

6. Formatting - Assignment 1.html

7. Formatting - Assignment 1 (Answer Guide)

6. Saving and Password Protection

1. Creating a New Workbook

2. Opening an Existing Workbook

3. Saving a Workbook

4. Changing the Default File Location

5. Password-Protecting a Workbook

6.1 6) Saving and Password Protection - Assignment 1.xlsx

6.2 6) Saving and Password Protection - Notes.pdf

6. Saving and Password Protection - Assignment 1.html

7. Saving and Password Protection - Assignment 1 (Answer Guide)

7. Printing

1. Printing from the Backstage View

2. Previewing the Printout

3. Changing Your Page View

4. Previewing the Pages

5. Creating PDF Files

6.1 7) Printing - Assignment 1.xlsx

6.2 7) Printing - Notes.pdf

6. Printing - Assignment 1.html

7. Printing - Assignment 1 (Answer Guide)

8. Intro to Formulas, Functions, and Cell References

1. Formulas & Editing Formulas

2. Order of Operations

3. Functions

4. Relative & Absolute Cell References

5. Mixed References

6. Circular References

7.1 8) Intro to Formulas, Functions, and Cell References - Assignment 1.xlsx

7.2 8) Intro to Formulas, Functions, and Cell References - Notes.pdf

7. Intro to Formulas, Functions, and Cell References - Assignment 1.html

8. Intro to Formulas, Functions, and Cell References - Assignment (Answer Guide)

9. Math Functions

1. RANDBETWEEN

2. ROUND, ROUNDUP, ROUNDDOWN

3. INT, TRUNC, ROUND

4. MROUND

5. FLOOR, CEILING

6.1 9) Math Functions - Assignment 1.xlsx

6.2 9) Math Functions - Notes.pdf

6. Math Functions - Assignment 1.html

7. Math Functions - Assignment 1 (Answer Guide)

8. ODD, EVEN

9. MOD

10. SUM, AutoSum, Alt + Plus Sign, Quick Analysis

11. Running Total Formula

12. SUMIF

13. SUMIFS

14.1 9) Math Functions - Assignment 2.xlsx

14.2 9) Math Functions - Notes.pdf

14. Math Functions - Assignment 2.html

15. Math Functions - Assignment 2 (Answer Guide)

10. Logical Functions

1. AND Function

2. IF (boy)

3. IF (older than 4)

4. IF & AND (boy, and older than 4)

5. IF (not a boy)

6. IF & AND (not a boy, and younger than 4)

7.1 10) Logical Functions - Assignment 1.xlsx

7.2 10) Logical Functions - Notes.pdf

7. Logical Functions - Assignment 1.html

8. Logical Functions - Assignment 1 (Answer Guide)

9. OR Function

10. IF & OR (girl, and younger than 4)

11. IFS

12. Nested IF

13.1 10) Logical Functions - Assignment 2.xlsx

13.2 10) Logical Functions - Notes.pdf

13. Logical Functions - Assignment 2.html

14. Logical Functions - Assignment 2 (Answer Guide)

15. ISEVEN

16. ISODD

17. ISBLANK

18. ISFORMULA

19. ISERROR, IFERROR

20.1 10) Logical Functions - Assignment 3.xlsx

20.2 10) Logical Functions - Notes.pdf

20. Logical Functions - Assignment 3.html

21. Logical Functions - Assignment 3 (Answer Guide)

11. Statistical Functions

1. AVERAGE

2. MEDIAN

3. MODE

4. COUNT

5. COUNTA

6. COUNTBLANK

7. COUNTIF

8. COUNTIFS

9. MAX, MIN

10.1 11) Statistical Functions - Assignment 1.xlsx

10.2 11) Statistical Functions - Notes.pdf

10. Statistical Functions - Assignment 1.html

11. Statistical Functions - Assignment 1 (Answer Guide)

12. Text Functions

1. UPPER, LOWER, PROPER

2. LEN

3. TRIM

4. Concatenation using the Ampersand symbol (&)

5. LEFT, RIGHT, MID

6.1 12) Text Functions - Assignment 1.xlsx

6.2 12) Text Functions - Notes.pdf

6. Text Functions - Assignment 1.html

7. Text Functions - Assignment 1 (Answer Guide)

8. TEXTBEFORE

9. TEXTAFTER

10. Text to Columns

11. Concatenation using the Ampersand symbol (&) - Part 2

12. TEXTJOIN

13. CONCATENATE

14. TEXTSPLIT

15.1 12) Text Functions - Assignment 2.xlsx

15.2 12) Text Functions - Notes.pdf

15. Text Functions - Assignment 2.html

16. Text Functions - Assignment 2 (Answer Guide)

17. TEXT (including Leading Zeros and Padding Zeros)

18. TYPE

19. VALUE

20. T Function

21.1 12) Text Functions - Assignment 3.xlsx

21.2 12) Text Functions - Notes.pdf

21. Text Functions - Assignment 3.html

22. Text Functions - Assignment 3 (Answer Guide)

13. Date & Time Functions

1. Date

2. Time

3.1 13) Date & Time Functions - Assignment 1.xlsx

3.2 13) Date & Time Functions - Notes.pdf

3. Date & Time Functions - Assignment 1.html

4. Date & Time Functions - Assignment 1 (Answer Guide)

14. Lookup Functions

1. XLOOKUP

2. UNIQUE

3. TRANSPOSE

4. VSTACK, HSTACK

5.1 14) Lookup Functions - Assignment 1.xlsx

5.2 14) Lookup Functions - Notes.pdf

5. Lookup Functions - Assignment 1.html

6. Lookup Functions - Assignment 1 (Answer Guide)

139,000 تومان

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

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

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

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