explanation
The Everyday Excel Specialization is a training package of 0 to 100 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, and each project consists of several cells of data. Users can store their information in these cells in a completely organized and semantic manner and can also perform mathematical and logical calculations and operations on the stored data. This training set consists of three completely separate courses: In the first two courses, users become familiar with Excel features and test their skills and proficiency through targeted exercises. In the final period, a series of practical projects are presented along with several help files and it is expected that users will be able to easily perform the assigned tasks.
In the third period, the training project focuses on one of the new and innovative features of the latest version of Excel: the Dynamic Array feature. Upon completion of this course, the student is expected to be able to use general and semi-professional functions in Excel, depending on the conditions and prerequisites of the project, and be able to manage large databases with ease. Performing calculations on a variety of data, filtering and sorting data, searching across data, and displaying numerical data in a variety of graphs and graphical forms – these are just some of the topics taught in the collection.
What you’ll learn in the Everyday Excel Specialization
- Knowledge of general and semi-specialized tools and features in Excel software.
- Working with the Excel user interface and how to place each element on various pages and menus.
- Knowledge of formulas and functions in mathematics, logic, economics, statistics, etc.
- Manage mid to large databases using Excel functions
- Work with sorting features, filters, and more.
- Inquiry and search functions between different data
- Delete numeric data and duplicate strings
- Verification and validation of user data
Course specifications
publisher: Coursera
teacher: Charlie Nuttleman
Language:English
Level: Beginner
Institution/University: University of Colorado Boulder
Number of courses: 3
Duration: Approximately 4 months to complete – recommended pace is 4 hours per week.
Courses Included:
Course 1
Excel in everyday life, part 1
Course 2
Excel in everyday life, part 2
Course 3
Everyday Excel, Part 3 (Project)
precondition
A basic understanding of computers and computer navigation will be helpful, but beyond that, you’ll learn Excel “from scratch to an expert.” A basic knowledge of math is helpful, but don’t spend much time on math formulas.
movie
Everyday Excel specialty introduction video
installation manual
After extracting, watch with your favorite players.
English subtitles
Quality: 720p
This specialization consists of three courses:
download link
Excel in everyday life, part 1
Excel in everyday life, part 2
Everyday Excel, Part 3 (Project)
File password: free download software
size
Total approximately 2.7GB