A to Z Microsoft Office Bundle

Organizations have long depended on business intelligence to make more informed decisions. Once upon a time, enterprise BI tools were expensive, overly technical, and designed specifically for IT specialists. Today, however, Microsoft Power BI offers users true self-service BI, enabling users to interact with corporate information and extract the reports and intel they need without extensive technical expertise. In this course, you’ll get an intro to Microsoft Power BI so you can add this powerful platform to your resume and raise your earning potential.

• Access 8 sections & 7.5 hours of content 24/7
• Learn how to create compelling visualizations & reports which provide deep insights into your data
• Become confident in the three main components of Power BI: Desktop, Service, & Mobile Apps
• Connect to a wide variety of data sources using Power BI Desktop & BI Service
• Use the Query Editor to transform & morph data into the right format for your reporting purposes
• Perform complex data modeling operations using relationships, calculated columns, measures, & DAX expressions

In this course, you’ll learn how to use VBA programming to automate the distribution of Excel files by sending them as email attachments. By running a single macro, you’ll update five reports in Excel, then save and email the Excel file to as many email addresses as you have in your list. In seconds. This incredible time-saving method will completely streamline the way you organize and distribute information. You don’t have to know anything more than the bare basics of Access and Excel to leverage this trick.

• Access 8 sections & 3 hours of content 24/7
• Learn the benefits of VBA without working through a huge course
• Update a link from Access to Excel using VBA, save as an Excel file & email as an attachment using Outlook
• Distribute Excel reports by email in seconds

Although we’re surrounded by data, few people are familiar with Microsoft Access, one of the best tools for managing large data sets. This course is dedicated to the basics of how Access is constructed and why the structure makes sense. By the time you’ve finished the first part of this course, you’ll understand how to use Access and be ready to advance to more complex topics in the further sections. Ultimately, you’ll have a firm grasp of how to use Access to manage enormous amounts of data.

• Access 8 sections & 7.5 hours of content 24/7
• Understand the structure of the database file & its advantages
• Learn how you can save all your data in one place & how to extract only the info you want
• Discover how having separate report formats reduces report prep time
• Create subtotals & do calculations
• See how you can link data back to Excel sheets for distribution
• View demonstrations of how Macros can be used to automate tasks

PowerPoint and Excel are two of the most widely used programs in offices around the world but when you can use them together, you can create truly stunning, automated and data-driven presentations that will help you climb the career ladder. In this course, you’ll learn to master each and discover how to integrate them together to help you reach your full potential.

• Access 8 sections & 7 hours of content 24/7
• Learn how to design PowerPoint decks that will wow your audience
• Create stunning charts & tables that can be seamlessly integrated into your presentations
• Discover what tools & tricks Management Consultants use to create mind-blowing, data-driven presentations

Want to create better slideshows with PowerPoint? Here’s your one-stop shop to making it happen! In this hands-on course, you’ll discover how to get the most out of PowerPoint so you can deliver presentations that make an impact.

• Access 8 sections & 4 hours of content 24/7
• Get a PowerPoint & iMovie overview
• Add photos, text, music, shapes & more to projects
• Animate layers
• Create slideshows w/ online slideshow makers

Designed for absolute Microsoft Word beginners, this course will take you through real-world documents like formal business letters, monthly newsletters, business reports, and more to give you the hang of Word. This software is absolutely essential in today’s business environments so this course is a simple way to get prepared. Beginning with the basics, you’ll soon ramp up into the program’s newest, most advanced features.

• Access 8 sections & 3.5 hours of content 24/7
• Create a formal business letter, monthly company newsletter, business form, & more
• Format a long business report, adding charts & graphs from Excel
• Create a product overview PDF w/ basic interactivity
• Print personalized letterheads & envelopes for client lists

This master class is designed for professionals who want to learn the advanced ins and outs of the world’s leading spreadsheet software, Microsoft Excel. This day and age, if you don’t know Excel well, you’re bound to get left behind. If you know it expertly, then you can seriously thrive.

• Access 8 sections & 4 hours of content 24/7
• Boost your productivity & skills for work or personal use
• Cover Vlookup, PivotTable, & Macros

Today, everyone in the workforce should have at least a basic understanding of Microsoft Excel. Doesn’t describe you? Well, then this beginner-friendly course is here to help you out. You’ll start with the basics of Excel and slowly work your way up to more advanced concepts.

• Access 8 sections & 2 hours of content 24/7
• Discuss ribbons & features
• Perform simple math operations & common math functions
• Work w/ large data functions
• Explore graphing & data
• Understand formatting & types of graphs
• Discuss sample applications of Excel