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

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera