 |
 |
 |
|
|
If you are reluctant to learn about coding, using programming languages, and you want to answer essential business questions, then this course is for you.
Microsoft Excel is ubiquitous in the business world due to its compatibility, ease of use, and its importance in the data world. We use Excel predominantly to store data, visualize data, and import it into popular programming languages such as R and Python. However, Excel is more than just a spreadsheet. It has become a data analytics hub of its own. Excel continuously updates and transforms the way we prepare, calculate, model, and visualize data to acquire the right insights at the right time to make the best decisions for your business. This course goes beyond the basics and provide practical and applied methods to use Excel.
|
|
You will learn:
- Microsoft Excel’s interface (i.e. sheets, rows, columns, cells)
- How Excel fits into the essential relationship between business, data, and analysis
- Data analysis
- Importing: Entry and Formatting
- Preparation: Review, Cleaning, and Errors
- Organization: Sorting, Filtering, and PivotTable
- Calculations: Formulas, Equations, Modeling and Functions
- Analysis: Data Analysis and PivotChart
- Visualization: Charts, Mapping Tools, and PivotChart
- Integration and advanced features (Power Pivot)
- Using Excel with Power BI and Tableau
- Using Copilot with Excel
This course is geared towards:
- Anyone in a business environment with a basic understanding of Microsoft Excel, especially those who work with data regularly
- Those who want to learn about data analysis without learning how to code or programming such as Python and R; Excel can fulfill many of the capabilities required by businesses
Module 0: About the Course (2 min)
Module 1: Introduction to Data Analysis with Excel (17 min)
- Overview
- Relationships Between Business, Data, and Analysis
- About Microsoft Excel
- Summary
Module 2. Data Acquisition, Preparation, and Organization (24 min)
- Overview
- Introduction and Purpose
- Acquiring Data
- Preparing Data
- Organizing data
- Tips, Guidelines, and Summary
Module 3. Formulas, Statistics, and Analysis (25 min)
- Overview
- Introduction and Purpose
- Basic Formulas and Functions
- Advanced Functions
- Modeling and Analysis
- Tips, Guidelines, and Summary
Module 4. Visualization (24 min)
- Overview
- Introduction to Visualization
- The Process
- Types of Visualization
- Visualizing the Data
- Tips, Guidelines, and Summary
Module 5. Integration and Advanced Features (32 min)
- Overview
- Introduction and Purpose
- Advanced Features
- Sharing and Access
- Integrations
- Tips, Guidelines, and Summary
Module 6. Using BI with Excel (38 min)
- Overview
- Introduction to BI Tools
- Exporting Excel Data
- Excel and Power BI
- Excel and Tableau
- Tips, Guidelines, and Summary
Module 6. Using Copilot with Excel (21 min)
- Overview
- Introduction to Microsoft Copilot
- Overview and Features
- Prompt Engineering
- Using Copilot in Excel - Part 1
- Using Copilot in Excel - Part 2
- Tips, Guidelines, and Summary
Click
–here- to download a more detailed outline of this course.
|
This exam tests knowledge and understanding of basic concepts, principles, and terminology of analytics.
|
You will be tested in these areas:
- The relationships between business, data, and analysis
- The structure and components of an Excel spreadsheet
- Data analysis concepts and types of analysis
- Acquiring, preparing, and organizing data
- Data labeling, formatting, cleaning, filtering, and sorting
- Mathematical, statistical, and time-series formulas and functions
- Data analysis and forecasting capabilities of Excel
- Data visualization process and types of visualization
- Charting, mapping, and other visualization features
- Excel advanced features and integrations
- Using Excel with PowerBI and with Tableau
- Using Copilot in Excel and analyzing data with CoPilot
|
Additional Information
Number of Questions: 25
Time Limit: 50 minutes
Passing Score: 70%
|
|
Once you pass the exam, you will receive a Certificate of Education
documenting that you have demonstrated mastery of the topic. Course
exams count towards eLC certification programs. Visit our
Certification page for more information about our various programs.
We recommend that you take detailed notes and review the course material multiple times before taking this exam.
|
|
|
|
 |
|
 |
|