Description

Microsoft Office Suite 2016 for beginners and intermediates.This course covers wide range of topics such as Microsoft Word, Excel, Powerpoint , Access 2016 all in one place.I will promise to keep updating the course every 6 months and post bonus lectures of VBA usage with these tools based on the response.Excel:Master Microsoft Excel from Beginner to AdvancedBuild a solid understanding on the Basics of Microsoft ExcelLearn the most common Excel functions used in the OfficeMaintain large sets of Excel data in a list or tableCreate dynamic reports by mastering one of the most popular tools, PivotTablesWord:You will learn how to take full advantage of Microsoft WordBegin with the basics of creating Microsoft Word documentsVarious techniques to create dynamic layoutsPreparing documents for printing and exportingFormat documents effectively using Microsoft Word StylesControl page formatting and flow with sections and page breaksCreate and Manage Table LayoutsWork with Tab Stops to Align Content ProperlyPerform Mail Merges to create Mailing Labels and Form LettersBuild and Deliver Word FormsManage TemplatesTrack and Accept/Reject Changes to a DocumentPPT:Create a fully-animated and transition-filled business presentationRapidly improve your workflow and design skillsMinimize text quantity on presentations by using graphs and imagesWork comfortably with PowerPoint and many of its advanced featuresBecome one of the top PowerPoint users in your teamCarrying out regular tasks faster than everCreate sophisticated and well-organized PowerPoint presentationsFeel more confident when delivering presentations to superiorsMake an impression at work and achieve your professional goalsAccess:Understand how Access is constructed and how to use the major objects within it.Be confident in moving around within Access and be able to build effective database solutions for their unique data needs.What you’ll learnUnderstand the basics of Access tables, queries, forms and reports.Know how to structure tables being imported from Excel.Know how to create powerful queries and use them to create and modify tables.Understand how reports work and how to base them on tables or queries.Know how to create forms and subforms.