Most people spend the majority of their analysis time preparing their data. With Power Query, acquiring, transforming and preparing data becomes faster & simpler. If you're tired of spending HOURS on preparing your data and want to learn how to get your data into Excel and ready for analysis in an efficient way, this is the right course for you. And now updated in June 2020, with improved content and updated information. WHAT STUDENTS ARE SAYING: " Love the instructor! The explanations behind each concept enable me to understand not only what I am doing but WHY I am doing it." "I liked this course because it was focused and short. I completed it in a few hours and I really learned a lot about Power Query. I immediately signed up for four more courses. The course exceeded my expectations." "A huge learning experience; it opened my eyes to things I can do that I didn't know existed. Much appreciated and a big THANK YOU!" WHAT YOU CAN EXPECT: Introduction and Course Content Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns Advanced Data Transformations - Merging data into one table, Appending data,  Grouping data, conditional rules and custom fields Data Cleansing - Techniques and skills to clean up your data Connecting to Data Sources - Learn how to connect and access data from a variety of different data sources including, files, databases, web URL and SQL Analysis Services ABOUT THE TRAINER Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight. Ian has over 88,000 students and 24,000 reviews. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time. WHY YOU SHOULD SIGN UP: Learners buying this course get: Full access to 2.5 hours of HD quality video 7 downloadable resources and 7 articles Lifetime access Money-back guarantee (see Udemy terms and Conditions) Certificate of completion upon course conclusion We look forward to having you on the course! *************************************************************************************************************************************** DATA ANALYSIS COURSES ROADMAP: You can see all of Ian's other Data Analysis courses by searching for his name on Udemy. Excel Complete Introduction to Excel Pivot Tables and Pivot Charts Complete Introduction to Excel Power Pivot Complete Introduction to Excel Power Query Excel Interactive Dashboards and Data Analysis Complete Introduction to Business Data Analysis Tables and Formulas with Excel [2020 Edition] Power BI Complete Introduction to Microsoft Power BI [2020 Edition] Power BI Master Class - Query Editor [2020 Edition] Power BI Master Class-Data Models and DAX Formulas 2020 Power BI Master Class - Dashboards and Power BI Service 2020 Introduction to Data Analysis with Microsoft Power BI Google Data Studio Complete Introduction to Google Sheets Pivot Tables Complete Introduction to Google Data Studio 2020 Edition Google Analytics Reports and Dashboards with Data Studio

Students will learn about Microsoft OneDrive and how to get the most out of using OneDrive. Microsoft OneDrive is a cloud-based storage service that allows a user to access files from any device with an Internet connection. This means a user can share files with others within the organization as well as external users. Files stored on OneDrive can be edited in the Office Online applications and can even be co-authored by multiple users at once. Students will learn to access files, change the view and sorting options, open and save files, organize folders, share files, and view file details. Students will also learn to work with Version History, delete files, and sync files. Updated March 2019 This IAAP-certified counts for 1 recertification point 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.

Automation techniques and scripting skills are no longer optional for a systems administrator; they are a necessity! Powershell is the scripting language that’s behind this requirement. Since Microsoft has released the Powershell language it only continues to pick up steam and be implemented across dozens of platforms. Powershell is now not only a scripting language like VBscript it’s a fully featured management framework that you can’t afford not to utilize. This course will take your position to the next level if you’re a: Sharepoint Administrator Active Directory Administrator PC Technician Helpdesk Operator SAN Administrator VMware Administrator Amazon AWS Administrator ..and many more IT positions! Don’t get looked over for that promotion or new job. Learn Powershell today to keep up with the ever-changing IT culture and to help make your job so much easier through automation.

This course introduces the user to Microsoft PowerApps, a tool that allows you to create forms and gather data. PowerApps is part of the Microsoft 365 suite and is the successor to InfoPath. In this course, you will learn how to modify SharePoint List Forms using PowerApps as well as how to work with PowerApp formulas. This course will also review some of the more advanced features of InfoPath, such as working with data sources. Finally, you will look at how to distribute your PowerApp, including how to share, embed, and export your app. This IAAP-certified counts for 4.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.

