Excel Mastery vs Excel formulas

Learn Excel the way it sticks, and build skills that count at work. Short video lessons are followed by summaries, quizzes and flashcards, so every skill is locked in before you move on. Go from your first spreadsheet to PivotTables and dashboards on a clear, step-by-step path. At your own pace. No monthly fee. No traveling. MORE THAN A LIST OF VIDEOS Excel Mastery is a complete course. Every section ends with a summary, a quiz to check your understanding and flashcards to review the key ideas. You always know what you've learned and what comes next. FOUR COMPLETE COURSES • Excel Beginner: navigation, entering and formatting data, basic formulas and the essential skills every user needs. • Excel Intermediate: tables, functions such as VLOOKUP, INDEX/MATCH and XLOOKUP, data validation, and working faster with real-world spreadsheets. • Excel Advanced: database-style functions (DSUM, DAVERAGE, SUBTOTAL), data analysis, security and protection, and advanced techniques. • NEW! Excel PivotTables: From Basics to Power Pivot: build PivotTables, group and filter data, add PivotCharts and Slicers, create dashboards and get started with Power Pivot. LEARNING TOOLS IN EVERY COURSE • Video lessons: bite-sized, focused and easy to follow • Summaries: the key points of each section at a glance • Quizzes: check your understanding and see your score • Flashcards: review formulas, terms and shortcuts anytime • Tips & Tricks decks: time-saving tricks the pros use • Final project: put your skills together on a real task MADE FOR IPHONE DUO On iPhone Duo, lessons fill the large inner screen in portrait or landscape. Fold the phone halfway, stand it up like a small laptop, and the video plays on the upper screen while the lesson text sits on the lower one, so you can watch and follow along side by side. WORKS WITH YOUR VERSION OF EXCEL The core skills apply to Excel 2016, 2019, 2021 and Microsoft 365. Where features differ between versions, a dedicated notes lesson explains what changes, so you can follow along on the version you have. MORE FEATURES • Track your progress and performance with detailed statistics • Interactive cheat sheets for keyboard shortcuts • App interface in 7 languages: English, Chinese, Spanish, Japanese, French, German and Korean • Learn anytime, anywhere: on your commute, at lunch or at home WHO IT'S FOR Students, job seekers, office workers, career changers and small business owners. Anyone who wants to work faster and feel more confident with spreadsheets, from complete beginners to experienced users ready to master PivotTables. FREE TO START, PAY ONCE Unlock all courses, lessons, quizzes and flashcards with a one-time Premium purchase. No subscription, no monthly fee. Microsoft and Excel are trademarks of the Microsoft group of companies. This app is not affiliated with or endorsed by Microsoft.

Move from reading a function to understanding how its inputs affect a result. Excel formulas combines illustrated spreadsheet lessons, an editable formula playground and a chart workspace with tools that help you return to your studies. A reference you can explore at your own pace Start with logical, text or mathematical functions, or follow topics such as dates, lookups and statistical summaries. Fourteen function families also include financial, database, engineering, information, compatibility, cube, web and add-in lessons. Browse a category or search by a function name, a use case or an interview question. Each formula lesson presents an explanation and syntax with examples. Previous and Next controls let you move through a topic without returning to the list. Save a formula for later and mark a lesson complete when you have reviewed it. The reference topics explain spreadsheet functionality; they do not imply that every function can run inside the practice grid. Learn by changing the inputs Use Formula Playground to edit values in a small worksheet and enter a supported expression. Its result display responds as the formula or grid changes, making it easier to compare the calculation with the example you are reading. Where a lesson offers Try It, open the selected example with its formula and sample data already prepared. The quick input toolbar provides formula symbols for mobile typing. Practice with conditions, totals, averages and cell ranges, then use the lesson to check what each argument means. The playground implements a selection of functions and serves as a focused learning workspace. Create a visual from your data Enter labels and numeric series in the chart worksheet, adjust its rows and columns and give the chart a title. Select from column, bar, line, area, pie, doughnut, scatter and radar styles. The preview shows both the chart and the source data table, so you can review what you entered before exporting. Save the chart as a PNG image, create a PDF or share an image using your device's sharing options. Keep an illustration from a study exercise or share a comparison with another learner. Keep track of what you study Home brings together a daily formula, saved lessons and recently viewed items. Continue learning returns you to the formula you were studying. Marking lessons complete updates category progress and the beginner, intermediate and advanced paths in the Learning Hub. The daily formula also contributes to a learning streak and a 30-day challenge. Enable the optional daily reminder if you would like a prompt to study, subject to notification permission. Favorites and progress are kept locally on your device, letting the app remember your learning activity between sessions. More ways to review Use keyboard shortcut references, practical tips and interview questions with answers to support your preparation. Timed quizzes offer Bronze, Silver, Gold and Diamond levels, results and attempt history. Reach the required score for a level to unlock an in-app certificate that can be saved or shared. These certificates record app practice and are not professional accreditation. Choose a light, dark or system theme. Designed for students, independent learners and people revising spreadsheet skills for work, the app supports both quick reference visits and longer practice sessions. It contains advertising. Excel formulas is independently developed and is not affiliated with or endorsed by Microsoft.