Tutorial for MS Excel vs Excel formulas

Learn Excel step by step, from your first formula to PivotTables, dashboards, budgets and tax records. For beginners and anyone who wants to work faster. Tutorial for MS Excel is a complete, up-to-date course for Microsoft Excel on Windows and Mac, including the Microsoft 365 features. 58 clear lessons explain each skill in short pages with real screenshots and sample data, then let you check what you learned with a quiz and a hands-on practice task. Step-by-step courses then take you from an empty sheet to a real, working workbook. WHAT YOU WILL LEARN • Getting started: the ribbon, workbooks, entering data, rows and columns, worksheets, AutoFill and Flash Fill • Formatting: fonts and borders, alignment, number formats, conditional formatting, styles and themes • Formulas and functions: references, SUM to SUMIFS, IF and IFS, XLOOKUP, VLOOKUP and INDEX/MATCH, text, dates, named ranges, fixing errors • Working with data: sorting, filtering, Tables, drop-down lists, cleaning data, freeze panes, subtotals • Charts and analysis: charts, sparklines, PivotTables, slicers, Goal Seek and data tables • Printing and sharing: page layout, PDF, co-authoring, comments, protecting sheets • Microsoft 365: FILTER, SORT and UNIQUE, LET and LAMBDA, TEXTSPLIT, Power Query, Copilot, checkboxes and pictures in cells • Guided projects: a monthly budget, invoice, gradebook, task tracker, loan calculator and sales report COURSES: BUILD A REAL WORKBOOK, START TO FINISH • Build a Home Budget: one transactions Table, budget vs actual, a year view with charts and a savings tracker • Bookkeeping for a Small Business: ledger, invoice register, profit and loss, cash flow and a year-end page • Keep Track of Your Taxes: income, claims with receipts, VAT, a tax estimate, deadlines and a year-end page, for your own country's tax year • Build a Sales Dashboard: number cards, PivotCharts, filters and targets on one screen, ready to send as a PDF • Plan Projects with a Gantt Chart: a task Table, a self-drawing Gantt chart, status labels and owner roll-ups • Track Stock and Inventory: live counts and value, alerts, supplier orders and monthly reports • Timesheets and Pay: a protected shift log, weekly overtime and pay, and a printable timesheet • Make a Teacher's Gradebook: weighted grades, letters, at-risk flags, student reports and attendance • Clean Up Messy Data: from a bad export to a validated list, with a repeatable Power Query cleanup Every course has a free first chapter, a checklist at the end of each chapter and a final quiz. FUNCTION REFERENCE • 465 functions in 12 categories, each with syntax, arguments and worked examples • Search by name or by what you want to do FEATURES • Steps for both Windows and Mac, with Mac differences called out • Real screenshots you can open full screen and zoom • A quiz and a practice checklist in every lesson • 128 keyboard shortcuts for Windows and Mac, with examples and flash-card practice • Search every lesson, function and shortcut • Bookmarks, saved pages and progress tracking • Light and dark mode, adjustable text size ONE-TIME PURCHASES, NO SUBSCRIPTION • Free: 36 lessons, the full function reference, all 128 shortcuts and the first chapter of every course • All Lessons: every lesson and guided project, plus shortcut practice • Each course: unlock one course • Everything: all lessons and every course, including courses added later Any purchase removes ads. Already bought Pro in an earlier version? Tap Restore Purchase to get Everything at no extra cost. This is an independent learning app. It is not affiliated with, endorsed by or sponsored by Microsoft Corporation. Microsoft and Microsoft Excel are trademarks of the Microsoft group of companies.

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.