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

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 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 29270
    حجم: 4433 مگابایت
    مدت زمان: 450 دقیقه
    تاریخ انتشار: 25 دی 1402

    45,900 تومان
    افزودن به سبد خرید