Introduction to Microsoft Excel for Beginners (Office 365)

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

Learn Everything You Should know about Microsoft Excel Step by Step for Beginners

1. Introduction to Microsoft Excel

1. Introduction

2. How to Use this Course

3. What is Microsoft Excel

4.1 Buying Microsoft 365 Personal Subscription.pdf

4. Buying Microsoft 365 Personal Subscription

2. Setting Up One Drive Application on Windows OS

1. Introduction to OneDrive Application.html

2. OneDrive Cloud with Microsoft

3. Downloading OneDrive Application on Windows

4. Setting Up OneDrive Application on Windows

5. Accessing Your OneDrive Cloud Online

6. Creating a Blank Excel Workbook on Cloud

7. Accessing OneDrive Folder Locally on Windows

3. Getting Familiar with the Excel Interface

1. Launching Microsoft Excel on Windows OS

2. Reviewing the Sign in Option and Account Section in Excel

3. Revewing the Excel Backstage

4. Creating a Blank Workbook with Microsoft Excel

5. What is a Workbook

6. General Review of the Excel Interface

4. Microsoft Excel Quick Access Toolbar

1. Reviewing the Quick Access Toolbar in Excel

2. Reviewing the Default Quick Access Toolbar Icons in Excel

3. Undo and Redo Command in Quick Access Toolbar

4. Adding Commonly Used Commands on the Quick Access Toolbar

5. Customizing the Quick Access Toolbar

6. Rearranging the Command Icons in the Quick Access Toolbar

7. Placing the Quick Access Toolbar Below the Ribbon Bar

8. Removing Commands from Quick Access Toolbar

9. Export Customized Quick Access Toolbar in Excel

10. Resetting the Quick Access Toolbar in Excel

11. Import Customized Quick Access Toolbar in Excel

5. Microsoft Excel Ribbon Menu Bar

1.1 Introduction to Microsoft Excel Ribbon Menu System.pdf

1. Introduction to Microsoft Excel Ribbon Menu System

2. Excel Ribbon Menu System.html

3.1 Activating the Key Tip Letters in the Ribbon Menu Bar.pdf

3. Activating the Excel Key Tip Letters in the Ribbon Menu Bar

4. Activating the Excel Key Tip Letters in the Ribbon Menu Bar.html

5.1 Showing and Hiding the Ribbon Bar in Excel.pdf

5. Showing and Hiding the Ribbon Bar in Excel

6. Showing and Hiding the Ribbon Bar in Excel.html

7. Adding More Commands into Existing Tabs in Excel

8. Adding New Tabs, Groups and Commands into Excels Ribbon Bar

9. Rearranging Group and Tabs in Excel Ribbon Bar

10. Hiding the Menu Tabs in Excel Ribbon Bar

11. Hiding Custom Command Labels in Excel Ribbon Bar

12. Removing Custom Group and Tabs in Excel Ribbon Bar

13. Adding Ribbon Group Menu Commands to Quick Access Toolbar

14. Export Customized Ribbon Menu Bar in Excel

15. Reseting the Excel Ribbon Bar back to Default Layout

16. Import Customized Ribbon Menu Bar in Excel

17. A Brief Review of the Help Menu in Excel

6. Saving Microsoft Excel Workbooks

1. Saving a Microsoft Excel Workbook Locally on Windows Computers

2. Accessing Excel Workbook File Location and Local Path

3. Changing the Save As Option Default Location

4. Opening Excel Saved Workbooks on Windows OS

5. Opening a Copy of a Workbook in Excel.html

6. Adding More Description Properties to Excel Workbooks

7. Saving Excel Workbooks to OneDrive Cloud on Windows

8. Removing the Recent Workbooks from the Home Page

9. Removing Excel Workbooks from Windows OS

10. Saving the Workbook as a PDF File

7. Zooming and View Options in Microsoft Excel

1.1 Roommate Assignments and Bills.xlsx

1.2 Using the Mouse and Keyboard in Excel to Zoom.pdf

1. Using the Mouse and Keyboard in Excel to Zoom

2. Zooming in Excel with Mouse and Keyboard.html

3.1 Personal Monthly Budget.xlsx

3.2 Using the Zoom Slider in Excel Status Bar.pdf

3. Using the Zoom Slider in Excel Status Bar

4. Using the Zoom Slider to Zoom In or Out.html

5.1 Using the Zoom Dialog Box in Excel.pdf

5.2 Wedding Timeline Planner.xlsx

