Ultimate Microsoft Office; Excel, Word, PowerPoint & Access (Udemy.com)
Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019
Created by: Simon Sez IT
Produced in 2021
What you will learn
- Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access
- HUGE Value Bundle - Eight Courses!
- Learn practical methods to backup and recover your Excel spreadsheets and never lose data
- Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
- Discover the essentials of using formulas and functions in Excel
- Discover how to create stunning charts and graphs in Excel
- Learn practical methods to sort and filter your data in Excel
- Discover new features in PowerPoint 2019 including Icons and 3D Models
- Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
- Add charts, graphs and tables to your PowerPoint presentation information in a non-text format
- Wow your audience by adding animations, audio and video to PowerPoint
- Discover practical tips to present your PowerPoint presentation to your
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 90 / 100
Course Description
**This course includes practice exercises and LIFETIME access**Learn Excel, PowerPoint, Access, Outlook, Teams, and Word 2019 with this tremendous value 7-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 youre on this page.
Instead, youre probably wondering whether were the right team to teach you Office.
Simon Sez IT has been teaching MS Office for over ten years, and weve got pretty good at it. Just take a look at our Udemy ratings if you dont believe us.
For this Ultimate Microsoft Office 2019 course, weve bundled together 8 of our best-selling titles into one huge value offering.
You dont 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, and Microsoft Word.***UPDATEDAPRIL 2021 - Outlook 2019 Added******UPDATEDMay 2021 - Microsoft Teams 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 device***Exercise and demo files included***This bundle includes:
63+ hours of video tutorials480+ individual video lecturesExercise files to practice what you learnedCertificate of completionEIGHT full-length Microsoft coursesThese courses were all recorded in the 2019 versions of MS Office but are still applicable if youre working with Office 2013, 2016, or Office 365. Microsoft Teams was recorded using Office 365.
Heres 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 Munizza"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."- Monica Yvette Disbrow"It'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 Ba
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 youre on this page.
Instead, youre probably wondering whether were the right team to teach you Office.
Simon Sez IT has been teaching MS Office for over ten years, and weve got pretty good at it. Just take a look at our Udemy ratings if you dont believe us.
For this Ultimate Microsoft Office 2019 course, weve bundled together 8 of our best-selling titles into one huge value offering.
You dont 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, and Microsoft Word.***UPDATEDAPRIL 2021 - Outlook 2019 Added******UPDATEDMay 2021 - Microsoft Teams 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 device***Exercise and demo files included***This bundle includes:
63+ hours of video tutorials480+ individual video lecturesExercise files to practice what you learnedCertificate of completionEIGHT full-length Microsoft coursesThese courses were all recorded in the 2019 versions of MS Office but are still applicable if youre working with Office 2013, 2016, or Office 365. Microsoft Teams was recorded using Office 365.
Heres 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 Munizza"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."- Monica Yvette Disbrow"It'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 Ba
Instructor Details
- 4.5 Rating
224 Reviews
Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.
More courses by Simon Sez IT
The Ultimate QuickBooks Pro Training Bundle - 60+ Hours (2021)
4.4 (310 Reviews)
Provider: Udemy
Time: 61h
$11.99
The Ultimate Microsoft Office 2016 Training Bundle (2021)
4.5 (289 Reviews)
- Provider: Udemy
- Time: 62.5h
$11.99
QuickBooks Pro 2017 Training: Manage Small Business Finances (2018)
4.6 (216 Reviews)
- Provider: Udemy
- Time: 7.5h
$11.99
Learn Microsoft Windows 10 the Easy Way for Beginners (2021)
4.4 (206 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
Ultimate Microsoft Project 2016 Course - Beginner to Expert (2021)
4.5 (199 Reviews)
- Provider: Udemy
- Time: 19h
$11.99
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
60h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
