Tutorial for MS Excel

教育

免費 · App內購買 · 專為 iPad 設計。尚未針對 macOS 驗證。

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.

評分與評論

  • 此 App 尚未收到足夠的評分或評論，無法顯示概覽。

A brand-new app: 58 rewritten lessons with new screenshots for today's Excel, a quiz and practice task in every lesson, 465 functions explained, 128 Windows and Mac shortcuts, and 9 new step-by-step courses that build real workbooks, including one for keeping track of your taxes. Bought Pro before? Restore Purchase gives you everything.

版本 2.0

開發者Jakir Hossain指出App的隱私權實務可能包含下方描述的資料處理。如需更多資訊，請參閱 開發者的隱私權政策 。

  • 用來追蹤你的資料

    以下資料可能用於在其他公司的 App 和網站上追蹤你：

    • 位置
    • 識別碼
    • 使用狀況資料
    • 診斷

  • 會與你連結的資料

    系統可能會收集以下資料，並將其與你的身分連結：

    • 位置
    • 識別碼
    • 使用狀況資料
    • 診斷

依據你使用的功能或你的年齡等因素，隱私權實務可能有所不同。 更多內容

輔助使用

開發者尚未表示此 App 支援的輔助使用功能。 進一步瞭解

資訊

供應商
Jakir Hossain
大小
23 MB
類別
教育
相容性
需要 iOS 15.0 或以上版本。
  • iPhone
    需要 iOS 15.0 或以上版本。
  • iPad
    需要 iPadOS 15.0 或以上版本。
  • iPod touch
    需要 iOS 15.0 或以上版本。
  • Mac
    需要 macOS 12.0（或以上版本）以及配備 Apple M1（或以上版本）晶片的 Mac。
  • Apple Vision
    需要 visionOS 1.0 或以上版本。
語言
英文
年齡分級
4+
App內購買
是
  • Keep Track of Your Taxes $60.00
  • Clean Up Messy Data $60.00
  • Make a Teacher's Gradebook $60.00
  • Timesheets and Pay $60.00
  • Track Stock and Inventory $60.00
  • Plan Projects with a Gantt Chart $60.00
  • Build a Sales Dashboard $60.00
  • Bookkeeping for a Small Business $60.00
  • Build a Home Budget $60.00
  • All Lessons $120.00
  • 進一步瞭解
版權
© Jakir Hossain
  • 隱私權政策

    • 更多Jakir Hossain的作品

    你可能也會喜歡