Exponential Productivity - Corporate Time management

this advanced Microsoft excel course will teach you how to use advanced excel formulas and functions to solve business problems. This course is very detailed and it is designed for users who already have a basic knowledge of Microsoft excel. This course uses practical real-life datasets to explains what, why and when we use a particular excel function or formula as well as showing you how to use the function or formula. You will have access to the Excel spreadsheets used in this course so that you can follow along with the course instructor.At the end of this course, you will have learned:· How to validate your dataset.· How to use the logical statements to query excel dataset.· How to effectively use excel pivot tables to handle large dataset so as to provide answers to complex business problems.· Dynamic Cell locking· What, when, why and how to use Excel functions or formulas to automate task in excel.· How to analyze and make optimal decisions among competing projects.· How to clean big data set.You will begin by revising the basic Microsoft Excel paste special options and operations, as well as the transpose option. You will also revise how to use excel to automatically fill series in a spreadsheet. You will explore and fully understand how and when to use the cell locking options to lock an entire column, row, or just a cell in your spreadsheet. You will also learn how to create and when to use named ranges to reference an entire row, column or spreadsheet in Excel. You will learn how to audit a formula, filter and use the subtotal Excel functions. You will be taught the difference between the subtotal function and the sum function; you will also learn why learn when and why to use the subtotal function in place of the sum function. You will explore the Excel Lookup, Vlookup and Hlookup functions indepth. You will learn the difference between the True and False Match in Excel Vlookup function and when to they are to be used. You will learn how

This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more!WHAT MAKES OUR EXCEL COURSE UNIQUE?Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleepG-rated humor and lighthearted lessonsZERO FLUFF!Real world application that you can start applying todayWHAT YOU'LL BE LEARNINGThis course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+CVLOOKUP, IF, and Nested IF statementsSUMIFS and COUNTIFSText formulas including LEFT, RIGHT, and TRIMDate formulas including EOMONTH and EDATEPivotTables and SlicersConditional Formatting, Remove Duplicates, and Text-to-ColumnsBy the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course.__________NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.

If you want a clear, simple, and complete way to master Google Workspace, this course brings everything together for you in one place. You learn every major tool used daily in offices, agencies, classrooms, startups, and online businesses. This includes Google Docs, Sheets, Slides, Drive, Forms, Gmail, Keep, Calendar, Sites, Analytics, Google Ads, Tag Manager, and AI tools inside Google Workspace such as Google Gemini. Instead of learning each tool separately, you gain a full system that helps you work faster, organise better, and handle digital tasks with confidence.Most people only know the surface-level features of Google Suite or G Suite. Because of this, they take longer to finish simple tasks, struggle with settings, and miss many functions that could save time. This course fixes that by teaching you step-by-step, starting from zero and guiding you to a professional skill level. Every lesson is practical and easy to follow.You will learn how to write and format documents in Google Docs, prepare data in Google Sheets, create presentations in Google Slides, build forms and surveys, manage files in Google Drive, organise your schedule with Google Calendar, take quick notes in Google Keep, set up websites in Google Sites, track visitors in Google Analytics, manage campaigns in Google Ads, and use Google Tag Manager for tracking. Each tool is covered with the exact skills you need to use it confidently in real work.You will also learn how AI inside Google Workspace can speed up your work. Through Google Gemini prompts and practical examples, you discover how AI can help you write content, summarise documents, prepare emails, fix formulas, generate layouts, and support your day-to-day tasks.If you skip this course, you may continue spending more time on tasks that could be done faster with the right skills. You might also miss the chance to combine your Google Workspace skills with AI, which is becoming a standard requirement in many modern jobs. Companies now expect employees to kn

SharePoint Interview Questions and Answers Preparation Practice Test | Freshers to Experienced Welcome to the Comprehensive SharePoint Interview Questions Practice Test course! Are you preparing for a job interview in SharePoint? Are you looking to assess your knowledge and readiness for a SharePoint-related role? Look no further! This course is designed to provide you with a comprehensive set of interview questions covering various aspects of SharePoint, ensuring you're well-prepared to ace your interview.In today's competitive job market, it's essential to stand out from the crowd during interviews. This course offers an extensive collection of interview questions, meticulously crafted to cover all the crucial areas of SharePoint. Whether you're a beginner or an experienced professional, this practice test course will help you assess your understanding and identify areas for improvement.This course is divided into six sections, each focusing on different aspects of SharePoint. Let's take a closer look at what each section covers:1. SharePoint Basics and Architecture:Explore fundamental concepts such as site collections, lists, libraries, permissions, and web parts.Understand the architecture of SharePoint farms and how they function.2. SharePoint Development:Dive into SharePoint Framework (SPFx) development and REST API usage.Differentiate between SharePoint add-ins and SPFx solutions.Learn PowerShell scripting for SharePoint automation.3. SharePoint Administration:Gain insights into SharePoint Central Administration and essential administrative tasks.Master backup, restore, monitoring, and troubleshooting procedures.Explore service application configuration and permissions management.4. SharePoint Online and Office 365 Integration:<

Microsoft Word is one of the most used document editing software and one with a high demand on the market. Whether it is for writing resumes, reports, legal documents or publishing an eBook, Microsoft Word has the tools and templates that will make your project come to life.If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time. It is worth noting that such courses allow you to quickly gain required skills, without having to enroll in a full semester course.This course is divided into 5 sections, and made up of 28 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.The course is divided into the following sections and chapters:FormattingFontsParagraph LayoutTabs List Part 1Tabs List Part 2Custom TablesCustom ColumnsPage Control and FormattingHeaders FootersStyle Methods MadnessTemplatesGo GraphicalText and Graphic LayoutDrawing ObjectsPictures IllustrationsInserting ObjectsWord at workCover Pages, Watermarks, Digital SignaturesDifferent Document Types Printing OptionsCollaboration and SharingWord for lawyers and Wordperfect ConvertsWord For WritersTools For Every AuthorFrom Brainstorm To OutlineHumongous DocumentsDocument R

Microsoft Office All-in-One: Excel, Word, and PowerPoint is a complete practical course designed to help you build strong, job ready skills in the most widely used office applications.Whether you are a beginner or someone looking to improve productivity at work or school, this course will guide you step by step through Microsoft Word, Excel, and PowerPoint, from the basics to more advanced features. You will learn how to create professional documents, analyze and manage data efficiently, and design impactful presentations.In the Microsoft Word section, you’ll learn how to format documents, create reports, resumes, letters, and official documents with confidence. You’ll master styles, layouts, tables, headers and footers, and document organization to produce clean, professional results.The Microsoft Excel section focuses on essential spreadsheet skills used in offices and businesses worldwide. You’ll learn how to enter and organize data, use formulas and functions, create charts, apply formatting, and analyze information efficiently. This section emphasizes real-world tasks such as budgeting, tracking, and reporting.In the Microsoft PowerPoint section, you’ll learn how to design visually appealing and professional presentations. You’ll discover how to structure slides, use animations and transitions effectively, insert charts and visuals, and present information clearly for meetings, classes, and business presentations.This course includes hands-on exercises and practical examples to help you apply your skills immediately. You’ll work on real life scenarios that reflect everyday office tasks, improving both speed and accuracy.This course is ideal for:Beginners with no prior Microsoft Office experienceStudents and job seekersOffice professionals and administrators