Library

[Slon]

Master Microsoft Excel, Powerpoint And Word 2013 - 27 Hours
Last updated 1/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 19.45 GB | Duration: 31h 55m

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out-Quickly, No Travel or Classes.



What you'll learn
Introductory tutorials for Microsoft Excel 2013
Introductory tutorials for Microsoft Word 2013
Introductory tutorials for Microsoft PowerPoint 2013
Data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface.
Data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface. Tips for mouse and touch screen users.
Graphs and charts using templates or custom designs.
Pivot tables and slicing.
Working with flash fill.
Bonus exercise files.
Inserting images and videos directly from the internet
Opening and editing PDFs
Read mode, resume reading, object zoom, and collapsible headings
Protecting data with back-up and AutoRecover
Sharing work through email, blogs, and SkyDrive
Document security and editing restrictions
Creating backgrounds and working with templates
Images, audio, and video
Using a touch device
Trust Center and data protection
Align guides feature and shape merges

Requirements
Microsoft Office 2013

Description
Master the Ins and Outs of Microsoft Office 2013Spreadsheets with Excel 2013Documents with Word 2013Presentations with PowerPoint 2013Contents and OverviewThe course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.Through 27 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for college or work.PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.When you complete this course, you'll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013.What People Are Saying

★★★★★ "I look forward to learning more. This was recommended to me by my colleague." -Amanda Mueller

★★★★★ "Very informative and speaks very clearly. For a beginner like me, this is exactly the type of training that I need." -Darryl Henderson

★★★★★ "Small bites of Office, easy to digest. Plus, allows me to skip over items that I have experience without missing other topics of some interest." -Robert Heaton

★★★★★ "An excellent course. Well designed and well presented. Very professional audio and video. One of the best courses on Udemy. I will be sure to take other courses from this instructor. I very much enjoyed learning this material." -Terry Matthews

★★★★★ "This is a nice set of three courses for MS Office 2013 and provided the key features I needed to know after an upgrade at work. The production exceeded my expectations." -Michael Weiss** Updated December 2020. Live Webinar bonus lectures added.** Updated July 2017. English close captions added.** Updated June 2017. Course transcripts now available.

Overview

Section 1: Excel 2013: Introduction

Lecture 1 Introduction to Excel 2013

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 Downloadable Course Transcripts

Lecture 5 What's New

Section 2: Excel 2013: Using Touch

Lecture 6 Overview of Principles

Section 3: Excel 2013: Getting Started

Lecture 7 Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

Lecture 8 Templates; Creating, Opening, and Saving a Workbook

Section 4: Excel 2013: Help

Lecture 9 Course Review

Lecture 10 Online, Offline, and Contextual Help

Section 5: Excel 2013: Settings and Preferences

Lecture 11 Excel Options

Section 6: Excel 2013: The Ribbon and Toolbars

Lecture 12 Ribbon Interface

Lecture 13 Quick Access Toolbar

Lecture 14 Mini Toolbar

Section 7: Excel 2013: Backup and Recovery

Lecture 15 Create Backup Option; Auto-Recover and Autosave

Section 8: Excel 2013: Entering and Deleting Data

Lecture 16 Entering Text and Numbers

Lecture 17 Date Formats

Lecture 18 Formatting Cells; Editing and Deleting Data

Lecture 19 Fill

Lecture 20 Flash Fill

Section 9: Excel 2013: Formatting a Worksheet

Lecture 21 Themes and Cell Styles

Lecture 22 Inserting, Deleting, Hiding and Adjusting Rows and Columns

Lecture 23 Wrap Text and Alignment

Lecture 24 Merging Cells; Applying Themes and Styles

Lecture 25 Borders

Section 10: Excel 2013: Copy, Paste and Paste Special

Lecture 26 Copy, Cut and Paste

Section 11: Excel 2013: Proofing

Lecture 27 Spell checking

Section 12: Excel 2013: Managing Worksheets

Lecture 28 Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Section 13: Excel 2013: Comments

Lecture 29 Inserting Comments

Section 14: Excel 2013: Viewing and Printing

Lecture 30 Workbook Views, Zoom and Freeze

Lecture 31 Printing; Headers, Footers and Margins

Section 15: Excel 2013: Formulas and Functions

Lecture 32 Overview of Formulas and Functions

Lecture 33 Cell References

Lecture 34 Names

Lecture 35 Finding Errors; New Excel Functions

Section 16: Excel 2013: Working with Workbooks

Lecture 36 Multiple Workbooks and Windows; Comparing Workbooks

Section 17: Excel 2013: Find and Replace

Lecture 37 Go to; Find and Replace Options

Section 18: Excel 2013: Conditional Formatting

Lecture 38 Applying, Clearing and Managing Rules

Section 19: Excel 2013: Graphing and Charting

Lecture 39 Chart Types; Chart Recommendation

Lecture 40 Basic Formatting

Lecture 41 Selecting Data, Positioning and Printing Charts

Section 20: Excel 2013: File Types

Lecture 42 Saving Workbooks; PDF and CSV Formats

Section 21: Excel 2013: Managing Data

Lecture 43 Sorting

Lecture 44 Filtering

Lecture 45 Tables

Section 22: Excel 2013: Functions Case Study

Lecture 46 VLOOKUP

Lecture 47 Text Function

Lecture 48 Date and Time Functions

Lecture 49 Logical Functions

Section 23: Excel 2013: Analyzing Data

Lecture 50 Financial Analysis Case Study - Part 1

Lecture 51 Financial Analysis Case Study - Part 2

Lecture 52 Quick Analysis Tool

Section 24: Excel 2013: Shapes and Pictures

Lecture 53 Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Section 25: Excel 2013: Sharing and Protecting

Lecture 54 Protecting Worksheets

Lecture 55 Protecting Workbooks

Lecture 56 Sharing and SkyDrive

Section 26: Excel 2013: More Backstage View Options

Lecture 57 Trust Center; Export; Inspect Workbook

Section 27: Excel 2013: Closing

Lecture 58 Summary; More Help

Lecture 59 BONUS Lecture: Dashboards in Excel Live Webinar Recording

Section 28: Introduction to PowerPoint 2013

Lecture 60 Acquiring PowerPoint 2013

Lecture 61 WATCH ME: Essential Information for a Successful Training Experience

Lecture 62 DOWNLOAD ME: Course Exercise Files

Lecture 63 Downloadable Course Transcripts

Lecture 64 What's New in PowerPoint 2013

Section 29: PowerPoint 2013: Using Touch

Lecture 65 Overview of Principles

Section 30: PowerPoint 2013: Getting Started

Lecture 66 PowerPoint Workspace; Opening, Saving and Exiting

Lecture 67 Backstage View; Protecting Presentations; Editing Properties

Section 31: PowerPoint 2013: Help

Lecture 68 Online and Offline Help

Section 32: PowerPoint 2013: PowerPoint Options

Lecture 69 Customize Settings and Preference

Section 33: PowerPoint 2013: The Ribbon and Toolbars

Lecture 70 The Ribbon

Lecture 71 Quick Access Toolbar

Lecture 72 Mini Toolbar

Lecture 73 Status Bar

Section 34: PowerPoint 2013: Backup, AutoSave and AutoRecover

Lecture 74 Backup Files; Adjust AutoSave; Recover Unsaved Presentation

Section 35: PowerPoint 2013: Creating a Presentation

Lecture 75 New Blank Presentation; Slide Size, Orientation and Background

Lecture 76 Adding Contents; Adding and Deleting Slides

Section 36: PowerPoint 2013: Views

Lecture 77 Adjusting View and Adding Notes in Normal View; Promote/Demote and Expand/Collap

Lecture 78 Moving Slides in Slide Sorter View; Notes Page and Reading View

Lecture 79 Zoom

Section 37: PowerPoint 2013: Undo and Redo

Lecture 80 Undo and Redo Actions; Set Maximum Number of Undos

Section 38: PowerPoint 2013: Working with Text

Lecture 81 Adding and Formatting Text; Placeholder Textbox

Lecture 82 Manual Textbox; Inserting Symbols

Section 39: PowerPoint 2013: Copy, Cut and Paste

Lecture 83 Using Clipboard and Mini Toolbar; Paste Option

Section 40: PowerPoint 2013: Spelling and Grammar Checking

Lecture 84 AutoCorrect and Proofing

Section 41: PowerPoint 2013: Masters, Themes and Layouts

Lecture 85 Templates, Slides and Masters

Lecture 86 Background Color, Themes and Layouts

Lecture 87 Header and Footer

Section 42: PowerPoint 2013: Lists

Lecture 88 Bulleted and Numbered Lists

Section 43: PowerPoint 2013: Paragraph Formatting

Lecture 89 Alignment, Line Spacing, Ruler and Tabs

Section 44: PowerPoint 2013: Working with Images and Clip Art

Lecture 90 Inserting Pictures

Lecture 91 Formatting Pictures

Lecture 92 Photos and Photo Albums

Lecture 93 Clip Art

Lecture 94 Screenshots

Section 45: PowerPoint 2013: Working with Shapes and Drawings

Lecture 95 Drawing and Formatting Shapes

Lecture 96 Creating Complex Shapes

Lecture 97 SmartArt

Section 46: PowerPoint 2013: Saving a Presentation

Lecture 98 Save Options, Create PDF/XPS Document, Change File Type

Section 47: PowerPoint 2013: Tables

Lecture 99 Creating and Formatting Tables

Section 48: PowerPoint 2013: Charts

Lecture 100 Creating Charts using Excel; Editing Data, Chart Type and Chart Element

Section 49: PowerPoint 2013: Animation

Lecture 101 Basics of Animation

Lecture 102 Controlling Animation; Motion Path

Lecture 103 Animation of SmartArt

Section 50: PowerPoint 2013: Printing and Page Setup

Lecture 104 Printing Slides and Handouts

Section 51: PowerPoint 2013: Interactivity and Hyperlinks

Lecture 105 Linking to a Webpage and a Slide

Section 52: PowerPoint 2013: Laying out Slides

Lecture 106 Aligning Objects; Grid and Guides; Nudging

Section 53: PowerPoint 2013: Preparing for a Presentation

Lecture 107 Spell check; Create Handouts and Videos; Inspect Document; Hide Slide; Custom Sh

Lecture 108 Transitions and Timings; Setting up and Recording a Slide Show

Section 54: PowerPoint 2013: Delivering a Presentation

Lecture 109 Manual Presentation; Presenter View and Tools

Section 55: PowerPoint 2013: Collaboration

Lecture 110 Comments

Section 56: PowerPoint 2013: Sharing

Lecture 111 Saving your Presentation on SkyDrive

Lecture 112 PowerPoint Web App; Send Email; Get a Link

Section 57: PowerPoint 2013: Online Presentation

Lecture 113 Presenting on the Web

Section 58: PowerPoint 2013: Working with Multimedia

Lecture 114 Inserting and Formatting Video; Adding Audio

Section 59: PowerPoint 2013: Conclusion

Lecture 115 Protecting your Presentation; Trust Center; Closing

Lecture 116 BONUS Lecture: PowerPoint Tips and Tricks Live Webinar Recording

Section 60: Introduction to Word 2013

Lecture 117 Acquiring Word 2013; Information about Installing and Upgrading

Lecture 118 WATCH ME: Essential Information for a Successful Training Experience

Lecture 119 DOWNLOAD ME: Course Exercise Files

Lecture 120 Downloadable Course Transcripts

Lecture 121 What's New

Section 61: Word 2013: Using Touch

Lecture 122 Overview of Principles

Section 62: Word 2013: Getting Started

Lecture 123 Starting and Exiting; Templates; Creating, Opening and Saving Documents

Lecture 124 Word Workspace; Backstage View

Section 63: Word 2013: Help

Lecture 125 Online and Offiline Help

Section 64: Word 2013: Word Options

Lecture 126 Settings and Preferences

Section 65: Word 2013: The Ribbon and Toolbars

Lecture 127 The Ribbon

Lecture 128 Quick Access Toolbar

Lecture 129 Mini Toolbar/Bar

Section 66: Word 2013: Backup, AutoSave and AutoRecover

Lecture 130 Setting Up AutoSave and AutoRecover Preferences

Section 67: Word 2013: Entering and Editing Data

Lecture 131 Typing, Editing, and Deleting Text; Customizing Status Bar

Lecture 132 Navigation; Word Wrapping; Making a Selection

Lecture 133 Inserting Symbols, Date and Time, and Document Property

Section 68: Word 2013: Copy, Cut and Paste

Lecture 134 Various Methods of Copying, Cutting and Pasting

Section 69: Word 2013: Navigation and Find

Lecture 135 Uses of Navigation Pane

Lecture 136 Find and Replace; Go to

Section 70: Word 2013: Keyboard Shortcuts

Lecture 137 Keyboard Shortcuts and Key Tips

Section 71: Word 2013: Views

Lecture 138 Print Layout, Web Layout and Draft Views; Ruler and Gridlines; Split and Switch

Lecture 139 Zoom

Lecture 140 Read Mode

Section 72: Word 2013: Spell Checker

Lecture 141 Spelling and Grammar Errors; Language Settings

Lecture 142 AutoCorrect; Proofing Settings; Spell Checking

Section 73: Word 2013: Formatting

Lecture 143 Fonts, Font Size, and Font Colors; Text Effect and Text Highlight

Lecture 144 Alignment; Line and Paragraph Spacing; Indent

Lecture 145 Fill/Shading; Border Tab; Format Painter

Section 74: Word 2013: Lists

Lecture 146 Bulleted, Numbered and Multilevel Lists

Section 75: Word 2013: Managing Document

Lecture 147 File Formats

Section 76: Word 2013: Page Setup and Printng

Lecture 148 Printing

Lecture 149 Page Layout, Sections and Margins

Lecture 150 Headers, Footers and Page Numbers

Section 77: Word 2013: Templates, Themes and Styles

Lecture 151 Using Templates

Lecture 152 Using Themes and Styles

Section 78: Word 2013: PDF in Word

Lecture 153 Opening and Editing PDFs

Section 79: Word 2013: Tables

Lecture 154 Creating a Table; Inserting, Selecting and Deleting Rows and Columns

Lecture 155 Formatting Tables

Section 80: Word 2013: Graphics

Lecture 156 Inserting, Cropping, Resizing and Positioning Pictures

Lecture 157 Picture Styles; Picture Adjustments, Corrections and Effects

Lecture 158 Online Pictures and Clipart

Lecture 159 Inserting and Formatting Shapes and Textbox

Lecture 160 Smart Art and WordArt

Lecture 161 Screenshots

Section 81: Word 2013: Charts

Lecture 162 Creating Charts

Section 82: Word 2013: Resume

Lecture 163 Resume Reading and Editing

Section 83: Word 2013: Read Mode

Lecture 164 Object Zoom

Section 84: Word 2013: Mail Merge

Lecture 165 Mail Merge Wizard Part 1

Lecture 166 Mail Merge Wizard Part 2

Section 85: Word 2013: Collaboration, Reviewing and Sharing

Lecture 167 Send to Email; Post to Blog; SkyDrive; Invite People

Lecture 168 Restrict Editing, Comments, Simple Markup and Tracking Changes

Section 86: Word 2013: Long Documents

Lecture 169 Navigation, Headings, Table of Contents, Update Page numbers and Outline View

Section 87: Word 2013: Desktop Publishing

Lecture 170 Watermarks

Lecture 171 Page Borders

Section 88: Word 2013: Hyperlinks

Lecture 172 Types of Hyperlinks

Section 89: Word 2013: Security

Lecture 173 Inspecting and Protecting Documents

Section 90: Word 2013: Conclusion

Lecture 174 Microsoft Update; Closing

Lecture 175 BONUS Lecture: Advanced Word Live Webinar Recording

Anyone new to Microsoft Office or upgrading from a previous version

Code:

https://anonymz.com/?https://www.udemy.com/course/learn-microsoft-excel-powerpoint-and-word-2013/

Code:

https://rapidgator.net/file/be2f09c6e3a3e3d802e3075125893651/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part1.rar
https://rapidgator.net/file/685c185a38c690621686b890bc793368/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part2.rar
https://rapidgator.net/file/efb3d39c0040bd22ac25485e344fa83b/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part3.rar
https://rapidgator.net/file/a148f96afb288b67ec1c76218ae4e20a/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part4.rar

Code:

https://k2s.cc/file/549cc05f3a625/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part1.rar
https://k2s.cc/file/8ac08de3b0326/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part2.rar
https://k2s.cc/file/204904820dea6/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part3.rar
https://k2s.cc/file/c700ebc3da7ed/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part4.rar

Code:

https://nitroflare.com/view/7C1C4E656DBAA30/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part1.rar
https://nitroflare.com/view/5B15081FFC2BC9C/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part2.rar
https://nitroflare.com/view/B39B93357B8772B/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part3.rar
https://nitroflare.com/view/55AB5E982073CDF/Master_Microsoft_Excel_PowerPoint_and_Word_2013_27_Hours.part4.rar

[Slon]

The Dynamics of Microsoft Excel Workbook, Charts, PivotTable
Last Updated 08/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 161 lectures (22h 18m) | Size: 10.1 GB


[center]
The Practical Guide to EXCEL (2021, 2016, 2013) - Conditional Formatting, PivotTable, Analyze Data, 2D/3D Charts. Maps

[/center]


What you'll learn
Learn Excel from scratch to a comfortable professional
Harness the power of Macros to automate your tasks
You'll learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more
Explore the dynamics of Pivot Table and Pivot Chart
Maximize the customization of 3D and 2D charts
How to Protect your Excel files and worksheets properly.
Automate data entry with Auto-Fill and Flash-fill.
Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc)

Requirements
Excel 2013, Excel 2016, Excel 2019, Office Excel 365 software
A computer and the zeal to learn at your pace

Description
You are welcome to this Excel course. You will be guided step by step on how to be confident Microsoft Excel.

In this course you will

Learn how to work with Excel Workbook from scratch (absolute beginner) to a comfortable user

Learn how to create Excel Macro - Absolute referencing vs Relative referencing

Be able to create a Macro button

Automating Charts with Macros

Create Header and Footer within your Excel Worksheet

Learn how to use printing setup and page setup in Excel

Be able to use the conditional formatting tool to present data

Maximize the customization of 2D and 3D charts

Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc)

Formatting 3D Bar Chart, 3D pie Chart elements

Use slicer tools to makes charts operate in a dynamic way

Use the Analyze Data Tool in Office 365

Converting table to range and removing duplicates

Learn how to use printing setup and page setup in Excel

Be able to Freeze and unfreeze panes

Explore the dynamics of Pivot Table and Pivot Chart

Explore the dynamics of Excel Table and applying sorting and filtering tools

Understand how to use the slicer tools and timeline filter tools

Understand the dynamics of Sparklines - columns, win/loss, Line

Be able to create a Map Chart with multiple levels of geographic details

Create 3D Map with Time Line

Learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more

Automate data entry with Auto-Fill and Flash-fill.

Be able to work with smart art, take screenshots and manipulate shapes and edit images

Learn how to transpose data - that is switching the columns and rows in Excel

Who this course is for
This course is for absolute beginners. Intermediate Excel users are not exempted.
Understanding the dynamics of Excel Charts, Pivot Table, Maps can land you a Data Analyst job. So if you want to go that route, this Excel course is for you

Code:

https://anonymz.com/?https://www.udemy.com/course/the-dynamics-of-microsoft-excel-workbook-charts-pivottable/

Code:

https://rapidgator.net/file/1c0bb9b105c502dd664fe56f72db8c49/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part1.rar
https://rapidgator.net/file/f8ab9246ff62e728475766dfdbb45dbe/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part2.rar

Code:

https://k2s.cc/file/3fb6a00d3842b/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part1.rar
https://k2s.cc/file/234d2128c0f64/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part2.rar

Code:

https://nitroflare.com/view/85F7088C2F1D4C1/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part1.rar
https://nitroflare.com/view/32EF0A8644DD06E/The_Dynamics_of_Microsoft_Excel_Workbook_Charts_PivotTable.part2.rar

[Slon]

Microsoft Excel for Data & Business Analytics
Published 07/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 55 lectures (16h 25m) | Size: 7.9 GB


[center]
Microsoft Excel Course for Data & Business Analytics (Basic to Advanced)

[/center]


What you'll learn
Our Excel course is designed to take you from zero to hero so you can confidently list 'Advanced Excel Skills' on your resume/CV
Dashboard Reporting in Excel with Tips
Advanced Excel - More Scenario Examples, Data Analysis, Pivot Table
Modern Excel - DAX and Power Query

Requirements
Anyone can join | Student must have Microsoft Excel Desktop Version 2013 or above version

Description
Introduction

Are you ready to take your Excel skills to the next level?

Do you want to pursue a career in Excel related work?

Are you finding that employers these days want 'Advanced Excel Skills'?

Or maybe you've started a new job that requires more advanced Excel skills.

Do you struggle with Excel?

Not sure which formula to use for your situation?

Are you tired spending hours online trying to get "RIGHT" help?

When asked to make a dashboard or report, not sure where to start?

Module K - 15 Excel Functions Refresher, Module J - Exclusive Templates, Module I - Additional Learning 2 - Advanced Excel - More Scenario Examples, Module H - Additional Learning 1 - Dashboard Reporting in Excel with Tips, Module G - Modern Excel - DAX and Power Query, Module F - Pivot Table, Module E - Excel Charts and Visualizations, Module D - Data Analysis, Module C - Excel Formulas and Functions, Module B - Excel Essentials, Module A - Excel Basics (for Beginners)

Our Excel course is designed to take you from zero to hero so you can confidently list 'Advanced Excel Skills' on your resume/CV, or quickly get to grips with the requirements of a new job.

I have used the Excel 2021 / Office 365 to record these videos. Almost everything covered in this course will work for all the Excel versions (2010, 2013, 2016, 2019 & Office 365).

There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013. Dynamic Array Formulas will be available in Excel 2021 and Office 365 only.)

Who this course is for

Who this course is for
Data Analysts, Business Analysts, Finance Officers, Final Year University Students, Professionals working on EXCEL & Anyone who wants to explore EXCEL.

Code:

https://anonymz.com/?https://www.udemy.com/course/microsoft-excel-for-data-business-analytics/

Code:

https://rapidgator.net/file/74934588308b135c6b165d74b598134d/Microsoft_Excel_for_Data__Business_Analytics.part1.rar
https://rapidgator.net/file/6c67ee91dbfa74a4cb313b67135d4258/Microsoft_Excel_for_Data__Business_Analytics.part2.rar

Code:

https://k2s.cc/file/84a4c31ecd20b/Microsoft_Excel_for_Data__Business_Analytics.part1.rar
https://k2s.cc/file/383d13781f3d7/Microsoft_Excel_for_Data__Business_Analytics.part2.rar

Code:

https://nitroflare.com/view/D507B5D31E61DEF/Microsoft_Excel_for_Data__Business_Analytics.part1.rar
https://nitroflare.com/view/2C190AC2F4A2735/Microsoft_Excel_for_Data__Business_Analytics.part2.rar

[Slon]

Microsoft Excel 2019 for Beginners By Widhi Muttaqien
Published 07/2022
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.83 GB | Duration: 88 lectures • 10h 35m



What you'll learn
The basics of Excel
Graphics and Charts
Data processing techniques
Table and PivotTable
Conditional formatting
Printing and exporting
And many more


Requirements
Basic skills for operating a computer.
Have Microsoft Excel 365 or 2019 already installed.

Description
Are you new to Microsoft Excel? Or just looking for a good refresher? In this online course, you will learn Microsoft Excel from the very basics until you can master all aspects of the software.

What you will learn

There are tons of things that you will learn in this online course. It would be too long to explain all of them in this short description text. To see the details, you can check the curriculum section of this course. I will only explain some of them briefly here.

In the first chapter, you will get to know the basics of Microsoft Excel, such as how to work with files, exploring the user interface, how to navigate, and so on.

Then you will learn the basics of working with data in Excel, such as using AutoFill, using formulas, understanding different types of copy-and-paste, learn to use various types of cell references, from the simplest to the complex ones, and so on.

Next, you will learn the ins and outs of data presentation in Excel. From formatting basic texts, numbers, cells, borders, effects, styles, and so on. Then learn various techniques for structuring the table.

In the next section, you will learn about various things related to graphics. Such as inserting and managing image files, creating shape and text box objects, creating SmartArt, creating Charts, and also Sparklines.

In the next chapter, we will discuss advanced data processing techniques. We will discuss things like notes, comments, find and replace techniques, data sorting, filters, Freeze Pane, and so on.

Then after that, we will discuss in detail everything related to tables, pivot tables, and how to combine the two features. We'll also cover a variety of conditional formatting features from the basic examples to more complex ones.

And in the final chapter, we will cover different techniques related to printing and exporting, such as defining print areas, managing headers and footers, data protection, exporting to PDF or XPS, etc.

So, join this course now! And become the master of Excel.

Who this course is for
Beginners who want to learn Microsoft Excel from scratch.
Employees who want to improve their career by leveraging Excel.
Students and academics who need effective tools to support research.
Managers or CEOs who need to perform data analysis and present them effectively.

Code:

https://anonymz.com/?https://www.udemy.com/course/microsoft-excel-2019-for-beginners/

Code:

