Description
Everyday Excel Specialization is a zero-to-hundred Excel software training series published by Coursera Academy. Excel is one of the most useful tools in the Microsoft Office software suite. Excel is actually a spreadsheet software that each project consists of a number of information cells. The user can store his information in a completely organized and meaningful way in these cells and even perform calculations and mathematical and logical operations on the stored data. This educational series consists of three completely separate courses. In the first two courses, the user will get acquainted with the capabilities of Excel and will test his skill and mastery by using targeted exercises. In the last course, a series of practical projects are presented along with a number of guide files, and the user is expected to be able to perform the assigned tasks easily.
In the third period, practice projects focus on dynamic array functions, which is one of the new and revolutionary features of Excel in recent versions. At the end of this training 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 manage large databases easily. Performing calculations on different data, filtering and sorting data, searching among data, displaying numerical data in the form of charts and graphs, etc. are only part of the topics taught in the collection.
What you will learn in the Everyday Excel Specialization training series:
- 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 mathematical, logical, economic, statistical formulas and functions, etc.
- Management of medium and large databases using Excel functions
- Working with sorting, filtering and…
- Lookups and search functions among different data
- Remove numeric data and duplicate strings
- Validation of user data and confirmation of their eligibility
Course details
Publisher: Coursera
teacher: Charlie Nuttelman
English language
Education level: introductory
Presenting Institution/University: University of Colorado Boulder
Number of courses: 3
Duration of training: assuming 4 hours of work per week, about 4 months
Courses available in the Everyday Excel Specialization series
Course 1
Everyday Excel, Part 1
Course 2
Everyday Excel, Part 2
Course 3
Everyday Excel, Part 3 (Projects)
Course 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.
Course images
Introduction video of the Everyday Excel Specialization course series
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
This collection includes 3 different courses.
download link
Everyday Excel, Part 1
Everyday Excel, Part 2
Everyday Excel, Part 3 (Projects)
Password file(s): www.downloadly.ir
Size
About 2.7 GB in total