microsoft excel assignment for students

Excel Practice Exercises PDF with Answers

In this article, we will provide you with 11 Excel practice exercises in PDF format with answers. Additionally, you will get an Excel file where you can try to solve these problems yourself. These problems are mostly beginner friendly. However, a little bit of intermediate knowledge is required to solve a few problems. You will need to know about the SUM , AVERAGE , IF , VLOOKUP , INDEX , MATCH , ROUNDUP , UNIQUE , COUNTIF , LEFT , SEARCH , MID , RIGHT , LEN , FIND , SUBSTITUTE , AND , and SUMIF functions and the Data Bars feature of Excel. If you have Excel 2010 or later, you can solve these problems, except for the UNIQUE function, which is only available in Excel 2021 .

Download Practice Files

You can download the PDF and Excel files by filling out this form:

Eleven Practice Exercises with Solutions.pdf [/wpsm_box] [wpsm_box type="download" float="none" textalign="left"] Eleven Practice Exercises.xlsx [/wpsm_box] -->

Problem Overview

There are eleven problems in this PDF file, and the solutions to those problems are given after each problem. Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet of Excel file.

Now, the eleven exercise problems are as follows:

• Exercise 01. Class Performance Evaluation . You will find these values –
• The total number for each student,
• Their average on those subjects,
• Based on the average score, you will return a GPA. For GPA calculation, less than 60 is B and higher is A .
• You need to find the employee salary in the lookup table on the right side.
• Exercise 03: Lookup Values (Any Direction) .
• Here your task is the same as the second task. However, this time the lookup range is on the right side. Therefore, you cannot use the VLOOKUP function here.
• You will need to round the sales generated values in this exercise.
• You will need to add the first name and last name.
• Your task is to create a Data Bar for the salary values and hide the salary values.
• Firstly, you need to find the unique values in a list of names.
• Then, you will find how many times that value occurred in that lis
• You need to separate the three parts of a name from a given list.
• You will need to find the total sales for a particular country.
• Your objective is to ensure that users cannot type less than 0 in a column.
• Your target is to determine whether a date is between two dates or not.

Here is a screenshot of the solutions to the first two problems. The solutions to these problems are provided in the PDF and Excel files.

Thank you for reading this article. We hope that with these practice exercises in PDF format with answers, you can test your Excel skills. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

You really help me alot thanks

Hello, Aleem!

Thanks for your appreciation. stay in touch with ExcelDemy .

Regards ExcelDemy

Thanks a lot

Dear Rashmi ,

You are most welcome.

This is very helpful. You are God send

Thanks for your appreciation.

Leave a reply Cancel reply

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact  |  Privacy Policy  |  TOS

• User Reviews
• List of Services
• Service Pricing

• Create Basic Excel Pivot Tables
• Excel Formulas and Functions
• Excel Charts and SmartArt Graphics
• Advanced Excel Training
• Data Analysis Excel for Beginners

Advanced Excel Exercises with Solutions PDF

Excel Tutorial

Excel formatting, excel data analysis, table pivot, excel functions, excel how to, guided projects, excel examples, excel references, excel exercises.

You can test your Excel skills with W3Schools' Exercises.

We have gathered a variety of Excel exercises (with answers) for each Excel Chapter.

Try to solve an exercise by editing some code, or show the answer to see what you've done wrong.

Count Your Score

You will get 1 point for each correct answer. Your score and total score will always be displayed.

Start Excel Exercises

Start Excel Exercises ❯

If you don't know Excel, we suggest that you read our Excel Tutorial from scratch.

COLOR PICKER

Report Error

If you want to report an error, or if you want to make a suggestion, do not hesitate to send us an e-mail:

[email protected]

Top Tutorials

Top references, top examples, get certified.

Practice And Learn Excel Online For Free

Welcome to Excel Practice Online!

Now you can practice Excel everywhere! You can even practice on your mobile phone!

Every function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online!

The tutorials are sorted from beginner level to advanced level. If you like this site please share it with your friends! 🙂

Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it.