5. Using the Zoom Dialog Box in Excel

6.1 Inventory List.xlsx

6.2 Using the Zoom to Selection Feature in Excel.pdf

6. Using the Zoom to Selection Feature in Excel

7. Using the Zoom Option in Excel.html

8.1 Overview of the Different View options in Excel.pdf

8.2 PhoneBook.xlsx

8. Overview of the Different View options in Excel

9. Overview of the Different View options in Excel.html

8. Reviweing the Cells in Excel Worksheet

1. A Basic Review of Excel Worksheet

2. Basic Review of Working with Cells in Excel

3. Selecting a Cell or Range of Cells in Microsoft Excel

4. Selecting a Cell or a Range of Cells with the Go to Dialog Box

5. Naming a Cell Reference or a Range of Cells in Excel

6.1 Book1.xlsx

6. Exploring the Data Type on Excel Worksheet

7. Basic Text Entry in Microsoft Excel Worksheet

8. Using the Undo and Redo Commands in Excel

9. Editing the Basic Cell Contents in Excel

10. Exploring the Microsoft Excel Basic Cell Modes

11. Removing Cell Contents in Excel Worksheet

9. Working with Mouse and Keyboard in Excel Sheets

1. Moving in the Worksheet Cells with Keyboard Keys

2. Regular Mouse Icon in Excel Interface

3. Fat Plus Mouse Icon in Excel Worksheet

4. I-Beam Insertion Mouse Icon in Excel

5. Skinny Plus Mouse Icon in Excel

6. Black Arrow Mouse Icon in Excel Worksheet

7. Double Headed Arrow Mouse Icon in Excel

8. Maltese Cross Mouse Icon in Excel

9. Right Clicking in Microsoft Excel Worksheets

10. Working with Rows and Columns in Excel

1.1 A Brief Review of Microsoft Excel Worksheet.pdf

1. A Brief Review of Microsoft Excel Worksheet

2.1 Book1.xlsx

2. Selecting Rows and Columns in Excel

3.1 Book1.xlsx

3. Inserting Rows and Columns in Excel Worksheet

4. Adjusting Row Height and Column Width of Worksheets

5.1 Book1.xlsx

5. AutoFit Row Height and Column Width in Excel Worksheet

6. Exploring the Default Column Width and Row Height in Excel Worksheet

7.1 Book1.xlsx

7. Hide and Unhide Rows and Columns in Excel Worksheets

8.1 Book1.xlsx

8. Deleting Rows and Columns in Excel Worksheet

9. Change the Unit of Measurement in Excel

11. Basic Formatting Options in Microsoft Excel

1.1 Book1.xlsx

1. Changing Cell Content Font Type Face and in Excel

2.1 Book1.xlsx

2. Changing Cell Content Font Size in Excel

3.1 Book1.xlsx

3.2 Premium Weekly Chore Schedule.xlsx

3. Changing Cell Content Font Color and Background Color in Excel

4.1 A Basic List.xlsx

4. Adding Border Around the Cells in Excel

5.1 Simple personal Budget.xlsx

5. Removing All Applied Formatting Options from a Cell in Excel

6.1 A Basic PhoneBook.xlsx

6. Merging and Centering Cells in Excel Worksheets

7.1 A Basic Invoice.xlsx

7. Exploring the Text Alignment Tools in Excel

12. Working with Numbers in Excel Worksheet

1. A Basic Reviw of Entering Number Values in Microsoft Excel Worksheet

2. Entering Decimal Numbers in Excel Worksheets

3. Entering Fractional Numbers in Excel Worksheets

4. Entering a Basic Date in Excel Worksheet

5. Entering a Basic Time in Excel Worksheet

13. Formatting Cells in Micsosoft Excel

1. Exploring the Microsoft Excel Basic Cell Attributes

2.1 Reviewing the Font Group in Excel.xlsx

2. Reviewing the Font Group in Excel

3.1 A Basic Invoice.xlsx

3. Reviewing the Number Group in Excel

14. Working with Basic Formula and Functions

1. Getting Started with Formulas.html

2. Entering Your First Formula in Excel

3. What is Pointing-at Formula Cell in Excel

4.1 Basic Arithmetic Operations.xlsx

4. Performing a Basic Arithmetics with Operators in Excel

5.1 Basic Arithmetic Operations.xlsx

5. Editing a Basic Formula in Excel Worksheet

6.1 Student Marks.xlsx

