Hello and welcome to Excel Power Query Advanced course. At the outset I thank you for showing interest in this course. In this video I will provide overview of all the contents of this course and what are basic requirements before you enroll into this course. So let’s get started. There are four major areas I will be covering as part of this course. The first one is for troubleshooting the Power Query errors and workaround for limitation of Power Query. In real any software is not foolproof and has its own limitation. Also, if you don’t use the software as programmed you may encounter errors. And I hope you would agree that error codes or description in most of the software are not that user friendly or they do not provide appropriate solution to resolve the error. Hence in this first section I will show some of the common areas where you face Power Query limitation and erros. Some of them are as follows: Error encountered with adding / rename / deleting a particular column headings. Handling null values during arithmetic calculation. Identify error rows encountered while creating or on refresh of query. Multiplying effect when you JOIN queries Issues with filters and how to use advanced filters. Then the next area is for advanced case studies. Similar to my starter course of Excel Power Query where I have shown you more than 20+ real life case studies of applying power query, here also I have taken some real life case studies which require some more in depth knowledge of Power Query and workaround. This section will be updated new case studies as and when I see some interesting datasets. The current video are related to Applying local setting when converting the dates fields Leave dataset which needed leave details to be broken into separate rows from a single cell. Unstack the dataset which has uneven details Combine multiple rows data back to single cell. Then next section is for advanced M concepts. Here I will give you more information related to M Language in Power Query. What syntax is to be used under advanced editor. How to create parameters and use it inside your power query. How to create new custom M function using PQ interface or through advanced editor. I will also show how you can troubleshoot the custom M function you have created using advanced editor. Then I will show you how you can organize your multiple queries in separate groups. Further I will also show how to use Query Dependency view which will give you visual presentation of all the queries inside your excel file. This will help you understand the flow of all the data from source till the final output, where it is loaded or which queries are referenced to each other. All precedents and dependents to your queries can be easily identified. And now finally in last section I will be providing some readymade patterns for power query. I will provide all the power query code which you can copy paste into your file and start using it. You will not need to create any new query for these patterns. Since creating these patterns using power query requires lot of efforts and also very complex I am providing you these as ready to use. So now before you enroll I would like to tell you that there are few requirements. First one is that you should have latest version of Power Query installed if you are using Excel 2010 / 2013 or if you are using Excel 2016 then it should be updated. Second and most important is that you should have prior knowledge of using Power Query. So that is it. There are no further requirements other than these two. So what are you waiting for, enroll now into the course.

This course is designed to teach users about instant messaging with Skype for Business (formally Lync). Students will work with their Presence Status and explore Relationships in Skype Students will add contacts and create groups, learning to work with and edit the groups. In addition, students will be able to create IM (instant messages), share files, their Desktop and applications. Students will learn to create a Skype meeting and make video calls, record meetings, and utilize presentation tools like polls, presenting slides, and using the whiteboard.  Finally, students will set Skype options and collaborate using Skype in Outlook and other Office Apps.

Working with Access and VBA Microsoft Access has a lot of moving parts. Tables to store your data, Queries to retrieve data, Forms to work with data and Reports to report on your data. Each of these Access Objects are important all by themselves, but, the real power of Microsoft Access comes when you bring all these objects together. Automate with Access VBA Join me in this course on Microsoft Access VBA and learn how to create an intuitive, accessible Access application by automating yours and your users experience working with data in Access. Access VBA, or Visual Basic for Applications, will provide the means to streamline your efforts in working with Access. Through VBA you will learn to automate routine Access tasks as well as tasks that would normally take a large portion of your day to complete. Course Structure I have structures this course for those that are brand new to developing within VBA. Starting with the basics of working within the VBE (Visual Basic Editor) Window, your coding development environment, all the way through more advanced topics such as working with VBA variables and creating loops to repeat tasks, blocks of code. Enroll Now Enroll now and participate in the course by taking advantage of not only the step by step video demonstrations, test your understanding with section quizzes, but also download the exercise file that I will be using throughout the videos and follow along. Allow me to be your guide on the amazing journey of learning to program with the Microsoft Access with VBA.

