This course was ranked in the Top 100 Best Courses on Coursera, based on its high ratings and large number of ratings.
The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their daily operation. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the goal of using it for more advanced topics in Business Statistics later on. The course is designed with two types of learners in mind: those with very little working knowledge of Excel and those with
The use of Excel is widespread in the industry.
It is a very powerful data analysis tool and almost all big and small businesses use Excel in their daily operation.
This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the goal of using it for more advanced topics in Business Statistics later on.
The course is designed with two types of students in mind: those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and want to improve their skills.
The course takes you from basic operations like reading data into Excel using various data formats, organizing and manipulating data, to some of the more advanced features of Excel.
Throughout, Excel functionality is introduced through easy-to-understand examples that are demonstrated in a way that students feel comfortable understanding and applying.
To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later.
________________________________________ WEEK 1 Module 1: Introduction to Spreadsheets In this module, you will be introduced to using Excel spreadsheets and various basic Excel data functions.
Topics covered include: • Reading data into Excel using various formats • Basic functions in Excel, arithmetic, and various logical functions • Formatting rows and columns • Using formulas in Excel and copying and pasting them using absolute and relative references ________________________________________ WEEK 2 Module 2 : Spreadsheet Functions for Organizing Data This module introduces various Excel functions for organizing and viewing data.
Students are introduced to the IF, Nested IF, VLOOKUP, and HLOOKUP functions of Excel.
Topics covered include: • IF and Nested IF Functions • VLOOKUP and HLOOKUP • The RANDBETWEEN Function ________________________________________ WEEK 3 Module 3: Introduction to Filtering, PivotTables, and Charts This module introduces various Excel data filtering capabilities.
You will learn how to configure filters on data to selectively access data.
A very powerful data summary tool, the pivot table, is also explained, and we begin to introduce the charting feature of Excel.
Topics covered include: • VLOOKUP in worksheets • Filtering data in Excel • Using PivotTables with categorical and numeric data • Introduction to Excel's charting capabilities ________________________________________ WEEK 4 Module 4: Advanced Charts and Graphs This module explore various advanced graphing and charting techniques available in Excel.
Starting with various line, bar, and pie charts, we introduce dynamic charts, scatter plots, and histograms.
You will come to understand these various charts and be able to build them on your own.
Topics covered include • Line, Bar, and Pie Charts • Pivot Charts • Scatter Plots • Histograms Starting with various line, bar, and pie charts, we introduce dynamic charts, scatter plots, and histograms.
You will come to understand these various charts and be able to build them on your own.
Topics covered include • Line, Bar, and Pie Charts • Pivot Charts • Scatter Plots • Histograms Starting with various line, bar, and pie charts, we introduce dynamic charts, scatter plots, and histograms.
You will come to understand these various charts and be able to build them on your own.
Topics covered include • Line, Bar, and Pie Charts • Pivot Charts • Scatter Plots • Histograms
76
Introduction to spreadsheets, data reading, data manipulation. Basic operations and functions of the spreadsheet.
Introduction to some more useful functions like IF, Nested IF, VLOOKUP and HLOOKUP functions in Excel.
Introduction to Excel's data filtering capabilities, building pivot tables to organize data, and introduction to charts in Excel.
Construction of various line, bar and pie charts. Using Excel's PivotChart Features. Understanding and construction of histograms and scatter diagrams.
Prepare yourself from home with the most prestigious universities in the world.
The quality of Coursera's courses is supported by its instructors, who are often deans and have doctorates.
More than 85% of Coursera students report career benefits, such as promotions or salary increases.
Millions of students around the world are meeting their personal and professional goals with Coursera.
Coursera offers courses from over 200 leading universities and companies to deliver online learning around the world. With a Coursera Plus subscription, you get unlimited access to over 90% of all courses, and the most popular professional certificates and specializations on Coursera.
Data science, business and personal development. You can enroll in multiple courses at once, earn unlimited certificates, and learn in-demand job skills to start, grow, and even change careers.
DISCOVER HOW TO GET THE MOST, AND SAVE OVER USD $500 WITH AN ANNUAL SUBSCRIPTION TO COURSERA PLUS*
*You save up to USD$500 in 12 months, when you go from paying USD$59 for a monthly subscription, to an annual subscription with the promotion. The normal annual subscription is USD $399. With the promotion you will only pay USD $299. Find out everything by clicking the yellow button.
Associate Professor of Management
my person_add 223.417 students
my computer5 courses
Rice University is consistently ranked in the top 20 universities in the US and the top 100 in the world. Rice has highly respected schools of Architecture, Business, Continuing Studies, Engineering, Humanities, Music, Natural Sciences, and Social Sciences and is home to the Baker Institute for Public Policy.
Hello how can I help you? Are you interested in a course? About what subject?
Add a review