The Premium Microsoft Office & Data Apps Certification Bundle

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills! The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. This course will help you get the best out of Excel.

• Access 84 lectures & 6 hours of content 24/7
• Learn introductory topics such as the Excel interface, sheets, rows, columns & data types
• Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
• Format the sheet, numbers, rows, cells & more
• Sort, filter, & validate data
• Learn advanced functions such as VLOOKUPS, INDEX, MATCH, IF, & more
• Consolidate data with Power Query
• Speed up your work by recording and tweaking Macros

Microsoft’s PowerApps hasn’t gained the popularity it deserves, but it has the potential to be a gamechanger for companies. Without any coding knowledge, you can make your very own mobile apps that sync with Microsoft's tools. This course will walk you through the capabilities of PowerApps and focus particularly on SharePoint and Power Automate to automate lots of crucial everyday work tasks with PowerApps in developing some outstanding training on using this tool. There are some solid best practice guidance and more unconventional tips and strategies in getting the most out of it for, well, your team!

• Access 11 lectures & 1 hour of content 24/7
• Walk through the capabilities of PowerApps
• Create mobile apps
• Customize SharePoint list forms
• Work with templates & PowerAutomate

As the corporate world adopts more remote working practices, SharePoint's role as not just a document management tool but as a full collaboration tool is evolving. More than ever, SharePoint is playing a significant role in companies' success in managing their everyday work. Several of us experienced professionals at Earn and Excel collaborated and created an efficient and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs. This course introduces you to SharePoint and how it is important to day-to-day organization tasks.

• Access 32 lectures & 3 hours of content 24/7
• Understand why SharePoint is so important for the modern day organization
• Manage subsites & user permissions to add powerful controls
• Explore SharePoint apps, lists & libraries
• Work with SharePoint libraries to maximize document management capabilities
• List views & calendar for a visual interpretation of your team's assets
• Work with site pages to enhance & customize your SharePoint experience
• Sync with OneDrive to connect data sources
• Site columns & content types to further customize the management of your document assets

If you are working in a small company and you want to be able to manage your data, whether that be some sales data, expenses, marketing information, or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you. This course is created to teach you how to use Access to be a great end-user tool that you can get up and running quickly and give your database more advanced capability if you wish to.

• Access 36 lectures & 5 hours of content 24/7
• Learn the fundamentals of Access: tables, primary key & data types
• Query your database
• Create links between tables
• Create forms with & without the wizard
• Use the wizard to build a report or
• Export data to Excel, Word, or PDF
• Use buttons to carry out advanced functions, conditional outputs, & more

It's a misconception that you need to spend many hours learning Microsoft Project. This is a tool to help you schedule and manage projects. That's why this course was created: to get you up and to run and to work with best practices in a concise time frame. It will teach you how to get the most out of Microsoft Project. Your tutor, Martin, has many years of Project Management, Planning, PMO, and Scheduling in large global organizations and is ready to pass on to you what you really need to know to create and manage an efficient and effective project plan.

• Access 20 lectures & 2 hours of content 24/7
• Have great command of Microsoft Project
• Understand the ways of working with the tool that best set you up for success
• Set up the baseline for your project, track it & manage easily
• Know the 3 levels of project reporting
• Understand the importance of dependency relationships
• Use calendars to build a complete picture of schedule & delivery
• Create templates that can be reused on future projects

Paperless and productive — the two biggest benefits you will get from doing this course. OneNote lets you take your work with you, wherever you go, on any device. It syncs automatically, so you never have to worry about saving notes when you're on the go. Earn, and Excel brings you a course that will teach you everything you need to know about OneNote, and then some. You will be taught by the highly experienced corporate professional and trainer Claudia, who shares her many years of using Office in some of the biggest, most high profile global companies. By the end of this course, your notes will be highly organized, stored in one place, and easily accessed from any device.

• Access 58 lectures & 5 hours of content 24/7
• Get started with OneNote: introduction, quick access toolbar & inserting notes
• Copy cut text & split and merge containers
• Delete & insert time stamp
• Format text, apply styles & use format painter
• Add & organize sections
• Create subpages & section groups
• Work with different page versions
• Insert printouts & attachments