*** Microsoft 365 (Office 365) Fundamentals (Administration) MS-900. *** With more than 200 million active monthly paid users, learning Office 365 is key to learning Microsoft cloud. The course is for business owners, IT consultants, end-users, and even for developers who are working on the Microsoft ecosystem. Literally, there are no pre-requisites needed. Subscribe now. This course provides a practical approach to learning Microsoft 365 and its components. Targeted for beginners. Concentration on hands-on. Lifetime access. Topics will be added or removed as per Microsoft's future updates. Disclaimer: The course will help you pass MS 900. I am not guaranteeing that you will pass the exam with this course. Microsoft has made certifications tougher recently. You may need a couple of months of practice before taking the certification exam. About the Trainer -  Ex- Microsoft Employee. -  More than 11000 students on Udemy. 30 Day Money Back Guarantee We are offering a 30-day money-back guarantee, so if you are not happy with the course for any reason whatsoever, you can get your money back, no questions asked. You are going to learn the following concepts: Section 1: Introduction to Cloud Computing 1. Course Introduction 2. Principles of Cloud Computing 3. Benefits of Cloud Computing 4. Types of Cloud Services Section 2: Introduction to Microsoft 365 1. Northwind - A fictional company 2. Introduction to Microsoft 365 3. Creating Trial Account of Microsoft 365 4. Explore Microsoft 365 Admin Center Section 3: User Management in Microsoft 365 1. Introduction to User Management 2. Multi-Factor Authentication 3. Resource Booking Section 4: Office 365 Core Services 1. Basics of Exchange Online 2. Advanced Options in Exchange Online 3. Basics of OneDrive 4. OneDrive Demo 5. Basics of SharePoint Online 6. SharePoint Demo 7. OneDrive and SharePoint Data Migration 8. Basics of Microsoft Teams 9. Basics of Microsoft Sway 10. Basics of Microsoft Yammer Section 5: Service Life Cycle and Support 1. Service Life Cycle 2. Microsoft Support Section 6: Enterprise Mobility + Security 1. Basics of Microsoft Intune 2. Azure Active Directory & Security 3. Security Roles in Microsoft 365 4. Data Loss Prevention (DLP) Section 7: Subscriptions and Licensing 1. Microsoft 365 Subscriptions 2. Office 365 Subscriptions 3. Quiz & Scenarios - Subscriptions & Licensing

Welcome to the Complete Crash Course on 7 Basic Quality Tools. The course was designed to equip you with the tools and Techniques that are used to solve 90% of quality management related issues within an organization irrespective of the Industry. The course is easy to follow and equipped with examples which are easy to follow, At the end of every topic the Practical Application and Implementation is demonstrated using MS Excel. Being a Quality Professional for 15 years I have practically used and applied these tools in multiple Quality Projects thereby resulting in Millions of dollars as cost saving or Revenue Enhancement.

Quickfile Accounts course is about how to use Quick File based on the most popular functions which you as a QuickFile operator needs to know how to use, in order to be proficient in using the software. The learning is structured in a practical way. You are given a practical scenario assignment. There are various tasks to complete. You are given the task to do and have a go at, and then the video answer is available. It is suggested that you: Read the task Watch the video Have a go at it yourself on your own system Rewatch the video (if necessary) - to reinforce the learning You'll learn how to set up a QuickFile system from scratch, how to enter opening balances, post customer invoices and credit notes, post supplier bills and credit notes, pay suppliers, petty cash, prepare a VAT return, reconcile the bank, post journals, run reports amongst over things. This is a useful course if: You are thinking of working with the software, You are going for jobs which have a requirement for you to be able to use this software You want to put this skill on your CV, or You are a bookkeeper or accountant and will be using this for clients or even You run your own business and want to know how to use QuickFile for yourself. You will need to access to Quickfile Online. We give you the link to access the FREE online version. This will be sufficient The instructor is usually online to answer student queries within hours. The course materials includes: the handout of the assignment task Successful completion of the course is the equivalent to being at the level of having a level 2 certificate in computerised accounts. The course will take about 3-4 hours to complete.

Interested in learning how to quickly automate basic administrative functions? Windows PowerShell is rapidly becoming the solution that Operators turn to with its powerful combination of a scripting language, command line speed, and GUI tools (Graphical User Interface). This course is an introduction to Windows PowerShell where you'll have an opportunity to learn how to replace manual, repetitive, and time-consuming operations with an automated solution. In this course, you'll be introduced to the Windows PowerShell console and the Integrated Scripting Environment (ISE) as the main command line interfaces you'll use to work with PowerShell commands. Learn the importance of the Windows PowerShell Help system as the quickest way to discover the commands and associated syntax you need for the particular task you want to accomplish. Take advantage of the ISE's Intellisense features to learn PowerShell through syntax completion and sorting and filtering commands with the Show Command add-on. This course will let you be able to understand the thinking way of the Windows PowerShell and work with it as a servant person that will Execute your commands . Every section will be going to let you create a successful habit and a good strategy to easily find the right command, the right syntax of this command, and then running it to get the required result. Also, learn how Providers and Drives work with disparate data sources, such as registry keys, certificates, files, folders, and more What You Will Learn The course is designed to teach you: Basic concepts of Windows PowerShell How to navigate the Windows PowerShell Help system effectively Find and Discover Any PowerShell Commands Interpret and understand how to read the Help of any Commands Formalization of the Right Syntax and Running the commands Working with Providers and Drives Understand the Variables Strings, Hash tables, Core Operators and Regular Expression Basics... And more... By the end of this course, you should be well on your way to creating scripts that save you time, accomplish tasks with greater efficiency, and allow you to be even more productive on the job. PS : Check the Free Preview videos to know more about the course and to be sure you can get accustomed to my accent Enroll now!

WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself. A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics. This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory. ONLINE TRAINING AND THE MOST COMMON PROBLEMS One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time. Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy. COURSE DELIVERY STYLE I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing. WHAT YOU’LL LEARN IN THIS COURSE When you reach the stage where tables are getting larger and becoming more difficult to sift through, it is time to upgrade your tool set. The use of Lookup's is absolutely essential for the user trying to extract information from long rows or columns of data. This means, that for large or complex sets of data, especially recurring data, one formula can organise/calculate different types of information in one go. Too many times I see people manually searching for what they need for hours rather than simply creating a Lookup formula. Stop wasting your time doing manual searching. Learn this simple function and make your life easier. In this course, I'll teach you everything from the internal structure of the formula, to linking it between columns to even creating your own search engine. ABOUT ME Member of the Udemy Council Co-Founded Paperclip Learning which teaches Microsoft Office Over 60,000 students and over 17,000 students for this course alone Over 130,000 enrollments Over 5,000 Positive Reviews and over 1,000 Reviews for this course Over 20 courses on Udemy Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics. TESTIMONIALS Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!! Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing. Spencer Berkman - Extremely knowledgeable and clear on instructions. E Frank - Simple to learn techniques and instructor made it all really easy. Thank you! Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.

Save 20% by purchasing this 3-Course bundle! Over 200 courses included* Bundle includes: Microsoft 365 Mobility and Security (Exam MS-100) Microsoft 365 Mobility and Security (Exam MS-101) SharePoint 365 Site Owner The Microsoft 365 Identity and Services portion of this course will cover topics from the Microsoft MS-100 exam, which measures a student's ability to design and implement Microsoft 365 services, manage user identity and roles, manage access and authentication, and plan Office 365 workloads and applications. In this course, students will get a thorough overview of how to configure Exchange Online and SharePoint Online, how to work with Office Pro Plus, and how to migrate to Office 365. Finally, students will also learn how to configure Microsoft 365 Tenant, learn how to manage user and security groups and licenses, and learn how to use authentication in 365. - This IAAP-certified counts for 5.75 recertification points for the CAP certification under the Technology and Information Distribution content area. - Email [email protected] with proof of completion of the course to obtain your certificate. The portion of this course covering topics from the Microsoft MS-101 exam will measure a student’s ability to accomplish the following technical and administrative tasks: Identify threat vectors; use Secure Score; configure Azure Identity Protection; configure Exchange online protection; implement modern device services; implement Microsoft 365 security and threat management; and manage Microsoft 365 governance and compliance. - This IAAP-certified counts for 5.5 recertification points for the CAP certification under the Technology and Information Distribution content area. - Email [email protected] with proof of completion of the course to obtain your certificate. The SharePoint 365 Site Owner portion of this course will teach students an overview of SharePoint Site Owner roles and responsibilities. Students will learn to add and configure sites, create and configure libraries and lists, create and customize columns, and manage content types. Students will also learn to manage permissions and permission levels, create and modify site pages and work with navigation and regional settings. - This IAAP-certified counts for 5.25 recertification points for the CAP certification under the Technology and Information Distribution content area. - Email [email protected] with proof of completion of the course to obtain your certificate.

Every business wants to be more efficient, save time and increase revenue. Isn't it? That's why automation is so important for companies to take their business to the next level. Presenting, Microsoft Dynamics 365 Workflows Mastery Course. If your company or your clients are using Microsoft Dynamics 365, then you this can be the most important course for you to learn and Implement Microsoft Dynamics 365 Workflows. So, you can save more time, become efficient and increase business revenue. I have designed this course for Microsoft Dynamics consultants and Microsoft Dynamics Aspirants. By the end of this course, you will have complete practical understanding of Dynamics 365 workflows and how to use it for your company or client. Here's what you will learn: Dynamics 365 Workflows Introduction Types of Workflows Workflows Important Terms & Information Workflows - Creating Records Workflows - Updating Records Workflows - Assigning Records Workflows - Send Emails Workflows - Child Workflow Workflows - Perform Actions Workflows - Change Status, Wait Condition & Stop Workflow Workflows - Custom Workflow Activity (code included) Course Review & Next Steps And everything with a scenario (case study) and practical demo. Feel free to take a look at the course description, watch the preview videos and sign up for the course at the highly discounted price. To Your Success, Abhay Sharma