Description
**This course includes 10 hours of on-demand video lectures, practice exercises and LIFETIME access**Learn Excel, PowerPoint, Access, Word, Teams, and Publisher 365 in one courseThe Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity. This course is designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of Microsoft Office. Microsoft Word 365How to get started with Word 365Word 365 basics including navigation, editing and savingCharacter formatting in Word including Format Painter and AutoCorrectHow to properly work with bullets and numbering in Microsoft WordAll about formatting paragraphs and managing listsWorking with Tables in Word including formatting, converting data and formulasPage appearance including page-breaks, watermarks and stylesAll about Sectioning a documentInserting graphics, pictures, shapes, icons and 3d models (new for 2019)How to work with envelopes and labelsAll about mail-merge and operating Word at scaleHow to create an Index or Contents pageReviewing and Printing in Word and Page SetupProtecting a Word document and basic macros in WordMicrosoft Excel 365Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns, and cellsCut, Copy and PasteIntroduction to Functions and FormulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basicsAdvanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsStatistical functionsConnecting to other workbooks and datasets outside of Excel e. g. MS Access and the web. Mastery of PivotTables and Pivot ChartsAdvanced charts such as Surface, Radar, Bubble and Stock ChartsMicrosoft Access 365All about importing data and the datasheet viewHow tables work in Access and how to create relationships between themCreating forms and sub-forms that feed data into your tablesHow to run queries in AccessSetting up validations and calculations using expressions in AccessPrinting from AccessTo start to use macros and Modal DialogThe basics of the Access web appExporting and reporting in AccessAbout Primary Keys and Indexes in AccessAbout customizing and filtering on the Datasheet ViewHow to link to other databasesAll about Macros in Access More advanced techniques around creating forms in AccessAdvanced queriesGenerating reportsMicrosoft PowerPoint 365How to navigate around PowerPointPresentation dos and don'tsText and bullet edition optionsHow to use graphics, images, objects and shapesUsing SmartArtWorking with Charts and GraphsHow to utilize Master Slides and just how much time this could save youHow to add audio and video to a presentationAll about transitions & animations between slidesSetting your slideshow optionsPresentation preparation and deliveryThe backstage area of PowerPoint including printing a presentationMicrosoft Publisher 365How to create and use event templateCustomizing templateText and bullet edition optionsHow to use graphics, images, objects and shapesAdding color schemes Microsoft TeamsHow to create your first team and manage members and channelsAll about posting and receiving public and private messagesHow to do user announcements, tags, and message extensionsHow to schedule an audio or video callHow to use the audio and video calling options including recording callsHow to use the meeting notes functionAll about using built-in appsHow to adjust admin and user settings