• Free Excel Courses and Resources
• Excel Self-Assessment Tool
• Free Excel Online Exercises
• Excel Basics – Zero to Hero
• Excel Tests
• Top 10 formulas and functions in Excel
• Vlookup – Tutorial with Example and Exercise Sheet
• Pivot Tables Tutorial
• Excel Shortcuts – Windows and Mac
• HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.
• New! Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version
• Can’t find what you’re looking for? Suggest a tutorial here!
• Excel Basics – Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency!
• Addition (Plus)
• Subtraction (Minus)
• Multiplication
• Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!
• Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac!

Formulas/Functions

• SUM function – Sum multiple values in Excel
• MAX – find the maximum value in a range
• MIN – find the minimum value in a range
• COUNT – Count numeric values in a range
• COUNTA – Count numeric and textual values
• AVERAGE – Calculate average of a range
• Filtering in Excel – Learn how to filter your data using Excel’s Filter Tool
• Excel Sort – Learn how to sort your data in Excel.
• Flash Fill – Excel’s hidden gem for auto-completing data based on a pattern
• Remove Duplicates – Remove duplicate values in a single column or multiple columns!

Intermediate

Conditional.

• IF function – check if a condition is met
• NESTED IF – Multiple if conditions
• Conditional Formatting – Format Excel Cells based on criteria
• COUNTIF – Count cells in range which meet a certain criteria
• SUMIF – Sum range based on criteria
• AVERAGEIF – Calculate the average of a range based on criteria
• SUMIFS – Sum cells using multiple criteria
• COUNTIFS – Count cells using multiple criteria
• MAXIFS – Find maximum value in a range based on criteria
• MINIFS – Find minimum value in a range based on criteria
• AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)
• ISBLANK – Check if a cell is blank or not
• VLOOKUP – lookup value and return corresponding value from a table
• HLOOKUP – lookup value and return corresponding value from a table
• Hot!!! XLOOKUP – Excel’s next generation lookup function which combines the best features from VLOOKUP, INDEX MATCH, HLOOKUP and IFERROR/IFNA

Pivot tables

• Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!

Text Formulas

• LEFT, MID, RIGHT – Basic Text Functions
• HOT! – TEXTBEFORE & TEXTAFTER – Extract text before or after a delimiter using Excel’s brand new powerful functions!
• HOT! – TEXTSPLIT – Split your text into multiple cells using this super powerful new function!
• TEXTJOIN – Easily combine multiple cells using delimiter
• CONCAT – Combine range of cells without delimiter
• CONCATENATE – Combine two cells or more into one cell
• LEN – Find the length of a cell
• FIND – Find the position of a text within another text (Case-sensitive)
• SEARCH – Find the position of a text within another text (Case-insensitive)
• SUBSTITUTE – Replace text with another text in a cell/expression
• TRIM – Remove extra spaces from the text
• LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case
• VALUE – Convert data stored as text into values
• TEXT – Convert and format numbers into text
• Text to Columns – Quickly split a column into multiple columns using a delimiter. Bonus – Quickly change date formats or convert text to numbers!
• FORMULATEXT – display a formula in another cell as text

Date functions

• DAY, MONTH, YEAR – Extract day, month and year from a date in Excel
• DATE – Create a date from individual values
• WEEKDAY – Return the number of the day of the week
• EOMONTH – Return the date of the last day of the month based on a specific date

Index & Match lookup

• INDEX – Retrieve cell in nth position in a range
• MATCH – Find position of value in a range
• INDEX MATCH – Just like VLOOKUP, only better.

Other advanced tools

• SUMPRODUCT – Sum the products of Excel ranges
• Excel Wildcards – Advanced searching and matching in Excel
• Advanced Filter – Filter by multiple criteria in the same column, or even in different columns!

Power Query

• Combine data from multiple Excel workbooks using Power Query
• Column from Examples tool – Learn the secret to mastering Power Query without any prior knowledge!
• Unpivot columns easily using Power Query

Secret Excel Functions

This section covers Excel functions that are not available in most of Excel’s versions. These functions will unlock a new set of capabilities such as fining only unique values, sorting, and filtering – the tutorials below will help you with mastering Excel’s new functions!