6. TRUE or FALSE Values with Operators in Excel Worksheet

7.1 Student Marks - Copying Basic Formulas in Excel Worksheet.xlsx

7. Copying Basic Formulas in Excel Worksheet

8.1 Daily Living Expenses.xlsx

8. Using Functions in Formulas in Excel Worksheet

9.1 What Goes into a Function.xlsx

9. Looking at What Goes into a Function in Excel

10.1 A Basic Expenses List.xlsx

10. Editing Formulas Including Cell Range in Excel Worksheet

11.1 Company Inventory List.xlsx

11. Using the SUM Function from the Editing or Formula Library Group

12.1 Daily Living Expenses Full Year.xlsx

12. Calculating with Formulas in Both Directions in Excel

13.1 Profit & Loss Projection.xlsx

13. How To Use the SUM Function for Multiple Range of Cells

14.1 Loan Calculator.xlsx

14. Adding Column and Row Labels in SUM Function in Excel Formula

15.1 Basic Menu Items.xlsx

15. Using the Absolute Reference in Excel Formulas

16.1 Product Tax Calculation.xlsx

16. Using Names in Building Formulas in Excel

17.1 Five Years Average Sale.xlsx

17. Exploring the Normal AVERAGE Function in Excel

18.1 January Sale - Exploring the COUNT NUMBERS Function.xlsx

18. Exploring the COUNT NUMBERS Function in Excel

19.1 Total Wedding Budget.xlsx

19. Exploring the MIN and MAX Functions in Excel

20.1 Yealy Expenses.xlsx

20. Using the Insert Function Button in Excel

21.1 Total Wedding Budget with Status.xlsx

21. Exploring the Basic IF Function in Excel Worksheet

22.1 Gradebook and Assignments.xlsx

22. Exploring the IFS Function in Excel Worksheet

23.1 Project Invoice.xlsx

23. Exploring the COUNTIF Function in Excel Worksheet

24.1 A Basic Contact List.xlsx

24. Exploring the FILTER Function in Excel Worksheet

25.1 A Basic Sale Table.xlsx

25. Exploring the SUMIF Function in Excel Worksheet

26.1 Basic Sale List - SUMIF Function.xlsx

26. Exploring the SUMIFS Function in Excel Worksheet

27.1 Basic Food Budget.xlsx

27. Exploring the FIND and REPLACE Dialog Box in Excel

28.1 FIND Function.xlsx

28. Exploring the FIND Function in Excel Worksheet

29.1 A Basic Car List.xlsx

29. Exploring the SEARCH Function in Excel Worksheet

30.1 Loan Amortization Schedule.xlsx

30. Exploring the VLOOKUP Function in Excel Worksheet

31.1 Element List Element Names and Numbers.xlsx

31. Exploring the XLOOKUP Function in Excel Worksheet

32.1 A Basic List of Employees.xlsx

32. Exploring the MATCH Function in Excel Worksheet

33.1 Exploring the Formulas Tab in Excel Ribbon Bar.xlsx

33. Exploring the Formulas Tab in Excel Ribbon Bar

34.1 Basic Food Budgeting.xlsx

34. Defining Name Groups and Use in Formula in Excel

35.1 Basic Food Budgeting - Managing Defined Names.xlsx

35. Managing Defined Names for Excel Formulas

15. Copying and Moving Contents Around in Excel

1.1 ClipBoardGroup Review.xlsx

1. Reviewing the Clipboard Group in Home Tab in Excel

2.1 ExerciseFile-Cut-Copy-Paste-Commands.xlsx

2. Using the Cut Command in Excel

3.1 ExerciseFile-Cut-Copy-Paste-Commands.xlsx

3. Using the Copy Command in Excel

4.1 Homework Log Exercise File.xlsx

4. Using the Format Painter in Excel

5.1 Moving the Cell Content with Mouse in Excel.xlsx

5. Moving the Cell Content with Mouse in Excel

16. Creating and Managing Worksheets in Excel

1. Understanding the Microsoft Excel Workbook and Worksheets

2. Inserting New Sheets in an Excel Workbook

3. Using the Tab Scrolling Buttons for Sheets

4. Active Sheets and Moving Between Sheets

5. Renaming Sheets in an Excel Workbook

6. Deleting Sheets in an Excel Workbook

7. Moving Sheet Tabs in an Excel Workbook

8. Moving a Sheet Tab to a New Excel Workbook

9. Changing Sheet Tab Color in an Excel Workbook

