YoVDO

Excel for Accounting

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Accounting Courses Spreadsheets Courses VLOOKUP Courses PivotTables Courses COUNTIFS Courses XLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn to use Excel more effectively in your accounting work.

Syllabus

Introduction
  • Being good at Excel
1. Your Excel Toolkit
  • Absolute and relative references
  • Using references to build spreadsheets
  • Loan and financial functions
  • Date functions
  • How time works in Excel
2. Becoming a Power User
  • IF formulas
  • Using XLOOKUP
  • Importance of VLOOKUP
  • PivotTables
  • COUNTIF and SUMIF
  • COUNTIFS and SUMIFS
  • SUMIF(S) for accounting and finance
  • Charts and graphs
  • Error checking
3. Continuing Your Excel Journey
  • Excel best practices
  • Common problems and troubleshooting
Conclusion
  • Let's get started

Taught by

Steve Friedman and Madecraft

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Analyze Data with Microsoft Excel
Codecademy
Conditional Formatting, Tables and Charts in Microsoft Excel
Coursera Project Network via Coursera
Data for Business Analysts Using Microsoft Excel
Microsoft via Coursera
Create Charts and Dashboards Using Microsoft Excel
Coursera Project Network via Coursera