Excel Everest: Interactive, Comprehensive Excel Training Excel Everest is an entirely different way to learn Excel. No, really. The whole Excel Everest experience takes place inside a giant interactive Excel workbook (called Excel Everest) that brings users step-by-step through 41+ business-critical topics, 160+ interactive, auto-graded exercises, and there's a scoreboard to measure progress along the way. Oh, and what Excel training would be complete without a dancing bear? (click "the fun button" once you're in Excel Everest). If helpful, watch a video overview of Excel Everest. Who is Excel Everest for? Your orgnization or employees may be a fit for Excel Everest if: You need a comprehensive Excel training that covers all the essential business Excel skills, and with unlimited access and upgrades. You need a training that covers all of your versioning needs, on both Mac & PC, including for Excel 2003, 2007, 2010, 2011, 2016 You realize that the best way to learn a complicated program like Excel is not by watching videos, but by going through exercises right there in an Excel document. You'd like to use the same Excel training for your organization that companies like Google and Eventbrite use for their employees. You want accountability, and a way to measure not if someone has watched a video, but if someone has completed the skill right there in Excel. What is the concept behind Excel Everest? The entire concept behind Excel Everest is that you can learn by doing. As you go through this course, you'll be guided on how to download the Excel Everest workbook. When you open it up, you'll see an index page with a set of 21 buttons that link you to the various areas of the workbook. And in each topic area, you'll: Learn why a specific concept is important, especially for being successful in a corporation Grasp the details on the topic through written explanations Go through a set of interactive Excersies that are categorized according to difficulty (easy, medium, and hard) Best of all, as you complete these exercises, they're graded, so you can easily keep track of your progress through the course, see which topics you've made the most progress on, and earn badgeds for certain milestones. What are the outcomes you should expect? As a user, if you go through Excel Everest, you'll be able to go from knowing nothing (for those who need it, we cover the absolute basics), to a deep understanding of all of the business critical aspects of Excel. In no time, you'll have your colleagues asking you to teach them how to do a VLookup or set up a Pivot Table on their behalf. As a training manager, you'll finally have a training system that provides interactivity, accountability, and a bit of fun along the way. Even small Excel errors can cost organizations an enormous amount of time, and even worse, inaccurate data can get reported up the chain and used for key business decisions. If you have limited training dollars to spend, you should put them toward Excel. An error in PowerPoint or Word doesn't result in catestrophic business outcomes. Excel Everest will help train on what matters most.
In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2013. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review advanced calendar and task usage, rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data. Number of Videos: 34 Length: 110
This course is designed to familiarize users with the general navigation and functionality of OneNote 2013. Students will work with adding content to OneNote Notebooks, reviewing how to use OneNote collaboratively, using OneNote with other applications, and managing notebooks and their content. Number of Videos: 33 Length: 130
This course is designed to give an overview of Office 365 features, functionality, and navigation of the online environment. Microsoft Office 365 is a productivity suite that allows a user to access many of the Office tools and features online from any device with an Internet connection. It helps facilitate sharing and collaboration. Learn to sign into Office 365 from anywhere, and navigate the Office 365 environment. Learn to customize the environment to your specifications and download the Office apps to your mobile device. Number of Videos: 6 Length: 20
This course will instruct students on the new features that have rolled out in Microsoft Office 2016. Students will review the common changes across the suite of products such as Tell Me, ink equations, new chart types, version history, and themes and review individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access. Number of Videos: 27 Length: 80
Many of us work with Microsoft Office applications every day. When a new suite is released, we don't need training on the full programs. Often we only need a review of what is new, different, exciting, and how we can apply these new tools to our work. This course does just that; it reviews the changes in the Office 2013 applications: Word, Excel, PowerPoint, Access, and Outlook. It also reviews changes appearing across all applications that are not unique to one product. Number of Videos: 35 Length: 180
In this course, students will gain familiarity with the features and functionality of Yammer in Office 365. Students will overview the interface and features, navigate Yammer, edit a profile, work with and manage conversations, work with groups, and connect to an external network. Additionally, students will work with and manage messages, chat using Online Now, search Yammer, create polls, give praise, and make announcements. Number of Videos: 14 Length: 79
Video is an app included in Microsoft Office 365 which allows a user to upload, share, stream, and play videos. In this course, students will gain a comprehensive overview of Video, including how to navigate in the app and how to watch videos. They will also learn how to search for videos, as well as use channels as a way to organize and share videos. In addition, students will learn how to edit channel settings, share videos with others, and edit permissions in Office 365 Video. Number of Videos: 9 Length: 31
Teams is a chat-based workspace that keeps a team’s important communication and files in one place. It works with Office 365 and features threaded chats to help everyone converse and collaborate more effectively. Students will learn to create teams, add users, manage a team, start a team conversations, reply to a conversation, and add files. In addition, students will explore channels, create new channels, add favorites, create and share files, work with meetings, schedule team meetings, integrate with SharePoint, add tabs to keep files, notes and apps available, and connectors to access content and get updates. Number of Videos: 11 Length 51
Sway for Office 365 makes it easy to create and share interactive reports, personal stories, presentations, and more. In this course, learn to create a project, add text and media, customize your presentation, use stack and group cards, and share your presentation. Number of Videos: 11 Length: 40
This course is an introduction to Office 365 Sites. Upon completion of this course, users will have a basic understanding of Sharepoint Sites and Sites structure, navigation, libraries, searching, newsfeeds, views, permissions, and organization. Students will learn the differences of Libraries and Lists and how to create different kinds of Libraries and Lists, add files to Libraries, add items to Lists, learn to use the Newsfeed to keep abreast of action on the site, and create and customize Views. In addition, students will explore Site and content organization, understand navigation of sites, search for content, and learn the basics of Permissions. Number of Videos: 27 Length: 130
In this Office 365 course, students will gain familiarity with the features and functionality of Planner. Planner is a new addition to the Office 365 suite of productivity tools that makes it easy for a team to create new plans, organize and assign tasks, share files, chat, and get updates on progress. Students will take a tour of Planner, create new plans, use Boards and Buckets, create and assign tasks, add members, use notifications.
OneNote Online, part of the Office 365 suite of apps, is a is a free-form note-taking application for everything from basic notes to drawings, links, and embedded files. A OneNote notebook contains pages and sections, similar to a multi-subject notebook. All work is autosaved, and therefore there is no need to save in OneNote. Students learn to navigate and create notebooks and will work with adding content such as text, images, web content, tables, embedded objects, and more to OneNote Online notebooks. Additionally, students will learn to share and print OneNote Online notebooks. Number of Videos: 11 Length: 55
Delve is a new app included in Microsoft Office 365. In this course, students will gain a basic understanding of the purpose, features, functionality, and navigation in Delve. Students will work with Content Cards, explore the various views, use Boards, search, and share documents in Delve. Number of Videos: 8 Length 40
This course shows students how to use the Microsoft powerful, all-in-one communication tool: Lync 2013. Over the course of this video, students will understand how to use the interface, manage contacts, and set important defaults. Additional time will be spent learning how to communicate via instant message, email, audio or video calls, and live online meetings. Students will also learn more about Lync's seamless integration with Microsoft Office. Number of Videos: 31 Length: 97
This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. Number of Videos: 75 Length: 241
Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Number of Videos: 67 Length: 226
This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, studentswill experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form.
This course is designed to be the intermediate level of Excel 2013. Students will learn intermediate functions and formulas, introduced to and work with PivotTables and Tables, work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. Number of Videos: 78 Length: 258