Overview

Why to buy individual courses when this complete package will give you everything you need! Boost your career and stand out from others in crowd!!1. Microsoft Word (Basic course)2. Microsoft Word (Advanced course)2. Microsoft Excel (Basic course) 4. Microsoft Excel (Advanced course)3. Unlock Macros & VBA Programming course4. Microsoft Outlook - Basic & Advanced5. Microsoft PowerPoint - Basic & AdvancedMicrosoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course:Looking for an online Excel course to improve your skills and save time but don't know where to start?I have picked out the Excel Essential skills and packaged them in a structured course.I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects.Microsoft Word complete Package - Don't use just Word, learn tips and tricks with this course to be a smart user. This course includes basic level, intermediate level and advanced level of MS Word. Enroll now to go from beginning to Advanced user. At completion of this course you will have mastered the Microsoft Word.Microsoft Excel:By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to:Input Data and Navigate Large SpreadsheetsEasily build dynamic tools & Excel dashboards to filter, display and analyze your dataApply Excel hacks to get your work done fasterBe able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more)Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functionsGet Answers from your DataOrganize, Clean and Manage Large DataCreate Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and TimelinesImport & transform data with tools like Get & Transform (Power Query)Manipulate dates, times, text, and arraysReduce manual routine tasks to the click of buttonVBA programming & read, write own Macro to automate the tasksWe will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn:Useful Excel shortcuts for data entry and navigation.Protect your Excel files and worksheets properly.To apply formatting correctly for cleaner and more professional reports.To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell.Add Comments & Notes to cells & how to print the same if needed.Add Data & time Stamps to your reports.Lookup/Reference Functions.Statistical Functions.Logic Functions.Text Functions.Date & Time Functions.The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more.Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.)Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data.What Excel Power Query can do for you and how easy it is to combine data from different spreadsheetsUse Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data.Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables.Import data from Text File.Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons.More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced.Microsoft Word: At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency and grace. Below are just a few of the topics you will master.Highlights:Creating Dynamic Microsoft Word DocumentsEffectively Formatting a Document with StylesPrepare Documents for Printing and ExportingManage Large DocumentsWorking with Page and Section BreaksControl Page OrientationCreate and Manage Table LayoutsWork with Tab Stops to Align Content ProperlyInsert Media and ImagesPerform Mail Merges to create Mailing Labels and Form LettersManage TemplatesProtect Documents from EditsTrack and Accept/Reject Changes to a DocumentBuild Dynamic Table of Contentsand much, much more...Microsoft Outlook:Outlook is an essential office software and understanding it fully is the best way to keep your daily correspondence running smoothly. This online course will help you learn tips and tricks for sending and organizing email, reducing inbox clutter, how to manage your calendar, contacts and tasks to maximize efficiency.Highlights:Office management tips to monitor inbox size, set up auto-archive, search for and organize email in folders and groups.Best practices for sending, receiving, and saving attachments.Set up email signatures and explore options such as read receipts and delayed send.Stay organized by using the calendar to schedule appointments, meetings, and events.Add and group contacts; create, assign, and filter tasks.Design Quick Steps to save time on repetitive yet unavoidable office tasks.Use mail merge to send personalized emails automatically to an entire list.Back up your Outlook file, export contacts and set up additional email accounts.Microsoft PowerPoint:Material was recorded using Microsoft PowerPoint 2019 but is relevant to PowerPoint 2010, 2013 and 2016. MAC users, since the videos are recorded with the Windows version of Microsoft PowerPoint, the interface will be a bit different.This Course Includes 3 SectionsMicrosoft PowerPoint 101 - Introductory LevelMicrosoft PowerPoint 102 - Intermediate/Advanced LevelMicrosoft PowerPoint 103 - Tips and TricksAt completion of this course you will have mastered the most popular and sought after Microsoft PowerPoint tools and come away with confidence to complete many PowerPoint tasks with efficiency and grace. Below are just a few of the topics you will master:Build and Deliver Effective PowerPoint PresentationsIntegrate Data from other Microsoft Office ApplicationsPick the Proper PowerPoint Slide Layouts for your ContentAnimate PowerPoint Content without Distracting the AudienceAutomate PowerPoint Formatting and Slide Layouts with Master Slidesand much, much more...So, what are you waiting for, enroll now and take the next step in mastering Microsoft office essential tools and go from Newb to Guru!What differentiates this course from other Courses?Yes, there are many Microsoft Office Courses out there teaching you the important functions and features you need to master. BUT, do you get step-step-step learning with of Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint with Quizzes, Exercises and VBA programming all in one course?So, what are you waiting for? Enroll Today and take the next step in mastering Excel, Word, Outlook, PowerPoint and VBA Programming. Boost your career and stand out from others in crowd. Go from Novice to Ninja in all this complete package of Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint, Macros & VBA! Become a certified Microsoft Office specialist and be a Excel, Word, Outlook, Powerpoint & VBA Ninja Today.The course comes with lifetime access. Buy now. Watch anytime.

Skills

Reviews