Welcome to Excel Savy
We help learners by bringing all their learning needs in one place. We offer Easy Excel tutorials on how to learn and use Excel efficiently and smartly. Below is an overview of Excel tutorials for your learning. Join with us to become Excel Savvy. We are popular among Excel learners. We make Excel learning easy and smart.
Introduction to Excel
Learn the essentials like cells, entering data, and simple calculations.
This is the perfect place for Excel beginners. As you may know, millions of people all over the world use Microsoft Excel every day. It allows users to enter data and easily handle financial, math, or statistical calculations.
1. Ranges in Excel: A range can be defined as a selection of two or more cells. In this tutorial, you will learn some of the very important range operations.
2. Formulas and Functions: A formula in Excel can be defined as a mathematical expression that is used to calculate the final value in a cell. Functions are built-in formulas that come with Excel.
Master Excel Functions
Master powerful formulas like VLOOKUP, IF, SUMIF, and more.
Learn to use Excel functions to save time. In the following 11 chapters, we will discuss Excel functions. Each chapter represents a particular category of Function. Master Excel functions quickly and easily!
1. Count and Sum: The most commonly used basic functions in Excel are SUM and COUNT, which are useful for performing simple calculations. This function counts or sums values when given conditions are met.
2. Logical Function: Logical functions are used to make choices based on logic. Discover how to use the AND, OR, NOT, and IF functions in Excel to perform logical tests and make decisions.
3. Cell References: Learn how to refer to cells in Excel. It’s important to understand relative, absolute, and mixed references in Excel.
4. Date & Time: Excel automatically recognizes when you enter a date or time. You should use a slash (/) or a dash (-) to enter dates in Excel. Similarly, to enter a time, use “:” (colon). It is possible to enter the date and time together in a single cell.
5. Text Function: Text functions are very important for handling text strings in Excel. This chapter will teach you several helpful Excel text functions.
6. Lookup & Reference: These are the functions mostly used when you work with real-world data. You will learn some important lookup functions like VLOOKUP, HLOOKUP, INDEX, MATCH, and CHOOSE.
7. Financial Function: In this chapter, you will learn all the most popular Excel financial functions.
8. Statistical Functions: Learn to calculate statistics in Excel with these functions.
9. Round: Learn how to round numbers in Excel with an easy function. You will learn three main functions: ROUND, ROUNDUP, and ROUNDDOWN.
10. Formula Errors: Learn how to identify and rectify some common formula errors in Excel.
11. Array Formulas: Learn how to use array formulas and how they simplify your calculations in Excel. You can use one array formula in a cell to perform many calculations and save time.
Powerful Data Analysis
Analyze and interpret data using PivotTables, Filters, and Tools
This section covers Excel’s data analysis features.
1. Sort: You can sort data in Excel to analyze it more clearly. Sort your data by one or more columns, either A to Z or Z to A.
2. Filter: This is mainly used to filter out most of the unwanted data from large data sets and display the data that meets certain criteria.
3. Conditional Formatting: Using conditional formatting, you can highlight cells with a certain colour depending on their value.
4. Charts: Charts are the key data analysis and visualization element. Charts help us to visually analyse and summering data sets, which is a better way to understand data than a sheet full of numbers.
5. Pivot Tables: Pivot Tables are key to effective data analysis in Excel. These are mostly useful for summarizing and analyzing large data sets.
6. Tables: Tables are very useful for handling data and related operations quickly and efficiently.
7. What-If Analysis: This feature helps you explore different scenarios by changing the values of the formula variable.
8. Solver: This Excel Add-In program helps you find the best solution through optimization. The main purpose of this tool is to find the desired outcome by varying the assumptions in the test model.
9. Analysis ToolPak: As the name says, this Excel add-in helps with data analysis in statistics, finance, and engineering.
Automate with VBA
Learn Excel’s built-in programming to create custom tools and automate tasks.
VBA (Visual Basic Application) is a simple programming language used for Excel automation and Programming. For Excel VBA beginners, these 16 chapters will help you get started.
1. Create a Macro: You can automate tasks in Excel using VBA macros. Learn how to build a simple macro in Excel VBA in this tutorial.
2. Working with MsgBox: Excel VBA offers MsgBox to programmers to show information to the users. It is something like a pop-up message that gives users important information..
3. Workbook and Worksheet Object: Excel VBA is a programming language that uses objects. In VBA, everything is an object, including the Excel workbook and worksheet. Learn more about this inside the chapter.
4. Range Object: Range objects are objects in the Excel VBA object model that represent a cell, a column, a row, or a selection of cells. Learn more inside the chapter.
5. Variables in Excel VBA: Learn how variables work in Excel VBA and why they are useful. Learn the basics of declaring, assigning, and displaying variables in Excel VBA.
6. If Then Statement: Learn how and when to apply the If Then statement in Excel VBA.
7. Loop: Looping is a powerful programming technique that helps you write efficient code. It basically allows you to repeatedly use your block of code till the specified condition is true. For example, You can use a loop to find an object in a range.
8. Macro Errors: In this chapter, you will learn a few of the common macro errors in Excel and how to fix them efficiently.
9. String Manipulation: Get familiar with the key string manipulation functions in Excel VBA.
10. Date and Time in Excel VBA: Understand how to manage dates and times using Excel VBA.
11. Events in VBA: An event is an action that triggers Excel VBA to execute some code or Macros.
12. Array in VBA: An array is a collection of similar types of items. You can access a specific element in an Excel VBA array by using its name and index.
13. Function and Sub: A function is a small set of instructions that perform a specific task and always returns a value. But in the case of the sub, it does not return a value. Get more details inside the chapter.
14. Application Object: The application object in Excel VBA refers to the Excel application itself. The application object contains other VBA objects. For example, Workbook objects are part of the Excel application objects. The application objects provide many Excel-related options.
15. ActiveX Control in Excel VBA: Understand how to use ActiveX controls in Excel VBA like buttons, text boxes, and list boxes.
16. Userform in Excel VBA: Learn how to create an Excel VBA Userform and how to design a Userform using ActiveX controls.
We make Excel Learning easy and Smart.
| 
| Expertly Curated Content | 
| 100% Free Learning | 
| Step-by-Step Explanations | 
| Real-World Skills | 
| Trusted by 10,000+ global learners
Struggling with Excel? Let us make it simple. Get weekly Excel tips and tutorials – straight to your inbox.
GETPIVOTDATA function in Excel To add a GETPIVOTDATA formula easily, type an equal sign (=) and then click on a cell inside the PivotTable. The GETPIVOTDATA function can be quite useful. 1. First, click on Read more
Calculated Field and Calculated Item in Pivot Table This example shows how to add a calculated field or item in a pivot table. Below you can find a pivot table. Return to Pivot Tables to Read more
Update a Pivot Table in Excel The pivot table does not automatically reflect changes made to the data set. To see the changes in your pivot table, refresh it or update its data source. 💎 Read more