• UNIQUE – Extract unique values from a range
• SORT Function – Sort range dynamically
• SORTBY – Sort range dynamically by using another range
• FILTER Function – Filter range by specific criteria
• RANDARRAY – Create an array of random numbers 
• SEQUENCE – Create a range of sequential values
• LET – Assign values and calculations to names to improve your formula’s ease of use, readability, and performance!
• HOT! – LAMBDA – The mother of all functions that will help you create amazing and powerful custom functions for your own need! 
• VSTACK – Vertically stack arrays/ranges in Excel
• HSTACK – Horizontally stack arrays/ranges in Excel
• CHOOSEROWS – Return specific rows from a range or array
• CHOOSECOLS – Return specific columns from a range or array
• TOROW – Convert a range/array into a single row
• TOCOL – Convert a range/array into a single column

Financial Functions

Learn how to use Excel to make financial calculations!

• Excel Financial Calculator – quickly calculate PV, FV, PMT, NPV, IRR
• PMT – Calculate the periodic payment amount of a loan, mortgage, or another financial instrument
• PPMT & IPMT – Find the Principal and Interest portion of a certain payment
• PV – Find the Present Value of a loan, mortgage, or any other financial instrument 

Excel Macros – VBA (Visual Basic for Applications)

• Start here – How to run your first VBA Macro in Excel without knowing VBA? 

Excel Data Sheets for Practice

Want to do some freestyle practice? Create your own Excel playground with our blank excel Worksheet!

• Excel-Online Blank Worksheet
• Excel Practice Data

How to Calculate in Excel – Excel-Online Calculators

• How to Calculate GPA in Excel
• How to Calculate BMI in Excel
• How to Calculate Density in Excel
• How to Calculate Weighted Average in Excel

Terms and Conditions - Privacy Policy

SpreadsheetCollege

Excel Tutorials, Excel Projects and Many More!

12 Excel Practice Projects & Exercises To Sharpen Your Skills

Excel is a powerful tool for organizing, analyzing, and visualizing data, but mastering its many features and functions can take time and practice.

In this article, we present 15 Excel practice projects and exercises that can help you sharpen your skills and become an Excel expert. From creating and formatting worksheets, to using formulas and functions, to working with pivot tables and data visualization tools, these projects will help you gain hands-on experience and confidence in using Excel.

Whether you are new to Excel or an experienced user, these projects will provide you with valuable opportunities to learn and improve your skills.

Read our other article to get an entire list of excel projects: 31+ Fun Excel Project Ideas (From Beginner To Advanced)

12 Excel Practice Projects & Exercises

1. basic excel operations.

One project that could help you improve your Excel skills is to become acquainted with the program’s basic functions and features. This can include creating and editing worksheets, formatting cells and data, and using simple formulas and functions.

To start, you can try creating a simple worksheet with some dummy data, such as a list of names, addresses, and phone numbers. Then, practice formatting the data using the various tools and options available in Excel, such as font size and color, cell alignment, borders, and fills.

Next, try using some of the basic formulas and functions in Excel, such as SUM, AVERAGE, and COUNT, to perform simple calculations on your data. For example, you might use the SUM function to total a column of numbers, or the AVERAGE function to calculate the average value of a range of cells.

Overall, completing this project can teach you the basics of Excel and provide a strong foundation for more difficult projects and tasks.

2. Pivot Tables

Another potential project to help improve your Excel skills is to practice creating and using pivot tables. Pivot tables are a powerful tool in Excel that allow you to summarize and analyze large amounts of data quickly and easily.

To start, you will need to have a dataset that you can use for your pivot table. This could be a set of data from a survey, a sales report, or any other type of data that you want to analyze. Once you have your data, you can create a pivot table by selecting the data range and then choosing the “Pivot Table” option from the Insert menu.

Once your pivot table is created, you can begin to customize it by adding and rearranging fields. For example, you can add a field to the rows area to group your data by a certain category, such as product type or sales region. You can also add a field to the columns area to create subgroups within your rows, such as by month or quarter.

In addition to grouping and arranging your data, you can also use pivot tables to perform calculations on your data. For example, you can use the SUM function to total the values in a column, or the AVERAGE function to calculate the average of a group of cells. You can also use pivot tables to create graphs and charts, which can make it easier to visualize your data and communicate your findings.

Overall, practicing with pivot tables can help you learn a valuable skill for working with large datasets in Excel, and can enable you to quickly and easily summarize and analyze complex data.

3. Experiment with excel data visualization tools

One of the best ways to improve your Excel skills is to learn how to create effective data visualizations.

Excel offers a variety of ways to create visual representations of your data, such as charts, graphs, and maps, which can make it easier to understand and communicate your data.

To start, you will need to have a dataset that you want to visualize. This could be a set of data from a survey, a financial report, or any other type of data that you want to analyze. Once you have your data, you can create a chart or graph by selecting the data range and then choosing the appropriate chart type from the Insert menu.

You can experiment with different chart types to see which one works best for your data. For example, a pie chart might be a good choice for showing the proportions of different categories in your data, while a scatter plot might be better for showing the relationship between two numerical variables.

Once you have created your chart or graph, you can customize it by adding labels, formatting the data series, and changing the layout and appearance. For example, you can add titles and axis labels to make your chart easier to understand, or you can change the colors and fonts to make it more visually appealing.

Overall, practicing with Excel’s data visualization tools can help you learn how to create effective and informative visualizations of your data, and can enable you to more effectively communicate your findings and insights.

4. Using Macros to automate repetitive tasks

Another useful project to help improve your Excel skills is to try creating simple macros to automate repetitive tasks. Excel macros are small programs that you can create and run within Excel to automate a series of actions. For example, you can use a macro to automatically format a range of cells, or to insert a standard set of formulas into a worksheet.

To start, you can try creating a simple macro by using the “Record Macro” feature in Excel. This will allow you to perform a series of actions in Excel, such as formatting cells or entering data, and then save those actions as a macro that you can run later with a single click. Once you have recorded your macro, you can edit it to add additional actions or to change the way it behaves.

In addition to recording macros, you can also create macros by writing VBA (Visual Basic for Applications) code. VBA is a programming language that is built into Excel and other Microsoft Office applications, and it allows you to create more sophisticated and flexible macros. You can use VBA to create custom functions, to interact with other applications or data sources, or to control the behavior of Excel itself.

Overall, working with Excel macros can help you learn how to automate repetitive tasks, increase your efficiency, and create custom solutions for specific problems or requirements.

5. Practice handling data from Excel to other applications

One potential project to help improve your Excel skills is to practice importing and exporting data from Excel to other applications. Excel allows you to easily import data from other sources, such as databases, text files, and web pages, and to export data to a variety of formats, such as CSV, XML, and HTML.

To start, you can try importing data into Excel from a variety of sources. For example, you can use the “From Text” or “From Web” options in the Data menu to import data from a text file or a web page, respectively. You can also use the “From Other Sources” option to import data from a database or other data source. Once you have imported your data, you can manipulate and analyze it in Excel just like any other data.

In addition to importing data, you can also practice exporting data from Excel to other formats. For example, you can use the “Save As” command to save your Excel data as a CSV or XML file, which can then be used by other applications or shared with others. You can also use the “Publish to Web” feature to create an HTML version of your data that can be viewed in a web browser.

Broadly speaking, using Excel’s data import and export features can help you learn how to integrate Excel with other applications and data sources, as well as work with a broader range of data and formats.

6. Solving real-world problems with Excel

Are you looking for a way to apply your Excel skills to real-world problems and challenges? In this project, you will have the opportunity to use Excel to solve a variety of problems and needs that you encounter in your daily life or work.

Such as budgeting, tracking expenses, analyzing data from surveys or experiments, and much more.

To start, you can try using Excel to solve a specific problem or need that you have in your own life or work. For example, you might use Excel to create a budget spreadsheet to track your income and expenses, or to create a grading sheet to calculate and record grades for a class. You can also use Excel to analyze data from a survey or experiment, such as to calculate means, medians, and other statistics, or to create graphs and charts to visualize your data.

In addition to solving specific problems, you can also practice using Excel to tackle more open-ended challenges. For example, you can use Excel to create a model or simulation of a real-world system, such as a supply and demand model, or a mortgage calculator. You can also use Excel to automate complex tasks and workflows, such as data cleansing and validation, or data consolidation and aggregation.

Overall, using Excel to solve real-world problems can help you learn how to apply your Excel skills to practical situations, and can give you a deeper understanding of the capabilities and potential of the program.

7. Practice with large and complex datasets

Working with large and complex datasets is one possible project to help you improve your Excel skills.

To start, you can try working with a large dataset that you have access to, or you can use a publicly available dataset from a source such as the World Bank or the United Nations. Once you have your dataset, you can begin to explore and analyze it using Excel’s various tools and features.

One important skill to practice when working with large datasets is using filters and pivot tables to summarize and extract relevant data. Filters allow you to quickly and easily hide or show rows or columns based on certain criteria, such as the values in a particular column or the color of a cell. Pivot tables, on the other hand, allow you to quickly and easily summarize your data by grouping and totaling values in different ways.

In addition to using filters and pivot tables, you can also practice using other techniques, such as using named ranges and dynamic formulas, to make your work with large datasets more efficient and manageable. For example, you can use named ranges to refer to specific groups of cells in your formulas, or you can use dynamic formulas such as OFFSET and INDEX to create formulas that can adapt to changes in your data.

Ultimately, practicing with large and complex datasets can help you learn how to effectively manage and analyze data in Excel, and can enable you to extract valuable insights and trends from your data.

8. Practice creating simple models and simulations

Using Excel to create simple models and simulations of real-world systems such as financial models, supply and demand models, and many others is one project that could help you improve your Excel skills.

To start, you can try creating a simple model or simulation in Excel, such as a mortgage calculator or a model of supply and demand. For example, a mortgage calculator might use input cells for the loan amount, interest rate, and loan term, and then use formulas to calculate the monthly payment and total interest paid. A supply and demand model, on the other hand, might use input cells for the supply and demand curves, and then use formulas to calculate the equilibrium price and quantity.

In addition to creating models and simulations, you can also practice using Excel’s sensitivity analysis and scenario analysis features to explore the behavior of your models under different conditions. Sensitivity analysis allows you to see how your model’s outputs change as you vary the input values, while scenario analysis allows you to compare different sets of input values to see how they affect your model’s outputs.

Overall, practicing with Excel’s modeling and simulation capabilities can help you learn how to create simple but powerful models of real-world systems, and can enable you to better understand and predict the behavior of those systems.

9. Familiarize yourself with collaboration features in Excel

One potential project to help improve your Excel skills is to practice using Excel’s collaboration and sharing features. Excel allows you to easily share your work with others, and to collaborate on workbooks and other Excel files in real time.

To start, you can try using Excel’s “Share” feature to share a workbook or other Excel file with others. This will allow you to invite other people to view or edit your workbook, and to see their changes in real time. You can also use Excel’s “Track Changes” feature to keep track of changes that are made to your workbook by others, and to review and accept or reject those changes.

In addition to sharing and collaborating on Excel files, you can also practice using Excel’s co-authoring features. Co-authoring allows multiple people to work on the same workbook at the same time, and to see each other’s changes as they are made. This can be a useful feature for team projects, or for working on large and complex workbooks.

Overall, practicing with Excel’s collaboration and sharing features can help you learn how to work more effectively with others, and can enable you to share your work and collaborate on projects in real time.

10. Experiment with Excel’s built-in financial functions

One potential project to help improve your Excel skills is to experiment with Excel’s built-in financial functions. Excel offers a variety of functions that are specifically designed for working with financial data, such as functions for calculating interest, amortization, and other financial quantities.

To start, you can try using some of Excel’s financial functions, such as the PMT function, which calculates the monthly payment for a loan, or the FV function, which calculates the future value of an investment. You can also use the PV function to calculate the present value of a future payment, or the RATE function to calculate the interest rate for a loan or investment.

