Problem Solving with Excel

Course Feature

Cost

Free
Provider

Coursera
Certificate

Paid Certification
Language

English
Start Date

10th Jul, 2023
Learners

No Information
Duration

No Information
Instructor

/

Add to Favorites

5.0

10,189 Ratings

This course explores Excel as a powerful tool for solving business problems. Through guided demonstrations, participants will learn the basic functions of Excel and build on their skills each week. They will have the opportunity to practice what they have learned and put their knowledge to work in a final project. Developed using a Windows version of Excel 2013, this course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, New York, 10017. Sign up now to learn how to use Excel to solve business problems!

Show All

Go to class

Course Overview

❗The content presented here is sourced directly from Coursera platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 13th, 2023]

Skills and Knowledge Acquired:
This course will provide learners with the skills and knowledge to use Excel as a tool for solving business problems. Learners will gain an understanding of the basic functions of Excel through guided demonstration. Each week, learners will build on their Excel skills and have the opportunity to practice what they have learned. Finally, learners will have the chance to apply their knowledge in a final project. The content in this course was developed using a Windows version of Excel 2013.

Contribution to Professional Growth:
This course provides an opportunity for professional growth by teaching the basic functions of Excel and providing guided practice and a final project. Through this course, participants will gain the skills necessary to use Excel as a tool for solving business problems. The content of the course was developed using a Windows version of Excel 2013, making it applicable to a wide range of users.

Suitability for Further Education:
This course is suitable for preparing further education as it provides an opportunity to learn the basic functions of Excel and build on those skills. Additionally, the course provides a chance to practice what has been learned and culminates in a final project. The content was developed using a Windows version of Excel 2013, making it a useful tool for those looking to further their education.

Show All

Recommended Courses

SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function Excel Magic Trick 978

2.5

Youtube 0 learners

Learn More

This course provides an in-depth look at the SUMIFS function in Excel. It covers 36 examples of how to use the function to add with criteria. It begins with initial remarks and defined names, and then moves on to examples such as adding with one condition, two criteria, three criteria, greater than, less than, equal, not, and more. It also covers topics such as data validation list feature, comparative operator, partial text match, and more. The course also covers solutions for SUMIFS with external references, year criteria mismatched against serial numbers, and more. By the end of the course, you will have a thorough understanding of the SUMIFS function and how to use it to add with criteria.

Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?

1.5

Youtube 0 learners

Learn More

This course will teach you how to count unique numbers in a list of numbers using either the FREQUENCY or COUNTIF function. You will learn how to time each function and how to count unique numbers in a list of numbers given one condition. You will also learn how to use unique count formulas for mixed data, mixed data and empty cells, and how to use the tilde (~) to help the formula to see wild cards as non-wild cards (actual characters). Additionally, you will learn how to use the tilde to count unique items including wild cards and empty cells with one condition, and how to use a helper column to count unique items with COUNTIFS and COUNTIF functions. Finally, you will learn how to create a dynamic range for a unique count formula.

Excel VBA Expert Tutorial

2.0

Youtube 2 learners

Learn More

This course provides an in-depth look at Excel VBA programming. It covers topics such as worksheets methods, DateSerial and Format, Sheet Template Generator, Move, PrintOut and PrintPreview, and practice parts 1-6. It also covers custom functions parts 1-3, and wraps up with a review of the material. This course is perfect for those looking to become an Excel VBA expert.

How to Transcribe and Excel In General Transcription

4.5

Udemy 3 learners

Learn More

This online course, How to Transcribe and Excel In General Transcription, is perfect for both beginners and experts. Learn transcription techniques such as grammar, punctuation, parts of speech and transcribing accented audios. Get certified and stand out among your peers. Plus, you can qualify for an internship with Transcription Certification Institute and get free access to practice tests. With this course, you can start earning $10 to $35 per hour working from home. Invest an hour to find out if you can join the 1000s of transcription companies outsourcing projects all over the world.