MS Excel Business Modeling: Managing Businesses through Excel

Description

This course aims to teach you how to use prominent excel features for business management purposes. You will be able to administer your own business operations more efficiently as well as gain the skillset necessary to work as an excel freelancer for other companies and businesses.

6 hours of recorded videos.

What you will learn in this course

MS-EXCEL spreadsheet usage
Using the toolbar and different tabs
Complete formatting and editing mastery
Using Excel for business segments and business purposes
How to apply excel function in business reporting and analysis context
Learn how to apply arithmetic formulas and calculations
Learn about cell referencing and applying conditional formulas
Learn about creating new rules and conditions
Learn how to create tables and use filters
Learn how to format tables and link data
Learn how to review and remove conflicting or duplicated data
Learn various shortcuts from basic functions such as cut, copy, paste, paste special to advanced shortcuts such as data manipulation
Formatting cells for currencies, dates, text functions
Learn how to draw and edit charts and graphs
Learn how to edit and infer from pie charts, bar graphs, histograms etc.
Learn how to create pivot tables and manipulate shown data
Learning about Slicers, Timelines, Report Connections, Group Selection, Calculated Fields
Learn about using Look Up and Reference Functions
Learn how to conduct Forecasts and apply "What-If Analysis"
Learn about Goal Seek
Learn on drawing 2D and 3D data tables
Learn how to use scenario manager functions
Learn about using forecasting functions
Learn about working with Macros
Learn the concepts for relative and absolute Macros
Learn about using the developer options such as Form Controls and ActiveX Controls
Learn about writing basic commands
Learn how to manage large data series
Practical Application with Examples