In addition to using these financial functions, you can also practice using Excel’s financial formulas and features to create more complex financial models. For example, you can use the PMT function in combination with other functions, such as IF and NPV, to create a model of a mortgage with variable interest rates. You can also use Excel’s goal seek and solver features to find the optimal values for input variables in your financial models.

Overall, practicing with Excel’s financial functions and features can help you learn how to use Excel for financial analysis and modeling, and can enable you to make better financial decisions based on the insights you uncover.

11. Practice using Excel to create reports and presentations

Another aspect that you want to practice in Excel is to properly generate attractive reports and presentations. In this project, you would use Excel to create reports and presentations such as financial statements or sales forecasts.

To begin, you would need to familiarize yourself with the Excel interface and its various features and functions. This may involve learning how to enter and format data, create formulas and functions, and use charts and graphs to represent data visually. Once you have a basic understanding of Excel, you can start working on creating your reports and presentations.

For example, if you were creating a financial statement, you would need to gather and enter the relevant financial data into Excel. This might include information on revenue, expenses, assets, and liabilities. You would then use Excel’s various functions and features to organize, calculate, and analyze the data, and create a professional-looking financial statement.

Similarly, if you were creating a sales forecast, you would need to gather data on past sales and market trends, and use Excel to create a projection of future sales. This might involve creating formulas and functions to calculate expected sales based on various factors, and using charts and graphs to represent the data visually.

Overall, using Excel to organize, calculate, and visualize data, and create professional-looking reports and presentations. This can be a valuable skill in a variety of industries, as Excel is a widely used tool for data analysis and presentation.

12. Use Excel to automate complex tasks and workflows

Excel is a powerful tool that allows users to automate processes using a combination of formulas, functions, and macros. In this project, you would use Excel to automate tasks such as data cleansing and validation, or data consolidation and aggregation.

To begin, you would need to familiarize yourself with the Excel interface and its various features and functions. This may involve learning how to enter and format data, create formulas and functions, and use charts and graphs to represent data visually. Once you have a basic understanding of Excel, you can start working on automating your tasks and workflows.

For example, if you were automating a data cleansing and validation process, you might use Excel to create a series of formulas and functions that automatically check for errors and inconsistencies in your data. This could involve using Excel’s built-in functions to check for missing or duplicated data, or to validate data against a set of rules or criteria. You could then use Excel’s macro capabilities to automate the process of running these checks and cleaning up the data.

Similarly, if you were automating a data consolidation and aggregation process, you might use Excel to create formulas and functions that automatically combine data from multiple sources and summarize it in a single location. This could involve using Excel’s built-in functions to merge data from different sheets or workbooks, or to calculate sums, averages, and other summary statistics. You could then use Excel’s macro capabilities to automate the process of running these calculations and consolidating the data.

Overall, this can be a valuable skill in a variety of industries, as Excel is a widely used tool for data analysis and automation. By using Excel to automate these tasks and workflows, you can save time and effort, and improve the accuracy and consistency of your data.

In conclusion, practicing and applying your Excel skills is essential for mastering the software and becoming an expert user.

The 12 Excel practice projects and exercises presented in this article provide a wide range of challenges and opportunities for learning and improving your skills. By working on these projects, you can gain hands-on experience and confidence in using Excel, and apply your knowledge to real-world situations.

Whether you are a beginner or an experienced user, these projects can help you take your Excel skills to the next level. So, why not pick a project and start practicing today?

Microsoft Excel Tutorials : Including Free Practice Exercises!

Right below you find +100 excel-tutorials. all tutorials are super practical and include free exercises. simply download the included sample file and start practicing your excel skills today.

More results...

Excel Line Spacing: How to Adjust Line Spacing (2024)

Excel Line Spacing: How to Adjust Line Spacing (2024) Sometimes, you may need to input a long text into your Excel spreadsheet. When you do, you need to make sure that it's organized and presentable, not only for your sake but for others as well😊 One of the many ways to do that [...]

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)

How to Calculate MEDIAN IF in Excel ("MEDIANIFS" Formula)Excel is a powerful tool that can help you easily analyze and manipulate data.One of the most useful functions in Excel is the median function, which helps find the middle value in a set of data.However, what if you only want to find the median of [...]

