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

Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

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

Become a Microsoft Excel 2021/365 expert with this three-course bundle


1. Excel 2021 Beginner Introduction
  • 1. Course Introduction
  • 2. WATCH ME Essential Information for a Successful Training Experience
  • 3.1 Excel 2021 Exercise Files.zip
  • 3. DOWNLOAD ME Course Exercise Files.html
  • 4.1 Excel 2021 Course Files.zip
  • 4. DOWNLOAD ME Course Instructor Files.html
  • 5. Excel 2021 vs Excel for Microsoft 365
  • 6. Section Quiz.html

  • 2. Beginner Getting Started in Excel 2021
  • 1. Launching Excel
  • 2. The Start Screen
  • 3. Exploring the Interface
  • 4. Understanding Ribbons, Tabs and Menus
  • 5. The Backstage Area
  • 6. Customizing the Quick Access Toolbar
  • 7. Useful Keyboard Shortcuts
  • 8. Getting Help
  • 9. Exercise 01
  • 10. Section Quiz.html

  • 3. Beginner Creating You First Excel Spreadsheet
  • 1. Working with Excel Templates
  • 2. Working with Workbooks and Worksheets
  • 3. Saving Workbooks and Worksheets
  • 4. Entering and Editing Data
  • 5. Navigating and Selecting Cells, Rows and Columns
  • 6. Exercise 02
  • 7. Section Quiz.html

  • 4. Beginner Introduction to Excel Formulas and Functions
  • 1. Formulas and Functions Explained
  • 2. Performing Calculations with the SUM Function
  • 3. Counting Values and Blanks
  • 4. Finding the Average with the AVERAGE Function
  • 5. Working with the MIN and MAX Functions
  • 6. Handling Errors in Formulas
  • 7. Absolute vs Relative Referencing
  • 8. Autosum and AutoFill
  • 9. Flash Fill
  • 10. Exercise 03
  • 11. Section Quiz.html

  • 5. Beginner Using Named Ranges
  • 1. What are Named Ranges
  • 2. Creating Named Ranges
  • 3. Managing Named Ranges
  • 4. Using Named Ranges in Calculations
  • 5. Exercise 04
  • 6. Section Quiz.html

  • 6. Beginner Formatting Numbers and Cells
  • 1. Applying Number Formats
  • 2. Applying Date and Time Formats
  • 3. Formatting Cells, Rows and Columns
  • 4. Using Format Painter
  • 5. Exercise 05
  • 6. Section Quiz.html

  • 7. Beginner Formatting Worksheets
  • 1. Working with Rows and Columns
  • 2. Deleting and Clearing Cells
  • 3. Aligning Text and Numbers
  • 4. Applying Themes and Styles
  • 5. Exercise 06
  • 6. Section Quiz.html

  • 8. Beginner Working with Excel Lists
  • 1. How to Structure a List
  • 2. Sorting a List (Single-Level Sort)
  • 3. Sorting a List (Multi-Level Sort)
  • 4. Sorting Using a Custom List (Custom Sort)
  • 5. Using Autofilter to Filter a List
  • 6. Format as a Table
  • 7. Creating Subtotals in a List
  • 8. Exercise 07
  • 9. Section Quiz.html

  • 9. Beginner Moving and Linking to Data
  • 1. Using Cut and Copy
  • 2. Paste Options
  • 3. Pasting from the Clipboard
  • 4. Linking to Other Worksheets and Workbooks
  • 5. 3D Referencing
  • 6. Inserting Hyperlinks to Worksheets
  • 7. Exercise 08
  • 8. Section Quiz.html

  • 10. Beginner An Introduction to Intermediate Formulas
  • 1. Looking up Information with VLOOKUP
  • 2. VLOOKUP Approximate Match
  • 3. Error Handling Functions
  • 4. Basic Logical Functions (IF, AND, OR)
  • 5. Making Decisions with IF Statements
  • 6. Cleaning Data using Text Functions
  • 7. Working with Time and Date Functions
  • 8. Exercise 09
  • 9. Section Quiz.html

  • 11. Beginner Analyzing Data with Charts
  • 1. Choosing the Correct Chart Type
  • 2. Presenting Data with Charts
  • 3. Formatting Charts
  • 4. Exercise 10
  • 5. Section Quiz.html

  • 12. Beginner Conditional Formatting
  • 1. Highlighting Cell Values
  • 2. Data Bars
  • 3. Color Scales
  • 4. Icon Sets
  • 5. Exercise 11
  • 6. Section Quiz.html

  • 13. Beginner Inserting Items into a Spreadsheet
  • 1. Inserting Pictures
  • 2. Inserting Shapes and Text Boxes
  • 3. Inserting Icons and 3D Models
  • 4. Creating Diagrams using SmartArt
  • 5. Inserting Screenshots
  • 6. Inserting Comments
  • 7. Exercise 12
  • 8. Section Quiz.html

  • 14. Beginner Working with Views and Zoom
  • 1. Workbook Views
  • 2. Using Zoom in a Worksheet
  • 3. Arranging Workbooks and Worksheets
  • 4. Freezing Panes
  • 5. Exercise 13
  • 6. Section Quiz.html

  • 15. Beginner Page Layout and Print Options
  • 1. Setting Margins and Orientation
  • 2. Setting and Clearing the Print Area
  • 3. Inserting Page Breaks
  • 4. Setting Print Titles and a Background
  • 5. Inserting Headers and Footers
  • 6. Printing a Workbook
  • 7. Exercise 14
  • 8. Section Quiz.html

  • 16. Beginner Finalizing the Spreadsheet
  • 1. Protecting Workbooks and Worksheets
  • 2. Spell Checking
  • 3. Inspecting the Workbook
  • 4. Saving the Workbook in Different Formats
  • 5. Sharing a Workbook
  • 6. Exercise 15
  • 7. Section Quiz.html

  • 17. Excel 2021 Beginner Course Close
  • 1. Course Close

  • 18. Excel 2021 Intermediate Introduction
  • 1. Course Introduction
  • 2. WATCH ME Essential Information for a Successful Training Experience
  • 3.1 Excel 2021 Intermediate Exercise Files.zip
  • 3. DOWNLOAD ME Course Exercise Files.html
  • 4.1 Excel 2021 Intermediate Course Files.zip
  • 4. DOWNLOAD ME Course Instructor Files.html
  • 5. Section Quiz.html

  • 19. Intermediate Designing Better Spreadsheets
  • 1. The Golden Rules of Spreadsheet Design
  • 2. Improving Readability with Cell Styles
  • 3. Controlling Data Input
  • 4. Adding Navigation Buttons
  • 5. Section Quiz.html

  • 20. Intermediate Making Decisions with Logical Functions
  • 1. Logical Functions (AND, OR, IF)
  • 2. The IF Function
  • 3. Nested IFs
  • 4. The IFS Function
  • 5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)
  • 6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)
  • 7. Error Handling with IFERROR and IFNA
  • 8. Exercise 01
  • 9. Section Quiz.html

  • 21. Intermediate Looking Up Information
  • 1. Looking Up Information using VLOOKUP (Exact Match)
  • 2. Looking Up Information using VLOOKUP (Approx Match)
  • 3. Looking Up Information Horizontally Using HLOOKUP
  • 4. Performing Flexible Lookups With INDEX And MATCH
  • 5. Using XLOOKUP and XMATCH
  • 6. The OFFSET Function
  • 7. The INDIRECT Function
  • 8. Exercise 02
  • 9. Section Quiz.html

  • 22. Intermediate Advanced Sorting and Filtering
  • 1. Performing Sorts on Multiple Columns
  • 2. Sorting Using a Custom List
  • 3. The SORT and SORTBY Functions
  • 4. Using the Advanced Filter
  • 5. Extracting Unique Values - The UNIQUE Function
  • 6. The FILTER Function
  • 7. Exercise 03
  • 8. Section Quiz.html

  • 23. Intermediate Working with Date and Time
  • 1. Understanding How Dates are Stored in Excel
  • 2. Applying Custom Date Formats
  • 3. Using Date and Time Functions
  • 4. Using the WORKDAY and WORKDAY.INT Functions
  • 5. Using the NETWORKDAYS and NETWORKDAYS.INT Function
  • 6. Tabulate Date Differences with the DATEDIF Function
  • 7. Calculate Dates with EDATE and EOMONTH
  • 8. Exercise 04
  • 9. Section Quiz.html

  • 24. Intermediate Preparing Data for Analysis
  • 1. Importing Data into Excel
  • 2. Removing Blank Rows, Cells and Duplicates
  • 3. Changing Case and Removing Spaces
  • 4. Splitting Data using Text to Columns
  • 5. Splitting Data using Text Functions
  • 6. Splitting or Combining Cell Data Using Flash fill
  • 7. Joining Data using CONCAT
  • 8. Formatting Data as a Table
  • 9. Exercise 05
  • 10. Section Quiz.html

  • 25. Intermediate PivotTables
  • 1. PivotTables Explained
  • 2. Creating a PivotTable from Scratch
  • 3. Pivoting the PivotTable Fields
  • 4. Applying Subtotals and Grand Totals
  • 5. Applying Number Formatting to PivotTable Data
  • 6. Show Values As and Summarize Values By
  • 7. Grouping PivotTable Data
  • 8. Formatting Error Values and Empty Cells
  • 9. Choosing a Report Layout
  • 10. Applying PivotTable Styles
  • 11. Exercise 06
  • 12. Section Quiz.html

  • 26. Intermediate Pivot Charts
  • 1. Creating a Pivot Chart
  • 2. Formatting a Pivot Chart - Part 1
  • 3. Formatting a Pivot Chart - Part 2
  • 4. Using Map Charts
  • 5. Exercise 07
  • 6. Section Quiz.html

  • 27. Intermediate Adding Interaction to PivotTables and Charts
  • 1. Inserting and Formatting Slicers
  • 2. Inserting Timeline Slicers
  • 3. Connecting Slicers to Pivot Charts
  • 4. Updating PivotTable Data
  • 5. Exercise 08
  • 6. Section Quiz.html

  • 28. Intermediate Interactive Dashboards
  • 1. What is a Dashboard
  • 2. Assembling a Dashboard - Part 1
  • 3. Assembling a Dashboard - Part 2
  • 4. Assembling a Dashboard - Part 3
  • 5. Exercise 09
  • 6. Section Quiz.html

  • 29. Intermediate Formula Auditing
  • 1. Troubleshooting Common Errors
  • 2. Tracing Precedents and Formula Auditing
  • 3. Exercise 10
  • 4. Section Quiz.html

  • 30. Intermediate Data Validation
  • 1. Creating Dynamic Drop-down Lists
  • 2. Other Types of Data Validation
  • 3. Custom Data Validation
  • 4. Exercise 11
  • 5. Section Quiz.html

  • 31. Intermediate WhatIf Analysis Tools
  • 1. Goal Seek and the PMT Function
  • 2. Using Scenario Manager
  • 3. Data Tables One Variable
  • 4. Data Tables Two Variables
  • 5. Exercise 12
  • 6. Section Quiz.html

  • 32. Excel 2021 Intermediate Course Close
  • 1. Course Close

  • 33. Excel 2021 Advanced Introduction
  • 1. Course Introduction
  • 2. WATCH ME Essential Information for a Successful Training Experience
  • 3.1 Excel 2021 Advanced Exercise Files.zip
  • 3. DOWNLOAD ME Course Exercise Files.html
  • 4.1 Excel 2021 Advanced Course Files.zip
  • 4. DOWNLOAD ME Course Files.html
  • 5. Exercise 01
  • 6. Section Quiz.html

  • 34. Advanced Dynamic Arrays
  • 1. What are Dynamic Arrays
  • 2. Introduction to Spills and Arrays
  • 3. Extract and Count Unique Entries
  • 4. Unique vs Distinct
  • 5. Extract Unique Values with Multiple Criteria
  • 6. Extract Unique Values by Column
  • 7. The SORT Function
  • 8. The SORT Function - Horizontal SORT
  • 9. The SORTBY Function
  • 10. The SORTBY Function - Horizontal SORT
  • 11. Simple SEQUENCE and Unstacking Records
  • 12. The FILTER Function
  • 13. FILTER with Logic + Operator (OR)
  • 14. FILTER with Logic Operator (AND)
  • 15. FILTER with Logic = Operator (Both or Neither)
  • 16. FILTER with Logic - Operator (One or the Other)
  • 17. Using RANDARRAY and RANDBETWEEN to Randomize Data
  • 18. Using XLOOKUP to Perform Complex Lookups
  • 19. Using XMATCH
  • 20. Exercise 02
  • 21. Section Quiz.html

  • 35. Advanced Advanced Lookup and Reference Functions
  • 1. Performing 2-Way Lookups
  • 2. Using the CHOOSE Function
  • 3. Using the SWITCH Function
  • 4. Exercise 03
  • 5. Section Quiz.html

  • 36. Advanced Statistical Functions
  • 1. Using MEDIAN, MODE.SNGL and MODE.MULT
  • 2. Using LARGE and SMALL
  • 3. Ranking Data with Sorting using RANK.EQ and RANK.AVG
  • 4. The COUNTBLANK Function
  • 5. Exercise 04
  • 6. Section Quiz.html

  • 37. Advanced Math Functions
  • 1. Rounding Values using ROUND, ROUNDUP and ROUNDDOWN
  • 2. Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH)
  • 3. Using the AGGREGATE Function
  • 4. Exercise 05
  • 5. Section Quiz.html

  • 38. Advanced New Functions - LET and LAMBDA
  • 1. The LET Function
  • 2. The LAMBDA Function
  • 3. Exercise 06
  • 4. Section Quiz.html

  • 39. Advanced Advanced PivotTables and Pivot Charts
  • 1. Creating a Custom PivotTable Style
  • 2. Applying Custom Number Formatting
  • 3. Sorting Using Custom Lists
  • 4. Applying Multiple Filters to Data
  • 5. Adjusting Slicer Settings
  • 6. Locking Workbooks but not Slicers
  • 7. Creating a Calculated Field
  • 8. Creating a Calculated Item
  • 9. Solve Order
  • 10. GETPIVOTDATA
  • 11. Using GETPIVOTDATA - Dependent Data Validation Lists
  • 12. Creating a Dynamic Pivot Chart Title
  • 13. Adding a Dynamic Series to a Pivot Chart
  • 14. Adding Totals to a Stacked Column Chart
  • 15. Exercise 07
  • 16. Section Quiz.html

  • 40. Advanced Form Controls
  • 1. Introduction to Form Controls
  • 2. Combo Box - Select from a List
  • 3. Check Box - CheckUncheck Option
  • 4. Option Button - Choose an Option
  • 5. Spin Button - Move Up and Down a List
  • 6. List Box - Select from a List of Items
  • 7. Scroll Bar - Scroll Through a List
  • 8. Exercise 08
  • 9. Section Quiz.html

  • 41. Advanced Working with Power Query
  • 1. Power Query Overview
  • 2. Importing Data Using Get and Transform
  • 3. The Power Query Editor
  • 4. Combining Files
  • 5. Transforming Files
  • 6. Loading Files into Excel
  • 7. Exercise 09
  • 8. Section Quiz.html

  • 42. Advanced Forecasting
  • 1. Getting Forecast Data with FRED
  • 2. Creating a Linear Sales Forecast
  • 3. Creating a Sales Forecast with Seasonality
  • 4. Adding Confidence Levels
  • 5. Using Forecast Sheets
  • 6. Exercise 10
  • 7. Section Quiz.html

  • 43. Advanced Macros and VBA
  • 1. Using Macros to Automate Tasks
  • 2. Recording, Saving and Running Macros
  • 3. Recording a Macro with Relative Referencing
  • 4. Multi-step Macros
  • 5. The VBA Editor
  • 6. Assigning Macros to Buttons
  • 7. Creating a Custom Macro Ribbon
  • 8. Exercise 11
  • 9. Section Quiz.html

  • 44. Advanced Practical Excel - Advanced Formulas
  • 1. Finding the Last Occurrence of a Value
  • 2. Finding the Closest Value
  • 3. Extract Data from the Middle of a String
  • 4. Exercise 12
  • 5. Section Quiz.html

  • 45. Excel 2021 Advanced Course Close
  • 1. Course Close
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 773
    حجم: 15046 مگابایت
    مدت زمان: 1832 دقیقه
    تاریخ انتشار: ۲۶ دی ۱۴۰۱
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید