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

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 دقیقه
    تاریخ انتشار: 10 آبان 1402
    دسته بندی محصول
    طراحی سایت و خدمات سئو

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