How to SUM by color in Excel: Step-by-Step Guide (2024)

How to SUM by color in Excel: Step-by-Step Guide (2024) Most of you know how to get the Excel SUM. It's one of the most basic Excel functions. What most people don't know is that you can get the Excel SUM by color, too 🤩 There is no built-in function for this but [...]

How to do RANK IF in Excel to Rank With Condition (2024)

How to do RANK IF in Excel to Rank With Condition (2024) Ranking values in Excel is something very common. And with the RANK function, that’s not even a problem. However, if you want to perform a conditional (or criteria-based) ranking in Excel, this might be a little problem at first 😣 That’s [...]

Excel Not Responding – Here is How to Fix it (2024)

Excel Not Responding - Here is How to Fix it (2024) Excel is a powerful tool used by millions of people around the world to handle data 💪🏻 However, it is common for Excel users to get issues with Excel files such as the Excel not responding error. This is such a frustrating [...]

“Reference isn’t Valid” Excel Error: How to Fix (2024)

"Reference isn't Valid" Excel Error: How to Fix (2024) When you're working in Excel to organize and analyze your data, you may encounter different types of Excel errors ⚠️ Getting Excel errors is so frustrating because it hinders you from getting work done 😩 The "Reference isn't Valid" error is one of the [...]

Excel Ran Out of Resources – How to Fix it Step-by-Step (2024)

Excel Ran Out of Resources - How to Fix it Step-by-Step (2024) Microsoft Excel is an amazing tool that we can use to do our calculations. But, sometimes you get a headache with Excel when there are errors 😞 Most of the time you have to sort out these issues by yourself because [...]

How to use the Excel functions TRUE & FALSE (Boolean)

How to use the Excel functions TRUE & FALSE (Boolean) Written by co-founder Kasper Langmann, Microsoft Office Specialist. There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. For example, you might manage a sales team. You [...]

How to Switch X and Y Axis in Excel (Flip Chart Axes)

How to Switch X and Y Axis in Excel (Flip Chart Axes) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble.  Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on [...]

How to Print Labels From Excel: Step-by-Step (2024)

How to Print Labels From Excel: Step-by-Step (2024) Mail Merge is one awesome feature that will help you create mass letters and email messages. But you can also use it to create and print mailing labels for your mailing list 😀 All you need to do is to prepare your label data in [...]

The 9 Best Project Management Templates for Excel (Free)

The 9 Best Project Management Templates for Excel (Free) Project managers are known for their decisiveness and time management. A project's success depends on how a project manager identifies, plans, and employs the resources available for any given project (especially the timespan). If you, too, have a complicated project ahead of you that [...]

Free Excel Dashboard Templates (My Top-6)

Free Excel Dashboard Templates (My Top-6) Excel dashboards are the difference between good and great data presentation. A well-built dashboard can breathe life into the most boring and mundane subjects. Simple Excel dashboards are easy enough to build if you follow a proper tutorial like ours here. But to truly wow your [...]

How to Create Macros in Excel: Step-by-Step Tutorial (2024)

How to Create Macros in Excel: Step-by-Step Tutorial (2024) Get ready to have your mind blown! 🤯 Because in this tutorial, you learn how to create your own macros in Excel! That’s right! And you don't need to know VBA (Visual Basic for Applications)! Instead, you will use the Excel macro recording feature [...]

How to Recover an Unsaved Excel File (5 Free Solutions)

How to Recover an Unsaved Excel File (5 Free Solutions) Losing an unsaved Excel file is a real pain🤕 Whether you lose an entire Excel spreadsheet or just the latest round of edits, it can take a lot of time to fix the problem. But don’t worry! In this guide, I’ve compiled the [...]

How to Insert a Checkbox in Excel (4 Uncomplicated Steps)

How to Insert a Checkbox in Excel (4 Uncomplicated Steps) If you want to collect user input in your spreadsheet there's no better way than the checkbox. User-friendly, slick-looking, and easy for you to work with. Well... After you learn it at least. If you're having a hard time understanding the ins [...]

How to Remove Blank Rows in Excel (3 Easy Methods)

