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

The Ultimate Microsoft Office 2021/365 Training Bundle

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

Learn the essentials of Microsoft Office in this 6-course bundle for Office 365 or Office 2021 users.


01 - Excel 2021 Beginners Introduction
  • 001 About This Bundle
  • 002 Course Introduction
  • 003 WATCH ME Essential Information for a Successful Training Experience
  • 004 DOWNLOAD ME Course Exercise Files.html
  • 004 Excel-2021-Exercise-Files.zip
  • 005 DOWNLOAD ME Course Instructor Files.html
  • 005 Excel-2021-Course-Files.zip
  • 006 Downloadable Course Transcript.html
  • 006 Excel-2021-Beginners-Transcription.pdf
  • 007 Excel 2021 vs Excel for Microsoft 365

  • 02 - Excel 2021 Beginners Getting Started in Excel 2021
  • 001 Launching Excel
  • 002 The Start Screen
  • 003 Exploring the Interface
  • 004 Understanding Ribbons, Tabs and Menus
  • 005 The Backstage Area
  • 006 Customizing the Quick Access Toolbar
  • 007 Useful Keyboard Shortcuts
  • 008 Getting Help
  • 009 Exercise 01

  • 03 - Excel 2021 Beginners Creating You First Excel Spreadsheet
  • 001 Working with Excel Templates
  • 002 Working with Workbooks and Worksheets
  • 003 Saving Workbooks and Worksheets
  • 004 Entering and Editing Data
  • 005 Navigating and Selecting Cells, Rows and Columns
  • 006 Exercise 02

  • 04 - Excel 2021 Beginners Introduction to Excel Formulas and Functions
  • 001 Formulas and Functions Explained
  • 002 Performing Calculations with the SUM Function
  • 003 Counting Values and Blanks
  • 004 Finding the Average with the AVERAGE Function
  • 005 Working with the MIN and MAX Functions
  • 006 Handling Errors in Formulas
  • 007 Absolute vs Relative Referencing
  • 008 Autosum and AutoFill
  • 009 Flash Fill
  • 010 Exercise 03

  • 05 - Excel 2021 Beginners Using Named Ranges
  • 001 What are Named Ranges
  • 002 Creating Named Ranges
  • 003 Managing Named Ranges
  • 004 Using Named Ranges in Calculations
  • 005 Exercise 04

  • 06 - Excel 2021 Beginners Formatting Numbers and Cells
  • 001 Applying Number Formats
  • 002 Applying Date and Time Formats
  • 003 Formatting Cells, Rows and Columns
  • 004 Using Format Painter
  • 005 Exercise 05

  • 07 - Excel 2021 Beginners Formatting Worksheets
  • 001 Working with Rows and Columns
  • 002 Deleting and Clearing Cells
  • 003 Aligning Text and Numbers
  • 004 Applying Themes and Styles
  • 005 Exercise 06

  • 08 - Excel 2021 Beginners Working with Excel Lists
  • 001 How to Structure a List
  • 002 Sorting a List (Single-Level Sort)
  • 003 Sorting a List (Multi-Level Sort)
  • 004 Sorting Using a Custom List (Custom Sort)
  • 005 Using Autofilter to Filter a List
  • 006 Format as a Table
  • 007 Creating Subtotals in a List
  • 008 Exercise 07

  • 09 - Excel 2021 Beginners Moving and Linking to Data
  • 001 Using Cut and Copy
  • 002 Paste Options
  • 003 Pasting from the Clipboard
  • 004 Linking to Other Worksheets and Workbooks
  • 005 3D Referencing
  • 006 Inserting Hyperlinks to Worksheets
  • 007 Exercise 08

  • 10 - Excel 2021 Beginners An Introduction to Intermediate Formulas
  • 001 Looking up Information with VLOOKUP
  • 002 VLOOKUP Approximate Match
  • 003 Error Handling Functions
  • 004 Basic Logical Functions (IF, AND, OR)
  • 005 Making Decisions with IF Statements
  • 006 Cleaning Data using Text Functions
  • 007 Working with Time and Date Functions
  • 008 Exercise 09

  • 11 - Excel 2021 Beginners Analyzing Data with Charts
  • 001 Choosing the Correct Chart Type
  • 002 Presenting Data with Charts
  • 003 Formatting Charts
  • 004 Exercise 10

  • 12 - Excel 2021 Beginners Conditional Formatting
  • 001 Highlighting Cell Values
  • 002 Data Bars
  • 003 Color Scales
  • 004 Icon Sets
  • 005 Exercise 11

  • 13 - Excel 2021 Beginners Inserting Items into a Spreadsheet
  • 001 Inserting Pictures
  • 002 Inserting Shapes and Text Boxes
  • 003 Inserting Icons and 3D Models
  • 004 Creating Diagrams using SmartArt
  • 005 Inserting Screenshots
  • 006 Inserting Comments
  • 007 Exercise 12

  • 14 - Excel 2021 Beginners Working with Views and Zoom
  • 001 Workbook Views
  • 002 Using Zoom in a Worksheet
  • 003 Arranging Workbooks and Worksheets
  • 004 Freezing Panes
  • 005 Exercise 13

  • 15 - Excel 2021 Beginners Page Layout and Print Options
  • 001 Setting Margins and Orientation
  • 002 Setting and Clearing the Print Area
  • 003 Inserting Page Breaks
  • 004 Setting Print Titles and a Background
  • 005 Inserting Headers and Footers
  • 006 Printing a Workbook
  • 007 Exercise 14

  • 16 - Excel 2021 Beginners Finalizing the Spreadsheet
  • 001 Protecting Workbooks and Worksheets
  • 002 Spell Checking
  • 003 Inspecting the Workbook
  • 004 Saving the Workbook in Different Formats
  • 005 Sharing a Workbook
  • 006 Exercise 15

  • 17 - Excel 2021 Beginners Course Close
  • 001 Course Close

  • 18 - Word 2021 Introduction
  • 001 Course Introduction
  • 002 WATCH ME Essential Information for a Successful Training Experience
  • 003 DOWNLOAD ME Course Exercise Files.html
  • 003 Word-2021-Exercise-Files.zip
  • 004 DOWNLOAD ME Course Instructor Files.html
  • 004 Word-2021-Course-Files.zip
  • 005 DOWNLOAD ME Course Transcript.html
  • 005 Word-2021-transcript.pdf
  • 006 Exercise 01

  • 19 - Word 2021 - The Basics
  • 001 The Start Screen
  • 002 Explore the Word Interface
  • 003 Work with the Ruler and Zoom
  • 004 Check Spelling as You Type
  • 005 Customize the Quick Access Toolbar
  • 006 Keyboard Shortcuts
  • 007 Screentips, Contextual Menus and Ribbons
  • 008 Get Help
  • 009 Exercise 02

  • 20 - Word 2021 Get Started - Work with Documents
  • 001 Create and Save a Document
  • 002 Open and Edit an Existing Document
  • 003 Create a Document from a Template
  • 004 Navigate Around a Document
  • 005 Find Tools in Word
  • 006 Exercise 03

  • 21 - Word 2021 View Documents
  • 001 Switch Document Views
  • 002 Use the Immersive Reader and Focus
  • 003 Dark Mode
  • 004 Exercise 04

  • 22 - Word 2021 Work with Text
  • 001 Enter Text and Apply Basic Formatting
  • 002 Make Selections
  • 003 Advanced Text Formatting
  • 004 Move Text with Cut, Copy and Paste
  • 005 Copy Formatting Using Format Painter
  • 006 Paste Options
  • 007 Find and Replace
  • 008 Exercise 05

  • 23 - Word 2021 Work with Paragraphs
  • 001 Format Paragraphs and Alignment
  • 002 Line Spacing Options
  • 003 Work with Non-Printing Characters
  • 004 Bullets and Numbered Lists
  • 005 Indent Paragraphs
  • 006 Align Text with Tabs
  • 007 Exercise 06

  • 24 - Word 2021 Themes
  • 001 Apply a Theme
  • 002 Create a Custom Theme
  • 003 Exercise 07

  • 25 - Word 2021 Word Styles
  • 001 Why Styles are Useful
  • 002 Apply Styles to Paragraphs
  • 003 Modify Styles in the Styles Pane
  • 004 Create a Custom Style
  • 005 Exercise 08

  • 26 - Word 2021 Insert Pictures, Tables and Other Objects
  • 001 Insert and Format Pictures
  • 002 Insert Stock and Online Pictures
  • 003 Text Wrapping
  • 004 Insert and Format Text Boxes
  • 005 Insert and Format Shapes
  • 006 Use the Selection Pane
  • 007 Insert Other Graphics
  • 008 Insert SmartArt, Charts and Screenshots
  • 009 Draw with Touch
  • 010 Organize Information in a Table
  • 011 Exercise 09

  • 27 - Word 2021 Format Pages
  • 001 Page Size and Margins
  • 002 Work with Section and Page Breaks
  • 003 Inserting Additional Pages (Cover Page and Blanks)
  • 004 Apply Columns
  • 005 Add Headers, Footers and Page Numbers
  • 006 Insert Hyperlinks
  • 007 Insert Bookmarks
  • 008 Use Quick Parts
  • 009 Exercise 10

  • 28 - Word 2021 References
  • 001 Modify and Update a Table of Contents
  • 002 Use Footnotes and Endnotes
  • 003 Build a Bibliography
  • 004 Insert Captions and a Table of Figures
  • 005 Create an Index
  • 006 Insert a Table of Authorities
  • 007 Insert Cross References
  • 008 Exercise 11

  • 29 - Word 2021 Mail Merge
  • 001 Use the Mail Merge Wizard to Create Letters
  • 002 Create Envelopes with Merge Fields
  • 003 Create Labels Using Merge Fields
  • 004 Exercise 12

  • 30 - Word 2021 Spelling and Grammar
  • 001 Check Spelling and Grammar
  • 002 Use Auto-correct to Fix Mistakes
  • 003 Exercise 13

  • 31 - Word 2021 Track Changes and Comments
  • 001 Use Track Changes
  • 002 Accept and Reject Changes
  • 003 Track Change Settings
  • 004 Add Comments
  • 005 Document Comparison
  • 006 Exercise 14

  • 32 - Word 2021 Finalize a Document
  • 001 Print Documents
  • 002 Document Properties
  • 003 Check a Document for Issues
  • 004 Protect a Document
  • 005 Share a File with Others
  • 006 Co-author Documents Online
  • 007 Exercise 15

  • 33 - Word 2021 Course Close
  • 001 Course Close

  • 34 - PowerPoint 2021 Introduction
  • 001 Introduction to PowerPoint 2021
  • 002 WATCH ME Essential Information for a Successful Training Experience
  • 003 DOWNLOAD ME Course Exercise Files.html
  • 003 PowerPoint-2021-Exercise-Files.zip
  • 004 DOWNLOAD ME Course Files.html
  • 005 Downloadable Course Transcripts.html
  • 005 PowerPoint-2021-Transcription.pdf
  • 006 Creating Visually Stunning Presentations
  • 007 Presentation Tips and Best Practice
  • 008 Free PowerPoint Resources
  • 009 Exercise 01

  • 35 - PowerPoint 2021 Getting Started in PowerPoint 2021
  • 001 The PowerPoint 2021 Interface
  • 002 Customizing the Quick Access Toolbar
  • 003 Opening, Closing, and Saving Presentations
  • 004 Using PowerPoint Templates
  • 005 Setting PowerPoint Options
  • 006 Exercise 02

  • 36 - PowerPoint 2021 Slides and Layouts
  • 001 Slide Layouts
  • 002 Adding, Arranging, and Duplicating Slides
  • 003 Reusing Slides from Other Presentations
  • 004 Creating Slides from an Outline
  • 005 Slide Themes and Backgrounds
  • 006 Exercise 03

  • 37 - PowerPoint 2021 Slide Workshop Title Slide
  • 001 Resizing a Background Image Crop and Fill
  • 002 Transparent Shape Overlays
  • 003 Drawing and Formatting Shapes
  • 004 Locking Shapes and Setting a Default Shape
  • 005 Merging Shapes
  • 006 Inserting a Logo Filling Shapes with Pictures
  • 007 Adding a Title and Subtitle Inserting Text Boxes
  • 008 Using the Eyedropper Tool
  • 009 Exercise 04

  • 38 - PowerPoint 2021 Selection, Alignment and Grouping
  • 001 Selecting Objects
  • 002 Arranging, Renaming, and Changing the Z-Order
  • 003 Aligning and Grouping Objects
  • 004 Exercise 05

  • 39 - PowerPoint 2021 Slide Workshop Meet The Team
  • 001 Duplicating and Reformatting Slides
  • 002 Filling Shapes with Images
  • 003 Copying Formatting Format Painter
  • 004 Bullets, Numbered Lists, and Paragraph Text
  • 005 The Morph Transition
  • 006 Exercise 06

  • 40 - PowerPoint 2021 Slide Workshop Divider Slides
  • 001 Merging Images Across Shapes
  • 002 Inserting and Formatting Icons
  • 003 Compressing Pictures
  • 004 Animating Objects Entrance, Emphasis, and Exit Effects
  • 005 Applying Multiple Animations
  • 006 Triggering Animations
  • 007 Organising Slides Slide Sorter View
  • 008 Exercise 07

  • 41 - PowerPoint 2021 Slide Workshop Our Destinations
  • 001 Adding Half-Page Image Slides
  • 002 Actions Linking to Slides
  • 003 Using Slide Zoom
  • 004 Inserting Hyperlinks to Slides, Websites, Documents, and Email
  • 005 Exercise 08

  • 42 - PowerPoint 2021 Slide Workshop Tables, Charts and Diagrams
  • 001 Adding and Formatting Tables
  • 002 Creating a Process Flow Diagram with SmartArt
  • 003 Creating a Custom Process Flow Diagram with Shapes and Connectors
  • 004 Creating an Organization Diagram with SmartArt
  • 005 Inserting Charts Line Chart
  • 006 Formatting Charts
  • 007 Exercise 09

  • 43 - PowerPoint 2021 More Graphics
  • 001 Inserting Stickers, Cut Out People, Illustrations, and Cartoon Images
  • 002 Removing an Image Background
  • 003 Exercise 10

  • 44 - PowerPoint 2021 Video, Audio and Screenshots
  • 001 Inserting and Editing Videos
  • 002 Creating a Motion Video Background
  • 003 Adding Audio Files
  • 004 Inserting Screenshots
  • 005 Recording the Screen
  • 006 Exercise 11

  • 45 - PowerPoint 2021 Slide Workshop Transitions, Zoom and Motion Paths
  • 001 Adding and Modifying Slide Transitions
  • 002 Advanced Morph
  • 003 Summary Zoom
  • 004 Pan and Zoom
  • 005 Animating Objects with Motion Paths
  • 006 Exercise 12

  • 46 - PowerPoint 2021 Master Slides
  • 001 What are Master Slides
  • 002 Modifying Master Slides
  • 003 Exercise 13

  • 47 - PowerPoint 2021 Extending PowerPoint with Add-ins
  • 001 PowerPoint Add-ins
  • 002 Countdown Timer Add-in
  • 003 QR Code Add-in
  • 004 Pro Word Cloud
  • 005 Exercise 14

  • 48 - PowerPoint 2021 Preparing Slides for Delivery
  • 001 Adding a Header and Footer
  • 002 Adding and Formatting Speaker Notes to a Presentation
  • 003 Using the Notes Master
  • 004 Hiding and Unhiding Slides
  • 005 Rehearse Timings
  • 006 Setting Up and Running a Custom Slide Show
  • 007 Adding and Replying to Comments
  • 008 Exercise 15

  • 49 - PowerPoint 2021 Delivering a Presentation
  • 001 Using Presenter View
  • 002 On-screen Presentation Options
  • 003 Record and Narrate a Presentation
  • 004 Exercise 16

  • 50 - PowerPoint 2021 Exporting, Sharing and Printing
  • 001 Sharing a Presentation
  • 002 Exporting a Presentation
  • 003 The Info Tab
  • 004 Protecting a Presentation
  • 005 Printing a Presentation
  • 006 Exercise 17

  • 51 - PowerPoint 2021 Course Close
  • 001 Course Close

  • 52 - Outlook 2021 Introduction
  • 001 Course Introduction
  • 002 WATCH ME Essential Information for a Successful Training Experience
  • 003 DOWNLOAD ME Course Exercise Files.html
  • 003 Outlook-2021-Exercise-Files.zip
  • 004 DOWNLOAD ME Course Instructor Files.html
  • 004 Outlook-2021-Course-Files.zip
  • 005 Downloadable Course Transcript.html
  • 005 Outlook-2021-transcript.pdf
  • 006 Staying Organized with Outlook 2021
  • 007 Exercise 01

  • 53 - Outlook 2021 Get Started and Connect Accounts
  • 001 Explore the Outlook 2021 Interface
  • 002 Configure a Microsoft Account
  • 003 Add a Gmail Account (IMAP)
  • 004 Check Spelling and Grammar Settings
  • 005 Customize the Quick Access Toolbar
  • 006 Using Outlook Today
  • 007 Get Help
  • 008 Exercise 02

  • 54 - Outlook 2021 Work with Mail - The Basics
  • 001 Send and Receive Mail
  • 002 Open and Read Mail
  • 003 Compose a Mail and Save to Drafts
  • 004 Insert Attachments
  • 005 Save Attachments from a Message
  • 006 Search and Find Mail
  • 007 Use Filters to Find Mail
  • 008 Customize the Inbox
  • 009 Exercise 03

  • 55 - Outlook 2021 Organize and Manage Mail
  • 001 Flag Messages as Junk
  • 002 Ignore Conversations
  • 003 Clean Up Conversations
  • 004 Apply Follow Up Flags and Set Reminders
  • 005 Assign Mail to Categories
  • 006 Organize Mail into Folders and Subfolders
  • 007 Make Emails Stand Out with Conditional Formatting
  • 008 Process Messages with Mail Rules
  • 009 Use Search Folders for Email Management
  • 010 Delete and Archive Mail
  • 011 Exercise 04

  • 56 - Outlook 2021 Create and Send Mail
  • 001 Create and Format a New Message
  • 002 Resend and Recall a Message
  • 003 Reply to and Forward a Message
  • 004 Create and Attach an Email Signature
  • 005 Create Voting Buttons
  • 006 Set Delivery Options
  • 007 Use Mentions to Target Specific People
  • 008 Translate and Read Messages Aloud
  • 009 Send an Out Of Office (Auto-Reply) Message
  • 010 Annotate Messages with Ink
  • 011 Insert Tables, Shapes, Icons and Other Items into a Mail
  • 012 Exercise 05

  • 57 - Outlook 2021 Work with Contacts
  • 001 Add a New Contact
  • 002 Import Contact Information from Excel
  • 003 Create Contact Groups
  • 004 Organize Contacts with Folders
  • 005 Share Contact Cards with Others
  • 006 Exercise 06

  • 58 - Outlook 2021 Manage Appointments and Meetings with the Calendar
  • 001 Customize Calendar Settings
  • 002 Create an Appointment or All Day Event
  • 003 Create and Respond to a Meeting Invite
  • 004 Add Delegates to Act on Your Behalf
  • 005 Work with Teams in Outlook
  • 006 Share Your Calendar and Open Other Calendars
  • 007 Exercise 07

  • 59 - Outlook 2021 Tasks and Notes
  • 001 Create Tasks in the ToDo List
  • 002 Edit, Assign and Monitor Tasks
  • 003 Create and Manage Notes
  • 004 Exercise 08

  • 60 - Outlook 2021 Outlook Settings
  • 001 Customize Outlook Settings
  • 002 The Navigation Pane
  • 003 Mailbox Cleanup
  • 004 Exercise 09

  • 61 - Outlook 2021 Course Close
  • 001 Course Close

  • 62 - Excel 2021 Intermediate Introduction
  • 001 Course Introduction
  • 002 WATCH ME Essential Information for a Successful Training Experience
  • 003 DOWNLOAD ME Course Exercise Files.html
  • 003 Excel-2021-Intermediate-Exercise-Files.zip
  • 004 DOWNLOAD ME Course Instructor Files.html
  • 004 Excel-2021-Intermediate-Course-Files.zip
  • 005 Downloadable Course Transcripts.html
  • 005 Microsoft-Excel-2021-Intermediate-transcript.pdf

  • 63 - Excel 2021 Intermediate Designing Better Spreadsheets
  • 001 The Golden Rules of Spreadsheet Design
  • 002 Improving Readability with Cell Styles
  • 003 Controlling Data Input
  • 004 Adding Navigation Buttons

  • 64 - Excel 2021 Intermediate Making Decisions with Logical Functions
  • 001 Logical Functions (AND, OR, IF)
  • 002 The IF Function
  • 003 Nested IFs
  • 004 The IFS Function
  • 005 Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)
  • 006 Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)
  • 007 Error Handling with IFERROR and IFNA
  • 008 Exercise 01

  • 65 - Excel 2021 Intermediate Looking Up Information
  • 001 Looking Up Information using VLOOKUP (Exact Match)
  • 002 Looking Up Information using VLOOKUP (Approx Match)
  • 003 Looking Up Information Horizontally Using HLOOKUP
  • 004 Performing Flexible Lookups With INDEX And MATCH
  • 005 Using XLOOKUP and XMATCH
  • 006 The OFFSET Function
  • 007 The INDIRECT Function
  • 008 Exercise 02

  • 66 - Excel 2021 Intermediate Advanced Sorting and Filtering
  • 001 Performing Sorts on Multiple Columns
  • 002 Sorting Using a Custom List
  • 003 The SORT and SORTBY Functions
  • 004 Using the Advanced Filter
  • 005 Extracting Unique Values - The UNIQUE Function
  • 006 The FILTER Function
  • 007 Exercise 03

  • 67 - Excel 2021 Intermediate Working with Date and Time
  • 001 Understanding How Dates are Stored in Excel
  • 002 Applying Custom Date Formats
  • 003 Using Date and Time Functions
  • 004 Using the WORKDAY and WORKDAY.INT Functions
  • 005 Using the NETWORKDAYS and NETWORKDAYS.INT Function
  • 006 Tabulate Date Differences with the DATEDIF Function
  • 007 Calculate Dates with EDATE and EOMONTH
  • 008 Exercise 04

  • 68 - Excel 2021 Intermediate Preparing Data for Analysis
  • 001 Importing Data into Excel
  • 002 Removing Blank Rows, Cells and Duplicates
  • 003 Changing Case and Removing Spaces
  • 004 Splitting Data using Text to Columns
  • 005 Splitting Data using Text Functions
  • 006 Splitting or Combining Cell Data Using Flash fill
  • 007 Joining Data using CONCAT
  • 008 Formatting Data as a Table
  • 009 Exercise 05

  • 69 - Excel 2021 Intermediate PivotTables
  • 001 PivotTables Explained
  • 002 Creating a PivotTable from Scratch
  • 003 Pivoting the PivotTable Fields
  • 004 Applying Subtotals and Grand Totals
  • 005 Applying Number Formatting to PivotTable Data
  • 006 Show Values As and Summarize Values By
  • 007 Grouping PivotTable Data
  • 008 Formatting Error Values and Empty Cells
  • 009 Choosing a Report Layout
  • 010 Applying PivotTable Styles
  • 011 Exercise 06

  • 70 - Excel 2021 Intermediate Pivot Charts
  • 001 Creating a Pivot Chart
  • 002 Formatting a Pivot Chart - Part 1
  • 003 Formatting a Pivot Chart - Part 2
  • 004 Using Map Charts
  • 005 Exercise 07

  • 71 - Excel 2021 Intermediate Adding Interaction to PivotTables and Charts
  • 001 Inserting and Formatting Slicers
  • 002 Inserting Timeline Slicers
  • 003 Connecting Slicers to Pivot Charts
  • 004 Updating PivotTable Data
  • 005 Exercise 08

  • 72 - Excel 2021 Intermediate Interactive Dashboards
  • 001 What is a Dashboard
  • 002 Assembling a Dashboard - Part 1
  • 003 Assembling a Dashboard - Part 2
  • 004 Assembling a Dashboard - Part 3
  • 005 Exercise 09

  • 73 - Excel 2021 Intermediate Formula Auditing
  • 001 Troubleshooting Common Errors
  • 002 Tracing Precedents and Formula Auditing
  • 003 Exercise 10

  • 74 - Excel 2021 Intermediate Data Validation
  • 001 Creating Dynamic Drop-down Lists
  • 002 Other Types of Data Validation
  • 003 Custom Data Validation
  • 004 Exercise 11

  • 75 - Excel 2021 Intermediate WhatIf Analysis Tools
  • 001 Goal Seek and the PMT Function
  • 002 Using Scenario Manager
  • 003 Data Tables One Variable
  • 004 Data Tables Two Variables
  • 005 Exercise 12

  • 76 - Excel 2021 Intermediate Course Close
  • 001 Course Close

  • 77 - Bonuses
  • 001 Ten Excel Tips and Tricks - Part 1
  • 002 Ten Excel Tips and Tricks - Part 2
  • 003 Ten Excel Tips and Tricks - Part 3

  • 78 - Excel 2021 Advanced Introduction
  • 001 Course Introduction
  • 002 WATCH ME Essential Information for a Successful Training Experience
  • 003 DOWNLOAD ME Course Demo Files.html
  • 003 Excel-2021-Advanced-Course-Files.zip
  • 004 DOWNLOAD ME Course Exercise Files.html
  • 004 Excel-2021-Advanced-Exercises-Files.zip
  • 005 Exercise 01

  • 79 - Excel 2021 Advanced Dynamic Arrays
  • 001 What are Dynamic Arrays
  • 002 Introduction to Spills and Arrays
  • 003 Extract and Count Unique Entries
  • 004 Unique vs Distinct
  • 005 Extract Unique Values with Multiple Criteria
  • 006 Extract Unique Values by Column
  • 007 The SORT Function
  • 008 The SORT Function - Horizontal SORT
  • 009 The SORTBY Function
  • 010 The SORTBY Function - Horizontal SORT
  • 011 Simple SEQUENCE and Unstacking Records
  • 012 The FILTER Function
  • 013 FILTER with Logic + Operator (OR)
  • 014 FILTER with Logic Operator (AND)
  • 015 FILTER with Logic = Operator (Both or Neither)
  • 016 FILTER with Logic - Operator (One or the Other)
  • 017 Using RANDARRAY and RANDBETWEEN to Randomize Data
  • 018 Using XLOOKUP to Perform Complex Lookups
  • 019 Using XMATCH
  • 020 Exercise 02

  • 80 - Excel 2021 Advanced Advanced Lookup and Reference Functions
  • 001 Performing 2-Way Lookups
  • 002 Using the CHOOSE Function
  • 003 Using the SWITCH Function
  • 004 Exercise 03

  • 81 - Excel 2021 Advanced Statistical Functions
  • 001 Using MEDIAN, MODE.SNGL and MODE.MULT
  • 002 Using LARGE and SMALL
  • 003 Ranking Data with Sorting using RANK.EQ and RANK.AVG
  • 004 The COUNTBLANK Function
  • 005 Exercise 04

  • 82 - Excel 2021 Advanced Math Functions
  • 001 Creating a Custom PivotTable Style
  • 002 Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH)
  • 003 Using the AGGREGATE Function
  • 004 Exercise 05

  • 83 - Excel 2021 Advanced New Functions - LET and LAMBDA
  • 001 The LET Function
  • 002 The LAMBDA Function
  • 003 Exercise 06

  • 84 - Excel 2021 Advanced Advanced PivotTables and Pivot Charts
  • 001 Creating a Custom PivotTable Style
  • 002 Applying Custom Number Formatting
  • 003 Sorting Using Custom Lists
  • 004 Applying Multiple Filters to Data
  • 005 Adjusting Slicer Settings
  • 006 Locking Workbooks but not Slicers
  • 007 Creating a Calculated Field
  • 008 Creating a Calculated Item
  • 009 Solve Order
  • 010 GETPIVOTDATA
  • 011 Using GETPIVOTDATA - Dependent Data Validation Lists
  • 012 Creating a Dynamic Pivot Chart Title
  • 013 Adding a Dynamic Series to a Pivot Chart
  • 014 Adding Totals to a Stacked Column Chart
  • 015 Exercise 07

  • 85 - Excel 2021 Advanced Form Controls
  • 001 Introduction to Form Controls
  • 002 Combo Box - Select from a List
  • 003 Check Box - CheckUncheck Option
  • 004 Option Button - Choose an Option
  • 005 Spin Button - Move Up and Down a List
  • 006 List Box - Select from a List of Items
  • 007 Scroll Bar - Scroll Through a List
  • 008 Exercise 08

  • 86 - Excel 2021 Advanced Working with Power Query
  • 001 Power Query Overview
  • 002 Importing Data Using Get and Transform
  • 003 The Power Query Editor
  • 004 Combining Files
  • 005 Transforming Files
  • 006 Loading Files into Excel
  • 007 Exercise 09

  • 87 - Excel 2021 Advanced Forecasting
  • 001 Getting Forecast Data with FRED
  • 002 Creating a Linear Sales Forecast
  • 003 Creating a Sales Forecast with Seasonality
  • 004 Adding Confidence Levels
  • 005 Using Forecast Sheets
  • 006 Exercise 10

  • 88 - Excel 2021 Advanced Macros and VBA
  • 001 Using Macros to Automate Tasks
  • 002 Recording, Saving and Running Macros
  • 003 Recording a Macro with Relative Referencing
  • 004 Multi-step Macros
  • 005 The VBA Editor
  • 006 Assigning Macros to Buttons
  • 007 Creating a Custom Macro Ribbon
  • 008 Exercise 11
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 22789
    حجم: 25212 مگابایت
    مدت زمان: 3538 دقیقه
    تاریخ انتشار: ۱۰ آبان ۱۴۰۲
    دسته بندی محصول
    طراحی سایت و خدمات سئو

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