This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners. You have already gotten your hands dirty with Power Pivot and seen how awesome it is. Now you are ready to take your skills to the next level by delving deeper and acquiring a more thorough understanding of how “ Disconnected ” or “ Parameter ” tables can be utilised to gain additional insights in your data models. The first part of the course addresses Microsoft’s change to the DAX engine that now makes editing queries a challenge if you aren’t an expert in SQL. Therefore, you learn to use Get & Transform to import data and in doing so, reduce the size of your data model file size considerably. You will draw upon your beginner DAX skills to delve deeper into the real meaning behind “ Initial Filter Context ”, “ Filter Context ” and “ Context Transition ” with explanations, diagrams, examples and practice exercises. To leverage the capabilities of “ Disconnected ” tables, I introduce you to the concept of thresholds , cut-offs and banding . This really does open the door to a wealth of possibilities and you’ll learn some useful techniques to gain some powerful new insights along the way. Throughout the course, you are building your skills and understanding – taking you to the next level at each Step – 1 - 10 . I’ll have a couple of surprises for you along the way – not only to boost your brownie-points at work but for your own piece of mind around administration of your data models! Here's what others said about the course: “ Gilly. Did it again with the Addition of Dax PowerPivot-10 easy steps for intermediate course. This intermediate Course adds more formulas and Dax functions and even disconnected slicers and cube formulas to add your learning base and continues to build off the previous two courses. Gilly is a brilliant teacher who clearly has an in-depth understanding of how power pivot works. She can break it down and simplify Dax so you know how functions works and understand how to use it in your day-to-day excel work. If you follow along and do the exercises when you’re done with a lesson you fully understand how to complete and use the Dax formulas in your data work. If you want to understand and learn Dax, Gilly courses are what you want to start with. I recommend Gilly courses, you will be pleased with your results afterwards. Well done Gilly. Thanks ” - SD " OUTSTANDING COURSE Love the exercises, really enforces the instruction Learning so much, will go over the course again reinforce learning Everything is explained in easy to understand terms " - JM “A lovely paced course with the different elements nicely segmented and of a good length. Certainly liked the extra surprise of Cubes. Will aid in displaying data that does not fit well with the confines of a pivot table. Cheers Gilly !” - GB “Do Love the way you teach. Hope to learn more from you for advanced DAX course with real world case studies. Bravo! ” - HA “Trainer explains concepts really well without using too much tech talk. The many examples support the good understanding of the subjects. The speed is ok for advanced users but too fast if you did not follow the basic course. Course is complete and every important subject is explained.” - R “Gilly does a great job of explaining complex concepts and makes her points using thought-provoking analogies. Excellent instructor! ” - SA “The course continued to build on the 10 Easy steps for Beginners. Detailed Instructions and real-world examples. Deep dive into advanced Power Pivot Formulas. ” - CJ What you will learn in this course: Get & Transform – building the Data Model DAX Iterators & Aggregator Functions Initial Filter Context Filter Context Context Transition VALUES() ALL(), ALLSELECTED() & ALLEXCEPT() IF() & HASONEVALUE() Disconnected/Parameter Tables Creating/Adding Disconnected tables “ Harvester ” Measures Conversion Measures Thresholds/Cut-offs Banding KPI’s I provide examples that we work through together. Then it’s over to you with practice exercises for you to help embed and consolidate your skills. I always provide video solutions – so, you’re never on your own. Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style dashboard and Insight reports. I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more. Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills. Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.

**My Microsoft Forms Course that covers the latest updates to the Microsoft Forms software** Whether you want to use surveys to improve your relationship and lifelong value of your customers or simply create quizzes for pleasure, you have come to the right place! Join over 7000 students that were able to create their own professional surveys. I will walk you through every step of creating your own surveys using a real life example. By the end of this course you will be able to create surveys and quizzes using industry best practices. This course will give you a deep understanding of Microsoft Forms functionality by using hands-on, contextual examples designed to showcase how to use Microsoft Forms with real world examples. By the end of the course you'll be able to: · Easily create a professional survey in minutes · Use Microsoft Forms to create a quiz · Manage customer feedback using Microsoft Forms · Be able to use Microsoft Forms to collect any feedback · Share feedback forms effectively · Build surveys using best practices Enroll today and enjoy: Lifetime access to the course and all future updates High quality, up to date video lectures Practical Microsoft Forms course with step by step video lessons

Learn Microsoft Publisher 2016 & 2013 with this comprehensive course from TeachUcomp, Inc. Mastering Publisher Made Easy features 64 video lessons with over 4 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises.  You will learn how to create dynamic fliers, postcards & business cards, perform mail merges, preparing your projects for printing and much more. Whether you are completely new to Publisher or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch a video lesson or open the manual and you’re on your way to mastering Publisher.

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.

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

* BRAND NEW COURSE * - July 2017 Everyone thinks that they know Microsoft Excel. Your sister knows Excel. The guy on the 3rd floor at work knows Excel. But they just think they know Excel. You REALLY know Excel. You're a Microsoft Excel expert. Well, now's your chance to prove it. This practice test is for the Microsoft Office Specialist exam for Excel, at the expert level, 77-728 . If you think you are ready to take the Microsoft exam and get certified, these practice tests will prove that you know your stuff. Take these tests before taking the real ones to identify your weaknesses, or give you the confidence to spend the money to sit for the real test. In these practice tests, you'll download a set of worksheets and be asked to perform tasks to prove that you know the advanced elements of Excel. The questions are based on the official exam requirements, and were prepared by Billy Wigley - a certified Excel expert and Microsoft Certified Trainer. These questions are tough. They're based on what you might see in the real exam, and every effort has been made to simulate the exam environment. There is also a project-based test that are a very close simulation to the project-based portion of the real exam. You'll get lifetime access to these questions. No 30-day expiry on these ones. Once you buy this, it's yours. Take your time and prepare for the exam, and use these tests to prove you're ready.