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.

O Microsoft Forms é um editor de formulários para coleta de dados ou mesmo edição de provas, e ainda possuem recursos para obtenção dos dados em forma de planilhas, correção e lançamento de notas. Você poderá também criar questionários e cadastros personalizados online. O app permite criar perguntas de vários formatos diferentes, publicar em um link na web e coletar as respostas em tempo real, com gráficos criados automaticamente.

Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model. If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop.

"Imagine Me…..Wowing Them With My Visio Diagrams!" In Master Visio 2010 by Simon Sez IT, get up to speed on Microsoft's handy diagramming program. Great for building org charts and flowcharts, Visio 2010 is a simple way to map out technology assets, process enhancements, networks, and other business functions. It's also an ideal way to generate seating charts and floor plans for events. Perfect for those seeking Microsoft Visio 2010 training or anyone looking to deepen their Visio knowledge, the Microsoft Visio 2010 training course provides 9 full hours of expert quality training videos. Find out how to manipulate and connect shapes, add pictures, and ensure perfect object alignment. Discover how to create sophisticated 2D images that impress your clients and co-workers and make you look like a diagramming pro. Plus, when you sign up for our class, you'll also get these 5 BONUSES in addition to the 44 online course videos: Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster. An online quiz (40 questions) - to test what you've learned. Downloadable & printable transcripts (over 180 searchable pages) – to give you another learning option, if you prefer reading but don't have time to take notes. 9 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym. A certificate of completion to tell everyone you've aced the course. Where else can you find so many extra tools to help you master Visio 2010?!?! So start learning today. Because being a technology dinosaur isn't going to get you a promotion or raise! All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on , and the videos enlarged. What people are saying: How wonderful it feels to have a company take personal interest in their customers and actually reach out to help. Again, thank you! This has been one of the best investments I've made. - Theo C. Your Visio tutorial flow is focused, calm and steady, everyone can appreciate that. Very nice work. - David F. All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on , and the videos enlarged.

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.