Courses

Excel: Tracking Data Easily and Efficiently

In this course, Curt Frye demonstrates effective ways of evaluating and visualizing cash flows using Microsoft Excel.


Description

Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more. Follow along with Excel MVP Oz du Soleil as he shows how to create a basic spreadsheet and transform it into an effective tracking system for any kind of data that is regularly updated. Learn spreadsheet basics, as well as more advanced techniques such as writing formulas that check that information is complete, protecting and hiding sheets, and creating alerts for deadlines and bad data. Oz wraps up with a challenge that pulls together everything you've learned into a polished final project.

Name Excel: Tracking Data Easily and Efficiently
Language English
Duration 1:30 hours
Sector IT-ITES
Price (INR) FREE
Availablity Available full time
Certification Availability from Knowledge Partner Available
Certification Availability from eSkillIndia Not Available
Pre-Qualification Any

Course Rating

Average Rating:5.0

*   The QP alignment of the course is provided by the Knowledge Partner and the course may not cover the QP in entirety.