https://rapidgator.net/file/305d22de19e42b40ba52de442d4d3158/Microsoft_Excel_2019_for_Beginners.part1.rar
https://rapidgator.net/file/5dedcb1cafa409bdc696923f21da45bf/Microsoft_Excel_2019_for_Beginners.part2.rar

Code:

https://k2s.cc/file/15d7675c69c73/Microsoft_Excel_2019_for_Beginners.part1.rar
https://k2s.cc/file/d87e501d74967/Microsoft_Excel_2019_for_Beginners.part2.rar

Code:

https://nitroflare.com/view/F20FCF016F12324/Microsoft_Excel_2019_for_Beginners.part1.rar
https://nitroflare.com/view/D8D35620EFBC12A/Microsoft_Excel_2019_for_Beginners.part2.rar

[Slon]

Microsoft Excel - Excel From Beginner To Advanced #2
Published 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.79 GB | Duration: 17h 18m

Learn excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365



What you'll learn
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Access to a Professional Trainer with 10+ years of Excel Training
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Requirements
No Prior Excel Knowledge Required
Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Description
Microsoft Excel all in One PackageThis Microsoft Excel course combines 4 different courses.Microsoft Excel 101 - An Introduction to ExcelMicrosoft Excel 102 - Intermediate Level ExcelMicrosoft Excel 103 - Advanced Level ExcelMaster Microsoft Excel Macros Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365).Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:Creating effective spreadsheetsManaging large sets of dataMastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)Create dynamic report with Excel PivotTablesUnlock the power and versatility of Microsoft Excel's Add-In, PowerPivotAudit Excel Worksheet formulas to ensure clean formulasAutomate your day to day Excel tasks by mastering the power of Macros and VBAWhat's Included?18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Overview

Section 1: Microsoft Excel Course Introduction

Lecture 1 Introduction

Lecture 2 How to Download Microsoft Excel 2010 For FREE

Lecture 3 Use Microsoft Excel Completely FREE__ Excel for Web

Section 2: Microsoft Excel Fundamentals

Lecture 4 The Beginner's Guide to Excel - Excel Basics Tutorial

Lecture 5 Intermediate Excel Skills, Tips and Tricks Tutorial

Lecture 6 Most Useful Excel Keyboard Shortcuts

Lecture 7 Excel Find and Replace Tutorial

Lecture 8 Customizing The Quick Access Toolbar in Microsoft Excel_ Word_ and Powerpoint

Lecture 9 Excel Double Mouse Click Tricks

Lecture 10 Zooming in and Out in Excel

Lecture 11 Automatically Open Several Excel Files

Lecture 12 Adding a Scroll Bar in Excel

Section 3: Advanced Excel

Lecture 13 VLOOKUP Basics

Lecture 14 Protecting a Sheet - Excel Tutorial

Lecture 15 3D Formulas - Advanced Excel

Lecture 16 Data Validation and Drop-Down

Lecture 17 Using the IF Function in Excel to Program Your Spreadsheets

Lecture 18 Flash Fill Tutorial

Lecture 19 Sorting in Excel

Lecture 20 Excel Quick Tip_ Repeat Last Action

Lecture 21 Excel_ INDEX and MATCH

Lecture 22 Generating Random Numbers in Excel

Section 4: Creating Basic Charts in Excel

Lecture 23 Excel Quick and Simple Charts Tutorial

Lecture 24 Excel In-Cell Charts

Lecture 25 Create a Map Chart in Excel

Lecture 26 Creating Organization Charts in Excel

Lecture 27 Creating Pie Charts in Excel

Section 5: Spilt Option

Lecture 28 Excel Tutorial - Using the Split Option to See Your Data

Lecture 29 Excel Split Names Tutorial

Lecture 30 Excel Spilled Results and Fixing the SPILL_ Error

Section 6: Excel Pivot Tables

Lecture 31 All About Excel Tables

Lecture 32 Creating Pivot Tables in Excel

Lecture 33 Using _Recommended Pivot Tables

Section 7: Microsoft Office Web Apps_ Excel_ PowerPoint _ Word

Lecture 34 Beginner_s Guide to Microsoft Office Web Apps_ Excel_ PowerPoint _ Word

Section 8: Excel for Mac

Lecture 35 Beginner_s Guide to Excel for Mac

Lecture 36 Excel for Mac Intermediate Skills_ Tips_ and Tricks

Section 9: Dealing with Duplicates

Lecture 37 Dealing with Duplicates in Excel and Finding Unique Data

Lecture 38 Remove Duplicates Tool in Excel

Section 10: Working with Large sets of Excel Data

Lecture 39 Using the Freeze Panes Tool

Lecture 40 Date Functions and Formulas in Excel

Lecture 41 Using the Speak Cells on Enter Tool in Excel

Lecture 42 Convert Excel Data into a Google Map

Lecture 43 Combining Excel Data by using TEXTJOIN or Flash Fill(

Lecture 44 Using the Excel Data Types Tools

Lecture 45 Inserting Excel Data into Microsoft Word

Lecture 46 Enter the Same Data in Multiple Excel Cells

Lecture 47 Creating Easy Data Entry Forms in Exce

Lecture 48 Using Excel Slicers to Filter Data

Lecture 49 Combining Data From Multiple Cells in Excel

Lecture 50 Quickly Fill a Huge Series of Numbers or Dates in Excel

Section 11: Working with all Basic Excel Function

Lecture 51 Beginner_s Guide to Excel Functions and Formulas

Lecture 52 The Excel AVERAGEIFS Function

Lecture 53 Using the Excel Today Function to Set Target Dates

Lecture 54 Using the Trim Function in Excel

Lecture 55 Combining Excel_s LEFT and Find Functions

Lecture 56 The Excel IFERROR Function_ Clean up Your Excel Errors

Lecture 57 Using the Powerful AND Function in Excel

Lecture 58 Using Excel_s XLOOKUP Function

Lecture 59 Using LEFT RIGHT _ MID Functions in Excel

Lecture 60 Using the New IFS Function in Excel

Lecture 61 Fixing Improper Capitalization in Excel Using the Proper Function

Lecture 62 Using the Excel FILTER Function to Create Dynamic Filters

Lecture 63 Create Interactive Worksheets in Excel by Using the IF and COUNTIF Functions

Lecture 64 Using Count and CountA in Excel

Lecture 65 Create a Timeline in Excel

Lecture 66 Creating a Calendar in Excel

Lecture 67 Creating a Family Budget with Excel

Lecture 68 Creating Easy Data Entry Forms in Excel

Lecture 69 Customize the Excel AutoFill Handle

Lecture 70 How to Create Excel Pixel Art

Section 12: Excel list Function

Lecture 71 Date Functions and Formulas in Excel

Lecture 72 The Excel SUMPRODUCT Function

Lecture 73 The Excel TRANSPOSE Function

Lecture 74 The Excel Quartile Function

Lecture 75 The Excel SUMIFS Function

Lecture 76 Excel_s LARGE Function and SMALL Function

Lecture 77 Two Excel Dynamic Array Functions_ UNIQUE and SORT

Lecture 78 Benefits of Naming Cells in Excel

Section 13: Inserting Images and shapes into an excel worksheet

Lecture 79 Linking Shapes to Data in Excel

Lecture 80 Adding Pictures and Backgrounds into Excel

Section 14: Navigating Within an Excel Spreadsheet

Lecture 81 Navigating Within an Excel Spreadsheet

Section 15: Mastering Excel's "What If" Tools

Lecture 82 Excel WhatIf Analysis with Scenario Manager and Goal Seek

Lecture 83 Using the Screenshot Tool in Word_ PowerPoint and Excel

Lecture 84 The Excel Quick Analysis Tool

Lecture 85 Using the Camera Tool in Excel

Section 16: Printing an Excel Worksheet

Lecture 86 Excel Print Options_ Tips and Tricks Tutorial

Lecture 87 Hiding Data in Excel

Lecture 88 Using Go to Special in Excel

Lecture 89 Work on Multiple Excel Sheets at Once by Grouping Sheets

Section 17: Modifying an Excel Worksheet

Lecture 90 Adding and Deleting Columns and Rows in Excel

Lecture 91 Moving and Copying Columns in Excel

Lecture 92 Create Interactive Worksheets in Excel by Using the IF and COUNTIF Functions

Lecture 93 Create Random Student Picker or Raffle Picker in Excel(

Section 18: Formatting Data in an Excel Worksheet

Lecture 94 Add Borders and Draw Borders in Excel

Lecture 95 Excel Conditional Formatting Advanced Technique

Lecture 96 Excel Formatting Shortcuts

Lecture 97 Excel Conditional Formatting in Depth

Lecture 98 Excel Number Formats Explained

Lecture 99 Display All Formulas in Excel

Section 19: Fit Data into your Spreadsheet Cells

Lecture 100 Excel Alignment Options Tutorial

Lecture 101 Making Excel Spreadsheets Hidden or Very Hidden

Section 20: Creating Basic Charts IN Excel

Lecture 102 Creating Organization Charts in Excel

Lecture 103 Creating Pie Charts in Excel

Lecture 104 Lightning Fast Excel Charts

Lecture 105 Easily Insert Charts and PivotTables into Excel with Analyze Data Button

Section 21: Dashboards in Excel

Lecture 106 Beginner_s Guide to Excel Dashboards

Lecture 107 Intermediate Guide to Excel Dashboards

Section 22: Excel Get _ Transform _ Power Query

Lecture 108 Beginner_s Guide to Excel Get _ Transform _ Power Query

Lecture 109 Intermediate Guide to Excel Get _ Transform _ Power Query

Section 23: Microsoft Excel Macros VBA Course Introduction

Lecture 110 Beginners Guide to Excel Macros - Create Excel Shortcuts

Lecture 111 Create an Excel Macro from Scratch_ AutoFit Columns

Lecture 112 Create an Excel Macro that Highlights Rows

Lecture 113 Create a Go Full Screen Macro in Excel and How to Create Custom Excel Buttons

Section 24: Working with Excel Templates

Lecture 114 Creating Your Own Excel Templates

Section 25: Editing Text

Lecture 115 Use the Excel TEXT Function to Display Numbers as Words

Lecture 116 Shortcuts for Editing Text in Excel

Lecture 117 Excel Quick Tip_ How to Wrap Text

Lecture 118 Create Text Shortcuts in Excel Word and PowerPoint

Section 26: Working with an Excel List

Lecture 119 Sorting in Excel - Basics and Beyond

Lecture 120 Copying Excel Formats_ Format Painter _ More

Lecture 121 Filtering in Excel_ Basics and Beyond

Lecture 122 The Excel Status Bar

Section 27: Fixing Common Excel Errors

Lecture 123 Fixing Common Excel Errors - Part 1_ DIV_0_ N_A_ _ NAME

Lecture 124 Fixing Common Excel Errors - Part 2_ NULL_ NUM

Lecture 125 Fixing Common Excel Errors - Part 3_ REF and VALUE

Lecture 126 Fixing Improper Capitalization in Excel Using the Proper Function

Lecture 127 Automatically Highlight Blank Cells and Errors in Excel

Section 28: Protecting Excel Worksheets and workbooks

Lecture 128 Password Protecting Your Excel Files

Lecture 129 How to Break Password Protection from a Protected Excel Sheet

Section 29: Excel Quick Tip_ F4 for Absolute Cell References

Lecture 130 Excel Quick Tip_ F4 for Absolute Cell References

Lecture 131 Excel Relative vs Absolute Cell References

Section 30: Using Checkboxes in Excel

Lecture 132 Using Checkboxes in Excel - Part 1

Lecture 133 Using Checkboxes in Excel - Part 2

Section 31: Exporting data

Lecture 134 Exporting Excel Files to PDFs

Lecture 135 Easily Save Microsoft Office Files to the Right Folder

This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).,If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-2-v/

Code:

https://rapidgator.net/file/308ee37ac51d3906a2b5aa1f2d383015/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part1.rar
https://rapidgator.net/file/f34b70c097fd096f361c303c0cae2bd5/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part2.rar
https://rapidgator.net/file/a798149392f481ceca0967286b820d47/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part3.rar

Code:

https://k2s.cc/file/d0170be0967cc/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part1.rar
https://k2s.cc/file/300404bd713ab/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part2.rar
https://k2s.cc/file/15c1f586dcbb5/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part3.rar

Code:

https://nitroflare.com/view/7632F46F49A8C79/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part1.rar
https://nitroflare.com/view/129AD43B7C2F6E1/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part2.rar
https://nitroflare.com/view/3CDF81CFD44E1E3/Microsoft_Excel_Excel_from_Beginner_to_Advanced_2.part3.rar

[Slon]

SAP MM - Materials Management Full Course
Published 09/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 53 lectures (26h 29m) | Size: 11.3 GB


[center]
SAP Material Management module from scratch and learn all business Processes (Beginners to Experienced Level)

[/center]


What you'll learn
Enterprise Structure - SAP MM
Procure to Pay Cycle - SAP MM
Master Data
Purchase Requisition
Request for Quotation and Quotation
Purchase Order
Release Strategy Procedure
Output Type Determination
Automatic PO
Pricing Procedure
Scales
Contracts (Outline Agreements)
Scheduling Agreements
Invoice Verification Receipt
Stock Transfer Order
Subcontracting
Vendor Consignment
Pipeline

Requirements
Advantage if had basic idea on Industry

Description
SAP MM is a very vast subject. It takes at least 30 to 40 hours of learning. The goal of the course is to simplify this process as much as possible. The word "simplify" - that is really the key. This course does not claim to be the most comprehensive course in MM, nor the most advanced course in MM. It has just one goal - to let you learn SAP MM as simple as possible.

This course is designed to tell you everything you need to know about SAP MM in a very gentle way. Since this course is designed from a freshers' perspective, if you are already an SAP functional consultant ( in other areas of SAP ), then the pace of this course might be a bit slow.

In this course, I provided an explanation of the above topics. I tried to give business usage examples along with configuration which will be handled by SAP Consultants. I also provided the testing of each process which will be helpful to both SAP Consultants and End Users.

I provided doubts end of every session videos which helps to clarify a few of your questions.

After this course, the students will be able to identify and analyze the business requirements for any organization related to the Procurement to Payment process cycle and configure SAP S4 HANA Sourcing and Procurement accordingly.

After taking this course, the Learners will be able to work both as a Consultant and End-User and can also take SAP S/4HANA Sourcing & Procurement certification exam

Who this course is for
Procurement Officers
Graduates
SAP MM Consultants
Beginners and Experienced level in SAP

Code:

https://anonymz.com/?https://www.udemy.com/course/sap-mm-materials-management-full-course/

Code:

https://rapidgator.net/file/131f3270d74d9772402766821324fbe2/SAP_MM_-_Materials_Management_Full_Course.part1.rar
https://rapidgator.net/file/c88bac2b13513076fc7aca0b9483aa23/SAP_MM_-_Materials_Management_Full_Course.part2.rar
https://rapidgator.net/file/21d72375c176b04de715ea1799df469d/SAP_MM_-_Materials_Management_Full_Course.part3.rar

Code:

https://k2s.cc/file/27abe4ace8410/SAP_MM_-_Materials_Management_Full_Course.part1.rar
https://k2s.cc/file/bc56c317d566d/SAP_MM_-_Materials_Management_Full_Course.part2.rar
https://k2s.cc/file/4b4f36c131e8e/SAP_MM_-_Materials_Management_Full_Course.part3.rar

Code:

https://nitroflare.com/view/09B5938B25F02BA/SAP_MM_-_Materials_Management_Full_Course.part1.rar
https://nitroflare.com/view/1DBD0DF7479D2C6/SAP_MM_-_Materials_Management_Full_Course.part2.rar
https://nitroflare.com/view/51BCADB5DE77C21/SAP_MM_-_Materials_Management_Full_Course.part3.rar

[Slon]

Advanced Microsoft Excel Power Query (Hindi + English)
Instructors: Pavan Lalwani, Ajinkya
13 sections • 73 lectures • 5h 46m
Video: MP4 1280x720 44 KHz | Hindi/English
Updated 7/2022 | Size: 5.555 GB

Microsoft Excel - Learn Quickly (Dual Language)



What you'll learn
Master Excel from Beginners to Advanced Learn the most common Excel Functions Maintain large datasets with ease Build a solid understanding on the basics Excel
Learn Formatting, Vlookup etc Learn wide range of shortcuts in Excel
Functions, Pivot Tables
Learning Sort Filter and Table Formatting

Requirements
Basic knowledge of ComputersLaptop with Microsoft ExcelEagerness to learn Excel

Description
Teach Excel to Do Your Work FOR YOU. . .

Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.

In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.

I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION.

My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by.

Take this course and access your true potential.

Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers!
Here's what some of the students are saying
"I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!" - Rajesh
"Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more." - Monica
"I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Nitin
"You can't go wrong with Daniel Strong!" - John
"Well explained, easy to understand lectures. Enjoyable and informative videos." - Ajinkya
"Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience." - Ritu
"Best course on Excel ever taken. Thanks a lot!" - Rita
"This is an excellent course!!! There's a lot of good, useful "stuff" here. The examples are practical and real-world!" - Sonali
"Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power; of Excel. Great course, fantastic instructor." - Arpika
"By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete, this throughout. I am amazed at how little I actually new about the Excel world. Thanks a million!" - Karthik
"Everything I have been looking for, you would have to buy multiple books for this level of instruction!" - Sunny
"Excellent VBA basic to advance tutorial." - Jeet
"This course is good for beginners and for experienced programmers. Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet. He goes over different events and triggers (like buttons) to execute code. This is a really good course if you plan to do some pretty complex vba code with forms and reports." - Anubhav
"Very helpful if you do any type of data analysis." - Pankaj
"I think this is an excellent gateway to the tools we need to use going forward. I like the
hands on nature." - Nancy
"Much better than other classes and seminars. Great course." - Manpreet
"The instructor made Excel easy and straight forward to use." - Rupali
"Very thorough and practical." - Tina


Who this course is for:Working Professionals looking to enhance skills in ExcelWorking Professionals looking to learn shortcutsWorking Professionals looking to Learn Pivot Table, Advanced Sort, Advanced FiltersStudents looking for PlacementStudents looking to complete their projectStudents looking for preparing for Interview

Homepage

Code:

https://www.udemy.com/course/microsoftexcelpart2/

Code:

https://rapidgator.net/file/c35c1b6ab4b28ed170302a927ee1661f/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part1.rar
https://rapidgator.net/file/2f3c5d33e2334189396b667a723fe99a/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part2.rar

Code:

https://k2s.cc/file/dd4f128b2d7c5/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part1.rar
https://k2s.cc/file/9676d3cc41fe4/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part2.rar

Code:

https://nitroflare.com/view/065C5B94F1BBDF1/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part1.rar
https://nitroflare.com/view/EAA6D478A5D437D/Advanced_Microsoft_Excel_Power_Query_Hindi___English.part2.rar

[Slon]

SAP Material Management(MM)- Basic to Advance
Published 09/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 29 lectures (20h 57m) | Size: 7.52 GB


[center]
Certification course designed to cover SAP MM configurations,Master data and End User Activities

[/center]


What you'll learn
Introduction to SAP S/4 Hana Material Management
Enterprise structure and Needful Configurations
Creation Material Master Data and extending material
Real time Business Scenario and Implementation

Requirements
No prior experience or skillset needed for learning this course. This course explains from very basics and gradually increases the level.

Description
1. Introduction to ERP
· ERP Definition
· Characteristics of ERP
· Products of ERP
· Benefits of using ERP

2. Introduction to SAP
· SAP History
· SAP Product line
· New Products of SAP
· Relation of New SAP Products with the core product
· Industry specific Products
· Type of SAP Projects
· Type of SAP Roles
· Architecture of SAP
· System Landscape
· Types of data used in the SAP system

3. Initial Screens
· How to login to the SAP system
· SAP Client / GUI
· SAP Session - What it is
· How to open a new Session
· Create new Sessions
· Navigation between Sessions
· Transactions and Activities
· Shortcuts or Transaction Codes
· SAP Easy Access screen
· SAP IMG screen
· Difference between Easy Access and IMG screens

4. Enterprise Structure

· What is Enterprise Structure
· The different types of Enterprise Structure
· Company structure in real time
· Company structure for each process
· MM Structure against other process structure
· Enterprise Structure terms in real time against those used in the SAP system
· Definitions of the elements of enterprise structure
· Creation of Enterprise Structure elements in the SAP system
a) Group
b) Company
c) Plant
d) Store
e) Purchasing Department
f) Valuation Area
g) Controlling Area
h) Assignment of the Enterprise Structure elements in the SAP system
o Assign Company to Group
o Assign Plant to Company
o Assign Store to Plant
o Assign Purchasing Departments
o Assign Controlling Area

5. Master Data
· Basics of Master Data
· Significance of Master Data
· Usage of Master Data
· Material Master
· What is Material Master

· Screen Reference
· Field Reference
· Material Type
· Material Number formatting
· Material Groups
· Purchasing Group
· Purchase Value Key
· Shipping Instruction
· Vendor Master
· General Data
· Company Code Data
· Purchasing Data
· Vendor Classification
· Types of Vendor
· Prerequisites for creating Vendor Master Record
· Vendor Account Group and its significance
· Creation of Vendor Master Record

· Changing the Vendor Master Record
· Other End user activities of Vendor Master
· Configuration of Vendor Master
· Vendor Field Selection
· Assignment of Number Ranges
· Screen selection for Vendor Master records
· Vendor Industries
· Terms of Payment
· Purchasing Info Record
· Source List
· Configuration
· Quota Arrangement
· Configuration