Earn and Excel brings you a comprehensive course from beginner to advanced to teach you everything you need to know about Outlook. There is so much more to Outlook than sending or receiving emails. This course will show you how to get Outlook's best use by organizing your calendar, syncing calendars, arranging meetings, setting and completing tasks, and maintaining contacts. You will learn how to organize your folders in ways that will ensure you never lose track of emails, meetings, or contacts. By the end of this course, you will be an expert at managing your emails, calendars, meetings, tasks, and contacts to an advanced level.

• Access 41 lectures & 4 hours of content 24/7
• Get comfortable with the Outlook environment & understand the Ribbon
• Create & format emails with ease
• Set up meetings, recurring meetings, & link them up in your calendar
• Understand the difference between Exchange, IMAP & POP email types
• Understand the different folders & how to set up your own folder structure to your preference
• Set rules to automatically store emails where your prefer
• Use conditional formatting & color coding
• Set up automatic replies when you are not available

Digital collaboration is the new normal in today’s world, and Microsoft has built the market-leading collaboration tool with Microsoft Teams. Earn and Excel worked with the Microsoft Certified and highly experienced Teams Consultant Henry Phillips to put together a masterclass training course to get the most from this incredible tool. Henry’s expertise in how companies can get the most out of Microsoft Teams means you don’t have to put yourself through an unnecessarily long course, and in under three hours, you will be able to get the most out of this tool for you and your company.

• Access 21 lectures & 3 hours of content 24/7
• Get a simplified overview of MS Teams as a whole
• Crreate & manage teams
• Understand conversations & notifications
• Work with channels & add apps to channels
• Use bots to your advantage
• Access & work with recordings and transcripts
• Work with files for collaboration on your documents
• Use SharePoint, OneDrive, OneNote, Wiki & Voicemails (exchange) with your channels

Highly experienced corporate professional and trainer Claudia Carrozzo brought her many years of using Office in some of the biggest, most high profile global companies. They created an incredible training course which will have you mastering PowerPoint in a few hours. From the very basics to eventually crafting creative slides and building persuasive pitch decks, this course will upskill your PowerPoint skills to the level of top management consultants that practice in the Big 4.

• Access 59 lectures & 6 hours of content 24/7
• Get started with Microsoft PowerPoint
• Work with shapes
• Use SmartArt, org chart, & arrow diagrams
• Works with guides, rulers, gridliens & formatting
• Utilize Excel & Word in PowerPoint
• Learn about logo slides, design ideas, spell check, add notes & more

Whether you need to map business processes, create floor layouts, build organization charts, create swimlane diagrams, or create any visual diagram, Visio is the industry standard for achieving this. This course teaches you how to truly capture the key skills you need to leverage this powerful diagramming tool. You will be taught by the highly experienced corporate professional and trainer Claudia Carrozzo, who shares her many years of using Office in some of the biggest, most high-profile global companies. You will learn the basics of Visio and then build on that knowledge lesson by lesson until you have mastered the art of diagramming.

• Access 75 lectures & 7 hours of content 24/7
• Insert & format text in Visio
• Understand & work with connectors
• Create sophisticated shapes
• Create flowcharts, org cahrts, swimlane diagrams & apply themes
• Organize pages, understand autosize & apply backgrounds
• Align & reposition shapes in charts & diagrams
• Work with containers & callouts

Building on from the basics, this course takes you through a much more advanced curriculum for Word users with more serious needs such as Legal resources, Office Managers, PA's, and Business Analysts among other professionals with advanced needs from Word.

• Access 41 lectures & 3 hours of content 24/7
• Use mail merge to automate document production
• Create Macros to speed up your work
• Explore captions, references, & legal citations
• Protect forms, compare documents, &Track changes
• Amend properties, password protection & digital signatures

Earn and Excel worked with the highly experienced corporate professional and trainer Claudia Carrozzo who brought her many years of using Office in some of the biggest, most high profile global companies and created an incredible training course which will have you working to an intermediate level with Word in a few hours.

• Access 83 lectures & 4 hours of content 24/7
• Be familiar with the quick access toolbar, Ribbon, & basic operations
• Get started with formatting, spell checking, & removing spaces
• Work with tables
• Use margins & alignments
• Know the best practices with text boxes
• Create shapes & objects
• Use styles to customize your documents

