Course info

Description

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables. Excel is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualize data, and innumerable other tasks

What you’ll learn

Requirements

• Willingness to learn the course

Here is exactly what we cover:

MS Excel use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs. Excel is typically used to organize data and perform financial analysis.

The main uses of Excel include:

• Data entry
• Data management
• Accounting
• Financial analysis
• Charting and graphing
• Programming
• Time management
• Task management
• Financial modeling
• Customer relationship management (CRM)
• Almost anything that needs to be organized!

Data Functions, Formulas, And Shortcuts

The Excel software program includes many functions, formulas, and shortcuts that can be used to enhance its functionality. We have defined the key functions and formulas in the course

Financial and accounting uses

Excel is used extensively in finance and accounting functions. In fact, many organizations run their entire budgeting, forecasting, and accounting functions entirely out of Excel spreadsheets.

While Excel is defined as a “data” management tool, the data that is most commonly managed is financial. We would define Excel as the ultimate financial software.