К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Using Excel for Accounting · LearnSpace
Назад в каталог
courseraБизнес

Using Excel for Accounting

Курс от Madecraft
Начальный≈ 6.9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

For accountants, speed and accuracy aren't just desirable: they're career-defining. Excel is the tool that separates professionals who spend hours on a task from those who finish it in minutes, and it determines whether the financial data you produce is trusted or questioned. With this course as your guide, you'll build your foundational toolkit with absolute, relative, and mixed references, apply financial and date functions that automate complex calculations, and construct intelligent spreadsheets using IF formulas, XLOOKUP, and VLOOKUP. You'll also aggregate large datasets with Pivot Tables and SUMIF functions, produce visual reports using Excel's charting tools, and apply error-checking and troubleshooting strategies that catch mistakes before anyone else sees them. By the end of this course, you'll produce accurate, polished spreadsheets with confidence, using Excel not as a source of dread but as a strategic tool that saves you time and elevates the quality of your accounting work.

Навыки, которые вы освоите

Microsoft ExcelExcel FormulasFinancial ReportingFinancial ModelingAuditingLoansSpreadsheet SoftwarePivot Tables And ChartsAccountingMaintainabilityScalabilityData AnalysisData VisualizationData SynthesisFinancial Accounting

Программа курса

7 модулей · 43 учебных материалов

01Building Accurate Spreadsheets with Excel References6 материалов

Excel as Your Competitive Edge in Accounting

Excel as Your Competitive Edge in AccountingВидео

Absolute and Relative References

Absolute and Relative ReferencesВидеоChoosing the Right Reference Type for the JobЗадание

Using References to Build Spreadsheets

Using References to Build SpreadsheetsВидео

Учитесь у экспертов

Madecraft

Преподаватель курса

Using Excel for Accounting
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 6.9 ч

7 модулей

Язык: Английский

Часть программы вашего университета
One Formula, Every Number: Building a Forecast That Holds UpDIALOGUE
Making Your Formulas Work Smarter with ReferencesЗадание
02Automating Accounting Calculations with Excel Functions8 материалов

Loan and Financial Functions

Loan and Financial FunctionsВидеоWhat's the Real Cost of That Loan?DIALOGUEAvoiding the Rate and Period Traps in PMT and NPERЗадание

Date Functions

Date FunctionsВидеоDates Are Numbers: How Excel's Date System Powers Accounting AnalysisЧтение

How Time Works in Excel

How Time Works in ExcelВидеоThe Timesheet That Pays the Wrong AmountDIALOGUEPutting Excel's Financial, Date, and Time Functions to WorkЗадание
03Automating Decisions and Data Retrieval with IF and Lookup Formulas8 материалов

IF Formulas

IF FormulasВидеоThe Spreadsheet That Can't Decide: Building Logic Into a Late Fee ReportDIALOGUEBuilding Multi-Path Formulas with IF and ISBLANKЗадание

Using XLOOKUP

Using XLOOKUPВидеоPulling the Right Numbers: Building a Cross-SheetSales Summary with XLOOKUPDIALOGUE

Importance of VLOOKUP

Importance of VLOOKUPВидеоWhy VLOOKUP Still Matters (Even Though XLOOKUP Is Better)ЧтениеMaking Spreadsheets Smart with IF and Lookup FormulasЗадание
04Summarizing Data with Pivot Tables and COUNTIF and SUMIF Formulas6 материалов

Pivot Tables

Pivot TablesВидеоFast Summary vs. Fragile Foundation: Choosing the Right Summarization ToolDIALOGUE

COUNTIF and SUMIF

COUNTIF and SUMIFВидео

COUNTIFS and SUMIFS

COUNTIFS and SUMIFSВидеоOne Grid, Every Number: Building a Multi-Criteria Sales Summary That Holds UpDIALOGUESummarizing the Numbers: Counts and Totals from Transaction DataЗадание
05Producing Accurate Financial Reports with SUMIF, Charts, and Error-Checking Strategies7 материалов

SUMIF(S) for Accounting and Finance

SUMIF(S) for Accounting and FinanceВидеоThe Budget Is $100K and the Bills Are $350K: Building a Payment Prioritization ToolDIALOGUE

Charts and Graphs

Charts and GraphsВидеоChoosing the Right Chart: When Line, Column, and Pie Work and When They Don'tЧтение

Error Checking

Error CheckingВидеоFinding the $270,000 Mistake Before the CFO DoesDIALOGUEReporting, Visualizing, and Verifying Financial Data in ExcelЗадание
06Building Efficient and Error-Free Spreadsheets5 материалов

Excel Best Practices

Excel Best PracticesВидеоNo One Can Change the Assumptions Without Breaking It: Rebuilding a Fragile Budget ModelDIALOGUE

Common Problems and Troubleshooting

Common Problems and TroubleshootingВидеоEighteen Times Too High: Diagnosing a Hidden Row Problem Before the Manager Sees ItDIALOGUEBuilding Spreadsheets That Last: Best Practices and TroubleshootingЗадание
07Conclusion3 материалов

Taking Your Excel Skills Forward

Taking Your Excel Skills ForwardВидеоFrom This Course to Your Daily Work: Using Your Excel Skills IntentionallyЧтениеMaking Excel Work for Your Accounting PracticeЗадание