10. Create a New Copy of a Sheet in an Excel Workbook

11. Assigin an Image as the Sheet Background in Excel

12. Hiding and Unhiding Excel Sheets

13. Selecting Multiple Sheets in a Excel Workbook Project

14. Preventing Sheet Actions in Microsoft Excel

15.1 Moving Cell Contents between Worksheets in Excel.xlsx

15. Moving Cell Contents between Worksheets in Excel

17. Adding Graphic Obejcts in Microsoft Excel Projects

1. Introduction to Adding Graphic Objects in Excel Worksheet

2.1 Introduction to Adding Graphic Objects.xlsx

2. Adding Pictures and Photos in Excel Worksheet from Stock Images

3.1 Adding Icons in an Excel Worksheet.xlsx

3. Adding Icons in an Excel Worksheet

4. Reviewing the Basics of Working with Shapes in Excel

5. Adding 3D Models in an Excel Worksheet

18. Presenting and Printing Excel Data

1.1 Exercise File - Basic Conditional Formatting.xlsx

1. Introduction to Using Conditional Formatting

2.1 Exercise File - Basic Conditional Formatting.xlsx

2. Creating Custom Conditional Formatting Rules in Excel

3.1 Managing Conditional Formatting Rules in Excel

3. Managing Conditional Formatting Rules in Excel

4. Protecting Worksheets with Password in Excel

5. Sharing Workbooks with Others

6. Printing a Worksheet in Excel

7. Clearing Conditional Formatting in Excel.html

19. Data Management in Microsoft Excel

1. Creating a Blank Table in Excel Worksheet

2.1 Project Invoice - Designing the Basic Table in Microsoft Excel.xlsx

2. Designing the Basic Table in Microsoft Excel

3. Exploring the Elements of an Excel table

4. Inserting a New Field and Record in an Excel Table

5.1 Project Invoice - Changing the Basic Properties.xlsx

5. Changing the Basic Properties of a Table in Excel

6. Difference between a Field and a Column in a Table.html

7.1 Project Invoice - Changing the Field and Columns Size of a Table in Excel.xlsx

7. Changing the Row and Columns Size of a Table in Excel

8. Applying a Standard Conditional Formatting in Excel.html

9.1 Project Invoice - Deleting Record and Fields and in an Excel Table.xlsx

9. Deleting Record and Fields and in an Excel Table

10.1 Project Invoice - Eliminating Duplicated Records.xlsx

10. Eliminating Duplicated Records in the Table in Excel

11.1 Start Up Cost - Sorting Records in a Single Field in the Table in Excel.xlsx

11. Sorting Records in a Single Field in the Table in Excel

12.1 Food Budget - Exploring the Multi Level Sorting in Excel.xlsx

12. Exploring the Multi Level Sorting in Excel

13.1 Food Budget - Sorting on Cell Colors.xlsx

13. Sorting a Table on Cell Colors in Excel

14.1 Basic Employee List.xlsx

14. Basic Filtering by Selecting a Specific Field Entries

15. Using the Text Filter Option in Excel

16.1 Basic Employee List - Using the Number Filter Option in Excel.xlsx

16. Using the Number Filter Option in Excel

17.1 Basic Employee List - Using the Date Filter Option in Excel.xlsx

17. Using the Date Filter Option in Excel

18. Filtering a Table on a Fields Font and Fill Color.html

19.1 Basic Employee List - Creating a Basic Pivot Table in Excel Worksheet.xlsx

19. Creating a Basic Pivot Table in Excel Worksheet

20.1 Basic Employee List - Sorting Data in a PivotTable in Excel.xlsx

20. Sorting Data in a PivotTable in Excel

21.1 Basic Employee List - Filtering Data in a PivotTable in Excel.xlsx

21. Filtering Data in a PivotTable in Excel

22.1 Basic Employee List - Deleting a PivotTable in Excel.xlsx

22. Deleting a PivotTable in Excel

20. Adding Charts and Visualization Graphics in Microsoft Excel Projects

1. Understanding the Pupose of Charts and Graphs

2. Creating Basic Charts in Excel Worksheet

3.1 Chart Type, Style and Layout.xlsx

3. Changing Chart Types and Layouts in Excel

4. Customizing the Basic Elements of a Chart in Excel

5. Creating a PivotChart in Excel Worksheet.html

21. Collaboration and Sharing in Excel

1. Collaboration and Sharing in Excel.html

45,900 تومان

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

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

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

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