6. Purchasing
· Basics of Purchasing
· What is Purchasing
· Difference Between Purchasing and Procurement
· Purchasing Cycle
· Purchasing Documents
· Different types of Purchasing documents used
· Division of Purchasing Document in the SAP system
· Type of data maintained in each division of the purchase document
· Purchase Requisition
· Request for Quotation (RFQ)
· Quotation
· Comparison
· Purchase Order
· Release Procedure
· Optimisation` of Purchasing
· Outline Agreements
· Quantity Contract
· Value Contract
· Creation of a Contract
· Other End User activities of Contract
· Scheduling Agreements
· Creation of Delivery Schedule
· Configuration of Purchasing
· Document Types configuration
· Assigning Number Ranges to Document Types
· Screen Selection for the Document Types
· Text Types and Copying Rules
· Tolerances for Archiving documents

7. Inventory Management
· Basics of Inventory Management
· Stock Types
· Movement Types
· Process of Goods Receipt
· Process of Goods Issue

· Stock Transfers
· What is Stock Transfer
· Types of Stock Transfer
· Transfer between Plants
· Transfer between Storage Locations
· Transfer between Stock types
· Transfer using Stock Transport Order
· Return to vendor
· Conditions under material returned to vendor
· Prerequisites for return to vendor
· Cancellation
· Initial Stock
· Reservations
· Physical Inventory
· Configuration
· Plant Parameters
· Number Range assignment
· Screen Selection
· Movement Types and its attributes
· Individual transaction configuration

8. Special Procurement Process / Special Stocks
· Basics of Special Procurement Process / Special Stocks
· Subcontracting
· Consignment
· Pipeline

9. External Services Management
· Basics of External Services Management
· Service Master
· Service Conditions
· Service Purchase Order
· Service Entry Sheet
· Configuration of External Services Management

10. Valuation and Account Determination

11. Logistics Invoice Verification

12. Pricing Procedure

13. Batch Management

14. Output Determination

Who this course is for
Designed for the person who wants make career in SAP MM
Beginners who wants to start their career in SAP ERP
SAP Consultants looking to expand their skillset in Material Management
Intermediaries who want to learn specific part of SAP Material Management
Material Management industrialist who want gain knowledge of SAP ERP

Code:

https://anonymz.com/?https://www.udemy.com/course/saphanamm/

Code:

https://rapidgator.net/file/b05b3e8559e7d94b72f0ad15a346531d/SAP_Material_ManagementMM-_Basic_to_Advance.part1.rar
https://rapidgator.net/file/82907b25973337e7f92e6b6915d83a3e/SAP_Material_ManagementMM-_Basic_to_Advance.part2.rar

Code:

https://k2s.cc/file/42c32de318fbc/SAP_Material_ManagementMM-_Basic_to_Advance.part1.rar
https://k2s.cc/file/0eb7ad5b46189/SAP_Material_ManagementMM-_Basic_to_Advance.part2.rar

Code:

https://nitroflare.com/view/9F8CA89D8B558E5/SAP_Material_ManagementMM-_Basic_to_Advance.part1.rar
https://nitroflare.com/view/19A9AA454D0CA12/SAP_Material_ManagementMM-_Basic_to_Advance.part2.rar

[Slon]

Excel VBA Basic to Super Advance Part2
Published 07/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 31 lectures (11h 6m) | Size: 5.35 GB


[center]
In-depth study of how to deal with 100s of files insider folders, text file data handling and SuperPowerful USERFORMS

[/center]


What you'll learn
In this VBA Part2 ,We are focusing on three topics and 3 sections for you - File & Folder Handling ,USERFORMS,Error handlers with message /input boxes
It has two sections and knowledge of arrays, loops, if statments is must. You can check VBA Part1, if you want to learn all this.
You shall learn how to create files or folders , text files
Taking a deep dive into library called Scripting and learning the classes of this library like fiesystemobject, file, folder and text stream
You shall be able to pick data from hundreds of excel or text files and will be able to collate it under one roof and then do whatever is required.
Creating workbooks, text files, folders, jumping inside subfolders, putting conditions, modifying the data , whatever is required, you shall be able to do it.
You shall be able to learn how to create VBA Dashboards using UserForms. Its fully basic to advance course
You shall be able to understand why it is important to know error handlers like On Error Resume Next and Go to Err.
Also, how to create message and input box with real time examples

Requirements
VBA Knowledge is required since this is our Part2. Knowlege of variables, arrays, loops ,functions is required. One can watch VBA Part1 , if haven't before opting for this part2.
If you already know above topics then please go ahead and take admission in this course.

Description
In section1, We are Learning to deal with small or large data stored in excel workbooks or text files using a library called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files and Textstream.

How to go inside a folder and pick the needed files and then do the things like compiling data from them or modifying the files or moving them or deleting them.

Learn how to use the file-dialogs so that user can choose any folder of his or her choice and work accordingly.

Not just folders or Excel files -we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using scripting library, Very useful especially when you are dealing with big data.

Skip the files while running loops which you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. save as dialog, folder dialog and also why and where we can use them.

Customization of file dialog buttons, titles to how to open multiple files with them to make more user friendly and robust program which can be run in any machine irrespective of the drives or folder paths they have.

Learn to manipulate text files using scripting library. We have everything discussed here from basic level to advance level when it comes to file and folder manipulations.

In section2, we have covered all form controls like labels, textboxes, combo, listbox, frame, option buttons, check boxes and many more.

From understanding the Userform control design and properties, you shall also see the magic of userform events which are very much required to create projects.

All of your doubts will be answered via email or forum in 24 hours.

in section3, you shall learn Error handlers like On error resume next and goto err.

You shall see what are the scenarios when we already know we can have errors - VBA Errors so if we want to ignore those errors and keep continuing running the vba code, how to do that and first of all, why in first place , I will like to ignore the errors.

We will then learn how to use and customize a message box and input box in vba with various examples.

Who this course is for
Excel data analytics, Those who like to automate data work in excel.
Those who want to create dashboards by using userforms of VBA.

Code:

https://anonymz.com/?https://www.udemy.com/course/excel-vba-basic-to-super-advance-part2/

Code:

https://rapidgator.net/file/1e8618defb0bf0715b8c863098bdf319/Excel_VBA_Basic_to_Super_Advance_Part2.part1.rar
https://rapidgator.net/file/79990657e52081ca3978de6c98e8e376/Excel_VBA_Basic_to_Super_Advance_Part2.part2.rar

Code:

https://k2s.cc/file/43db0c3268944/Excel_VBA_Basic_to_Super_Advance_Part2.part1.rar
https://k2s.cc/file/b981979c86c07/Excel_VBA_Basic_to_Super_Advance_Part2.part2.rar

Code:

https://nitroflare.com/view/DA77CA7A79ECBF9/Excel_VBA_Basic_to_Super_Advance_Part2.part1.rar
https://nitroflare.com/view/588E13D0E37ED75/Excel_VBA_Basic_to_Super_Advance_Part2.part2.rar

[Slon]

The Ultimate Microsoft Excel Data Analytics Course
Last Updated 07/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 85 lectures (8h 29m) | Size: 5.8 GB


[center]
This course will teach you advanced Excel techniques all aimed at helping you make sense of the numbers in your business

[/center]


What you'll learn
Learn and Understand Data Manipulation using Excel
Learn How to Create Formulas to Help you Analyze Data
Learn and Understand Data Cleansing
Learn and Understand Tables in Excel
Learn various ways to model data for businesses
Build impressive tables and combine datasets using Excel's built-in functionality
Learn basics of Pivot Tables and Charts
Clean and prepare your data
Create a basic Excel Pivot Table and format numbers in it
Use multiple fields and dimension, and methods of aggregation
Create Pivot Charts based on Pivot Table data
Learning Power Query, Power Map and Power Pivot

Requirements
You have an attitude to learn while having fun :)
Basic Excel knowledge is helpful but not required

Description
Welcome to this course. Microsoft Excel is one of the easiest to use data analysis tools you will ever come across. We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively. Microsoft Excel has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level.

We'll start with the basic topics in Microsoft Excel. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. You will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

In this course, you'll learn

Learn and Understand Data Manipulation using Excel

Learn How to Create Formulas to Help you Analyze Data

Learn and Understand Data Cleansing

Learn and Understand Tables in Excel

Learn various ways to model data for businesses

Build impressive tables and combine datasets using Excel's built-in functionality

Learn basics of Pivot Tables and Charts

Clean and prepare your data

Create a basic Excel Pivot Table and format numbers in it

Use multiple fields and dimension, and methods of aggregation

Create Pivot Charts based on Pivot Table data

Learning Power Query, Power Map and Power Pivot

At the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click.

Who this course is for
This course is for anyone who works with Microsoft Excel even if you've never used data analytics, Pivot Table and Pivot Charts

Code:

https://anonymz.com/?https://www.udemy.com/course/the-ultimate-microsoft-excel-data-analytics-course/

Code:

https://rapidgator.net/file/01521cde8fd0cd3086c7657a724fb277/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part1.rar
https://rapidgator.net/file/b891e669ab6f0e85f67d58085a49d35a/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part2.rar

Code:

https://k2s.cc/file/652ea5a524e3d/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part1.rar
https://k2s.cc/file/85dd6804abf84/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part2.rar

Code:

https://nitroflare.com/view/8557EA267B8AABA/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part1.rar
https://nitroflare.com/view/6DFF95AF944763C/The_Ultimate_Microsoft_Excel_Data_Analytics_Course.part2.rar

[Slon]

The Ultimate Microsoft Excel 2013 Training Bundle - 19 Hours
Last updated 1/2022
MP4 | Video: h264, 960x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 12.07 GB | Duration: 19h 22m

The Drop-Dead Simple Method to Mastering Microsoft Excel 2013, Without Books, in Less Time Than You Thought



What you'll learn
Practice with included exercise files.
Data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface.
Tips for mouse and touch screen users.
Graphs and charts using templates or custom designs.
SkyDrive and other tools for sharing work.
Pivot tables and slicing.
Working with flash fill.
Working with dates and times.
Averages, percentiles, and LINEST functions.
Calculating depreciation.
Inserting and formatting tables.
Sparklines and data bars.
Pivot charts.

Requirements
Microsoft Excel 2013

Description
Microsoft Excel is, by a long way, the most widely-used spreadsheet software out there, and the 2013 edition is the most powerful and versatile version yet. Packed with new features and design changes, Microsoft Excel 2013 has plenty to offer for any company.
Whether you're new to Excel, or just looking to update your knowledge to the latest version, you'll find that the Ultimate Microsoft Excel 2013 Training Bundle will help you put together stunning and impressive spreadsheets with ease, helping you to stand out in the workplace and impress your boss.
This bundle includes:
19.5 hours of video tutorials Over 100 individual video lectures 2 quizzes with 90 test questions Certificate of completion
Courses included with this Bundle:
Microsoft Excel 2013 Beginners/Intermediate Training
During this 10-hour Online Excel 2013 Training, you'll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you'll discover how to enter and format data in the quickest manner possible. Next you'll be introduced to the power of Excel's functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you'll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.
Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work.
Learn Microsoft Excel 2013 - Advanced
Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 - Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.
Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you'll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.
Where else can you find so many extra tools to help you gain advanced skills in Excel 2013?!?!
So start learning today.
What People Are Saying

★★★★★ "I love it! He takes the time to explain how and why the operation is performed, gives you examples, and allows your brain time to absorb." -Barbie E. Deen

★★★★★ "I am actually quite well versed in Excel but decided to start with the beginner's portion of the course for 2 reasons: 1) I could listen along while I work to pick up tips &/or discover new features (I found at least 20); and 2) Assess the entirety of the course so that I could recommend it to friends/colleagues who have very basic Excel knowledge. Very good course." -Karen Hatt

★★★★★ "Excellent course. I first took the Simon Sez IT MS Project 2013 Bundle and really enjoyed the course. I learned a great deal from it. Since I liked it so much I decided to try the MS Excel 2013 course. I was quite pleased to find that Toby Arnott was the instructor again as he did a fantastic job with the Project courses. I think it was covered well. I recommend the course." -Derrick Bourgeois

★★★★★ "I found the lectures easy to understand even with the British accent. Simon's speech patterns enhanced my understanding of the lecture material. I have signed up for his Office 2013 courses because I know I will enjoy and understand the information given." -David W. Olsen★★★★★ "I am now a business analyst and I attribute my promotion directly to your courses. I'm much more savvy and confident with Excel. Thanks Simon."- Daniel Venti
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
** Updated July 2017: English close captions added

Overview

Section 1: Excel 2013 Beginners: Introduction

Lecture 1 Introduction to Excel 2013

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Excel 2013 Exercise Files

Lecture 4 Downloadable Course Transcript

Lecture 5 What's New

Section 2: Excel 2013 Beginners: Using Touch

Lecture 6 Overview of Principles

Section 3: Excel 2013 Beginners: Getting Started

Lecture 7 Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

Lecture 8 Templates; Creating, Opening, and Saving a Workbook

Section 4: Excel 2013 Beginners: Help

Lecture 9 Online, Offline, and Contextual Help

Section 5: Excel 2013 Beginners: Settings and Preferences

Lecture 10 Excel Options

Section 6: Excel 2013 Beginners: The Ribbon and Toolbars

Lecture 11 Ribbon Interface

Lecture 12 Quick Access Toolbar

Lecture 13 Mini Toolbar

Section 7: Excel 2013 Beginners: Backup and Recovery

Lecture 14 Create Backup Option; Auto-Recover and Autosave

Section 8: Excel 2013 Beginners: Enterting and Deleting Data

Lecture 15 Entering and Deleting Data

Lecture 16 Date Formats

Lecture 17 Formatting Cells; Editing and Deleting Data

Lecture 18 Fill

Lecture 19 Flash Fill

Section 9: Excel 2013 Beginners: Formatting a Worksheet

Lecture 20 Themes and Cell Styles

Lecture 21 Inserting, Deleting, Hiding and Adjusting Rows and Columns

Lecture 22 Wrap Text and Alignment

Lecture 23 Merging Cells; Applying Themes and Styles

Lecture 24 Borders

Section 10: Excel 2013 Beginners: Copy, Paste and Paste Special

Lecture 25 Copy, Cut and Paste

Section 11: Excel 2013 Beginners: Proofing

Lecture 26 Spell checking

Section 12: Excel 2013 Beginners: Managing Worksheets

Lecture 27 Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Section 13: Excel 2013 Beginners: Comments

Lecture 28 Inserting Comments

Section 14: Excel 2013 Beginners: Viewing and Printing

Lecture 29 Workbook Views, Zoom and Freeze

Lecture 30 Printing; Headers, Footers and Margins

Section 15: Excel 2013 Beginners: Formulas and Functions

Lecture 31 Overview of Formulas and Functions

Lecture 32 Cell References

Lecture 33 Names

Lecture 34 Finding Errors; New Excel Functions

Section 16: Excel 2013 Beginners: Working with Workbooks

Lecture 35 Multiple Workbooks and Windows; Comparing Workbooks

Section 17: Excel 2013 Beginners: Find and Replace

Lecture 36 Go to; Find and Replace Options

Section 18: Excel 2013 Beginners: Conditional Formatting

Lecture 37 Applying, Clearing and Managing Rules

Section 19: Excel 2013 Beginners: Graphing and Charting

Lecture 38 Chart Types; Chart Recommendation

Lecture 39 Basic Formatting

Lecture 40 Selecting Data, Positioning and Printing Charts

Section 20: Excel 2013 Beginners: File Types

Lecture 41 Saving Workbooks; PDF and CSV Formats

Section 21: Excel 2013 Beginners: Managing Data

Lecture 42 Sorting

Lecture 43 Filtering

Lecture 44 Tables

Section 22: Excel 2013 Beginners: Functions Case Study

Lecture 45 VLOOKUP

Lecture 46 Text Function

Lecture 47 Date and Time Functions

Lecture 48 Logical Functions

Section 23: Excel 2013 Beginners: Analyzing Data

Lecture 49 Financial Analysis Case Study - Part 1

Lecture 50 Financial Analysis Case Study - Part 2

Lecture 51 Quick Analysis Tool

Section 24: Excel 2013 Beginners: Shapes and Pictures

Lecture 52 Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Section 25: Excel 2013 Beginners: Sharing and Protecting

Lecture 53 Protecting Worksheets

Lecture 54 Protecting Workbooks

Lecture 55 Sharing and SkyDrive

Section 26: Excel 2013 Beginners: More Backstage View Options

Lecture 56 Trust Center; Export; Inspect Workbook

Section 27: Excel 2013 Beginners: Closing

Lecture 57 Summary; More Help

Section 28: Excel 2013 Advanced: Introduction

Lecture 58 Prerequisites of Excel 2013 Advanced Course

Lecture 59 WATCH ME: Essential Information for a Successful Training Experience

Lecture 60 DOWNLOAD ME: Excel 2013 Advanced Exercise Files

Lecture 61 Downloadable Course Transcript

Lecture 62 Course Review

Section 29: Excel 2013 Advanced: Functions

Lecture 63 List of Functions; Common Types of Arguments; Basic Use of Functions

Lecture 64 Advanced Aspects of Functions; Searching for a Function

Lecture 65 Autosum

Section 30: Excel 2013 Advanced: Personal and Professional Financial Functions

Lecture 66 Payment

Lecture 67 Future Value

Lecture 68 Principle Payment

Lecture 69 Depreciations

Section 31: Excel 2013 Advanced: Date and Time Functions

Lecture 70 How Dates and Times are Stored

Lecture 71 Dates and Times Calculation

Lecture 72 Exercise on Date and Time Functions; Date and Time Settings

Section 32: Excel 2013 Advanced: Statistical Functions for Description and Prediction

Lecture 73 Average

Lecture 74 Percentile

Lecture 75 Regression

Lecture 76 LINEST Function

Lecture 77 Example of Functions for Inferential Statistics

Section 33: Excel 2013 Advanced: Text Functions

Lecture 78 Text Function Case Study - 1

Lecture 79 Text Function Case Study - 2

Section 34: Excel 2013 Advanced: Lookup Functions

Lecture 80 Lookup and Reference Functions

Section 35: Excel 2013 Advanced: Logical Functions

Lecture 81 Logical Functions

Section 36: Excel 2013 Advanced: Connecting to External Data

Lecture 82 Connecting to Other Workbooks

Lecture 83 Connecting to Access Data

Lecture 84 Connecting to Web Data

Section 37: Excel 2013 Advanced: Tables

Lecture 85 Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row

Lecture 86 Inserting Columns and Rows; Resizing Tables

Lecture 87 Table Reference

Lecture 88 Table Styles

Lecture 89 Table Selection

Section 38: Excel 2013 Advanced: Pivot Tables

Lecture 90 Basic Principles of Pivot Tables

Lecture 91 Presentational Side of Pivot Tables

Lecture 92 Filtering in Pivot Tables; Slices

Section 39: Excel 2013 Advanced: Data Analysis

Lecture 93 What if

Lecture 94 Scenario Manager

Lecture 95 Goal Seeker

Lecture 96 Solver

Section 40: Excel 2013 Advanced: Charts

Lecture 97 Area Charts

Lecture 98 Surface Charts

Lecture 99 Stock Charts - Part 1

Lecture 100 Stock Charts - Part 2

Lecture 101 Radar Charts

Lecture 102 Bubble Charts

Section 41: Excel 2013 Advanced: Graphs

Lecture 103 Regression and Scatter Chart

Section 42: Excel 2013 Advanced: Pivot Charts

Lecture 104 Creating Pivot Charts

Section 43: Excel 2013 Advanced: Sparklines

Lecture 105 Using Sparklines

Section 44: Excel 2013 Advanced: Web App

Lecture 106 Creating Workbooks using a Web App

Lecture 107 Sharing your Workbook

Section 45: Excel 2013 Advanced: Conclusion

Lecture 108 Closing

Anyone new to Microsoft Excel or upgrading from a previous version.

Code:

https://anonymz.com/?https://www.udemy.com/course/the-ultimate-microsoft-excel-2013-training-bundle/

Code:

https://rapidgator.net/file/8b2f8dc798b586fcb37e808ede22107b/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part1.rar
https://rapidgator.net/file/bf1e56029920c449dbb224b5c5fb8731/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part2.rar
https://rapidgator.net/file/91c41bc808a39b4502571f8be4638db3/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part3.rar

Code:

https://k2s.cc/file/dc37fdcc5cfba/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part1.rar
https://k2s.cc/file/52404e181fb58/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part2.rar
https://k2s.cc/file/256b6e3b63fce/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part3.rar

Code:

https://nitroflare.com/view/07382155F393CA1/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part1.rar
https://nitroflare.com/view/1E2A598C46E2A0E/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part2.rar
https://nitroflare.com/view/B9BF5617012742A/The_Ultimate_Microsoft_Excel_2013_Training_Bundle_19_Hours.part3.rar

[Slon]

Capm Exam Cram Session - Pmbok Guide, 6Th Edition
Last updated 2/2019
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.42 GB | Duration: 6h 58m

CAPM Success! Everything you must know to pass the CAPM



What you'll learn
Final push to prepare to pass the CAPM exam
Discuss complete coverage of all exam objectives
Everything you must know to pass the CAPM

Requirements
Experience working with projects
Thorough understanding of project management
Desire to pass the CAPM exam

Description
Ready to pass your CAPM exam but need a final boost to get you there? This is the course for you.This short, but accurate, CAPM course focuses on the most important processes you must know to pass your CAPM exam. Focus on these topics and you'll be in great shape for earning those four wonderful letters: CAPM. This course covers the most essential components of the PMI CAPM exam. We'll also review all of the project management processes you should know for your CAPM exam. We've also included our popular CAPM Memory Sheets to help cram more efficiently.The CAPM Exam Cram includes a test-passing strategy that focuses on what you'll be tested on - not just what's in the PMBOK Guide, Sixth Edition. We've pared down the fluff and drilled it down into the exam objectives. If you're serious about passing the CAPM exam and need a final push for exam day - this is the seminar for you.In this CAPM Exam Cram session we include:A test-passing strategy for the CAPM examSpecific guidelines on what you need to know for CAPM exam successIn-depth explanations for CAPM topics like float, EVM, and chartingEvery CAPM exam topic explained and definedCAPM Memory Sheets to print and memorizeComplete walkthrough of the ITTOs135-practice exam questions30-day satisfaction guarantee

Overview

Section 1: Preparing to Pass the CAPM Exam

Lecture 1 CAPM Cram Session Course Overview

Lecture 2 CAPM Foundations

Lecture 3 How to Study to Pass the CAPM Exam

Lecture 4 Memory Sheets

Lecture 5 CAPM Foundations Wrap

Section 2: PMBOK Guide, Sixth Edition and the CAPM Exam

Lecture 6 PMBOK Guide, Sixth Edition Overview

Lecture 7 Organizations and Project Management

Lecture 8 Agile Project Management

Lecture 9 Tailoring Project Management Processes

Lecture 10 PMBOK Guide, Sixth Edition Wrap

Section 3: CAPM Terminology

Lecture 11 Project Management Terminology Overview

Lecture 12 Project Management Business Documents

Lecture 13 PMBOK Guide Terms

Lecture 14 Benefits Management Plan

Lecture 15 Governance and Project Management

Lecture 16 Organization Structures

Lecture 17 Project Management Offices

Lecture 18 Role of the Project Manager

Lecture 19 Project Management Values and Competencies

Lecture 20 Project Management Leadership Styles

Lecture 21 Politics and Power

Lecture 22 Project Management Terminology Wrap

Section 4: Project Integration Management

Lecture 23 Project Integration Management Overview

Lecture 24 Develop Project Charter

Lecture 25 Selecting Projects for Initiation

Lecture 26 Assumptions and Constraints

Lecture 27 Typical Project Management Plan

Lecture 28 Integrated Change Control

Lecture 29 Closing Activities

Lecture 30 Project Integration Management Wrap

Section 5: Project Scope Management

Lecture 31 Project Scope Management Overview

Lecture 32 Planning the Project Scope

Lecture 33 Creating the WBS

Lecture 34 Performing Scope Validation

Lecture 35 Controlling Project Scope

Lecture 36 Project Scope Management Wrap

Section 6: Project Schedule Management

Lecture 37 Project Schedule Management Overview

Lecture 38 Planning Schedule Management

Lecture 39 Developing the Project Schedule

Lecture 40 Creating Duration Estimates

Lecture 41 Finding Float

Lecture 42 Project Schedule Management Wrap

Section 7: Project Cost Management

Lecture 43 Project Cost Management Overview

Lecture 44 Creating Cost Estimates

Lecture 45 Developing the Project Budget

Lecture 46 Earned Value Management

Lecture 47 Project Cost Management Wrap

Section 8: Project Quality Management

Lecture 48 Project Quality Management Overview

Lecture 49 Planning Quality Management

Lecture 50 Controlling Project Quality

Lecture 51 Quality Management Charts

Lecture 52 Project Quality Management Wrap

Section 9: Project Resource Management

Lecture 53 Project Resource Management Overview

Lecture 54 HR Theories

Lecture 55 Planning Resource Management

Lecture 56 Developing the Project Team

Lecture 57 Managing the Project Team

Lecture 58 Project Resource Management Wrap

Section 10: Project Communications Management

Lecture 59 Project Communications Management Overview

Lecture 60 Planning Communications

Lecture 61 Communications Model

Lecture 62 Project Communications Management Wrap

Section 11: Project Risk Management

Lecture 63 Project Risk Management Overview

Lecture 64 Identifying Project Risks

Lecture 65 Performing Qualitative Analysis

Lecture 66 Performing Quantitative Analysis

Lecture 67 Responding to Positive and Negative Risks

Lecture 68 Project Risk Management Wrap

Section 12: Project Procurement Management

Lecture 69 Project Procurement Management Overview

Lecture 70 Reviewing Contract Types

Lecture 71 Determining Build or Buy

Lecture 72 Following the Procurement Workflow

Lecture 73 Closing the Project Contracts

Lecture 74 Project Procurement Management Wrap

Section 13: Project Stakeholder Management

Lecture 75 Project Stakeholder Management Overview

Lecture 76 Identifying Project Stakeholders

Lecture 77 Performing Stakeholder Analysis

Lecture 78 Reviewing Stakeholder Register and Engagement

Lecture 79 Project Stakeholder Management Wrap

Section 14: Ethics, Process ITTOs, and Course Wrap

Lecture 80 PMI Code of Ethics

Lecture 81 49 Project Management Processes and ITTOs

Lecture 82 CAPM Cram Session Course Wrap

CAPM exam candidates,Project managers and aspiring project managers

Code:

https://anonymz.com/?https://www.udemy.com/course/capm-exam-cram-session-pmbok6/

Code:

https://rapidgator.net/file/e9ba343c7e6c328b693b6729a903c309/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part1.rar
https://rapidgator.net/file/ccdd75e9310ee0180feaeb08f99ec453/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part2.rar

Code:

https://k2s.cc/file/68f430432c80d/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part1.rar
https://k2s.cc/file/c6e72a2c0b451/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part2.rar

Code:

https://nitroflare.com/view/45E9076A9888A77/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part1.rar
https://nitroflare.com/view/07446C119BB7391/CAPM_Exam_Cram_Session_PMBOK_Guide_6th_edition.part2.rar

[Slon]

Ultimate Microsoft Project 2016 Course - Beginner To Expert
Last updated 1/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.10 GB | Duration: 19h 0m

18 Hours of Training + 18 PDUs. The Most Convenient Way to Learn MS Project 2016 Inside And Out-Quickly



What you'll learn
Consolidating multiple projects.
Learn to effectively split projects into sub-projects.
How to track costs.
Effective use of budgets.
Manage cost rate changes.
Import and exporting of project data.
Includes exercise files.
Learn valuable new skills for complex projects at work
Discover how to work with costs, deadlines, and overcome scheduling issues
Learn critical paths
Setting up tasks and tracing their paths
Discover how to use subtasks, dependencies, deadlines, and resources
How to format a Gantt chart
Resource allocation
Leveling
Interim plans and baselines
Safeguards and restrictions
Learn how to use Project 2016 on a touch device
How to measure a project against a baseline project
How to save your project as a template for future projects
Utilize calendars and timelines in MS Project 2016
Assign resources to a task
Discover how to manage cost rate changes
Use of outline codes and WBS codes
How to use macros the speed up use and work more efficiently

Requirements
Microsoft Project 2016

Description
**Course includes practice exercise files, LIFETIME access and is covered by the Udemy money-back guarantee**** Claim 18.75 PDUs**Learn Project 2016 Inside and Out with This 2-Course Training Bundle Includes 2 complete courses: The Project 2016 Beginner Course & The Project 2016 Advanced Course Includes 18 hours of high-quality training by your professional trainer Taught by a Certified Project Manager with real project management experience Practice along using exercise files Watch and learn with demo project files Progresses logically from the beginning with an easy intro to advanced topics Printable course transcriptions to follow along and take notesKeep Track of Projects from Start to Finish With Microsoft's Comprehensive Program Microsoft Project is Microsoft Corporation's project management software. Over the years since its initial development, MS Project has become one of the most widely used project management applications in existence. It provides assistance to project managers and coordinators by organizing plans, resources, tasks, budgets, workloads, and much more, all while keeping track of a project's overall progress from start to finish. Knowledge of Microsoft Project can be an invaluable tool for anyone whose work requires the orchestration of long-term projects and plans. Contents and Overview for the 9-Hour Project 2016 Beginner Course This course starts right at the very beginning. It doesn't assume you know anything about Microsoft Project, so beginners will feel right at home. The first video lesson introduces you to the software. You'll learn how to get your own copy of Project 2016, see what's new in version 2016 and explore the structure of this course. The second chapter takes on the basics you need to begin using Project 2016. It first discusses the Help section where you can get answers and tutorials for any question that comes up. This chapter also discusses creating a Workspace, using Toolbars, Ribbons, and the Status Bar. Continue on as you learn how to use Touch, Task basics, and Project Options. By now you will have become proficient with Project 2016. The chapters that follow lead learners through all the various aspects of managing a project. These more advanced topics carry you through Tracking Costs, Tracking the Project, Budgeting, and Reporting. Each topic is explained with its own professional video that shows you in detail how to properly use the function. Nine hours of insightful video give you an in-depth understanding of each topic. 63 individual lessons are included. Upon completion of the course, you'll have an excellent mastery of Microsoft Project 2016.

Contents and Overview for the 9-Hour Project 2016 Advanced Course Even difficult features and activities are made easy. This course keeps things understandable and logical to follow. It starts with an overview of the course structure and how to get the most out of the training. Chapter 2 launches into Consolidation and Resource Sharing, giving you advanced insight into how to create efficiency with staff and materials. This is often where major savings begin for a business or organization that uses MS Project. Chapter 3 shows you how to set up recurring tasks to save lots of time and effort. Chapter 4 instructs you how to set up custom fields, an advanced activity that lets you customize MS Project for your company or project. Chapter 5 delves into Outline Codes and WBS codes. It's important to note each chapter is concluded with an exercise. This gives you the opportunity to practice applying concepts and actions in real-life situations. Chapter 6 lets you master all advanced aspects of the Costs section of MS Project 2016. This gives you the ability to control cost across multiple projects to bring them all in under budget. Subsequent chapters show you how to customize a number of aspects of MS Project, create a variety of helpful reports and how to use macros.

* Includes quizzes, exercise files, demo files and certificate of completion** Updated July 2017: English close captions added** Updated June 2017. Course transcripts now available. What People Are Saying: ★★★★★ "I think the course is very comprehensive for beginners to Microsoft Project. Even if you are familiar with most of the common Microsoft Office programs, the guidelines presented serve as a very useful refresher." -Johan Deosaran ★★★★★ "Wonderful Examples and able to follow along nicely with clear descriptions and lay out. I am finally able to understand the basic usage of MS Project 2016." -Terri Leedy

Overview

Section 1: Introduction to Project 2016 Beginner Course

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Demo Files

Lecture 5 Downloadable Course Transcripts

Lecture 6 Acquiring Project 2016

Lecture 7 Course Structure

Lecture 8 What's New in Project 2016

Section 2: Project Beginner: Workspace, The Ribbon and Help

Lecture 9 The Project 2016 Workspace

Lecture 10 Online Help

Lecture 11 Ribbon and Toolbars

Lecture 12 Status Bar

Lecture 13 Keyboard Shortcuts and Tips

Section 3: Project Beginner: Using Touch

Lecture 14 Overview of Principles

Section 4: Project Beginner: Project Options

Lecture 15 Overview of Project Options

Section 5: Project Beginner: Task Basics

Lecture 16 Entering Tasks

Lecture 17 Opening and Closing Projects

Lecture 18 Exercise 1

Lecture 19 Task Properties

Section 6: Project Beginner: Subtasks

Lecture 20 Subtasks

Lecture 21 Exercise 2

Section 7: Project Beginner: Dependencies, Deadlines and Milestones

Lecture 22 Linking and Unlinking Tasks

Lecture 23 Setting Constraints and Deadlines

Lecture 24 Setting Milestones

Lecture 25 Exercise 3

Section 8: Project Beginner: Resources

Lecture 26 Filling Up the Resource Sheet

Lecture 27 Resource Assignment Basics

Lecture 28 Adding Resources to Tasks

Lecture 29 The Basics of Scheduling

Lecture 30 Resource Leveling Basics

Lecture 31 Leveling Options

Lecture 32 Exercise 4

Section 9: Project Beginner: Views and Timelines

Lecture 33 Views - Part 1

Lecture 34 Views - Part 2

Lecture 35 Timelines

Section 10: Project Beginner: Costs

Lecture 36 Setting Cost for Tasks

Lecture 37 Exercise 5

Lecture 38 Adding Cost Resources

Lecture 39 Setting Up Budget Cost

Section 11: Project Beginner: Baselines and Critical Paths

Lecture 40 Measuring a Project Against a Baseline

Lecture 41 Working with Critical Path

Lecture 42 Exercise 6

Lecture 43 Changing Baselines

Section 12: Project Beginner: Tables

Lecture 44 Modifying Task and Resource Tables

Section 13: Project Beginner: Gantt Chart

Lecture 45 Formatting a Gantt Chart

Section 14: Project Beginner: Notes

Lecture 46 Applying Notes to Tasks or Resources

Section 15: Project Beginner: Printing and Spellchecking

Lecture 47 Modifying Print Options and Printing your Current View

Lecture 48 Spellchecking Your Project

Section 16: Project Beginner: Tracking Progress

Lecture 49 Tracking Progress - Part 1

Lecture 50 Tracking Progress - Part 2

Lecture 51 Exercise 7

Section 17: Project Beginner: Reporting

Lecture 52 Reporting - Part 1

Lecture 53 Reporting - Part 2

Lecture 54 Exercise 8

Section 18: Project Beginner: Tracking Costs

Lecture 55 Recording Costs

Section 19: Project Beginner: The Organizer

Lecture 56 Using the Organizer to Manage Views

Section 20: Project Beginner: Saving Projects

Lecture 57 Save As Options

Section 21: Project Beginner: Project Security

Lecture 58 Password Protect an MPP file

Section 22: Project Beginner: Project Templates

Lecture 59 Saving your Project as a Template

Section 23: Project Beginner: Calendars

Lecture 60 Calendars - Part 1

Lecture 61 Calendars - Part 2

Lecture 62 Exercise 9

Section 24: Project Beginner: Scheduling Issues

Lecture 63 Task Inspector

Lecture 64 Task Paths

Lecture 65 Team Planner

Section 25: Project Beginner: Conclusion

Lecture 66 Additional Topics and Closing

Section 26: Project Advanced: Introduction

Lecture 67 Introduction to Project 2016 Advanced Course

Lecture 68 WATCH ME: Essential Information for a Successful Training Experience

Lecture 69 DOWNLOAD ME: Course Exercise Files

Lecture 70 DOWNLOAD ME: Course Demo Files

Lecture 71 Downloadable Course Transcripts

Lecture 72 Course Structure

Section 27: Project Advanced: Consolidation and Resource Sharing

Lecture 73 Introduction to Consolidation and Resource Sharing

Lecture 74 Resource Sharing

Lecture 75 Project Consolidation

Lecture 76 Exercise 1

Lecture 77 Practical Sharing and Consolidation - Part 1

Lecture 78 Practical Sharing and Consolidation - Part 2

Section 28: Project Advanced: Recurring Tasks

Lecture 79 Setting Up Recurring Tasks

Section 29: Project Advanced: Custom Fields

Lecture 80 Creating a Custom Field

Lecture 81 Calculated Custom Field - Part 1

Lecture 82 Calculated Custom Field - Part 2

Lecture 83 Exercise 2

Section 30: Project Advanced: Outline Codes and WBS Codes

Lecture 84 What are Outline Numbering and WBS Codes

Lecture 85 Problems in Outline Numbering and WBS Codes

Lecture 86 Outline Codes

Lecture 87 Exercise 3

Section 31: Project Advanced: Costs

Lecture 88 Fixed Task Costs

Lecture 89 Cost Accrual

Lecture 90 Budget Costs

Lecture 91 Cost Rates and Rate

Lecture 92 Overtime

Lecture 93 Variable Material Costs

Lecture 94 Exercise 4

Section 32: Project Advanced: Custom Tables

Lecture 95 Customization of Tables

Lecture 96 Management of Custom Table Definitions

Section 33: Project Advanced: Custom Views

Lecture 97 Use of Custom Views

Section 34: Project Advanced: Sorting, Filtering, and Grouping

Lecture 98 Sorting

Lecture 99 Filtering

Lecture 100 Grouping

Lecture 101 Exercise 5

Section 35: Project Advanced: Reports

Lecture 102 Reporting Overview

Lecture 103 Creating and Customizing Reports - Part 1

Lecture 104 Creating and Customizing Reports - Part 2

Lecture 105 Creating and Customizing Reports - Part 3

Lecture 106 Creating and Customizing Reports - Part 4

Lecture 107 Targeted Reporting - Part 1

Lecture 108 Targeted Reporting - Part 2

Lecture 109 Exercise 6

Lecture 110 Comparing Projects

Section 36: Project Advanced: Visual Reports

Lecture 111 Visual Reporting using Excel

Lecture 112 Visual Reporting using Visio

Section 37: Project Advanced: Earned Value Analysis

Lecture 113 Earned Value Analysis Basic Terminology

Lecture 114 Example of Earned Value Analysis

Lecture 115 Exercise 7

Section 38: Project Advanced: Import and Export

Lecture 116 Importing Data to Project

Lecture 117 Exporting Data from Project

Lecture 118 Exercise 8

Section 39: Project Advanced: Macros

Lecture 119 Recording a Macro

Lecture 120 Writing a Macro

Lecture 121 Macro Security

Lecture 122 Exercise 9

Section 40: Project Advanced: Conclusion

Lecture 123 Closing

Lecture 124 Claim PDUs

Section 41: Congratulations!

Lecture 125 BONUS Lecture

Users new to Microsoft Project 2016 and those upgrading from previous software versions,Anyone new to the project management role,New project managers,Anyone who wants to learn project management and Microsoft Project,Project Managers and other business professionals who are familiar with Microsoft Project 2013 (or previous versions) and are looking to deepen their knowledge with more advanced skills.,Experienced Project Managers or those who are familiar with MS Project 2016 or 2013

Code:

https://anonymz.com/?https://www.udemy.com/course/ultimate-microsoft-project-2016-course-beginner-to-expert/

Code:

https://rapidgator.net/file/2274a3b17ca67b1e6bf875654da1101e/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part1.rar
https://rapidgator.net/file/919d92a79eda7305106c422f184807b3/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part2.rar

Code:

https://k2s.cc/file/e36df0906d662/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part1.rar
https://k2s.cc/file/5c0c8cc3efee6/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part2.rar

Code:

https://nitroflare.com/view/DEB7C84A4E402AE/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part1.rar
https://nitroflare.com/view/2D42FB8CC438E0B/Ultimate_Microsoft_Project_2016_Course_Beginner_to_Expert.part2.rar

[Slon]

Ultimate Microsoft Access 2019 Bundle: Beginner - Advanced
Last updated 4/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.22 GB | Duration: 15h 46m

Master Microsoft Access with this comprehensive beginner to advanced MS Access course



What you'll learn
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Explore the use of Visual Basic for Applications (VBA).
Practice what you learned with included exercise files
Sorting information and running queries
Creating tables and relationships
Navigating the Access 2019 interface
Design forms and generate reports
Learn valuable new skills for complex data projects at work
Supercharge your database projects
Discover how to into import data from Excel
Learn Queries, use validations, how to create and print reports
How to compact, repair and backup your database
How to create a linked table
Discover how to use the Query Wizard
Learn to use Model Dialog and Macros
Discover advanced options for the use of forms.
Dive into options for packaging your application for distribution.
Follow along as you learn to create and maintain macros.
Get helpful techniques that allow you to link, report, and package your data quickly.

Requirements
Microsoft Access 2019, 2016 or Access 365

Description
**This course includes practice exercises and LIFETIME access**Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it's far more user-friendly and ideal if you're not a developer.This huge-value Microsoft Access bundle is made up of two full MS Access courses, Access for Beginners and Access Advanced. If you are brand new to Microsoft Access, that's no problem. We start at the very beginning and take you on a journey to becoming an Access database superstar. We take a project approach to this course, which means you build your own project out as we go. By the end of this Access 2019 course, you will be using Advanced Access functions such as VBA and Macros and SQL.In the Microsoft Access Beginners course you will learn:Where to start in Microsoft Access and whether to use a template or notHow to modify Access to suit your needsAll about importing data and the datasheet viewHow tables work in Access and how to create relationships between themCreating forms and sub-forms that feed data into your tablesHow to run queries in AccessSetting up validations and calculations using expressions in AccessPrinting from AccessTo start to use macros and Modal DialogThe basics of the Access web appExporting and reporting in AccessIn the Microsoft Access Advanced course you will learn:All about Primary Keys and Indexes in AccessAbout customizing and filtering on the Datasheet ViewHow to link to other databasesAll about using ODBC and SQL ServerHow to split an Access database into front and back-endAll about Macros in Access including AutoExecHow to do basic VBA in Access including code and error handlingMore advanced techniques around creating forms in AccessAdvanced queries including "multiple where" criteria***Exercise and demo files included***This course includes:14+ hours of video tutorials100+ individual video lecturesExercise files to practice what you learnedCertificate of completionThis course is designed for students that are new to Microsoft Access, are upgrading from a previous version, or have a basic understanding and are looking to sharpen their skills. If you've been using Access for years but are convinced that you're not utilizing its full potential, then you need this course.If your Excel spreadsheets keep crashing with too much data, then it's time you got to know Microsoft Access. Let us show you how.Here's what our students are saying."This was a great course. I already had a base in some of these programs, but this has taken my understanding to a whole new level!"- Nathaniel Andrew Putnam"Great course!I've created some decent Access databases in years past but it was mostly self taught through reading and some early YouTube videos. There was much that I didn't know or comprehend that left my databases incomplete or didn't perform the way I wanted. This course explains all of the things I was missing.Tons of information provided and explained very well. Access is very powerful with so many options, properties, and such that it will take a beginner quite some time to become proficient but this course explains so much, with many examples that reinforce learning. Macros, SQL, and VBA, has been a big mystery for years...for me. The instructor walks you through the basics and now I have a foundation to pursue these topics further without hesitation.The instructor is pleasant to listen to and is very organized in the information given, both in order and detail."- David Keach"I am using access 2019 and this course is very informative. I want to say think you for taking your time and explaining each step. I recommend this course to everyone who wants to improve their access knowledge."- Adam HanekDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!

Overview

Section 1: Access 2019 Beginners: Introduction

Lecture 1 Introduction to Access 2019

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Demo Files

Lecture 5 DOWNLOAD ME: Course Transcripts

Lecture 6 Acquiring Access 2019

Lecture 7 Structure of the Course

Section 2: Access 2019 Beginners: Getting Started with Access 2019

Lecture 8 Using Database Templates

Lecture 9 Creating, Saving and Opening Databases

Lecture 10 The Access Workspace and Backstage

Lecture 11 Online Help and Tell Me What You Want To Do

Section 3: Access 2019 Beginners: The Ribbon and Toolbars

Lecture 12 Working with the Ribbon

Lecture 13 The Quick Access Toolbar

Lecture 14 Contextual Menus

Lecture 15 The Status Bar

Section 4: Access 2019 Beginners: Keyboard Shortcuts and Key Tip

Lecture 16 Keyboard Shortcuts

Lecture 17 Key Tips

Section 5: Access 2019 Beginners: Access Options

Lecture 18 Exploring Access Options

Section 6: Access 2019 Beginners: Tables

Lecture 19 Creating a Table and Fields

Lecture 20 Indexed Field

Lecture 21 Lookup Wizard

Lecture 22 Numeric Fields

Lecture 23 Practice Exercise 01

Section 7: Access 2019 Beginners: Importing Data

Lecture 24 Importing Data from Excel

Lecture 25 Practice Exercise 02

Section 8: Access 2019 Beginners: Backup, Restore and Repair

Lecture 26 Backing up your Database

Lecture 27 Compact and Repair

Section 9: Access 2019 Beginners: Datasheet View

Lecture 28 Design in the Datasheet View

Lecture 29 Sorting and Filtering in Datasheet View

Lecture 30 Entering and Modifying Data in Datasheet View

Section 10: Access 2019 Beginners: Relationships

Lecture 31 Creating a Link Table

Lecture 32 Setting up Relationships

Lecture 33 Practice Exercise 03

Section 11: Access 2019 Beginners: Forms

Lecture 34 Creating a Form

Lecture 35 Modifying a Form

Lecture 36 Practice Exercise 04

Lecture 37 Forms in Layout View

Lecture 38 Forms in Design View

Lecture 39 Form Design

Lecture 40 Practice Exercise 05

Section 12: Access 2019 Beginners: Subforms

Lecture 41 Setting Up Subforms - Part 1

Lecture 42 Setting Up Subforms - Part 2

Lecture 43 Setting Up Subforms - Part 3

Lecture 44 Practice Exercise 06

Section 13: Access 2019 Beginners: Queries

Lecture 45 Creating a Query

Lecture 46 Joins

Lecture 47 Query Wizard

Lecture 48 Practice Exercise 07

Section 14: Access 2019 Beginners: Expressions

Lecture 49 Setting Up Validations

Lecture 50 Calculation using Expressions

Section 15: Access 2019 Beginners: Reports

Lecture 51 Basic Reports

Lecture 52 Report Design

Lecture 53 Complex Reports

Lecture 54 Practice Exercise 08

Section 16: Access 2019 Beginners: Printing

Lecture 55 Printing and Print Properties

Section 17: Access 2019 Beginners: More Data Types

Lecture 56 Yes/No, OLE Objects and Hyperlink Data Types

Section 18: Access 2019 Beginners: More About Forms

Lecture 57 Form Controls

Lecture 58 Form Themes

Lecture 59 Navigation Forms

Section 19: Access 2019 Beginners: Exporting

Lecture 60 Exporting an Access Database

Section 20: Access 2019 Beginners: Application Parts

Lecture 61 Adding Application Parts to a Database

Section 21: Access 2019 Beginners: More Access Options

Lecture 62 Additional Access 2019 Options

Section 22: Access 2019 Beginners: Info Tab

Lecture 63 Edit Database Properties and Encrypt with Password

Section 23: Access 2019 Beginners: Course Close

Lecture 64 Course Close

Section 24: Access 2019 Advanced: Introduction

Lecture 65 Course Overview and Content

Lecture 66 WATCH ME: Essential Information for a Successful Training Experience

Lecture 67 DOWNLOAD ME: Course Exercise Files

Lecture 68 Downloadable Course Transcripts

Section 25: Access 2019 Advanced: Primary Keys and Indexes

Lecture 69 Primary Keys and Indexing Rules and Guidelines

Lecture 70 More About Indexes

Section 26: Access 2019 Advanced: Using Datasheet View

Lecture 71 Setting-up Northwind Database

Lecture 72 Working in a Datasheet View

Lecture 73 Customizing Datasheet View and Advanced Sorting and Filtering

Lecture 74 Subdatasheets

Lecture 75 Exercise 01

Section 27: Access 2019 Advanced: Linking to Other Access Databases

Lecture 76 Linking Two Tables to Other Access Databases

Section 28: Access 2019 Advanced: Using ODBC and SQL Server

Lecture 77 Acquiring and Installing SQL Server Express

Lecture 78 Setting Up SQL Server Database

Lecture 79 Exercise 02

Section 29: Access 2019 Advanced: Splitting an Access Database

Lecture 80 Splitting an Access Database into Front-end and Back-end

Lecture 81 Converting Shared Table into Local Table; Moving Back-end Database

Lecture 82 Exercise 03

Lecture 83 Addressing Multi-user Issues when Sharing Data

Section 30: Access 2019 Advanced: Macros

Lecture 84 Basics of Macros

Lecture 85 Macros on Events; AutoExec

Lecture 86 More About AutoExec; Bypassing AutoExec

Lecture 87 Macro Security Settings

Lecture 88 Exercise 04

Section 31: Access 2019 Advanced: The Ribbon

Lecture 89 Customizing the Ribbon and Quick Access Tool

Section 32: Access 2019 Advanced: Visual Basic for Applications

Lecture 90 Convert Macros to VBA; VBA Editor and Property Windows

Lecture 91 VBA Modules; Running Code and Error Handling

Lecture 92 Creating Modules; Subs, Functions, Intellisense and Variables

Lecture 93 Scope, Variable Naming and Strings

Lecture 94 Standard Functions; Logical, Case and Loop Statements

Section 33: Access 2019 Advanced: Access Events Model

Lecture 95 Adding Events to Assets Database

Lecture 96 Exercise 05

Lecture 97 Common Events; Form and Report Events

Lecture 98 Switchboard and Navigation Form; Error Handling

Lecture 99 Exercise 06

Section 34: Access 2019 Advanced: Forms

Lecture 100 Formatting Bound and Control Form

Lecture 101 Split Forms; Macro Error Handling

Lecture 102 Creating Form with Tab

Lecture 103 Go To Combo Box and Its Properties

Lecture 104 Exercise 07

Section 35: Access 2019 Advanced: Advanced Use of Queries

Lecture 105 Basics of Queries

Lecture 106 Syntax of SQL Statements

Lecture 107 Use of Multiple Where Criteria & Select Statements Function

Lecture 108 Exercise 08

Lecture 109 Action Queries - Part 1

Lecture 110 Action Queries - Part 2

Section 36: Access 2019 Advanced: Packaging You Application

Lecture 111 Steps in Packaging Access Application

Lecture 112 Exercise 9

Section 37: Extras

Lecture 113 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic

Section 38: Conclusion

Lecture 114 Course Close

Anyone new to Microsoft Access,Experienced database managers or those who are familiar with Access 2016 or 2013,Users new to Microsoft Access 2019 and those upgrading from previous software versions,Anyone new to the data management role,Anyone who wants to learn data management and Microsoft Access

Code:

https://anonymz.com/?https://www.udemy.com/course/microsoft-access-2019-course-beginner-advanced/

Code:

https://rapidgator.net/file/537c3d58a7a63caa192fece6ab1e161b/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part1.rar
https://rapidgator.net/file/2414fec5d154f284345813264bdd4f95/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part2.rar

Code:

https://k2s.cc/file/c8a6406db2d59/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part1.rar
https://k2s.cc/file/ba5d410107ed2/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part2.rar

Code:

https://nitroflare.com/view/47A419A9A197DA3/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part1.rar
https://nitroflare.com/view/2F323CB9214B147/Ultimate_Microsoft_Access_2019_Bundle_Beginner_Advanced.part2.rar

[Slon]

Microsoft 365 Ultimate Guide 2022
Instructors: Learn Tech Plus
39 sections • 506 lectures • 22h 25m
Video: MP4 1280x720 44 KHz | English + Sub
Updated 7/2022 | Size: 9.7 GB

Everything you need to know about Microsoft 365 for 2022



What you'll learn
Setup Microsoft 365 Account
Learn Microsoft 365
Learn Microsoft 365 Menu and Interface
Home
Users
Groups
Billing
Setup
Reports
Health
Security
Compliance
Azure Active Directory
Dark Mode
User Management
Show more
Show less


Requirements
Willingness to Have Fun and Learn!Setup Microsoft 365 AccountHave Access to Microsoft 365 Account


Description
Have you always wanted to learn Microsoft 365 but don't know where to start?
Would you like to manager accounts and bring your ideas to life?
Then Microsoft 365 2021 Ultimate Course is for you!
Hi, I'm your instructor Josh Werner and I'll be leading you through this course.
Microsoft 365 is an in-demand skill in 2021.
The course begins with the basics.;
I'll take you through everything you need to know to start adding accounts like an expert with Microsoft 365.
You'll learn all the fundamentals of Microsoft 365.
This is great for students starting or for IT Personal that need a refresher course on Microsoft 365.
There are no requirements necessary to enroll I only ask that you come open minded and ready to learn
Feel Free to look through the course description and checkout some of my preview videos
The course is packed with over 22 hours of hands-on tutorials
Here's What You'll Learn:
01. Introduction
; 001. Overview
02. Products - For Home
; 002. Overview
; 003. Plans and Pricing
; 004. For Families
; 005. For Individuals
; 006. For Students
; 007. Summary
03. Products - For Business
; 008. Overview
; 009. Plans and Pricing
; 010. Small Business
; 011. Summary
04. Products - Enterprise
; 012. Overview
; 013. Plans and Pricing
; 014. Enterprise Features
; 015. Summary
05. Business Premium Account
; 016. Overview
; 017. Setup Account
; 018. Summary
06. Admin Center - Main Menu
; 019. Overview
; 020. Home
; 021. Users
; 022. Devices
; 023. Groups
; 024. Roles
; 025. Resources
; 026. Billing
; 027. Support
; 028. Settings
; 029. Setup
; 030. Reports
; 031. Health
; 032. Security
; 033. Compliance
; 034. Endpoint Manager
; 035. Azure Active Directory
; 036. Exchange
; 037. SharePoint
; 038. Teams
; 039. Summary
07. Outlook - Web App
; 040. Overview
; 041. Launch Outlook Web App
; 042. Inbox
; 043. Sent Items
; 044. Drafts
; 045. Add Favorite
; 046. Deleted Items
; 047. Junk Email
; 048. Archive
; 049. Notes
; 050. New Folder
; 051. New Group
; 052. Discover Groups
; 053. Manage Groups
; 054. Calendar
; 055. People
; 056. Files
; 057. To-Do
; 058. Launch Word Web App
; 059. Launch Excel Web App
; 060. Launch PowerPoint Web App
; 061. Launch OneNote Web App
; 062. Summary
08. OneDrive - Web App
; 063. Overview
; 064. Launch OneDrive Web App
; 065. My Files
; 066. Recent
; 067. Shared
; 068. Recycle Bin
; 069. Get The OneDrive App
; 070. Return To Classic OneDrive
; 071. Summary
09. Word - Web App
; 072. Overview
; 073. Launch Word App
; 074. New Blank Document
; 075. Save File
; 076. Home
; 077. Insert
; 078. Layout
; 079. References
; 080. Review
; 081. View
; 082. Help
; 083. Editing
; 084. Share
; 085. Comments
; 086. Catch Up
; 087. Home
; 088. New
; 089. Open
; 090. Info
; 091. Save As
; 092. Export
; 093. Print
; 094. Share
; 095. About
; 096. Summary
10. Excel - Web App
; 097. Overview
; 098. Launch Excel Web App
; 099. New Blank Workbook
; 100. Save File
; 101. Home
; 102. Insert
; 103. Draw
; 104. Page Layout
; 105. Formulas
; 106. Data
; 107. Review
; 108. View
; 109. Automate
; 110. Help
; 111. Editing
; 112. Share
; 113. Comments
; 114. Home;
; 115. New
; 116. Open
; 117. Info
; 118. Save As
; 119. Print
; 120. Share
; 121. Options
; 122. About
; 123. Summary
11. PowerPoint - Web App
; 124. Overview
; 125. Launch PowerPoint Web App
; 126. New Blank Presentation
; 127. Save File
; 128. Home
; 129. Insert
; 130. Draw
; 131. Design
; 132. Transitions
; 133. Animations
; 134. Slide Show
; 135. Review
; 136. View
; 137. Help
; 138. Editing
; 139. Share
; 140. Comments
; 141. Present
; 142. File
; 143. Project - Download Files
; 144. Project - Overview
; 145. Project - Layout Slides
; 146. Project - Content for Slides
; 147. Project - Check Slides
; 148. Project - Add Transitions
; 149. Project - Add Animations
; 150. Project - Rehearsal
; 151. Project - Present
; 152. Project - Summary
; 153. Summary
12. OneNote - Web App
; 154. Overview
; 155. Launch OneNote Web App
; 156. New Notebook
; 157. Home
; 158. Insert
; 159. Draw
; 160. View
; 161. Help
; 162. Open in Desktop App
; 163. Share
; 164. File Menu
; 165. Summary
13. Teams - Web App
; 166. Overview
; 167. Launch Teams Web App
; 168. Activity
; 169. Chat
; 170. Teams
; 171. Calendar
; 172. Files
; 173. Apps
; 174. Help
; 175. Download Desktop App
; 176. Settings
; 177. Summary
14. Power Automate - Web App
; 178. Overview
; 179. Launch Power Automate Web App
; 180. Home
; 181. Action Items
; 182. My Flows
; 183. Create
; 184. Templates
; 185. Connectors
; 186. Data
; 187. Monitor
; 188. AI Builder
; 189. Process Advisor
; 190. Solutions
; 191. Learn
; 192. Summary
15. Planner - Web App
; 193. Overview
; 194. Launch Planner Web App
; 195. New Plan
; 196. Planner Hub
; 197. My Tasks
; 198. Get The Planner App
; 199. Create A Plan
; 200. Board
; 201. Charts
; 202. Schedule
; 203. Conversation
; 204. Members
; 205. Files
; 206. Notebook
; 207. Sites
; 208. Add to Favorites
; 209. Copy Plan
; 210. Export Plan to Excel
; 211. Copy Link to Plan
; 212. Plan Settings
; 213. Add Plan to Outlook Calendar
; 214. Summary
16. Power Apps - Web App
; 215. Overview;
; 216. Launch PowerApps Web App
; 217. Home
; 218. Learn
; 219. Apps
; 220. Create
; 221. Data
; 222. Flows
; 223. Chatbots
; 224. AI Builder
; 225. Solutions
; 226. Summary
17. Visio - Web App
; 227. Overview;
; 228. Launch Visio Web App
; 229. New Blank Drawing
; 230. Flowchart Template
; 231. Basic Diagram Template
; 232. Process Steps Template
; 233. Block Diagram Template
; 234. Business Matrix Diagram
; 235. More Templates
; 236. Popular Templates
; 237. Basic Network Diagram Project
; 238. Home
; 239. Insert
; 240. Design
; 241. Review
; 242. View
; 243. Share
; 244. Comments
; 245. File Menu
; 246. Summary
18. Conclusion
; 247. Summary

So what are you waiting for? I look forward to going through course with you I'll see you inside!

Who this course is for:Beginner to Advanced Students wanting to Learn Microsoft 365

Homepage

Code:

https://www.udemy.com/course/learn-microsoft-office-365/

Code:

https://k2s.cc/file/916c73e996f51/Microsoft_365_Ultimate_Guide_2022.part1.rar
https://k2s.cc/file/d4ead520fc549/Microsoft_365_Ultimate_Guide_2022.part2.rar

Code:

https://nitroflare.com/view/7A9875E5BFE9536/Microsoft_365_Ultimate_Guide_2022.part1.rar
https://nitroflare.com/view/BBF6634BE970855/Microsoft_365_Ultimate_Guide_2022.part2.rar

Code:

https://rapidgator.net/file/ae87b595dea313164ed7368375d02206/Microsoft_365_Ultimate_Guide_2022.part1.rar.html
https://rapidgator.net/file/4b8cb6da642f4108770d2fb219e930bf/Microsoft_365_Ultimate_Guide_2022.part2.rar.html

[Slon]

Diversity And Inclusion Certification2 Management Coaching
Last updated 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.79 GB | Duration: 11h 1m

Diversity and Inclusion Management Coaching Graduates Prepared Professionals in Hybrid Workplace Diversity and Inclusion



What you'll learn
July 2022 Updated + Level 2 Certification Bonus $1791 We Cover (Read Description) Work as a Management Coach in Level 2 Coaching Practicums.
Diversity and Inclusion Management 11 hours Interactive Video Training, 167+ PDFs, 10 Ready-to-Use Sessions + Skills Training to Master Management Coaching.
Diversity and Inclusion Training using Get Results Diversity and Inclusion Coaching System Empowers You to Confidently Coach Any Team Starting Today.
Priceless Diversity and Inclusion Management Coaching Mentoring to Move You Past the Blocks and Obstacles to Developing Your Management Career.

Requirements
Before buying, click on PREVIEW THIS COURSE found on this page. Watch the Certification + FAQ video to discover our world-class approach to training and certifying Diversity and Inclusion Management Coaching Professionals plus the cost-saving bonuses Get Results Coach Academy gives you.
Diversity and Inclusion Certification Management Coaching Training offers its own verifiable certificate of completion plus it is Certification #2 in the 10 Course Master Management Coaching Certification Program offered by Get Results Coach Academy on Udemy. Read the Udemy Instructor Profile to learn more.

Description
Diversity and Inclusion Management in the new normal workplace requires a new approach! Be prepared to meet those needs by becoming a Certified Get Results Diversity and Inclusion Management Coach. With 11 hours of step-by-step video training, 167+ downloadable and ready to use resources, you become skilled in using a proprietary 10 Session Get Results Management Coaching Program that has been done-for-you so that you can begin Diversity and Inclusion Management Coaching Sessions with your online, in-person or hybrid teams or corporate clients starting TODAY.Diversity and Inclusion Management Coaching Training Prepares You to Get ResultsYou don't have to waste time trying to figure out what works and what doesn't. The hard work, research and carefully crafted Diversity and Inclusion Management Coaching Session guides give you the exact timings, coaching questions, activities, and resources so you can start coaching work teams or clients immediately. With 2 Levels of Certification, your skill and professionalism as a trained Get Results Diversity and Inclusion Management Coach is of the highest priority.Diversity and Inclusion Management Coaching Training for the New NormalIn your company, Diversity and Inclusion has suffered since the crisis. Imagine that you've been selected to implement a company-wide New Normal Diversity and Inclusion Program. Your challenge is to coach a global team of highly skilled diverse employees to adapt a more inclusive strategy that gets results. This is the opportunity you've been waiting for! The problem is, they want you to start tomorrow.Are you prepared for the challenge? Do you have the technology and mindset know-how to coach a hybrid remote/in-office team? Do you understand the top 10 unconscious bias that negatively impact Diversity and Inclusion in the workplace? Do you have a proven Diversity and Inclusion Group Coaching Program with the exact questions and interactive online resources to GET BETTER RESULTS in the new normal?The New Normal Get Results Inclusion Approach Shows You How to Manage Diversity in the WorkplaceOpportunities like this can change your career! As Curriculum Developer and Lead Instructor for Get Results Coach Academy, I designed Diversity and Inclusion Certification Management Coaching Training to give you everything you need to confidently manage diversity in the workplace and coach a team toward inclusion success starting today. Whether you lead a remote team, an in-office team or a combination of both, you are guided step-by-step with the exact how to manage diversity in the workplace plan through mastery of the Diversity and Inclusion Management Coaching for getting results in the new normal.Build your confidence, even if you have never organized a virtual workspace or ran a virtual meeting, through Level 1 behind-the-scenes video training, hands-on practicums and my step-by-step guidance.Maximize your impact using my done-for-you action focused Diversity and Inclusion Get Results Coaching Model to engage a remote team, in-office team or a combination of both.Advance your people skills with 10 unconscious bias re-enactments that take the guesswork out of understanding your teams' underlying challenges.Increase your aptitude in using the latest technology for delivering virtual meetings and managing virtual workspaces.Accelerate your Diversity and Inclusion Management Coach Career or Business/Practice with free but optional Level 2 coaching practicums and Diversity and Inclusion Management Coach Directory Listing.Management Coaching Specializing in Diversity and Inclusion to Get Results in the New NormalThe Covid-19 crisis changed the way many companies work. Remote work and teams divided are the new normal. According to a white paper called COVID-19 Impact on Diversity & Inclusion published by Boston College, the crisis has created more division. The findings, which identified the impact of this crisis on Diversity and Inclusion within organizations, state that "one of the greatest challenges is understanding the needs and circumstances of employees who themselves are diverse in all of the traditional measures, but also are affected by widely varying life, work, family and mental health conditions." The white paper sums up by concluding that during crises, the presence of diversity and the practice of inclusion is essential. Now more than ever, you need a targeted program that mitigates any further negative impact. You need a Diversity and Inclusion Program that Gets New Results.Diversity and Inclusion Certification Management Coaching Content OverviewWith 11 hours of video tutorials, 167+ downloadable resources ready to use, hands-on practice assignments, interactive learning and Q & A, this continually updated course keeps you relevant and indispensable as a Leader. Let's break it down for you:I developed my GET RESULTS Management Coaching Program to provide you with the professionalism yet agility that is required in today's fast-paced ever-changing workplace. In each section of the course, you receive specific Diversity and Inclusion insight that is relevant for this new workplace normal.Through case-study re-enactments, you look closely at the complexity of the human psyche impacted by unconscious bias that is sometimes slow to change and how this ultimately alters the company culture if left unchecked. You assess your own bias and with what you discover, adjust as needed before coaching your team.You learn how to set up a Slack Workspace for delivering the Diversity and Inclusion GET RESULTS Program. Even if you have used Slack before, you will learn how to develop an engaged, diverse and inclusive virtual workplace that gets results.You are given step-by-step instruction designed to improve your proficiency using the latest technology to deliver the remote meetings as well as the how-to insight for delivering the professional program.Even if there is no money for Diversity and Inclusion initiatives, the strategically selected interactive online resources are free to use. The research, coaching questions and the usable PDF documents have been developed for your use saving you time and money.2 LEVELS OF CERTIFICATION: Students and Graduates of Get Results Coach Academy on Udemy benefit from the G.R.C.A 2 Levels of Certification at no extra cost. Here are the details of the 2 Levels + the benefits of joining:LEVEL 1 CERTIFICATIONIncluded with your one-time low-cost enrollment fee on Udemy is life-time access to the course content and features on Udemy; including a verifiable Udemy generated certificate of completion.GET RESULTS COACH ACADEMY COVERS THE $995 U.S.D. RIGHT OF USE FEE: When you join this course on Udemy and stay enrolled (no refund), you have permission to use my Proprietary Accredited Management Coaching Session Guides with your work team or to coach clients.PLEASE NOTE: A "right-of-use fee" is not a licensing fee. I own the copyright to the accredited session guides including the processes and material which means that you do not have permission to re-sell it or develop training, workshops, speaking or books based on my proprietary program.1) Watch 100% of the coursework lectures as fast or as slow as you want.2) Download all of the accredited resources including the session guides.3) Download your Udemy generated certificate of completion when you have completed 100% of the coursework.LEVEL 2 CERTIFICATIONIn addition to the cost-saving benefits and features of Level One, when you remain enrolled in the program past 35 days, you have access to LEVEL 2 benefits; a total of $1791 U.S.D in fees that we cover when you join this one course on Udemy and graduate Level 2.GET RESULTS COACH ACADEMY COVERS THE $995 U.S.D. RIGHT OF USE FEE: When you join this course on Udemy and stay enrolled (no refund), you have permission to use my Proprietary Accredited Management Coaching Session Guides to coach work teams or clients.GET RESULTS COACH ACADEMY COVERS THE $199 U.S.D. ACCREDITATION FEE: Level 2 requires that you complete a mandatory Management Coaching Practicum which assesses your competency using my accredited proprietary session guides with real work teams or clients. This is referred to as hands-on coaching fieldwork. This is step-by-step easy to complete but submission is mandatory for Level 2 Graduation. This is what differentiates this program and the Get Results Coach Academy Management Coaching Graduates above the rest. While a quickie diploma or certification from having just simply watched videos is appealing and what some coaching courses on Udemy use as a marketing tool to get you to buy, this is not the solution to long-term success. If that is your goal and expectation, this professional coaching program is not for you.GET RESULTS COACH ACADEMY COVERS THE $99 U.S.D. CERTIFICATION FEE: This is a one-time fee to create one individualized certificate of completion from Get Results Coach Academy that displays your certification designation verifying your completion of accreditation.GET RESULTS COACH ACADEMY COVERS THE $199 U.S.D. COACH DIRECTORY LISTING FEE: This is a one-time listing one-time fee to add your first and last name to this niche specific management coaching directory on Get Results Coach Academy.GET RESULTS COACH ACADEMY COVERS THE $299 U.S.D ASSOCIATION FEE: This is a one-time membership fee to keep your certification current and valid.GET RESULTS COACH ACADEMY COVERS $1791 U.S.D IN FEES WHEN YOU JOIN ON UDEMY AND GRADUATE LEVEL 2Now you might be thinking "this sounds too good to be true; what's the catch?" or you might be saying "Management Coaching Training like this should cost 5 thousand or more; why would such a valuable program be available on Udemy for such a low price?" There is no catch just a vision, a purpose and a mission to empower diversity and inclusion among hybrid work teams to achieve success in the new normal.Diversity and Inclusion Management Coaching Students Share Their Experience"Extremely practical information and step by step processes appeal to the busy professional""Louise A. Maurice always gives great information for our life long study for our coaching businesses. Love, Love, the courses""I've been in working Diversity groups before, and this is looking at it from a different angle at the moment particularly in a closer team setting than an overall company picture catering for different groups""I am just in part 3 of the program, but loving every minute. The presenter is organized and easy to understand, and the supplemental materials have already come in handy at work"Excel as a Leader in the New Normal with Diversity and Inclusion Management CoachingLet me show you how to manage diversity and inclusion for success in the new normal! If you have never met me before my name is Louise Anne Maurice. The thousands and thousands of people I have either coached, trained, consulted or taught over the past 30+ years have benefited from my Empowered Coaching Approach™. I teamed up with the Udemy E-Learning Platform to make my proprietary Diversity and Inclusion Management Coaching Certification Training Course easily accessible to a global audience at an affordable price. This comprehensive and streamlined curriculum shortens the learning curve for you to become a Professional World-Class Diversity and Inclusion Management Coach.I invite you to join with me as well as the other students starting today! Simply click on the "Buy now" button to enroll in this course or click on the "Add to cart" button to enroll in all 10 courses of the Master Management Coaching Certification Training Program.I will see you in the first lecture.LouiseYour Coach Louise Anne Maurice© Intellectual Copyright of all details in this description (except for student reviews) and training material in this Diversity and Inclusion Management Coaching Certification Training Course are owned by Louise Anne Maurice of Get Results Coach Academy

Overview

Section 1: Diversity and Inclusion Management Coaching

Lecture 1 Diversity and Inclusion Welcome to Management Coaching

Lecture 2 Diversity and Inclusion Analysis

Lecture 3 Diversity and Inclusion Statistics for Management Coaching

Lecture 4 Diversity and Inclusion A-Q Remote Prep Management Coaching

Lecture 5 Diversity and Inclusion R-T Remote Prep Management Coaching

Lecture 6 Diversity and Inclusion 1 Session Intro Management Coaching

Lecture 7 Diversity and Inclusion 1 Session UX Prep Management Coaching

Lecture 8 Diversity and Inclusion 1 Session YZ Prep Management Coaching

Lecture 9 Diversity and Inclusion 1 Session Step 1 Management Coaching

Lecture 10 Diversity and Inclusion 1 Session Step 2 Management Coaching

Lecture 11 Diversity and Inclusion 1 Session Step 3 Management Coaching

Lecture 12 Diversity and Inclusion 1 Session Step 4 Management Coaching

Lecture 13 Diversity and Inclusion 1 Session Step 5 Management Coaching

Lecture 14 Diversity and Inclusion 1 Session End Management Coaching

Lecture 15 Diversity and Inclusion 1 Session Practicum Management Coaching

Lecture 16 Certification + FAQ Diversity and Inclusion Management Coaching

Section 2: Diversity and Inclusion Session 2 Management Coaching

Lecture 17 Diversity and Inclusion 2 Session Intro Management Coaching

Lecture 18 Diversity and Inclusion 2 Session Prep Management Coaching

Lecture 19 Diversity and Inclusion 2 Session Step 1 Management Coaching

Lecture 20 Diversity and Inclusion 2 Session Step 2 Management Coaching

Lecture 21 Diversity and Inclusion 2 Session Step 3 Management Coaching

Lecture 22 Diversity and Inclusion 2 Session Step 4 Management Coaching

Lecture 23 Diversity and Inclusion 2 Session Step 5 Management Coaching

Lecture 24 Diversity and Inclusion 2 Session End Management Coaching

Lecture 25 Diversity and Inclusion 2 Session Practicum Management Coaching

Section 3: Diversity and Inclusion Session 3 Management Coaching

Lecture 26 Diversity and Inclusion 3 Session Intro Management Coaching

Lecture 27 Diversity and Inclusion 3 Session Prep Management Coaching

Lecture 28 Diversity and Inclusion 3 Session Step 1 Management Coaching

Lecture 29 Diversity and Inclusion 3 Session Step 2 Management Coaching

Lecture 30 Diversity and Inclusion 3 Session Step 3 Management Coaching

Lecture 31 Diversity and Inclusion 3 Session Step 4 Management Coaching

Lecture 32 Diversity and Inclusion 3 Session Step 5 Management Coaching

Lecture 33 Diversity and Inclusion 3 Session End Management Coaching

Lecture 34 Diversity and Inclusion 3 Session Practicum Management Coaching

Section 4: Diversity and Inclusion Session 4 Management Coaching

Lecture 35 Diversity and Inclusion 4 Session Intro Management Coaching

Lecture 36 Diversity and Inclusion 4 Session UX Prep Management Coaching

Lecture 37 Diversity and Inclusion 4 Session YZ Prep Management Coaching

Lecture 38 Diversity and Inclusion 4 Session Step 1 Management Coaching

Lecture 39 Diversity and Inclusion 4 Session Step 2 Management Coaching

Lecture 40 Diversity and Inclusion 4 Session Step 3 Management Coaching

Lecture 41 Diversity and Inclusion 4 Session Step 4 Management Coaching

Lecture 42 Diversity and Inclusion 4 Session Step 5 Management Coaching

Lecture 43 Diversity and Inclusion 4 Session End Management Coaching

Lecture 44 Diversity and Inclusion 4 Session Practicum Management Coaching

Section 5: Diversity and Inclusion Session 5 Management Coaching

Lecture 45 Diversity and Inclusion 5 Session Intro Management Coaching

Lecture 46 Diversity and Inclusion 5 Session UX Prep Management Coaching

Lecture 47 Diversity and Inclusion 5 Session YZ Prep Management Coaching

Lecture 48 Diversity and Inclusion 5 Session Step 1 Management Coaching

Lecture 49 Diversity and Inclusion 5 Session Step 2 Management Coaching

Lecture 50 Diversity and Inclusion 5 Session Step 3 Management Coaching

Lecture 51 Diversity and Inclusion 5 Session Step 4 Management Coaching

Lecture 52 Diversity and Inclusion 5 Session Step 5 Management Coaching

Lecture 53 Diversity and Inclusion 5 Session End Management Coaching

Lecture 54 Diversity and Inclusion 5 Session Practicum Management Coaching

Section 6: Diversity and Inclusion Session 6 Management Coaching

Lecture 55 Diversity and Inclusion 6 Session Intro Management Coaching

Lecture 56 Diversity and Inclusion 6 Session UX Prep Management Coaching

Lecture 57 Diversity and Inclusion 6 Session YZ Prep Management Coaching

Lecture 58 Diversity and Inclusion 6 Session Step 1 Management Coaching

Lecture 59 Diversity and Inclusion 6 Session Step 2 Management Coaching

Lecture 60 Diversity and Inclusion 6 Session Step 3 Management Coaching

Lecture 61 Diversity and Inclusion 6 Session Step 4 Management Coaching

Lecture 62 Diversity and Inclusion 6 Session Step 5 Management Coaching

Lecture 63 Diversity and Inclusion 6 Session End Management Coaching

Lecture 64 Diversity and Inclusion 6 Session Practicum Management Coaching

Section 7: Diversity and Inclusion Session 7 Management Coaching

Lecture 65 Diversity and Inclusion 7 Session Intro Management Coaching

Lecture 66 Diversity and Inclusion 7 Session UX Prep Management Coaching

Lecture 67 Diversity and Inclusion 7 Session YZ Prep Management Coaching

Lecture 68 Diversity and Inclusion 7 Session Step 1 Management Coaching

Lecture 69 Diversity and Inclusion 7 Session Step 2 Management Coaching

Lecture 70 Diversity and Inclusion 7 Session Step 3 Management Coaching

Lecture 71 Diversity and Inclusion 7 Session Step 4 Management Coaching

Lecture 72 Diversity and Inclusion 7 Session Step 5 Management Coaching

Lecture 73 Diversity and Inclusion 7 Session End Management Coaching

Lecture 74 Diversity and Inclusion 7 Session Practicum Management Coaching

Section 8: Diversity and Inclusion Session 8 Management Coaching

Lecture 75 Diversity and Inclusion 8 Session Intro Management Coaching

Lecture 76 Diversity and Inclusion 8 Session Prep Management Coaching

Lecture 77 Diversity and Inclusion 8 Session Step 1 Management Coaching

Lecture 78 Diversity and Inclusion 8 Session Step 2 Management Coaching

Lecture 79 Diversity and Inclusion 8 Session Step 3 Management Coaching

Lecture 80 Diversity and Inclusion 8 Session Step 4 Management Coaching

Lecture 81 Diversity and Inclusion 8 Session Step 5 Management Coaching

Lecture 82 Diversity and Inclusion 8 Session End Management Coaching

Lecture 83 Diversity and Inclusion 8 Session Practicum Management Coaching

Section 9: Diversity and Inclusion Session 9 Management Coaching

Lecture 84 Diversity and Inclusion 9 Session Intro Management Coaching

Lecture 85 Diversity and Inclusion 9 Session Prep Management Coaching

Lecture 86 Diversity and Inclusion 9 Session Step 1 Management Coaching

Lecture 87 Diversity and Inclusion 9 Session Step 2 Management Coaching

Lecture 88 Diversity and Inclusion 9 Session Step 3 Management Coaching

Lecture 89 Diversity and Inclusion 9 Session Step 4 Management Coaching

Lecture 90 Diversity and Inclusion 9 Session Step 5 Management Coaching

Lecture 91 Diversity and Inclusion 9 Session End Management Coaching

Lecture 92 Diversity and Inclusion 9 Session Practicum Management Coaching

Section 10: Diversity and Inclusion Session 10 Management Coaching

Lecture 93 Diversity and Inclusion 10 Session Intro Management Coaching

Lecture 94 Diversity and Inclusion 10 Session UX Prep Management Coaching

Lecture 95 Diversity and Inclusion 10 Session YZ Prep Management Coaching

Lecture 96 Diversity and Inclusion 10 Session Step 1 Management Coaching

Lecture 97 Diversity and Inclusion 10 Session Step 2 Management Coaching

Lecture 98 Diversity and Inclusion 10 Session Step 3 Management Coaching

Lecture 99 Diversity and Inclusion 10 Session Step 4 Management Coaching

Lecture 100 Diversity and Inclusion 10 Session Step 5 Management Coaching

Lecture 101 Diversity and Inclusion 10 Session End Management Coaching

Lecture 102 Diversity and Inclusion 10 Session Practicum Management Coaching

Lecture 103 Diversity and Inclusion 10 Session Wrap Management Coaching

Section 11: Diversity and Inclusion Next Steps for Management Coaching

Lecture 104 Diversity & Inclusion Management Coaching Program Review

Lecture 105 Level 2 Self-Assessment

Lecture 106 Level 2 Fieldwork Instructions

Lecture 107 Level 2 Fieldwork Templates

Lecture 108 Ongoing Personal and Professional Development

Lecture 109 Level 1 Graduates

Lecture 110 Level 2 Graduates

If you are in a leadership position working with teams, then the Diversity and Inclusion Management Coaching will give you the inside track on the skills necessary to lead in the new normal.,If you have lost your job or want to be indispensable in your current career, then Diversity and Inclusion Certification in Get Results Management Coaching is your solution.,If you want to start a new business or private practice as a Management Coach in a highly sought-after niche area, then Diversity and Inclusion Management Coaching Certification Training will give you a head start.,If you are fresh out of college and you have been told that your resume/CV needs more professional experience, enrol in Diversity and Inclusion Management Coaching Training and participate in the hands-on coaching practicum so that your resume stands-out.

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/2-diversity-inclusion-management-coaching-certification/

Code:

https://k2s.cc/file/4208c21253b22/Diversity_and_Inclusion_Certification2_Management_Coaching.part1.rar
https://k2s.cc/file/3de0b7a9b1aab/Diversity_and_Inclusion_Certification2_Management_Coaching.part2.rar

Code:

https://nitroflare.com/view/FD796308B237234/Diversity_and_Inclusion_Certification2_Management_Coaching.part1.rar
https://nitroflare.com/view/6C42D042C9DF2F4/Diversity_and_Inclusion_Certification2_Management_Coaching.part2.rar

Code:

https://rapidgator.net/file/f915f74c05005688b99c977b4e45fa6e/Diversity_and_Inclusion_Certification2_Management_Coaching.part1.rar.html
https://rapidgator.net/file/06859d0c706a2d7a04677785e1b7a601/Diversity_and_Inclusion_Certification2_Management_Coaching.part2.rar.html

[Slon]

Learn Microsoft Excel Fast - The Advanced Excel Course
Last updated 4/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.05 GB | Duration: 11h 33m

Microsoft Certified Master Instructor - Financial Functions - NPV - IRR - Amortization - Pivot Tables - Data Analysis



What you'll learn
Learn how to more effectively manage finances.
Learn all about financial functions in Microsoft Excel.
Learn how to calculate the future value of cash flows.
Learn how to calculate the present value of cash flows.
Learn how to calculate a loan payment.
Learn how to create a loan amortization schedule.
Learn how to calculate an annuity payment.
Learn how to calculate payment and interest.
Learn all about NPV (net present value) and learn how to calculate it.
Learn all about IRR (internal rate of return) and learn how to calculate it.
Learn how to create pivot tables and how to work with pivot tables.
Learn how to group data in pivot tables.
Learn how to use slicers and timelines in pivot tables.
Learn how to work with the data model power pivot.
Learn how to use "get and transform" to work with data.
Learn how to transform data
Learn how to split by delimiter, pivot, unpivot, replace, extract, and format data
Learn how to work with "append and merge"
Learn all about merges and joins include outer joins and inner joins
Learn how to work with data visualization in Microsoft Excel
Learn how to create a 3-D map
Learn how to use Microsoft Excel collaboration tools
Learn how to automate Microsoft Excel with macros
Learn how to use Object linking & embedding (OLE)

Requirements
All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.

Description
Master Excel with a Microsoft Certified Master Instructor.You can master Microsoft Excel easily and quickly if it is taught correctly.Developed by a Microsoft Certified Master Instructor, this course will help you master Microsoft Excel. Taught by a university professor with over twenty years of experience teaching individuals of all ability levels how to use Microsoft Excel, Todd McLeod has designed and refined this course to make it easy for you to master Microsoft Excel.Providing a comprehensive curriculum of 140 video lectures, including 51 hands-on exercises with solutions, you will learn all of the following about Microsoft Excel: Learn fundamentals of financeLearn about the time value of money.Learn how to work with financial functionsLearn how to calculate present value and future value.Learn how to calculate loan payments, loan amortization, and annuity payments.Learn about Net Present Value (NPV) and learn how to calculate it.Learn about Internal Rate of Rate (IRR) and learn how to calculate it.Learn to use pivot tables and master the art of data visualization.Learn to use the "data model" power pivot tool to advance your data analysis.Learn to use "Get and Transform" power query.Learn to transform data with split by delimiter.Learn to replace, extract, and format data.Learn to append and merge data.Learn to work with merge and joins.Learn to create inner joins and outer joins.Learn to use data visualization.Learn to create 3-D Maps.Learn to collaborate more effectively in Excel.Learn to automate Excel with macros.Learn to integrate Excel with other software.Learn about Object Linking and Embedding (OLE).Receive 51 "hands-on exercises" Receive solutions to all of the "hands-on exercises" download all of the Excel project files that are used in the videos.This class is guaranteed to help you master Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. Described as "fun" and "amazing" and "life changing," Todd McLeod's Excel training will forever transform the way you work with Excel. Try this course for yourself and see how quickly and easily you too can master Microsoft Excel.

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Course resources

Lecture 3 Course files

Lecture 4 Versions

Section 2: Financial functions I

Lecture 5 Financial health

Lecture 6 Time is money

Lecture 7 Future value I

Lecture 8 Future value II

Lecture 9 Future value III

Lecture 10 Future value IV

Lecture 11 Present value

Lecture 12 Present value II

Section 3: Exercises - Ninja Level 19

Lecture 13 Hands-on exercise #1

Lecture 14 Hands-on exercise #2

Lecture 15 Hands-on exercise #3

Lecture 16 Hands-on exercise #4

Lecture 17 Hands-on exercise #5

Lecture 18 Hands-on exercise #6

Lecture 19 Hands-on exercise #7

Section 4: Financial functions II

Lecture 20 Loan payment

Lecture 21 Loan amortization

Lecture 22 Annuity payment

Lecture 23 Payment & interest

Lecture 24 NPV

Lecture 25 IRR

Section 5: Exercises - Ninja Level 20

Lecture 26 Hands-on exercise #1

Lecture 27 Hands-on exercise #2

Lecture 28 Hands-on exercise #3

Lecture 29 Hands-on exercise #4

Lecture 30 Hands-on exercise #5

Section 6: Pivot tables

Lecture 31 Introduction

Lecture 32 Pivoting your data

Lecture 33 Data into information

Lecture 34 Adding information to a table

Lecture 35 Refreshing pivot tables

Lecture 36 Nesting with pivot tables

Lecture 37 Grouping in pivot tables

Lecture 38 Using slicers in pivot tables

Lecture 39 Using timelines in pivot tables

Lecture 40 Creating pivot charts

Lecture 41 Recommended pivot tables

Section 7: Exercises - Ninja Level 21

Lecture 42 Hands-on exercise #1

Lecture 43 Hands-on exercise #2

Lecture 44 Hands-on exercise #3

Lecture 45 Hands-on exercise #4

Lecture 46 Hands-on exercise #5

Lecture 47 Hands-on exercise #6

Lecture 48 Hands-on exercise #7

Section 8: Data model (power pivot)

Lecture 49 Introduction

Lecture 50 Add to data model

Lecture 51 Creating relationships

Lecture 52 Calculated columns

Lecture 53 Writing a measure

Lecture 54 Pivot your data

Section 9: Exercises - Ninja Level 22

Lecture 55 Hands-on exercise #1

Lecture 56 Hands-on exercise #2

Section 10: Get & transform (power query)

Lecture 57 Orientation

Lecture 58 1,048,576+ records

Lecture 59 Excel broke

Lecture 60 1,048,576+ records II

Lecture 61 Get csv files

Lecture 62 Adding data

Lecture 63 Get txt files

Lecture 64 Get xlsx files, single sheets

Lecture 65 Get xlsx files, many sheets

Lecture 66 Data preparation

Lecture 67 Get txt, csv, accd, xlsx

Lecture 68 Get web

Lecture 69 Get JSON

Section 11: Exercises - Ninja Level 23

Lecture 70 Hands-on exercise #1

Lecture 71 Hands-on exercise #2

Lecture 72 Hands-on exercise #3

Lecture 73 Hands-on exercise #4

Lecture 74 Hands-on exercise #5

Section 12: Transforming data

Lecture 75 Overview

Lecture 76 Split by delimiter

Lecture 77 Pivot

Lecture 78 Unpivot

Lecture 79 Replace

Lecture 80 Extract

Lecture 81 Format

Section 13: Exercises - Ninja Level 24

Lecture 82 Hands-on exercise #1

Lecture 83 Hands-on exercise #2

Lecture 84 Hands-on exercise #3

Lecture 85 Hands-on exercise #4

Lecture 86 Hands-on exercise #5

Lecture 87 Hands-on exercise #6

Lecture 88 Hands-on exercise #7

Section 14: Append & merge

Lecture 89 Append

Lecture 90 Append updating

Lecture 91 Merge & joins

Lecture 92 Left outer join

Lecture 93 Right outer join

Lecture 94 Full outer join

Lecture 95 Inner join

Lecture 96 Left anti join

Lecture 97 Right anti join

Section 15: Exercises - Ninja Level 25

Lecture 98 Hands-on exercise #1

Lecture 99 Hands-on exercise #2

Lecture 100 Hands-on exercise #3

Lecture 101 Hands-on exercise #4

Lecture 102 Hands-on exercise #5

Lecture 103 Hands-on exercise #6

Lecture 104 Hands-on exercise #7

Lecture 105 Hands-on exercise #8

Section 16: Data visualization

Lecture 106 Overview

Lecture 107 3-D map

Lecture 108 3-D map II

Lecture 109 3-D map III

Lecture 110 3-D map IV

Lecture 111 3-D map animation

Lecture 112 Themes

Lecture 113 Defined names

Lecture 114 Defined names & tables

Lecture 115 Defined names management

Lecture 116 Formula auditing

Lecture 117 Error checking

Lecture 118 Evaluate formula

Lecture 119 Watch window

Lecture 120 Calculation

Section 17: Exercises - Ninja Level 26

Lecture 121 Hands-on exercise #1

Lecture 122 Hands-on exercise #2

Lecture 123 Hands-on exercise #3

Lecture 124 Hands-on exercise #4

Lecture 125 Hands-on exercise #5

Lecture 126 Hands-on exercise #6

Section 18: Collaborating

Lecture 127 Signature line

Lecture 128 Comments

Lecture 129 Protect (lock)

Section 19: Exercises - Ninja Level 27

Lecture 130 Hands-on exercise #1

Section 20: Automation

Lecture 131 Understanding macros

Lecture 132 Relative reference macros

Section 21: Exercises - Ninja Level 28

Lecture 133 Hands-on exercise #1

Section 22: Excel & Word integration (OLE)

Lecture 134 Object linking & embedding (OLE)

Section 23: Exercises - Ninja Level 29

Lecture 135 Hands-on exercise #1

Section 24: Farewell

Lecture 136 Congratulations

Lecture 137 Bonus lecture

This course is for individuals who already have a good understanding of Microsoft Excel.

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/master-excel/

Code:

https://k2s.cc/file/e687271cb0d2c/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part1.rar
https://k2s.cc/file/ef7c273cf3cf6/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part2.rar
https://k2s.cc/file/774ab3c53ff87/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part3.rar

Code:

https://nitroflare.com/view/80499EC83646FE4/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part1.rar
https://nitroflare.com/view/C7A4BB293166509/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part2.rar
https://nitroflare.com/view/CC73531A51FB3E2/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part3.rar

Code:

https://rapidgator.net/file/45683686576c79bb734b95021833cafe/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part1.rar.html
https://rapidgator.net/file/beae8cd18f13e85d17a2a643077e52a1/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part2.rar.html
https://rapidgator.net/file/ec6bdb52e55a6a6a56bb591a21dc4dc5/Learn_Microsoft_Excel_Fast_The_Advanced_Excel_Course.part3.rar.html

[Slon]

Office 2021/365 Essentials Bundle
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 21.09 GB | Duration: 41h 19m

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



What you'll learn
What's new in Excel 2021
Navigating the Excel 2021 interface
Analyzing data using PivotTables and representing data visually with charts and PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to use Excel tables to structure data and make it easy to update

Requirements
Microsoft Office 2021 desktop version for Windows installed and ready to use on your computer.

Description
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Learn Excel (beginner and intermediate), PowerPoint, and Word 2021 with this tremendous value four-course bundle from Office experts Simon Sez IT.Microsoft Office remains the go-to tool for the modern worker, yet so many users fall short of using its full potential.We're here to make sure you aren't one of those people.In this Microsoft Office bundle, we make the three essential MS Office programs (Excel, PowerPoint, and Word) simple to understand. The bundle includes four full-length courses to help you achieve your goals: Excel 2021 for Beginners, Excel 2021 Intermediate, PowerPoint 2021 for Beginners, and Word 2021 for Beginners.Each course goes into depth on how to get the most from each program and will help you become a more skillful user.What's included?Excel 2021 for BeginnersBecome familiar with what's new in Excel 2021Navigate the Excel 2021 interfaceUtilize useful keyboard shortcuts to increase productivityCreate your first Excel spreadsheetUse basic and intermediate Excel formulas and functionsEffectively apply formatting to cells and use conditional formattingUse Excel lists and master sorting and filteringWork efficiently by using the cut, copy, and paste optionsLink to other worksheets and workbooksAnalyze data using chartsInsert pictures in a spreadsheetWork with views, zooms, and freezing panesSet page layout and print optionsProtect and share workbooksSave your workbook in different file formatsExcel 2021 IntermediateDesign better spreadsheets and control user inputUse logical functions to make better business decisionsConstruct functional and flexible lookup formulasUse Excel tables to structure data and make it easy to updateExtract unique values from a listSort and filter data using advanced features and new Excel formulasWork with date and time functionsExtract data using text functionsImport data and clean it up before analysisAnalyze data using PivotTablesRepresent data visually with PivotChartsAdd interactions to PivotTables and PivotChartsCreate an interactive dashboard to present high-level metricsAudit formulas and troubleshoot common Excel errorsControl user input with data validationUse WhatIf analysis tools to see how changing inputs affect outcomesPowerPoint 2021 for BeginnersCreate visually stunning presentations that meet best practice guidelinesFind free, high-quality resources like images, icons, fonts, and videosImprove efficiency with keyboard shortcuts and the Quick Access ToolbarOpen, close, and save presentationsWork with PowerPoint templatesApply slide layouts to new or existing slidesDuplicate, arrange, copy, and paste slides and objectsWork with images, icons, video, text, shapes, and audio filesCorrectly select, align, and group objects on a slideWork with animations, transitions, and motion pathsCreate summary pages using slide and summary zoomInsert and edit charts, diagrams, and tablesInsert hyperlinks to other slides, external websites, and mail addressesCreate motion video backgroundsInsert screenshots and record and narrate presentationsWork with the Slide Master to make universal changesIncorporate third-party add-ins into PowerPointPrepare a presentation for delivery by adding speaker notes, header and footer, and commentsSet up a custom slide show and rehearsing timingsUse Presenter View to deliver a presentationExport, share, and print a presentationWord 2021 for BeginnersNavigate the Word 2021 interfaceCustomize the quick access toolbarAccess and modify Word optionsCreate new documents from scratch and from a templateOpen and save existing documentsSwitch between different document viewsEnter, select, and apply formatting to textUse cut, copy, paste, and different paste optionsFind and replace text in a documentFormat paragraphsAlign paragraphs using indents and tab stopsInsert bulleted and numbered listsApply a theme to control the look and feel of the documentApply and modify Word stylesInsert content like shapes, icons, text boxes, 3D images, SmartArt, and chartsAnnotate a documentOrganize information using tablesAdjust the margins and orientationInsert section and page breaksApply headers and footersInsert blank pages and cover pagesLink to websites, other documents, and other sections using hyperlinks and bookmarksCreate re-usable content with Quick PartsCreate and format a table of contentsAdd footnotes and end notes to a documentCreate citations and inserting a bibliographyCreate an indexAdd captions to pictures and create a table of figuresCreate multiple letters, envelopes, and labels using mail mergeCheck spelling and set up auto-correct optionsTrack changes from multiple authorsCompare and combine documentsAdjust document propertiesCheck a document for accessibility and compatibility issuesProtect a document to prevent changesShare a document with othersCollaborate on a document with others in real timePrint a documentThis bundle includes:40+ hours of video tutorials350+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Overview

Section 1: Excel 2021 Beginner: Introduction

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Instructor Files

Lecture 5 Excel 2021 vs Excel for Microsoft 365

Section 2: Excel 2021 Beginner: Getting Started in Excel 2021

Lecture 6 Launching Excel

Lecture 7 The Start Screen

Lecture 8 Exploring the Interface

Lecture 9 Understanding Ribbons, Tabs and Menus

Lecture 10 The Backstage Area

Lecture 11 Customizing the Quick Access Toolbar

Lecture 12 Useful Keyboard Shortcuts

Lecture 13 Getting Help

Lecture 14 Exercise 01

Section 3: Excel 2021 Beginner: Creating You First Excel Spreadsheet

Lecture 15 Working with Excel Templates

Lecture 16 Working with Workbooks and Worksheets

Lecture 17 Saving Workbooks and Worksheets

Lecture 18 Entering and Editing Data

Lecture 19 Navigating and Selecting Cells, Rows and Columns

Lecture 20 Exercise 02

Section 4: Excel 2021 Beginner: Introduction to Excel Formulas and Functions

Lecture 21 Formulas and Functions Explained

Lecture 22 Performing Calculations with the SUM Function

Lecture 23 Counting Values and Blanks

Lecture 24 Finding the Average with the AVERAGE Function

Lecture 25 Working with the MIN and MAX Functions

Lecture 26 Handling Errors in Formulas

Lecture 27 Absolute vs Relative Referencing

Lecture 28 Autosum and AutoFill

Lecture 29 Flash Fill

Lecture 30 Exercise 03

Section 5: Excel 2021 Beginner: Using Named Ranges

Lecture 31 What are Named Ranges?

Lecture 32 Creating Named Ranges

Lecture 33 Managing Named Ranges

Lecture 34 Using Named Ranges in Calculations

Lecture 35 Exercise 04

Section 6: Excel 2021 Beginner: Formatting Numbers and Cells

Lecture 36 Applying Number Formats

Lecture 37 Applying Date and Time Formats

Lecture 38 Formatting Cells, Rows and Columns

Lecture 39 Using Format Painter

Lecture 40 Exercise 05

Section 7: Excel 2021 Beginner: Formatting Worksheets

Lecture 41 Working with Rows and Columns

Lecture 42 Deleting and Clearing Cells

Lecture 43 Aligning Text and Numbers

Lecture 44 Applying Themes and Styles

Lecture 45 Exercise 06

Section 8: Excel 2021 Beginner: Working with Excel Lists

Lecture 46 How to Structure a List

Lecture 47 Sorting a List (Single-Level Sort)

Lecture 48 Sorting a List (Multi-Level Sort)

Lecture 49 Sorting Using a Custom List (Custom Sort)

Lecture 50 Using Autofilter to Filter a List

Lecture 51 Format as a Table

Lecture 52 Creating Subtotals in a List

Lecture 53 Exercise 07

Section 9: Excel 2021 Beginner: Moving and Linking to Data

Lecture 54 Using Cut and Copy

Lecture 55 Paste Options

Lecture 56 Pasting from the Clipboard

Lecture 57 Linking to Other Worksheets and Workbooks

Lecture 58 3D Referencing

Lecture 59 Inserting Hyperlinks to Worksheets

Lecture 60 Exercise 08

Section 10: Excel 2021 Beginner: An Introduction to Intermediate Formulas

Lecture 61 Looking up Information with VLOOKUP

Lecture 62 VLOOKUP Approximate Match

Lecture 63 Error Handling Functions

Lecture 64 Basic Logical Functions (IF, AND, OR)

Lecture 65 Making Decisions with IF Statements

Lecture 66 Cleaning Data using Text Functions

Lecture 67 Working with Time and Date Functions

Lecture 68 Exercise 09

Section 11: Excel 2021 Beginner: Analyzing Data with Charts

Lecture 69 Choosing the Correct Chart Type

Lecture 70 Presenting Data with Charts

Lecture 71 Formatting Charts

Lecture 72 Exercise 10

Section 12: Excel 2021 Beginner: Conditional Formatting

Lecture 73 Highlighting Cell Values

Lecture 74 Data Bars

Lecture 75 Color Scales

Lecture 76 Icon Sets

Lecture 77 Exercise 11

Section 13: Excel 2021 Beginner: Inserting Items into a Spreadsheet

Lecture 78 Inserting Pictures

Lecture 79 Inserting Shapes and Text Boxes

Lecture 80 Inserting Icons and 3D Models

Lecture 81 Creating Diagrams using SmartArt

Lecture 82 Inserting Screenshots

Lecture 83 Inserting Comments

Lecture 84 Exercise 12

Section 14: Excel 2021 Beginner: Working with Views and Zoom

Lecture 85 Workbook Views

Lecture 86 Using Zoom in a Worksheet

Lecture 87 Arranging Workbooks and Worksheets

Lecture 88 Freezing Panes

Lecture 89 Exercise 13

Section 15: Excel 2021 Beginner: Page Layout and Print Options

Lecture 90 Setting Margins and Orientation

Lecture 91 Setting and Clearing the Print Area

Lecture 92 Inserting Page Breaks

Lecture 93 Setting Print Titles and a Background

Lecture 94 Inserting Headers and Footers

Lecture 95 Printing a Workbook

Lecture 96 Exercise 14

Section 16: Excel 2021 Beginner: Finalizing the Spreadsheet

Lecture 97 Protecting Workbooks and Worksheets

Lecture 98 Spell Checking

Lecture 99 Inspecting the Workbook

Lecture 100 Saving the Workbook in Different Formats

Lecture 101 Sharing a Workbook

Lecture 102 Exercise 15

Section 17: Excel 2021 Beginner: Course Close

Lecture 103 Course Close

Section 18: Excel 2021 Intermediate: Introduction

Lecture 104 Course Introduction

Lecture 105 DOWNLOAD ME: Course Exercise Files

Lecture 106 DOWNLOAD ME: Course Instructor Files

Section 19: Excel 2021 Intermediate: Designing Better Spreadsheets

Lecture 107 The Golden Rules of Spreadsheet Design

Lecture 108 Improving Readability with Cell Styles

Lecture 109 Controlling Data Input

Lecture 110 Adding Navigation Buttons

Section 20: Excel 2021 Intermediate: Making Decisions with Logical Functions

Lecture 111 Logical Functions (AND, OR, IF)

Lecture 112 The IF Function

Lecture 113 Nested IFs

Lecture 114 The IFS Function

Lecture 115 Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)

Lecture 116 Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)

Lecture 117 Error Handling with IFERROR and IFNA

Lecture 118 Exercise 01

Section 21: Excel 2021 Intermediate: Looking Up Information

Lecture 119 Looking Up Information using VLOOKUP (Exact Match)

Lecture 120 Looking Up Information using VLOOKUP (Approx Match)

Lecture 121 Looking Up Information Horizontally Using HLOOKUP

Lecture 122 Performing Flexible Lookups With INDEX And MATCH

Lecture 123 Using XLOOKUP and XMATCH

Lecture 124 The OFFSET Function

Lecture 125 The INDIRECT Function

Lecture 126 Exercise 02

Section 22: Excel 2021 Intermediate: Advanced Sorting and Filtering

Lecture 127 Performing Sorts on Multiple Columns

Lecture 128 Sorting Using a Custom List

Lecture 129 The SORT and SORTBY Functions

Lecture 130 Using the Advanced Filter

Lecture 131 Extracting Unique Values - The UNIQUE Function

Lecture 132 The FILTER Function

Lecture 133 Exercise 03

Section 23: Excel 2021 Intermediate: Working with Date and Time

Lecture 134 Understanding How Dates are Stored in Excel

Lecture 135 Applying Custom Date Formats

Lecture 136 Using Date and Time Functions

Lecture 137 Using the WORKDAY and WORKDAY.INT Functions

Lecture 138 Using the NETWORKDAYS and NETWORKDAYS.INT Function

Lecture 139 Tabulate Date Differences with the DATEDIF Function

Lecture 140 Calculate Dates with EDATE and EOMONTH

Lecture 141 Exercise 04

Section 24: Excel 2021 Intermediate: Preparing Data for Analysis

Lecture 142 Importing Data into Excel

Lecture 143 Removing Blank Rows, Cells and Duplicates

Lecture 144 Changing Case and Removing Spaces

Lecture 145 Splitting Data using Text to Columns

Lecture 146 Splitting Data using Text Functions

Lecture 147 Splitting or Combining Cell Data Using Flash fill

Lecture 148 Joining Data using CONCAT

Lecture 149 Formatting Data as a Table

Lecture 150 Exercise 05

Section 25: Excel 2021 Intermediate: PivotTables

Lecture 151 PivotTables Explained

Lecture 152 Creating a PivotTable from Scratch

Lecture 153 Pivoting the PivotTable Fields

Lecture 154 Applying Subtotals and Grand Totals

Lecture 155 Applying Number Formatting to PivotTable Data

Lecture 156 Show Values As and Summarize Values By

Lecture 157 Grouping PivotTable Data

Lecture 158 Formatting Error Values and Empty Cells

Lecture 159 Choosing a Report Layout

Lecture 160 Applying PivotTable Styles

Lecture 161 Exercise 06

Section 26: Excel 2021 Intermediate: Pivot Charts

Lecture 162 Creating a Pivot Chart

Lecture 163 Formatting a Pivot Chart - Part 1

Lecture 164 Formatting a Pivot Chart - Part 2

Lecture 165 Using Map Charts

Lecture 166 Exercise 07

Section 27: Excel 2021 Intermediate: Adding Interaction to PivotTables and Charts

Lecture 167 Inserting and Formatting Slicers

Lecture 168 Inserting Timeline Slicers

Lecture 169 Connecting Slicers to Pivot Charts

Lecture 170 Updating PivotTable Data

Lecture 171 Exercise 08

Section 28: Excel 2021 Intermediate: Interactive Dashboards

Lecture 172 What is a Dashboard?

Lecture 173 Assembling a Dashboard - Part 1

Lecture 174 Assembling a Dashboard - Part 2

Lecture 175 Assembling a Dashboard - Part 3

Lecture 176 Exercise 09

Section 29: Excel 2021 Intermediate: Formula Auditing

Lecture 177 Troubleshooting Common Errors

Lecture 178 Tracing Precedents and Formula Auditing

Lecture 179 Exercise 10

Section 30: Excel 2021 Intermediate: Data Validation

Lecture 180 Creating Dynamic Drop-down Lists

Lecture 181 Other Types of Data Validation

Lecture 182 Custom Data Validation

Lecture 183 Exercise 11

Section 31: Excel 2021 Intermediate: WhatIf Analysis Tools

Lecture 184 Goal Seek and the PMT Function

Lecture 185 Using Scenario Manager

Lecture 186 Data Tables: One Variable

Lecture 187 Data Tables: Two Variables

Lecture 188 Exercise 12

Section 32: Excel 2021 Intermediate: Course Close

Lecture 189 Course Close

Section 33: PowerPoint 2021: Introduction

Lecture 190 Introduction to PowerPoint 2021

Lecture 191 DOWNLOAD ME: Course Exercise Files

Lecture 192 DOWNLOAD ME: Course Instructor Files

Lecture 193 Creating Visually Stunning Presentations

Lecture 194 Presentation Tips and Best Practice

Lecture 195 Free PowerPoint Resources

Lecture 196 Exercise 01

Section 34: PowerPoint 2021: Getting Started in PowerPoint 2021

Lecture 197 The PowerPoint 2021 Interface

Lecture 198 Customizing the Quick Access Toolbar

Lecture 199 Opening, Closing, and Saving Presentations

Lecture 200 Using PowerPoint Templates

Lecture 201 Setting PowerPoint Options

Lecture 202 Exercise 02

Section 35: PowerPoint 2021: Slides and Layouts

Lecture 203 Slide Layouts

Lecture 204 Adding, Arranging, and Duplicating Slides

Lecture 205 Reusing Slides from Other Presentations

Lecture 206 Creating Slides from an Outline

Lecture 207 Slide Themes and Backgrounds

Lecture 208 Exercise 03

Section 36: Slide Workshop: Title Slide

Lecture 209 Resizing a Background Image: Crop and Fill

Lecture 210 Transparent Shape Overlays

Lecture 211 Drawing and Formatting Shapes

Lecture 212 Locking Shapes and Setting a Default Shape

Lecture 213 Merging Shapes

Lecture 214 Inserting a Logo: Filling Shapes with Pictures

Lecture 215 Adding a Title and Subtitle: Inserting Text Boxes

Lecture 216 Using the Eyedropper Tool

Lecture 217 Exercise 04

Section 37: PowerPoint 2021: Selection, Alignment and Grouping

Lecture 218 Selecting Objects

Lecture 219 Arranging, Renaming, and Changing the Z-Order

Lecture 220 Aligning and Grouping Objects

Lecture 221 Exercise 05

Section 38: Slide Workshop: Meet The Team

Lecture 222 Duplicating and Reformatting Slides

Lecture 223 Filling Shapes with Images

Lecture 224 Copying Formatting: Format Painter

Lecture 225 Bullets, Numbered Lists, and Paragraph Text

Lecture 226 The Morph Transition

Lecture 227 Exercise 06

Section 39: Slide Workshop: Divider Slides

Lecture 228 Merging Images Across Shapes

Lecture 229 Inserting and Formatting Icons

Lecture 230 Compressing Pictures

Lecture 231 Animating Objects: Entrance, Emphasis, and Exit Effects

Lecture 232 Applying Multiple Animations

Lecture 233 Triggering Animations

Lecture 234 Organising Slides: Slide Sorter View

Lecture 235 Exercise 07

Section 40: Slide Workshop: Our Destinations

Lecture 236 Adding Half-Page Image Slides

Lecture 237 Actions: Linking to Slides

Lecture 238 Using Slide Zoom

Lecture 239 Inserting Hyperlinks to Slides, Websites, Documents, and Email

Lecture 240 Exercise 08

Section 41: Slide Workshop: Tables, Charts and Diagrams

Lecture 241 Adding and Formatting Tables

Lecture 242 Creating a Process Flow Diagram with SmartArt

Lecture 243 Creating a Custom Process Flow Diagram with Shapes and Connectors

Lecture 244 Creating an Organization Diagram with SmartArt

Lecture 245 Inserting Charts: Line Chart

Lecture 246 Formatting Charts

Lecture 247 Exercise 09

Section 42: PowerPoint 2021: More Graphics

Lecture 248 Inserting Stickers, Cut Out People, Illustrations, and Cartoon Images

Lecture 249 Removing an Image Background

Lecture 250 Exercise 10

Section 43: PowerPoint 2021: Video, Audio and Screenshots

Lecture 251 Inserting and Editing Videos

Lecture 252 Creating a Motion Video Background

Lecture 253 Adding Audio Files

Lecture 254 Inserting Screenshots

Lecture 255 Recording the Screen

Lecture 256 Exercise 11

Section 44: Slide Workshop: Transitions, Zoom and Motion Paths

Lecture 257 Adding and Modifying Slide Transitions

Lecture 258 Advanced Morph

Lecture 259 Summary Zoom

Lecture 260 Pan and Zoom

Lecture 261 Animating Objects with Motion Paths

Lecture 262 Exercise 12

Section 45: PowerPoint 2021: Master Slides

Lecture 263 What are Master Slides?

Lecture 264 Modifying Master Slides

Lecture 265 Exercise 13

Section 46: PowerPoint 2021: Extending PowerPoint with Add-ins

Lecture 266 PowerPoint Add-ins

Lecture 267 Countdown Timer Add-in

Lecture 268 QR Code Add-in

Lecture 269 Pro Word Cloud

Lecture 270 Exercise 14

Section 47: PowerPoint 2021: Preparing Slides for Delivery

Lecture 271 Adding a Header and Footer

Lecture 272 Adding and Formatting Speaker Notes to a Presentation

Lecture 273 Using the Notes Master

Lecture 274 Hiding and Unhiding Slides

Lecture 275 Rehearse Timings

Lecture 276 Setting Up and Running a Custom Slide Show

Lecture 277 Adding and Replying to Comments

Lecture 278 Exercise 15

Section 48: PowerPoint 2021: Delivering a Presentation

Lecture 279 Using Presenter View

Lecture 280 On-screen Presentation Options

Lecture 281 Record and Narrate a Presentation

Lecture 282 Exercise 16

Section 49: PowerPoint 2021: Exporting, Sharing and Printing

Lecture 283 Sharing a Presentation

Lecture 284 Exporting a Presentation

Lecture 285 The Info Tab

Lecture 286 Protecting a Presentation

Lecture 287 Printing a Presentation

Lecture 288 Exercise 17

Section 50: PowerPoint 2021: Course Close

Lecture 289 Course Close

Section 51: Word 2021: Introduction

Lecture 290 Welcome and Overview

Lecture 291 DOWNLOAD ME: Course Exercise Files

Lecture 292 DOWNLOAD ME: Course Instructor Files

Lecture 293 Exercise 01

Section 52: Word 2021: The Basics

Lecture 294 The Start Screen

Lecture 295 Explore the Word Interface

Lecture 296 Work with the Ruler and Zoom

Lecture 297 Check Spelling as you Type

Lecture 298 Customize the Quick Access Toolbar

Lecture 299 Keyboard Shortcuts

Lecture 300 Screentips, Contextual Menus and Ribbons

Lecture 301 Get Help

Lecture 302 Exercise 02

Section 53: Word 2021: Get Started - Work with Documents

Lecture 303 Create and Save a Document

Lecture 304 Open and Edit an Existing Document

Lecture 305 Create a Document from a Template

Lecture 306 Navigate Around a Document

Lecture 307 Find Tools in Word

Lecture 308 Exercise 03

Section 54: Word 2021: View Documents

Lecture 309 Switch Document Views

Lecture 310 Use the Immersive Reader and Focus

Lecture 311 Dark Mode

Lecture 312 Exercise 04

Section 55: Word 2021: Work with Text

Lecture 313 Enter Text and Apply Basic Formatting

Lecture 314 Make Selections

Lecture 315 Advanced Text Formatting

Lecture 316 Move Text with Cut, Copy and Paste

Lecture 317 Copy Formatting Using Format Painter

Lecture 318 Paste Options

Lecture 319 Find and Replace

Lecture 320 Exercise 05

Section 56: Word 2021: Work with Paragraphs

Lecture 321 Format Paragraphs and Alignment

Lecture 322 Line Spacing Options

Lecture 323 Work with Non-Printing Characters

Lecture 324 Bullets and Numbered Lists

Lecture 325 Indent Paragraphs

Lecture 326 Align Text with Tabs

Lecture 327 Exercise 06

Section 57: Word 2021: Themes

Lecture 328 Apply a Theme

Lecture 329 Create a Custom Theme

Lecture 330 Exercise 07

Section 58: Word 2021: Word Styles

Lecture 331 Why Styles Are Useful?

Lecture 332 Apply Styles to Paragraphs

Lecture 333 Modify Styles in the Styles Pane

Lecture 334 Create a Custom Style

Lecture 335 Exercise 08

Section 59: Word 2021: Insert Pictures, Tables and Other Objects

Lecture 336 Insert and Format Pictures

Lecture 337 Insert Stock and Online Pictures

Lecture 338 Text Wrapping

Lecture 339 Insert and Format Text Boxes

Lecture 340 Insert and Format Shapes

Lecture 341 Use the Selection Pane

Lecture 342 Insert Other Graphics

Lecture 343 Insert SmartArt, Charts and Screenshots

Lecture 344 Draw with Touch

Lecture 345 Organize Information in a Table

Lecture 346 Exercise 09

Section 60: Word 2021: Format Pages

Lecture 347 Page Size and Margins

Lecture 348 Work with Section and Page Breaks

Lecture 349 Inserting Additional Pages (Cover page and blanks)

Lecture 350 Apply Columns

Lecture 351 Add Headers, Footers and Page Numbers

Lecture 352 Insert Hyperlinks

Lecture 353 Insert Bookmarks

Lecture 354 Use Quick Parts

Lecture 355 Exercise 10

Section 61: Word 2021: References

Lecture 356 Modify and Update a Table of Contents

Lecture 357 Use Footnotes and Endnotes

Lecture 358 Build a Bibliography

Lecture 359 Insert Captions and a Table of Figures

Lecture 360 Create an Index

Lecture 361 Insert a Table of Authorities

Lecture 362 Insert Cross References

Lecture 363 Exercise 11

Section 62: Word 2021: Mail Merge

Lecture 364 Use the Mail Merge Wizard to Create Letters

Lecture 365 Create Envelopes with Merge Fields

Lecture 366 Create Labels Using Merge Fields

Lecture 367 Exercise 12

Section 63: Word 2021: Spelling and Grammar

Lecture 368 Check Spelling and Grammar

Lecture 369 Use Auto-correct to Fix Mistakes

Lecture 370 Exercise 13

Section 64: Word 2021: Track Changes and Comments

Lecture 371 Use Track Changes

Lecture 372 Accept and Reject Changes

Lecture 373 Track Change Settings

Lecture 374 Add Comments

Lecture 375 Document Comparison

Lecture 376 Exercise 14

Section 65: Word 2021: Finalize a Document

Lecture 377 Print Documents

Lecture 378 Document Properties

Lecture 379 Check a Document for Issues

Lecture 380 Protect a Document

Lecture 381 Share a File with Others

Lecture 382 Co-author Documents Online

Lecture 383 Exercise 15

Section 66: Word 2021: Course Close

Lecture 384 Course Close

Users of Microsoft 2021 and those upgrading from previous software versions,Users who have Microsoft Office foundation and seeking to advance their Excel knowledge.

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/office-2021-365-essentials-bundle/

Code:

https://k2s.cc/file/2c0f25bb33797/Office_2021365_Essentials_Bundle.part1.rar
https://k2s.cc/file/4cde3b074c46a/Office_2021365_Essentials_Bundle.part2.rar
https://k2s.cc/file/54d5eb78dc40c/Office_2021365_Essentials_Bundle.part3.rar
https://k2s.cc/file/32dda6ae70443/Office_2021365_Essentials_Bundle.part4.rar
https://k2s.cc/file/5ab7e036f2ece/Office_2021365_Essentials_Bundle.part5.rar

Code:

https://nitroflare.com/view/E523D096EB8AED5/Office_2021365_Essentials_Bundle.part1.rar
https://nitroflare.com/view/842F2DB91C439CA/Office_2021365_Essentials_Bundle.part2.rar
https://nitroflare.com/view/6BD64753FAE2EF8/Office_2021365_Essentials_Bundle.part3.rar
https://nitroflare.com/view/0AB6224EFB201F4/Office_2021365_Essentials_Bundle.part4.rar
https://nitroflare.com/view/1D87C4B5EF4980F/Office_2021365_Essentials_Bundle.part5.rar

Code:

https://rapidgator.net/file/85192c64ca999a90b849ae57306d7686/Office_2021365_Essentials_Bundle.part1.rar.html
https://rapidgator.net/file/366c4c58661b01da6afbb64efdc68889/Office_2021365_Essentials_Bundle.part2.rar.html
https://rapidgator.net/file/78bc30f030f870f43284026adec1ce2a/Office_2021365_Essentials_Bundle.part3.rar.html
https://rapidgator.net/file/39962ca8d2d9d1eb3d1feb964d222eac/Office_2021365_Essentials_Bundle.part4.rar.html
https://rapidgator.net/file/34241d10c8842e307d4b8b3d97869c8c/Office_2021365_Essentials_Bundle.part5.rar.html

[Slon]

How To Connect With Your Customers
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 131.83 GB | Duration: 100h 27m

Learn to connect, talk to and super satisfy your customers



What you'll learn
How to connect with your customers
How to talk to your customers
How to sell to your customers on a long term basis
How to create and maintain a relationship with your customers
How to stay in touch with your customers
How to get customers to follow you on social media
How to keep the customers you have
How to gain the trust of your customers

Requirements
No prerequisites, anyone can start

Description
Hi. Welcome to "How to connect with your customers". In this course we're dividing into the topic of connecting with your customers. When you connect with your customers, sales and relationships are more easy and more effective. You make long term relationships where customers become regulars. Talking to customers becomes easy and more enjoyable. Customers generally feel a sense of having a great shopping experience. I cover talking to your customers, connecting with your customers, selling to your customers and staying in touch with your customers. I also cover how to super satisfy your customers to increase the chances of that customer buying from you regularly. You want to start with chatting up your customers to get to know them and have them get to know you. When you get to know each other, you know more of what to say and you give your customer a sense of trust. Then you need to ask the right questions in order to suggest the perfect product of their dreams. When the product is perfect, the sale is easier and more relevant. Now that you have their perfect product, you give them the best deal and close the sale. That is a brief summary of how this sales technique works. You must also connect with your customers on social media in order to stay in touch, sell to them long term, and get them to share your posts, coupons and offers with their friends. Check out this course because it all starts with connecting with your customers and staying connected with your customers. The better your connection, the better your relationships and the more you know about your customers, the better your long term sales and success of your business. Take this course and improve your connections, relationships, sales, enjoyment and effectiveness with your customers.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Overview

Lecture 2 Why connect with your customers

Lecture 3 How to connect with your customers

Lecture 4 Relevance

Lecture 5 Selling in stages

Lecture 6 Consultation

Lecture 7 Connecting in conversation

Lecture 8 Caring about the customer

Lecture 9 Social media

Lecture 10 Persuasion and harmony

Lecture 11 When to sell

Lecture 12 Communicate what the customer gets from your product

Lecture 13 Conversation

Lecture 14 Salesperson traits

Lecture 15 Giving free stuff

Lecture 16 Engagement

Lecture 17 Connection and goals

Lecture 18 Goals

Lecture 19 High pressure sales

Section 3: Conversation

Lecture 20 Having a conversation

Lecture 21 Staying positive

Lecture 22 Starting a conversation

Lecture 23 Things you have in common with your customer

Lecture 24 Complements

Lecture 25 Breaking the ice

Lecture 26 The purpose of the conversation

Lecture 27 Maintaining a conversation

Lecture 28 Get the customer engaged in conversation

Lecture 29 Transitioning conversational stages

Lecture 30 How to have a good conversation

Lecture 31 Communicate good feelings

Lecture 32 Communicating product knowledge

Lecture 33 Communicating product buy ability

Lecture 34 Communicate high value

Lecture 35 Ending the social conversation

Lecture 36 Conversational goals

Section 4: Consultation

Lecture 37 Connecting to your customer with consultation

Lecture 38 Giving value through consultation

Lecture 39 How to consult with a customer

Lecture 40 Asking questions to improve results

Lecture 41 What questions to ask

Lecture 42 Demonstration and consultation

Lecture 43 Value influences customers

Lecture 44 Prospecting and consultation

Section 5: Sales

Lecture 45 Sales and up sales

Lecture 46 Maintaining a connection through sales

Lecture 47 Focus on the customer

Lecture 48 Confidence

Lecture 49 Honesty

Lecture 50 Sales logistics

Lecture 51 Persuasion

Lecture 52 How to persuade

Lecture 53 What persuades people

Lecture 54 Things that get people to buy

Lecture 55 Deals

Lecture 56 Competition

Lecture 57 Relevance

Lecture 58 Relationship

Lecture 59 Building the sale

Lecture 60 Stages of selling

Lecture 61 Having enough information about the customer

Lecture 62 Trying the product

Lecture 63 Replying to customer comments

Lecture 64 What gets the customer to make the purchase

Lecture 65 Showing the best product

Lecture 66 Goals of the sale

Lecture 67 Making regular sales to your customer

Section 6: Social media

Lecture 68 How social media works for customers

Lecture 69 Selling through social media

Lecture 70 Growing an audience

Lecture 71 Goals of connecting on social media

Lecture 72 How to get social media information

Lecture 73 YouTube

Lecture 74 Facebook

Lecture 75 Get people to follow you and stay subscribed

Section 7: Connection

Lecture 76 What is connection

Lecture 77 What is the best connection

Lecture 78 Find commonalities

Lecture 79 Authenticity

Lecture 80 Get the customer to connect with you

Lecture 81 Relating in the conversation

Lecture 82 Interest and connection

Lecture 83 Recommend a better product

Lecture 84 Maintain positivity

Lecture 85 Have positive intentions

Lecture 86 Treating customers really well

Lecture 87 Maintain a connection

Lecture 88 Business connection

Lecture 89 How the customer wants to connect

Lecture 90 Give free stuff

Lecture 91 Confidence

Lecture 92 Hospitality

Lecture 93 Honesty

Lecture 94 Persuasion

Section 8: What customers like

Lecture 95 The shoppers high

Lecture 96 What customers generally like

Lecture 97 Being all engaged with the customer

Lecture 98 The experience

Lecture 99 Knowing what the specific customer likes

Lecture 100 Know what your customers like

Lecture 101 More hits, less misses

Lecture 102 Know before making recommendations

Lecture 103 The entire package

Lecture 104 Caring about your customers

Lecture 105 People and equality

Lecture 106 Browsing

Section 9: Shopping experience

Lecture 107 Delighting your customer

Lecture 108 Convenience

Lecture 109 Intentions

Lecture 110 Mutual enjoyment

Lecture 111 Get into a good mood

Lecture 112 Give free stuff

Lecture 113 Give in ways you don't directly profit from

Lecture 114 Great first impressions

Lecture 115 Relationship experience

Lecture 116 Play music for your customers

Section 10: Satisfying customers

Lecture 117 Satisfying customers is the goal

Lecture 118 Good communication

Lecture 119 Communicate your goal to satisfy your customers

Lecture 120 How to satisfy your customers

Lecture 121 Attention to detail

Lecture 122 Get regular customer feedback

Section 11: Relationship

Lecture 123 Why form a relationship

Lecture 124 How to start a relationship

Lecture 125 Why customers want relationships with salespeople

Lecture 126 Relationship dynamics

Lecture 127 Building relationships

Lecture 128 What relationships do customers want

Lecture 129 How to build a relationship

Lecture 130 Relationships keep existing customers

Lecture 131 Approaching your customers mindset

Lecture 132 How to get your customer to want a relationship with you

Section 12: Approach

Lecture 133 A better approach

Lecture 134 How to approach

Lecture 135 Give good impressions

Lecture 136 What to say during the approach

Lecture 137 Demonstrate high value

Lecture 138 How to communicate high value

Lecture 139 Warming up

Lecture 140 Purpose of the approach

Lecture 141 Approach your way

Lecture 142 Responses of the approach

Section 13: Customer responses

Lecture 143 Customer responses

Lecture 144 Get a good response

Lecture 145 Giving responses to customers

Lecture 146 Spontaneity

Lecture 147 Negative responses

Section 14: Customers

Lecture 148 Customers use money

Lecture 149 Treating customers well

Lecture 150 Relating to customers

Lecture 151 Sharing the same goal

Lecture 152 Treating customers properly

Lecture 153 Getting customers and keeping customers

Section 15: Deals

Lecture 154 Find the right product first

Lecture 155 Prices

Lecture 156 Competition

Lecture 157 Bargaining

Lecture 158 Talking about deals to your customer

Lecture 159 Deals attract customers

Lecture 160 Deals and sales

Section 16: Making regular customers

Lecture 161 Creating regular customers

Lecture 162 Relationships

Lecture 163 Staying in touch with your customers

Lecture 164 Giving free stuff

Lecture 165 Know your customer

Lecture 166 Shopping experience

Lecture 167 Making your customers feel welcome

Lecture 168 Satisfied customers

Lecture 169 Treating regular customers

Lecture 170 Create content people like to consume

Section 17: Goals

Lecture 171 The various goals of the customer interaction

Lecture 172 Covering all of your goals

Lecture 173 Goals to start with

Lecture 174 Enjoying your goals

Lecture 175 Social media shoutouts

Lecture 176 Shopping experience

Lecture 177 Human connection

Lecture 178 Achieving your goals

Section 18: How to treat your customers

Lecture 179 Treating your customers well

Lecture 180 How to treat your customers well

Lecture 181 What customers see as being treated well

Lecture 182 How customers want to be treated

Section 19: How to get customers to buy from you

Lecture 183 Getting customers to buy from you

Lecture 184 How to get customers to buy from you

Lecture 185 What makes customers shop where they shop

Lecture 186 How companies get people to buy from them

Lecture 187 Get the customer to feel like buying

Lecture 188 Things that matter to customers

Lecture 189 Details and more important things

Lecture 190 Knowing your customer

Lecture 191 Mutual admiration

Lecture 192 Set the goal to get the customer to buy from you

Section 20: Delight your customers

Lecture 193 How companies delight their customers

Lecture 194 What delights customers

Lecture 195 Know what delights your customer

Lecture 196 What matters

Lecture 197 What to give your customers

Lecture 198 Complements

Section 21: Internet connection

Lecture 199 Creating a following

Lecture 200 Creating content

Lecture 201 Responding to comments

Lecture 202 What content gets attention

Lecture 203 Selling on the internet

Lecture 204 Grow an audience

Lecture 205 Interest your followers

Section 22: Appealing to customers

Lecture 206 Fan talk

Lecture 207 Talk about what your customer loves

Lecture 208 Find similarities

Lecture 209 How to appeal to customers

Lecture 210 Talk about what's interesting

Lecture 211 One customer represents your relationship to more customers

Lecture 212 What appeals to customers

Lecture 213 Do what appeals to your customers

Lecture 214 Selling

Lecture 215 How to know what appeals to your customers

Section 23: Approaches to sales

Lecture 216 Appealing to different customers

Lecture 217 Forming a personal connection first

Lecture 218 Enthusiasm

Lecture 219 Authenticity

Lecture 220 Honesty

Lecture 221 Selling speed

Lecture 222 Responses from the customer

Lecture 223 Spontaneous conversation

Lecture 224 Guiding the customer

Lecture 225 Customizing the sale

Section 24: What customers say

Lecture 226 Bargaining

Lecture 227 I'll think about it

Lecture 228 I'll shop around

Lecture 229 Asks for something cheap

Lecture 230 How to influence what customers say

Lecture 231 Controlling the conversation

Lecture 232 Solving problems

Lecture 233 What's wrong with the product

Lecture 234 Asks for something specific

Lecture 235 When the customer is not talking

Section 25: Interaction

Lecture 236 Enjoying the interaction

Lecture 237 How to have an enjoyable interaction

Lecture 238 Interacting with the customer

Lecture 239 Getting people to interact

Lecture 240 Interacting in a positive way

Lecture 241 Do things for the customer

Section 26: Positive conversation

Lecture 242 Positive conversation

Lecture 243 Communicating positivity

Lecture 244 Communicate negativity positively

Lecture 245 Positive guidance

Lecture 246 Creating positivity

Lecture 247 How to create positivity

Lecture 248 Influencing the conversation

Lecture 249 Positive selling

Lecture 250 Focus on the positive

Lecture 251 Win through positivity

Section 27: Understanding your customers

Lecture 252 Understanding your customers

Lecture 253 Learning about your customers

Lecture 254 What your customers talk about

Lecture 255 Make the customer feel understood

Lecture 256 Knowing your customer

Lecture 257 Asking questions

Lecture 258 Connect in the conversation

Lecture 259 How to ask good questions

Section 28: Communication

Lecture 260 Creating good communication

Lecture 261 How to create good communication

Lecture 262 Good communication builds relationships

Lecture 263 Good communication makes better connection

Lecture 264 Asking questions about what your customers are saying

Lecture 265 Honestly communicating

Section 29: Transitioning sales stages

Lecture 266 Transitioning in the sales stages

Lecture 267 Conversation and social media

Lecture 268 Conversation to consultation

Lecture 269 Transitioning to consultation

Lecture 270 Getting to the sale

Lecture 271 How to transition into the sale

Lecture 272 Reasons for the transitions

Lecture 273 Keeping the customer engaged

Lecture 274 Keeping the connection during the transition

Lecture 275 Keeping the connection after the sale

Section 30: Creating regular customers

Lecture 276 Building trust and expertise

Lecture 277 Getting customers to a decision

Lecture 278 Getting the customer interested

Lecture 279 Knowing what customers are interested in

Lecture 280 Giving more than the perfect product

Lecture 281 The sales timeline

Lecture 282 Connecting with second time customers

Lecture 283 Reconnecting to customers you remember

Lecture 284 Improving the product the customer buys

Lecture 285 Connecting to regular customers

Section 31: Different customers

Lecture 286 How customers are different

Lecture 287 Connecting to different people

Lecture 288 Being interested in different people

Lecture 289 Talking to different people

Lecture 290 Selling to different people

Lecture 291 Finding a connection

Lecture 292 Finding interest

Lecture 293 Different things that are important to customers

Section 32: Relating to customers

Lecture 294 How to relate with customers

Lecture 295 Relating in conversation

Lecture 296 Authentic relations

Lecture 297 Being authentic

Lecture 298 Acknowledging similarity

Lecture 299 Ways to relate

Lecture 300 Building honest relations

Lecture 301 Telling your customer that you relate with them

Lecture 302 Relating to the customer's needs

Lecture 303 Get the customer to relate with you

Section 33: How to connect

Lecture 304 Sales and connection

Lecture 305 Selling and connecting

Lecture 306 Connections lead to sales

Lecture 307 How connection leads to business

Lecture 308 Conversation leads to connection

Lecture 309 Connecting on multiple levels

Lecture 310 Connecting in consultation

Lecture 311 How to connect in stages

Lecture 312 Sales and recommending products

Lecture 313 Logistics

Section 34: Important factors

Lecture 314 Connecting on multiple levels

Lecture 315 Satisfying customers is the best connection

Lecture 316 Social media connection

Lecture 317 Getting customers to share your social media

Lecture 318 Connecting on a practical level

Lecture 319 The customer will talk about their experience

Lecture 320 Handling irate customers

Lecture 321 Talking to irate customers

Lecture 322 If customers don't want to buy

Lecture 323 Showing people the right product

Lecture 324 Positivity in your connections

Lecture 325 Create positive connections

Lecture 326 What holds customers back from buying

Lecture 327 When the customer can't decide

Lecture 328 When to be persuasive

Lecture 329 Convincing the customer to buy

Section 35: Things to know

Lecture 330 Getting the customer to respond positively

Lecture 331 Avoid a negative response

Lecture 332 Customers want honesty

Lecture 333 Talking about product negatives

Lecture 334 Playing the long game

Lecture 335 How not to lose a connection

Lecture 336 How finding similarities works

Lecture 337 How positivity works

Lecture 338 What influences sales

Lecture 339 Improving your product

Lecture 340 Working with the right companies

Lecture 341 Enjoying yourself

Lecture 342 Leading the sale or following

Lecture 343 Build trust with expert recommendations

Lecture 344 When customers ask for products you don't have

Lecture 345 Showing high quality products

Lecture 346 Get the customer to buy from you

Lecture 347 Have enough information

Lecture 348 How to ask customers for information

Lecture 349 How to ask for social media information

Lecture 350 What is most persuasive to the customer

Lecture 351 Relevance and honesty

Section 36: Types of connections

Lecture 352 Authentic connections

Lecture 353 Admiration

Lecture 354 Relatability

Lecture 355 Compassion

Lecture 356 Practice

Lecture 357 Try to sell to every customer

Lecture 358 Mindset

Lecture 359 Connecting on a mindset level

Lecture 360 Finding connections

Lecture 361 Connecting to customers who are different

Lecture 362 Business level connections

Lecture 363 Connecting on multiple levels

Lecture 364 Talking about travel

Lecture 365 Talk about where your customer is from

Lecture 366 Consultation and connection

Lecture 367 Using expertise to connect with customers

Lecture 368 Tell stories

Lecture 369 Strengths of connections

Lecture 370 How to find connections

Lecture 371 Internet connection

Lecture 372 Social media connections

Lecture 373 How to connect on social media

Lecture 374 Talking about price

Lecture 375 Connecting on a sales level

Lecture 376 Timing your connections

Lecture 377 Purpose of timing your connections

Lecture 378 Give free stuff

Lecture 379 Play your customer's favorite music

Lecture 380 Helping the customer

Lecture 381 Social media profiles

Section 37: Summary

Lecture 382 Achieving certain goals

Lecture 383 Have satisfying products

Lecture 384 Logistics

Lecture 385 Connecting to different people

Lecture 386 Structure of the sale

Lecture 387 How to relate with your customers

Lecture 388 Building the sale

Lecture 389 How to make the sale

Lecture 390 Showing customers the right product

Lecture 391 Connecting on social media

Lecture 392 Persuasion

Lecture 393 Relationship and sales

Lecture 394 What holds people back from buying

Lecture 395 Customer experience

Lecture 396 Troubleshooting

Lecture 397 Customer feedback

Lecture 398 When and when not to sell

Lecture 399 Levels of importance

Lecture 400 Being agreeable

Lecture 401 Getting to know the customer

Lecture 402 Talking about relevant topics

Lecture 403 Being genuine

Lecture 404 Persuade for the benefit of the customer

Lecture 405 Customers buy revolutionary products

Lecture 406 Spontaneity

Lecture 407 Expertise

Lecture 408 Giving to your customers

Lecture 409 Having a great shopping experience

Lecture 410 Create events

Lecture 411 Impressing your customers

Lecture 412 It's all practice

Lecture 413 Deal makers and breakers

Lecture 414 What customers want

Lecture 415 How to sell

Lecture 416 Being yourself

Lecture 417 How customers want to connect with you

Lecture 418 Ask questions

Lecture 419 Positive mindset

Section 38: Success

Lecture 420 Elevate your customer's mood

Lecture 421 Taking chances

Lecture 422 Caring about your customers

Lecture 423 Staying in touch with your customers

Lecture 424 Creating content to get a following

Lecture 425 Giving the most value

Lecture 426 Connections and selling

Lecture 427 Knowing your customer through connection

Lecture 428 Relate with your customer

Lecture 429 Selling and building a relationship

Lecture 430 Enjoy what you do

Lecture 431 Sell the thing that makes the most positive impact on your customer

Lecture 432 The deal matters

Lecture 433 Don't worry about the word "no"

Lecture 434 Customer expectations

Lecture 435 More about social media

Lecture 436 Internet content builds a following

Lecture 437 Connecting with social media

Lecture 438 Getting the customer to trust you

Lecture 439 How to get into a positive mood

Lecture 440 How to get your customers into a positive mood

Lecture 441 How to create a positive environment

Lecture 442 Customer feedback

Lecture 443 Keep the customer engaged

Lecture 444 Stay relevant

Lecture 445 Learn what your customers like

Lecture 446 Talking about technical things

Lecture 447 Making a product sound great

Lecture 448 How to build trust

Lecture 449 Being honest and effective

Lecture 450 How to communicate that you understand your customer

Lecture 451 How to get to know your customer's personality

Lecture 452 How to get the customer in the mood to buy

Lecture 453 Actions are more important than words

Lecture 454 Show and demonstrate the product

Lecture 455 Radiate a positive mood

Lecture 456 Do more for your customer

Lecture 457 How to know what's valuable to the customer

Lecture 458 How to approach a new customer

Lecture 459 Finding a good price

Lecture 460 Trying out new things

Section 39: Bonus

Lecture 461 How to implement sales techniques

Lecture 462 Gauge your customer's interest

Lecture 463 How you feel about the customer matters

Lecture 464 Assume there is trust between you and your customer

Lecture 465 Being patient with your customers

Lecture 466 Promising a fulfilling product

Lecture 467 Selling happiness

Lecture 468 Find what value the customer needs

Lecture 469 Selling with confidence

Lecture 470 Being in the moment

Lecture 471 Price products to move

Section 40: Conclusion

Lecture 472 Conclusion

Salespeople,Business people,People selling anything,People who have customers

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/how-to-connect-with-your-customers/

Code:

https://k2s.cc/file/84451a37ad407/How_To_Connect_With_Your_Customers.part01.rar
https://k2s.cc/file/a1e42191677a2/How_To_Connect_With_Your_Customers.part02.rar
https://k2s.cc/file/a202123b741f7/How_To_Connect_With_Your_Customers.part03.rar
https://k2s.cc/file/41fb8fb09e9f9/How_To_Connect_With_Your_Customers.part04.rar
https://k2s.cc/file/310d536bc74d1/How_To_Connect_With_Your_Customers.part05.rar
https://k2s.cc/file/e6c5606b97954/How_To_Connect_With_Your_Customers.part06.rar
https://k2s.cc/file/be6ce9dd59d04/How_To_Connect_With_Your_Customers.part07.rar
https://k2s.cc/file/17a50fb34d69d/How_To_Connect_With_Your_Customers.part08.rar
https://k2s.cc/file/c9364e7c93fee/How_To_Connect_With_Your_Customers.part09.rar
https://k2s.cc/file/afb02d8fa5ba2/How_To_Connect_With_Your_Customers.part10.rar
https://k2s.cc/file/ad9199a1c4971/How_To_Connect_With_Your_Customers.part11.rar
https://k2s.cc/file/364ef673f1372/How_To_Connect_With_Your_Customers.part12.rar
https://k2s.cc/file/dff04ab24b995/How_To_Connect_With_Your_Customers.part13.rar
https://k2s.cc/file/265703b73bfd4/How_To_Connect_With_Your_Customers.part14.rar
https://k2s.cc/file/1346751a2657f/How_To_Connect_With_Your_Customers.part15.rar
https://k2s.cc/file/d85576e106914/How_To_Connect_With_Your_Customers.part16.rar
https://k2s.cc/file/3d88cd1e39642/How_To_Connect_With_Your_Customers.part17.rar
https://k2s.cc/file/fb4ed9f0094c8/How_To_Connect_With_Your_Customers.part18.rar
https://k2s.cc/file/a99cb0a19a4f1/How_To_Connect_With_Your_Customers.part19.rar
https://k2s.cc/file/15f3b9065cfb8/How_To_Connect_With_Your_Customers.part20.rar
https://k2s.cc/file/b6bcec87f902f/How_To_Connect_With_Your_Customers.part21.rar
https://k2s.cc/file/ca56c9d86796b/How_To_Connect_With_Your_Customers.part22.rar
https://k2s.cc/file/56333103a838f/How_To_Connect_With_Your_Customers.part23.rar
https://k2s.cc/file/baa031d45bf67/How_To_Connect_With_Your_Customers.part24.rar
https://k2s.cc/file/bbb2d642805a0/How_To_Connect_With_Your_Customers.part25.rar
https://k2s.cc/file/bc23df40b2239/How_To_Connect_With_Your_Customers.part26.rar
https://k2s.cc/file/2da3e39314256/How_To_Connect_With_Your_Customers.part27.rar

Code:

https://rapidgator.net/file/734f3d824c628b2e6b4851a6aa2717b7/How_To_Connect_With_Your_Customers.part01.rar.html
https://rapidgator.net/file/87e0a8b72bd58e6e5cc95896d15b5cde/How_To_Connect_With_Your_Customers.part02.rar.html
https://rapidgator.net/file/0146503937d72668bdfe33acab58ff8f/How_To_Connect_With_Your_Customers.part03.rar.html
https://rapidgator.net/file/84469f64891d718c01941810bfb57b39/How_To_Connect_With_Your_Customers.part04.rar.html
https://rapidgator.net/file/74acf543aa52c0b5c105e183bf6854a5/How_To_Connect_With_Your_Customers.part05.rar.html
https://rapidgator.net/file/afca3a5e8266799225a82fb05a02609e/How_To_Connect_With_Your_Customers.part06.rar.html
https://rapidgator.net/file/c5426f1fed3ba5d24495c210658a2167/How_To_Connect_With_Your_Customers.part07.rar.html
https://rapidgator.net/file/f57f604ff863c8393daa7d553c0eea48/How_To_Connect_With_Your_Customers.part08.rar.html
https://rapidgator.net/file/df86b159a9a34bcf9f60feb9cde67629/How_To_Connect_With_Your_Customers.part09.rar.html
https://rapidgator.net/file/d1d36fe184cb2e4299121743836f19a0/How_To_Connect_With_Your_Customers.part10.rar.html
https://rapidgator.net/file/d0eefc3867710ea28cd9b93a29fa10cd/How_To_Connect_With_Your_Customers.part11.rar.html
https://rapidgator.net/file/953bd9a22c883d2f6dc5625981556817/How_To_Connect_With_Your_Customers.part12.rar.html
https://rapidgator.net/file/6b2e4d63fe81e9e3e1125355c2f36666/How_To_Connect_With_Your_Customers.part13.rar.html
https://rapidgator.net/file/2cab705788bc1a97b2f8d0fcc5e228bf/How_To_Connect_With_Your_Customers.part14.rar.html
https://rapidgator.net/file/a056e6b55ff632e96ce3e76c372a2da4/How_To_Connect_With_Your_Customers.part15.rar.html
https://rapidgator.net/file/7e93ca886bdb0f03c710cb0363e261d0/How_To_Connect_With_Your_Customers.part16.rar.html
https://rapidgator.net/file/171df57d7d4906e98ff762590dfd5db3/How_To_Connect_With_Your_Customers.part17.rar.html
https://rapidgator.net/file/6546c5b86f5fb401fadf08e0f5ae655d/How_To_Connect_With_Your_Customers.part18.rar.html
https://rapidgator.net/file/72d268d33c27a1cb876e524f6b2aa0d6/How_To_Connect_With_Your_Customers.part19.rar.html
https://rapidgator.net/file/6b89eaf94c9a72f57de0355d4c83ef79/How_To_Connect_With_Your_Customers.part20.rar.html
https://rapidgator.net/file/0566bc770fc35f3e0e5e16ff7a05e0a8/How_To_Connect_With_Your_Customers.part21.rar.html
https://rapidgator.net/file/85d628998d02456f50d9e4a68ee8b0f2/How_To_Connect_With_Your_Customers.part22.rar.html
https://rapidgator.net/file/938e783a9696095268855ee32a2a4bba/How_To_Connect_With_Your_Customers.part23.rar.html
https://rapidgator.net/file/016a0236bfde785a1fb917d0a41c10aa/How_To_Connect_With_Your_Customers.part24.rar.html
https://rapidgator.net/file/f3c2d065e5a876f766fa34b2b6079d58/How_To_Connect_With_Your_Customers.part25.rar.html
https://rapidgator.net/file/8f1f5c75cb901caa40c7b3a41f821868/How_To_Connect_With_Your_Customers.part26.rar.html
https://rapidgator.net/file/16c7ee036e3c09dca5a7c4a5fab1ae20/How_To_Connect_With_Your_Customers.part27.rar.html

Code:

https://nitroflare.com/view/2EFF83200D575F7/How_To_Connect_With_Your_Customers.part01.rar
https://nitroflare.com/view/97089C05759B3D3/How_To_Connect_With_Your_Customers.part02.rar
https://nitroflare.com/view/0E737225F9FFF57/How_To_Connect_With_Your_Customers.part03.rar
https://nitroflare.com/view/41285DB07BE3F94/How_To_Connect_With_Your_Customers.part04.rar
https://nitroflare.com/view/61416FF489FA2B5/How_To_Connect_With_Your_Customers.part05.rar
https://nitroflare.com/view/DB599403E27AC69/How_To_Connect_With_Your_Customers.part06.rar
https://nitroflare.com/view/54375F907E684BC/How_To_Connect_With_Your_Customers.part07.rar
https://nitroflare.com/view/5B0B5933DA1F5DE/How_To_Connect_With_Your_Customers.part08.rar
https://nitroflare.com/view/12D9ACB8F4E5C96/How_To_Connect_With_Your_Customers.part09.rar
https://nitroflare.com/view/B15372CDA902790/How_To_Connect_With_Your_Customers.part10.rar
https://nitroflare.com/view/EDD63DAC5400CD5/How_To_Connect_With_Your_Customers.part11.rar
https://nitroflare.com/view/EE4DF6A33939E47/How_To_Connect_With_Your_Customers.part12.rar
https://nitroflare.com/view/CBC28EFD5A11A50/How_To_Connect_With_Your_Customers.part13.rar
https://nitroflare.com/view/32AE95BC71D5FDB/How_To_Connect_With_Your_Customers.part14.rar
https://nitroflare.com/view/232451AC8EDC881/How_To_Connect_With_Your_Customers.part15.rar
https://nitroflare.com/view/1BECDD9368D9495/How_To_Connect_With_Your_Customers.part16.rar
https://nitroflare.com/view/0EA535ACCB776A1/How_To_Connect_With_Your_Customers.part17.rar
https://nitroflare.com/view/1E5D093CAD115F2/How_To_Connect_With_Your_Customers.part18.rar
https://nitroflare.com/view/298D5414C91BC6E/How_To_Connect_With_Your_Customers.part19.rar
https://nitroflare.com/view/3E4D6B63F107B6A/How_To_Connect_With_Your_Customers.part20.rar
https://nitroflare.com/view/EB3D4452316B592/How_To_Connect_With_Your_Customers.part21.rar
https://nitroflare.com/view/3465A67943953A7/How_To_Connect_With_Your_Customers.part22.rar
https://nitroflare.com/view/0512309F049FB81/How_To_Connect_With_Your_Customers.part23.rar
https://nitroflare.com/view/1B8EE7922C3D2C7/How_To_Connect_With_Your_Customers.part24.rar
https://nitroflare.com/view/8228865820EA385/How_To_Connect_With_Your_Customers.part25.rar
https://nitroflare.com/view/FC95EA67AD2E5DA/How_To_Connect_With_Your_Customers.part26.rar
https://nitroflare.com/view/58120814E4E7AC7/How_To_Connect_With_Your_Customers.part27.rar

[Slon]

Excel Bootcamp A-Z | The Hands-On Excel Training
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.13 GB | Duration: 5h 51m

Learn how to get the most out of excel



What you'll learn
You will master Excel and boost your work productivity
You will be able to create interactive dashboards using pivot tables and charts
You will be able to create impactful charts and get the most out of Excel's visualization features such as conditional formatting and sparklines
You will be able to leverage formulas and functions for your data analysis to get more insights more quickly
You will learn from hands-on exercises that make sure you are able to implement everything straight away and to ensure you will remember all new information
You will learn the most useful tips and tricks - no time is spent on trivial functionalities or examples
You will have lifetime access to the ultimate excel training, which successfully helped thousands of students master excel
You will have access to a trainer with 10+ years of training who is well-known within the analytics community

Requirements
No prior experience is needed
Any windows excel version (Excel 2007, 2010, 2013, 2016, 2019, Office 365)

Description
You want to get up and running quickly in Excel or you already know a bit and want to learn how to get the most out of this wonderful tool. Then this training is for you. With a lot of practical examples and exercises you will learn about the most important topics you need to know. From working with formulas and functions to building dashboards with pivot tables and charts.This training is what you need if you are starting with Excel, struggling with Excel or want to deepen the Excel knowledge you already have. It is a complete Excel course that will help you build one of the most crucial skills in business- Excel proficiency.But be aware! It is not another boring copy/paste training where you learn irrelevant shortcuts or explore functionalities that do not provide much value in practice. You will learn tips and tricks that make you more efficient than ever in your everyday work. With a good grasp of key features and how they can be combined you'll be able to tackle common business challenges more effectively. Topics include: Building dashboards with Pivot Tables & Charts, visualization tools such as conditional formatting and sparklines, and of course everything you need to know about formulas and functions from conditional logic with IF functions to lookup functions like XLOOKUP and INDEX MATCH.After this training you will be able to gain insights from data quicker, visualize data correctly and automate some common manual tasks. Let's go!

Overview

Section 1: Let's Get the Training Files First

Lecture 1 Download Course Files

Section 2: Getting Started with Excel | Excel Bootcamp Part 1

Lecture 2 Shortcuts for selecting data and moving around the workbook

Lecture 3 What you need to know about text, values, and dates

Lecture 4 So what options do we have for sheets, rows & columns, and cells

Lecture 5 Copy pasting data - clipboard tasks

Lecture 6 Making everything pretty with formatting

Lecture 7 Getting everything ready for printing

Section 3: Fun with Formulas & Functions | Excel Bootcamp part 2

Lecture 8 Creating a simple formula

Lecture 9 Formulas for logical comparisons

Lecture 10 Cell references: what's up with the dollar signs $

Lecture 11 Exercise: where to put the $ signs?

Lecture 12 Aggregation functions: get more done more quickly with functions

Lecture 13 Logical functions: how to handle more complex logical conditions

Lecture 14 IF function + nesting functions: if within an if, within another if

Lecture 15 Some more practice with the IF function

Lecture 16 IFS function: maybe easier?

Lecture 17 Exercise: cell references, IF function, and returning blanks

Lecture 18 Conditional calculations: COUNTIF(S)

Lecture 19 Conditional calculations: SUMIF(S), AVERAGEIF(S)

Section 4: Lookup Functions | Excel Bootcamp Part 3

Lecture 20 VLOOKUP | The basics

Lecture 21 HLOOKUP | Same logic, just the other way around

Lecture 22 XLOOKUP | New and improved version

Lecture 23 Matching data with lookup functions

Lecture 24 Approximate vs exact match

Lecture 25 Wildcards for more flexibility

Lecture 26 INDEX MATCH | How it works

Lecture 27 Row and column lookup

Lecture 28 Multiple colum lookup

Section 5: Charts and Data Visualization | Excel Bootcamp Part 4

Lecture 29 Creating charts - where it all starts

Lecture 30 Dealing with missing data and filters

Lecture 31 How to customize any chart in any way you like

Lecture 32 Best practices: making charts pretty and easier to read

Lecture 33 Saving time with chart templates

Section 6: Pivot Tables & Charts | Excel Bootcamp Part 5

Lecture 34 Why pivot tables?

Lecture 35 Preparing the data

Lecture 36 Pivot tables 101

Lecture 37 Customizing pivot tables

Lecture 38 Grouping sorting and filtering

Lecture 39 Custom calculations

Lecture 40 Pivot charts

Lecture 41 Creating a dashboard

Anyone that wants a hands-on and fun excel training that focuses on the most impactful features,Excel users that want to deepen their knowledge and see if there are more efficient ways of doing this as well as explore new functionalities,Absolute beginners that want a structured learning path to master excel within a day

Homepage

Code:

https://anonymz.com/?https://www.udemy.com/course/excel_bootcamp/

Code:

https://k2s.cc/file/6ac697e05244b/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part1.rar
https://k2s.cc/file/d443be0b009bf/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part2.rar

Code:

https://nitroflare.com/view/F988A7140A01F47/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part1.rar
https://nitroflare.com/view/79CA722B48BFBFE/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part2.rar

Code:

https://rapidgator.net/file/06d09035d20bcbab15f6e1ae5ed67176/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part1.rar.html
https://rapidgator.net/file/4aaf6c9fffc6569951ffd04d363a8b72/Excel_Bootcamp_AZ_The_HandsOn_Excel_Training.part2.rar.html