If you are regularly producing the same reports, doing the same data analysis, and another repetitive work week after week in Excel, then we will show you how to get off the hamster wheel of repetitive work so you can focus on adding real value to your company. This is the only Excel VBA and Macros course on the market purpose-built to teach Excel VBA and Macros skills to corporate professionals, including Analysts, Accountants, Controllers, PMO’s, Project Managers, Management Consultants, And Other Corporate Professionals.

• Access 40 lectures & 6 hours of content 24/7
• Get started with VBA & Macros
• Know the fundamentals of automation with loops & logic
• Automate cahrts, filters, & formulas to speed up your workflow
• Understand the 5 levels of looping
• Automate an entire weekly/monthly reporting process
• Automate slide packs production, documentation & manipulation

You will learn VBA and Macros with this unique experienced-based approach focusing on a handful of key themes. You will be effortless programming in a shockingly quick time frame. This course is so efficient that we don’t even allow you to learn unnecessary and confusing jargon. All other courses teach you first, so you get to experience some quick wins and find out exactly how amazing VBA/Macros can be!

• Access 14 lectures & 1 hour of content 24//7
• Understand the importance of VBA & Macros
• Control cells, ranges, copy & paste
• Control fonts & color cells
• Build logic with IF & Select case
• Get started with automation & looping
• Work with constants & variables

Data is growing at an alarming rate in many situations. Excel is becoming less of a viable option to deal with all of this data, so what do we do? Does it make sense to move to a database immediately? Well, that comes with a lot of commitment and a lot of cost in terms of implementation and maintenance. However, in the last decade, a powerful alternative has emerged, PowerPivot. This course takes you from beginner to advanced level with PowerPivot. It gives you technical advice on how to make the most of PowerPivot and practical advice on how to work with data.

• Access 58 lectures & 5 hours of content 24/7
• Get familiar with the Excel Data Model & learn fundamental Data Modelling concepts
• Load data into the Data Model from a variety of sources
• Use Pivot Tables in conjunction with PowerPivot
• Work with Iterator functions such as TOPN & REATEDTABLE
• Learn advanced data manipulation with the use Context & Filter functions

If you have been wasting vast amounts of time at work trying to gather, fix, and combine your Excel data before you’ve ever done any analysis and reporting, then this is the course for you. Power Query is the No.1 Excel feature added in the last decade because it can help you get data from various sources, no matter what format it is, and clean it all up for you with nothing more than a few clicks! This course teaches you how to get, transform, and refresh your data, after which it will be ready for quick analysis and report.

• Access 45 lectures & 5 hours of content 24/7
• Get data from various sources & clean it up
• Rapidly transpose, pivot & un-pivot your data to make it useful
• Quickly combine multiple data sets by appending & joining
• Speed up your data queries with duplication & tweaking parameters
• Troubleshoot your queries & set up auto refreshing of your data

This is a crash course on Pivot Tables to get you from complete beginner to advanced. It will start immediately by building Pivot Table. You'll learn how to get your data correct and briefly drive into Power Query. It will also teach you important features and tools on layout, formatting, filters, slicers, and more. Once you've gained great understanding, it will step up even more by teaching you advanced analysis.

• Access 46 lectures & 2 hours of content 24/7
• Quickly build your first pivot table
• Refine data by tweaking the layout
• Dig into running totals, grouping data, sorting, filtering & more
• Slice & dice your data with multiple filter techniques
• Connect multiple data sources & use calculated fields for deep analysis)
• Visualize your data
• Put your skills to the test & create a sales dashboard

This course takes you step-by-step from the very basics of setting up Publisher with personalizations and preferences through to designing and publishing a booklet. Along the way, you will learn how to maximize your efforts with tips and tricks to speed up your work. You will see how to create mail merges that can distribute your publications at the click of a button. Claudia will also show you how to find and personalize templates for business cards and much, much more.

• Access 46 lectures & 5 hours of content 24/7
• Personalize & set page options
• Insert pages, business info, & setting preferences
• Insert text boxes, columns & symbols
• Find & replace list and tab stops
• Master pages, spell check templates & mail merge