Looking to create a world-class Professional Quality Diagrams and Drawings? Want to learn a powerful diagramming solution software used by 12 million users worldwide? Want a powerful skill on your resume? Whatever your motivation to learn Visio, you've come to the right place. This course is the first, most comprehensive, cost effective Visio 2016 course on the entire web - or your money back. Course latest Update: 01-Nov-2017 30+ exercise files added - every lesson can be exactly replicated by you New section (4 lessons) added - Software Wireframing techniques!! New section added (6 lessons) - Using Layers in Visio - Advanced - 23 /Aug/2016 Microsoft Visio 2016 is trusted by organizations and institutions large and small worldwide - making it the the one-stop diagramming solution to simplify and communicate complex information. Visio's worldwide numbers of more than 12 million users across both Enterprise level usage and academic makes it the world's most widely used diagramming solution. Master the World's Most Popular Diagramming Solution - VISIO in this Comprehensive Course. Learn the LATEST version - VISIO 2016 - and stay miles AHEAD of the curve Start from the very basics - this course makes no assumptions Earn promotions with your new skills - Become indispensable in your institution BONUS - learn what the LATEST and greatest version Visio 2016 brings to the table Create, Simplify and Communicate complex information with data-linked diagrams that you can create in just a few clicks. Get started with Visio easily with a select set of pre-crafted starter diagrams and contextual tips and tricks Take advantage of refreshed templates and thousands of shapes that meet industry standards including Unified Modeling Language ( UML ) 2.4, Business Process Model and Notation ( BPMN ) 2.0 and Institute of Electrical and Electronics Engineers ( IEEE ) compliance Learn Visio 2016 to create Powerful, Professional Diagrams Bring diagrams to life- using hundreds of predefined templates. Communicate One Version of the Truth - As your underlying data refreshes, your diagrams is refreshed in the browser. Secure diagrams with Information Rights Management (IRM), Visio Professional 2016 now offers IRM features. What am I going to get from this course? A step-by-step video tutorial starting from the absolute basics - all the way to advanced topics. 170 minutes of video lecture - over 35 separate lessons Countess hours saved with Visio 2016's diagramming and automation tools (like the Starter Diagrams) Respect of your Boss, peers, juniors, seniors - and your Domain Industry A powerful and absolutely essential diagramming tool that is indispensable in today's professional life A lifetime access to this course - and all future updates, enhancements BONUS: Tips, tricks, pitfalls and other points distilled from a lot of experience - these are distributed through out the course lessons

*** 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

Need to learn Visio quickly? Looking to enhance your skills at the office? Then this is the course for you. Join author, Microsoft Certified Trainer, and bestselling Udemy instructor Brian Culp for Udemy's #1 reviewed course on Visio as he demonstrates the most frequently-used, most time-saving features of this pro diagramming tool. The Like a Boss series has received hundreds of five-star reviews. Here's what others are saying: "Excellent content! Just what I was looking for to enhance productivity at the office." -Paige Popejoy "Great personality and explained things well. Felt like he was at my desk explaining it to me." -William Potts "Very precise, clear and constructive." -Forent Sidler "Perfect." -Yvonne Belo Microsoft Visio Like a Boss includes approximately eight hours of video instruction delivered in over 100 separate, bite-sized lessons, making it perfect for learning the application from the ground up, or for going back to review/refresh on a specific skill. Whether you're creating a first Visio diagram, or a veteran looking for a deeper understanding of Visio's capabilities, you'll be given a guided tour that will help you make professional diagrams with less frustration. Students will quickly progress from basic skills to a deeper dive into Visio's more advanced features by learning about: adding and editing diagram shapes and text connecting and grouping creating flowcharts, floor plans, and org charts documenting business processes linking Visio with external data sources collaborating with other users creating custom Visio shapes time-saving tips and tricks and much more In this course, you'll learn by doing. Most lessons start exactly where you would while at work or at school - with a blank diagram. By simply following along, students will create and edit Visio shapes, text, and connectors, building the skills needed to create flowcharts, floor plans, business process, or start from one of hundreds of ready-made templates. There's nothing to lose, except the headache of struggling to make the diagrams that can help your company (and your career). After completing Microsoft Visio Like a Boss, you'll be able to communicate your ideas visually more easily and effectively than ever before. Plus, you're always covered by Udemy's refund policy. So, if you're ready to explore the potential of this powerhouse diagramming tool, please enroll today. Because whether you're documenting timelines, engineering designs, or UX decision trees, communicating with a professional diagram can make all the difference in the world. See you in class!

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.