Coursera – Everyday Excel Specialization 2021-12

Published on: 2021-12-22 21:29:34

Categories: 28

Description

Everyday Excel Specialization is a training package of zero to one hundred Excel software published by Coursera Academy. Excel is one of the most useful tools in the Microsoft Office suite. Excel is actually a spreadsheet software, each project of which consists of a number of data cells. The user can store his information in these cells in a completely organized and semantic way, and even perform the mathematical and logical calculations and operations on the stored data. This educational set consists of three completely separate courses. In the first two courses, the user will become familiar with Excel capabilities and will test their skill and mastery by using targeted exercises. In the last period, a series of practical projects are presented along with a number of help files and it is expected that the user will be able to easily perform the assigned tasks.

In the third period, training projects focus on dynamic array functions, which is one of the new and revolutionary capabilities of Excel in recent versions. At the end of this course, the student is expected to be able to use the general and semi-specialized functions and capabilities of Excel depending on the conditions and prerequisites of the project and easily manage large databases. Performing calculations on different data, filtering and sorting data, searching between data, displaying numerical data in the form of various graphs and graphs, etc. are just some of the topics taught in the collection.

What you will learn in Everyday Excel Specialization

Familiarity with general and semi-specialized tools and functions of Excel software
Working with the Excel user interface and how to place each element in its various pages and menus
Familiarity with formulas and functions of mathematics, logic, economics, statistics and …
Manage medium and large databases using Excel functions
Work with sorting functions, filters and …
Functions of lookups and searches between different data
Delete numeric data and duplicate strings
Validation of user data and their validation

Course Specifications

Publisher: Coursera
Instructors: Charlie Nuttelman
Language: English
Level: Beginner

institution / university: University of Colorado Boulder

Number of Courses: 3
Duration: Approximately 4 months to complete – Suggested pace of 4 hours/week

Courses included:

Course 1

Everyday Excel, Part 1

Course 2

Everyday Excel, Part 2

Course 3

Everyday Excel, Part 3 (Projects)

Prerequisites

It is beneficial to have a basic understanding of computers and navigating around computers, but other than that you will learn Excel from “scratch to expert”. A basic knowledge of math is helpful, but not a lot of time is spent on mathematical formulas.