A tanfolyamról
The potential of Excel in the world of Data analysis is now being realized and organizations are on the lookout for professionals who have mastered this tool. Our virtual class, with its comprehensive course structure, real-world examples and plenty of hands-on examples will help you master Excel and use it to achieve professional and academic success.
If you want to move beyond Excel basics and master the core statistical tasks that will help you as a student or business professional, then this course on Advanced MS Excel 2021 is just right for you. Our experienced faculty will guide you through the various aspects of MS Excel, starting from the basics and then moving on to advanced concepts such as correlation and regression, binomial, IF Functionality, sparklines, PivotTables, advanced mathematical functions and formulas and much more.
Who Should Attend This Course
- Students
- Graduates
- Freshers
- Professionals
- Business Analysts
- Data Analysts
What You Will Learn
-
Microsoft Excel 2021 Basics
Get an overview of basic Excel functions like MIN, MAX, and SUM -
Mathematical Functions
Understand functions like MEAN, MEDIAN and MODE -
IF Functionality
Understand how to use the AND and OR operators within the IF function -
Performing Data Lookups
Learn how to work with the VLOOKUP and HLOOKUP functions -
Sparklines
Understand how to create and design a Sparkline -
Advanced Mathematical Functions
Learn advanced functions including the Time and Date functions
During this course, a variety of topics will be covered with the aim of making you an expert in Microsoft Excel 2021.
The following are the practical skills you’ll gain on course completion:
- Developing a proficiency in basic as well as advanced concepts of Excel 2021
- Understanding the various features and functions that are a part of the Excel Suite.
- Applying the learning to analyze and expose trends that will help organizations.
- Learning to leverage Excel 2021 as a tool to help you in Big Data Analytics.
We provide the course in English.
Tematika
Curriculum
1. Microsoft Excel Fundamentals
Topics
- What are Rows, Cells, and Column
- Customizing Excel Quick Access Toolbar
- Common Excel Shortcuts
- Different Types of Data Types
- Moving the Cells to Different Position
- Understand the Menu and Toolbars
- Use of Function Box
- Use of Cell Reference and Cell Edits
- Use of Name Box and Range
2. Formatting Concepts
Topics
- Understand the Formatting Techniques
- Data Type Formatting
- Formatting Techniques on Rows and Columns
- Conditional Formatting
3. Formulas in Excel
Topics
- Text Functions
- Date Functions
- Basic Excel Formulas
4. Managing Lists
Topics
- Understanding Lists as a Table and Database
- Sorting Lists
- Filters
- Grouping and Outlining Data
5. Inserting Images
Topics
- Inserting Images in Excel
- Inserting Shapes in Excel
- Working with SmartArt
6. Using Functions
Topics
- SUM Function
- AVERAGE Function
- PRODUCT Function
- MIN Function
- MAX Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- COUNTIF Function
- SUMIF(): Adding Only the Cells You Specify
- COUNTIFS() and SUMIFS(): Counting and Summing
- IF Function
- AND Function
- OR Function
7. Advanced Formulas
Topics
- VLOOKUP With Exact Match
- INDEX and MATCH vs VLOOKUP
- VLOOKUP With Approximate Match
- Format as Table
- Data Model Tool
- Slicer in Pivot Table
8. Templates, Macros and VBA
Topics
- Using Predefined Templates
- Creating Custom Templates
- Creating Macros
- VBA Modules
- Visual Basic Editor
- VBA Coding and Scripting
9. Data Cleaning and Preparing
Topics
- Text to Columns
- Remove Duplicates
- Data Validation
- Find and Replace
- Data Entry Form
10. Pivot Table and Grouping for Data Analysis
Topics
- Calculated Fields in Pivot Table
- Grouping Data with Pivot Table
- GetPivotData
- Group and Ungroup
11. Scenario and Sensitivity Analysis
Topics
- What-If Analysis: Goal Seek
- What-If Analysis: Data Table
- What-If Analysis: Scenario Manager
- Auditing Formulas
12. Formatted and Interactive Tables
Topics
- Format as Table
- Data Model Tool
- Formatting Pivot
- Value Fields Setting
13. Charts and Visualization Techniques
Topics
- Sparklines as Mini Charts
- Column Chart and Bar Chart
- Line Chart
- Pie Chart
- Area Chart
- Combo Charts
- Speedometer Chart
- PivotChart
- Creation of Interactive Dashboard
- Presentation of Final Results
14. Data Analysis ToolPak for Statistics
Topics
- Activation of Data Analysis ToolPak Add-in
- Descriptive Statistics
- Histogram
- Correlation
- Linear Regression
- Explanation of Regression Output
- Muliple Linear Regression
- Probability
- Z-scores
- Download the Results of Statistical Analysis
- Time Series Analysis in Excel
Kinek ajánljuk
Előfeltételek
Prerequisites
There are no prerequisites to attend this course.
Basic knowledge of MS Excel will be helpful.