The Complete Microsoft Excel Data Analysis and Pivot Tables

This comprehensive video course provides you with the skills to Master any version of Microsoft Word, including Microsoft Word Desktop 2025, Word 365, and industry-specific editions. Even if you're a beginner or have an older version (2010-2025), this course will transform you into a MS Word expert in no time.Enroll now to transform from a beginner to an advanced Microsoft Word user. In this course, With Expertise of 10+ years in Microsoft Office. Ill guide you step-by-step through the most powerful and sought-after tools in Word. Even the very beginners who have never used Word or any other office application before will easily understand and will discover new techniques to enhance productivity and efficiency.By the end of this course, you will have mastered these key Microsoft Word features and will confidently complete a wide range of tasks with ease. Here are just a few of the topics you’ll master:Creating dynamic Word documents using the latest tools and presets.Converting PDFs directly into Word with the latest 2025 version.Automating formatting with saved templates and styles.Effectively managing large documents with sections, page breaks, and orientation control.Designing and managing tables, utilizing rulers, tab stops, and formatting tools.Inserting media, images, and applying professional styling to text.Performing complex mail merges for labels and form letters.Building and securing Word forms and protecting documents from unauthorized edits.Tracking changes, accepting/rejecting modifications, and automating proofreading.Creating dynamic tables of contents automatically, figure references, and cross-referencing within documents.Integrating Word with Excel for real-time data and creating linked charts.Exploring the power of Macros and ensuring they are safe with virus checks.</

In this course, students will ultimately learn to implement, manage, as well as monitor security and compliance solutions for Microsoft 365 and hybrid environments. Specifically, time from this course will be spent managing Microsoft identity and access, password and identity protection, identity synchronization, access management, Microsoft 365 security, threat intelligence, mobile device management, information protection, encryption, data loss prevention, cloud application security, archiving and retention, and data governance. This course will prepare students for the MS-500 exam. Students passing the exam will earn the Microsoft 365 Certified: Security Administrator Associate certification. This course aligns with the CAP Body of Knowledge and should be approved for 7.5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.**Updated as of August 2021**With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

OneNote is a powerful tool by Microsoft that allows you to manage and organize your notes. In this course, you will learn everything that you need to know to start taking and managing notes with the application.You will learn about how to manage sections and pages properly so that it will be easy for you to find the notes that you need in the future.One Note provides a variety of formatting and customization features with allow you to visually manage your notes the way you want which as well is what we are going to cover.After that, you will also learn how to change the page size and color and add tags to the notes as well. Also, we will look at how to apply templates and make templates of our own for future use.We will also see how we can insert tables in our notes and then alter the table according to how we want. In the end, we will look at different capabilities of OneNote including how to share our notes with others and work with others in real-time, use the immersive reader view, and then integrate tasks and calendar with outlook tasks.And finally, we will wrap up the course with an example project.

This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open and close files, how to enter formulae into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel.

You don't have to know everything there is to know about Excel. But, there are a few things the pros know that you'll want to know, too.Most of these skills are easy to learn and they will enable you to use Excel in a much more powerful way.If you use Excel regularly but you don't feel the sense of confidence and efficiency that you wish you did, this course is for you. It's designed to teach you the 23 Excel skills that will give you the biggest advantage with the least amount of effort when you use Excel.Based on my research and experience, these 23 Excel skills are the most important and useful skills you can learn beyond the basics of creating a spreadsheet.Most of them are easy to learn, and offer huge returns in efficiency for the small time they take to learn.A few of them will take a little more practice, but I've included them because they can be immensely powerful in ways that many experienced Excel users don't realize.You know how to use Excel. You've get the basics down. Now it's time to learn the 23 essential skills the Excel Pros know!

This is concise Excel course that will give you all the key ingredients to master how to use Excel and make you become proficient at using Excel to its full potential.The course starts at a basic level showing you the way around Excel, the ribbon and the different options you have at your disposal. The course then delves into the different functions Excel has, as well as the more advanced level features such as pivot tables, advanced formulas and charts alongside combining all these different functions together to create valuable dashboards and great ways of showcasing and highlighting important information in a clear and concise manner.The course has a number of sections and will go through the below functions and topics:1. Introduction - This will highlight the structure of the course and provide the basics needed to progress to more intermediate and advanced level content.2. Mathematical Functions - This section covers all the key mathematical formulas such as: sum, average, min, max and subtotal.3. Textual Functions - This section covers all the key textual formulas such as: concatenate, trim, length, upper, lower, proper, left, mid and right.4. Logical Functions - This section covers all the key logical formulas such as: if, and, or, countif and sumif.5. Date/time Functions - This section covers the date/time related functions such as: today. now. day. month, year and datedif.6. Lookup Functions - This section covers key look up formulas such as: vlookup, hlookup, index and match and xlookup.7. Data Tools - This section covers data tools such as: sorting, filtering, data validating, removing duplicates and text to column importing of data.8. Formatting data - This section covers how to format tables to highlight data effectively by the use of conditional formatting and other features.9. Pivot tables - This sect