Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Office 365. Excel expert Curt Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; create and filter PivotTables; and share your spreadsheets with others.

Looking to master all the formulas and functions available in Excel for Mac? In this comprehensive course, Dennis Taylor presents numerous Excel formulas and functions and shows how to use them efficiently. Dennis begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. He then covers how to perform logical tests with the IF, AND, OR, and NOT functions, search and retrieve data with lookup functions (VLOOKUP, XLOOKUP, MATCH, and INDEX), analyze data with statistical functions, use text functions to clean up worksheets, work with array formulas and functions, and master date and time calculations. If you’re looking to up your formulas and functions skills in Excel, join Dennis as he uses practical examples that transition effortlessly to real-world scenarios.

Excel for the web offers many powerful features, but because its interface differs from the interface of the desktop tool, most users only use its basic spreadsheet functionality. In this course, instructor Joshua Rischin shows you how to get more out of Excel for the web. Joshua explains some basics of data, including how to cleanse data and use Flash Fill to add data quickly. He gives several useful tips for using custom formatting, hyperlinks, and conditional formatting in Excel for the web. Joshua goes over how to customize your workbooks, as well as create Pivot Tables and Pivot Charts. He covers ways to collaborate, while still protecting your work, and discusses how to use Excel Desktop to get even more from your Excel for the web experience. He steps you through some advanced features, like Excel Ideas and scripts, then concludes with advice on how to apply what you’ve learned from the course.

Excel is the most widely used data analysis software on the market, but many people in business are not using it to its full potential. Excel can be a great tool for building financial and operational models, allowing users to understand what may happen in the future and how the business can position itself. In this course, learn how to build effective and useful financial models in Excel to forecast sales and costs, profits, operational KPIs, business assets and liabilities, and much more. Instructor Michael McDonald covers rules and best practices for financial modeling and then shows how to set up single-sheet and multi-sheet financial models and add inputs and assumptions, external data, projections, and more. Plus, learn how to determine the accuracy and strength of your models and keep them up to date as the data evolves. By the end of this course, you will have the tools and tricks you need to become a master of Excel modeling for businesses ranging from restaurants and manufacturing firms to banks and software companies.

The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time.

Did you know you can record and run Solver macros, generate random inputs, run multiple simulations, and more, in Excel? Moreover, you can do all this without buying expensive specialty software. In this course, instructor Curt Frye shows how to enhance your supply chain analysis using the Solver add-in in combination with VBA. Working from an example transportation problem, Curt steps through creating a reference to the Solver VBA library, recording and running a Solver macro, generating random inputs, and defining a loop structure to run multiple simulations. Then he moves on to enabling detailed analysis by writing model output, creating a results dashboard to analyze your model output, exploring alternative scenarios with a Solver model, and more.

Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.

Conditional formatting sounds more complicated than it is. This powerful tool in Microsoft Excel allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this short course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Learn how to use all the rules and options, such as data bars and icon sets, and apply conditional formatting across many rows of data.

Excel macros allow you to automate routine tasks. Although working with macros involves the Visual Basic for Applications (VBA) programming language, you don’t need to be a programmer to use it. In this course, Excel guru and Microsoft content developer Chris "Smitty" Smith provides a quick introduction to macros and VBA. He walks through the steps of recording a basic macro, then demonstrates how to edit macros, including testing and adjusting, and making recorded macros dynamic. Learn how to do more with Excel using macros.

If even a small part of your job entails using Microsoft Excel, there’s a good chance that at some point you’ve received a spreadsheet where the data is unorganized, disconnected, or generally not in great shape. And despite common practice, a long, heavy sigh is not officially part of any recommended Excel workflow. Rather than pull your hair out at the mess of data you see before you, you can use Power Query in Excel to help you import and clean data into something easier to work with. In this course, Excel expert Dave Ludwig takes you through the robust features set of Power Query. Dave shows you how to use Power Query to connect to your data source, filter data, and create conditional columns of data. He also shows off the significant cleansing capabilities of Power Query. Once your data is cleaned up, you can more easily create formulas, PivotTables, charts, and generally get on with your business.

Creating accurate and reliable sales forecasts is essential for any sales leader. Professor Michael McDonald shows how to use Excel to forecast sales more effectively, beginning with a quick primer on sales forecasting, then explaining the business intelligence used in forecasting and the basics of regression analysis. Next, Michael shows how to use Excel to gather the necessary data for your forecast, how to cleanse data so that it will lead to more accurate forecasts, and how to interpret and explain the results of a regression forecast. The course concludes with a sample project, forecasting sales for a fictional restaurant. In this sample project, you’ll construct a data set, compute a simple set of forecast metrics, and construct an in-depth sales forecast. Finally, Michael explains the limitations of sales forecasting and how you can mitigate risk.

You probably already know many ways to exert influence. Methods like reason, authority, and scarcity are often effective ways to get people to do what you want. But the best leaders go beyond regular influence, in who, how, when, and why they influence, and how they extend their influence. In this course, John Ullmen details the concept of executive influence. While regular influence centers around using tactics to get tasks done, executive influence adds to that, energizing people to create possibilities for the next task and beyond. As John explains, the more chaotic and dynamic your leadership challenges become, the more you need executive influence to succeed. John shares his executive influence roadmap, using real-world examples from exceptional leaders he’s coached, and details tools you can use to generate better outcomes and multiply your positive influence when regular influence techniques are not enough.

Are you interested in pivoting into a career in healthcare? Instructor Christine Alexander introduces ten high-demand, entry-level jobs in healthcare and allied healthcare that can take less than a year of training. Christine walks you through a typical “day in the life” of an emergency medical technician, licensed vocational nurse, medical assistant, certified nursing assistant, personal care assistant, medical biller and coder, dental assistant, pharmacy technician, dietary technician, and veterinary technician. She identifies job duties, personality characteristics that are needed, the pros and cons, training required, salaries and career trajectories, and other resources to help you decide if one of these jobs might be right for you. All of these jobs can be great stepping-stones leading to advancement in the healthcare industry.

Are you a homeowner or a small business owner with a wireless network problem to solve? In this course, instructor Jess Stratton walks you through identifying and solving a variety of problems. Jess shows you how to take inventory with a network map, so that you know every computer and device connected to your network. She explains how different devices connect and how to set devices to the correct Wi-Fi channel frequencies. Jess describes how one old Wi-Fi device can slow down your network and presents some options for dealing with them. She steps through how to conduct an active site survey and optimize your router connections, including how to identify dead spots in your home or office. After going over some options for extending your network’s signal, Jess concludes with a discussion of how you can identify if your network problems have been solved.

How good are you at staying focused? From top athletes to famous musicians, from movie stars to successful entrepreneurs, a common trait is a laser-sharp focus. In this course, focus expert Bill Williams shows you how to drive a high level of focus across your entire life. He demonstrates ways to improve your focus by controlling your environment and identifying your distraction patterns. Bill also points out the barriers to focus and how you can overcome them, how to prepare yourself for high performance, and how to develop better focus habits.

This course was created by Madecraft. We are pleased to host this training in our library.

By utilizing social media platforms like Facebook, you can increase brand visibility and take advantage of free features to communicate and advertise your photography, design, or videos. In this course, instructor Richard Harrington shows you how to succeed as a creative professional using the Facebook platform. Richard explains the evolution of the platform and describes how to find new connections, create events, and decide what and when to post. He also covers creating a company page distinct from your personal profile and using Facebook groups and messaging to manage client projects.

In some areas of the world, the pandemic is starting to get under control and companies are contemplating a return to the workplace. The ability to do so safely is dependent on many factors: the existing physical space, work functions, and local attitudes and expectations. Facility managers need to assess the new normal and develop strategies for changes to the built environment. This course with Jim Rogers—a recognized leader in the fields of construction management and occupational safety and health—provides practical strategies for evaluating your current systems and spaces, making changes, and managing ongoing health and safety issues. Learn how to deal with reduced room capacity, alter conference rooms, make improvements to your HVAC system, and more. With these guidelines, you can ensure your company is making the workplace as safe and secure as possible for your employees.

COVID-19 has drastically altered the way we move through familiar spaces. As more people start returning to work and school, facilities management teams must grapple with a number of complicated decisions. In this course, instructor Shaun Bryant prepares you to face those challenges head-on, explaining how to change the way people enter buildings, proper placement and distribution of hygiene stations, directional flow, and the creation of Neutral Zones (NZs). Shaun shows you how to change the layout of workplaces and classrooms to allow for social distancing. He also points out the impact of working from home, seating in public spaces, and other alternative methods of working.

Brainstorm better with FigJam. Learn about the new whiteboard collaboration tool for user experience and design thinking projects. This short introductory course explores the FigJam collaborative workflow and deep integration with Figma, which allows Figma designers and non-designer stakeholders to easily share ideas. Discover how to set up accounts, manage teams, create and edit files, collaborate with teammates, and integrate Figma content in a FigJam file.