How to Remove Blank Rows in Excel (3 Easy Methods) Choosing the right method to remove blank rows in Excel is crucial - a wrong move can lead to lost data. Method 1: Remove all rows that contain only blank cells Method 2: Remove all rows that contain one or more blank cells Method [...]

How to use the VLOOKUP Formula in Excel (Example)

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

How to Add Axis Labels in Excel Charts (X and Y Titles)

How to Add Axis Labels in Excel Charts (X and Y Titles) An axis label briefly explains the meaning of the chart axis. It's basically a title for the axis. Like most things in Excel, it's super easy to add axis labels, when you know how. So, let me show you 💡 If [...]

How to Use INDEX MATCH With Multiple Criteria in Excel

In this tutorial, you'll learn to use the MATCH INDEX functions with multiple criteria by following 5 easy steps. In the end, you'll have built a tool to search through your spreadsheet for information that you define. Don't miss this one!

How to Create a Drop-down List in Excel (in 60 Seconds)

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.

How to Drag a Formula Down in Excel (Fastest Way)

How to Drag a Formula Down in Excel (Fastest Way) One big reason why I and many other Excel users love Microsoft Excel is the “Drag and drop”  feature of Excel. You type a formula for one cell, drag the fill handle, and Excel automatically updates and populates the same for literally [...]

Excel Formula: Calculate Business Days (WORKDAY)

Excel Formula: Calculate Business Days (WORKDAY) Calculating how many more days  do you have to go to work before you plan for your vacations this year? Stop counting days on your fingers. Instead, let me show you how to do that in Excel in a few minutes only, if not seconds ⏰ [...]

How to Count Cells With Specific Text Using a Formula

How to Count Cells With Specific Text Using a Formula Counting cells with specific text in a worksheet is a task that one needs to perform on a daily basis to review large sets of data and extract information. Luckily, Excel offers a variety of methods you can use to find text in [...]

How to Calculate Ratios in Excel (Ratio Formula)

How to Calculate Ratios in Excel (Ratio Formula) Past is a good place to visit so how about I take you back to elementary mathematics where we studied ratios? Ratios express the quantitative relationship between two numbers that shows one number is how many times the other number. For example, if [...]

How to Instantly Expand The Formula Bar in Excel

How to Instantly Expand The Formula Bar in Excel One of the most important parts of an Excel worksheet is the Formula Bar. The Formula Bar is a toolbar that displays the Excel formulas or text entries in the cells of the worksheet. 🧐 Knowing how to expand the Excel formula bar can [...]

How to Not Calculate If Cell is Blank in Excel (Ignore Formula)

How to Not Calculate If Cell is Blank in Excel (Ignore Formula) In Data Analysis, accounting for blank cells is a regular task. But sometimes, you might want to ignore these empty cells when applying a formula to a range. It could be because the cell contains a null value that could result [...]

How to Make a Frequency Chart in Excel (Step-by-Step)

How to Make a Frequency Chart in Excel (Step-by-Step) Have you ever felt lost in a huge database of numbers trying to make sense of where everything fits in? In today’s data-driven world, that’s a common struggle. But what if I told you there is a tool that can help you visually see [...]

How to Search for Words and Names in Excel Sheet

How to Search for Words and Names in Excel Sheet If you’re always working with Excel workbooks with multiple worksheets containing rows and columns of information, finding relevant data can be overwhelming and stressful. 😩 But with Microsoft Excel’s Find feature, it doesn’t have to be. This feature allows you to search and [...]

How to Apply Excel Formula to Entire Column (Easy)

How to Apply Excel Formula to Entire Column (Easy) Excel's ability to apply formulas across a whole column in a single go makes it a superhero for number crunching🔢 Dragging a formula’s power down the whole column helps you save loads of time. It makes working just so much more efficient and accurate. [...]

How to Easily Calculate CAGR (Using Excel Formulas)

How to Easily Calculate CAGR (Using Excel Formulas) How do you assess the annual growth of a business  over a certain time (say 5 years 10 years or even more)? It is simple to tell that an investment grew by say 10% since the last year. But as the time horizon increases [...]