Description
**This course includes practice exercises and LIFETIME access**Learn Excel, PowerPoint, Access, Outlook, Teams, OneNote, and Word with this tremendous value 9-course bundle from Simon Sez IT. The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity. But you know all that because you're on this page. Instead, you're probably wondering whether we're the right team to teach you Office. Simon Sez IT has been teaching MS Office for over 13 years, and we've got pretty good at it. Just take a look at our Udemy ratings if you don't believe us. For this Ultimate Microsoft Office 2019 course, we've bundled together 9 of our best-selling titles into one huge value offering. You don't just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Microsoft Word, and Microsoft OneNote.***UPDATED APRIL 2020 - Outlook 2019 Added******UPDATED May 2020 - Microsoft Teams Added******UPDATED 2021 - Microsoft OneNote Added**What's covered in each course?Microsoft Excel 2019What's new in Excel 2019Creating 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 Microsoft Excel 2019What's new/different in Excel 2019Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e. g. MS Access and the web. How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek, and SolverAdvanced charts such as Surface, Radar, Bubble, and Stock ChartsMicrosoft PowerPoint 2019How 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 between slidesAnimation, the animation pane, and motion pathsSetting your slideshow optionsPresentation preparation and deliveryThe backstage area of PowerPoint including printing a presentationMicrosoft Word 2019How to get started with Word 2019Word 2019 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 Access 2019Where to start in Microsoft Access and whether to use a template or notHow to modify Access to suit your needsAll 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 AccessAdvanced Microsoft Access 2019About Primary Keys and Indexes in AccessAbout customizing and filtering on the Datasheet ViewHow to link to other databasesAll about using ODBC and SQL ServerHow to split an Access database into front and back-endAll about Macros in Access including AutoExecHow to do basic VBA in Access including code and error handlingMore advanced techniques around creating forms in AccessAdvanced queries including "multiple where" criteriaMicrosoft Outlook 2019How to get set up in OutlookSome useful Outlook keyboard shortcutsAll about sending and receiving emailsHow to customize your mailbox and viewHow to search in OutlookHow to organize and manage your mail including ignoring, flagging, and conditional formattingHow to effectively deal with Junk MailAttaching files, photos, and graphics in OutlookAbout recalling a messageHow to use signatures and voting buttonsHow to best use, add to, and manage contactsWorking with the Outlook Calendar, including creating meetings and appointmentsHow to share Calendars with colleaguesHow to use Tasks in OutlookHow to create Notes and link Outlook to OneNoteHow to print the right thing in OutlookMicrosoft TeamsHow to access, download and set up 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 functionHow to create a wikiAll about using apps, bots, and connectorsHow to adjust admin and user settingsHow to use Teams on your mobile deviceMicrosoft OneNoteHow to get started using OneNote Desktop or OneNote Windows 10How to add text, videos, images, clips, and links to OneNoteHow to use the screen clipping tool in OneNoteHow to format notes in OneNoteHow to create a to-do list in OneNoteHow to add tags in OneNote and search for contentHow to link notes in OneNoteHow to format pages in OneNoteHow to use the pen tools in OneNote, including handwriting to textHow to link OneNote with OutlookHow to share notebooks in OneNoteHow to collaborate using OneNoteHow to customize your options in OneNoteAbout using OneNote Online and the OneNote App***Exercise and demo files included***This bundle includes:68+ hours of video tutorials600+ individual video lecturesExercise files to practice what you learnedCertificate of completionNINE full-length Microsoft coursesThese courses were all recorded in the 2019 versions of MS Office but are still applicable if you're working with Office 2013, 2016, or Office 365. Microsoft Teams and Microsoft OneNote were recorded using Office 365. Here's what our students are saying…I'm finding this course very helpful and the instructor is very easy to understand. I am learning so much more than I did from another course I tried to take and lost interest in. This course has really kept my interest.- Dianne MunizzaLoving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time..- Monica Yvette DisbrowIt's still early on in the course, but I love it. He's so very clear with each tiny thing he's teaching you. He sounds quite like a gentle and patient friend or mentor walking you through step by step. He also repeats things (not monotonously) which helps you retain what you're learning. When I first registered for this course, I thought 'oh my goodness, what have I done'. when you look at the 'your progress' dropdown at the upper right corner of your dashboard and see that you're on #21 of 518(!), it can seem a bit intimidating. But, no - I think with this particular instructor's gift of friendly teaching, we'll all do fantastically well!- Celine Barton
