Excel Exercises helps regular people learn Excel as quickly as possible.
Our bite-sized, interactive lessons make excel skills easy to learn and remember..
![assignment for ms excel assignment for ms excel](https://excelexercises.com/excelImages/berkeleyLogo.webp)
Trusted by users from these organizations (& many more!)
![](http://rss3.fun/777/templates/cheerup/res/banner1.gif)
"I finished up all the lessons, they really helped me understand Excel logic better. Can't wait for more!"
"i stumbled across your website with excel exercises, and it's seriously an amazing resource [...] i seriously believe your platform proves to be one of the most efficient ways to learn excel", "when i first started the practice exercises at your site i just found it really acclerated my comprehension of excel. i started to understand it so much better than any other prior learning platform that i had visited.", a better way to learn excel skills.
Welcome to the fun, hands-on way to learn Excel! My name is Jake and I'm known as a spreadsheet wizard around my office, but it wasn't a fast or easy process to get here. I watched several hours worth of Excel training videos, but found I didn't really master a formula until I actually got my hands dirty and used the formula at work. It took me a few years of working in finance and consulting- using Excel nearly every day- to internalize all the keyboard shortcuts and functions. I started wondering why there wasn't an easier and faster way to master Excel.
Like I mentioned before, I spent hours watching Excel training videos, but they were honestly kind of boring. I'd find myself zoning out and would need to rewind and re-watch each video two or three times. And without immediately putting the techniques from the videos into practice, I'd forget the techniques right after watching the video.
Excel Practice For Real People
Practice Excel the right way - in small, bite-sized, engaging lessons, rather than falling asleep reading a lengthy article or daydreaming through a long video. This is Excel practice for those who learn by doing, not by watching. There's a reason thousands of people are choosing to get their Excel practice from Excel Exercises: because it works. Each lesson is designed to keep you engaged and entertained while walking you through new concepts, so that you can't advance if you're not absorbing the information. That's just one of the ways Excel Exercises helps you learn more efficiently and maximize your practice time.
Excel Exercises Solves the "Boring Video" Problem
We walk you through all the Excel functions that you need to know, forcing you to type through practice exercises to get hands-on and commit them to memory. You'll also practice keyboard shortcuts on your own keyboard to build muscle memory and get faster at manipulating spreadsheets. Through hands-on repetition and smart skills targeting, I've distilled all the skills I've learned from years of working with Excel to a program that can be completed in a matter of days.
Have Fun While You Learn With Excel Exercises
These practice exercises aren't just engaging; they are actually fun. Score points by answering questions correctly and advance through the levels as you learn, rather than relying on boring memorization. You'll start by practicing some easy skills and work your way up to practicing more advanced techniques. By gradually introducing new concepts for you to practice, we make it easy to learn all the techniques you need to become an Excel master. Whether you're searching for easy Excel practice exercises or more advanced formula practice, Excel Exercises offers a fun learning experience for all skill levels - it doesn't even feel like learning!
Thousands of people have already used Excel Exercises to practice Excel skills and advance their careers. Solid Excel skills are critical for most finance, accounting, consulting, and other data-oriented jobs. And let's be honest - if your shortcut game is on point you'll impress anyone watching over your shoulder. Learn Excel the fun way today and get your career moving in the right direction.
Use Excel Exercises to Excel-erate Your Career
Almost any job in Finance, Accounting, Data Science, Consulting, or any other quantitative industry will require you to use spreadsheets. By mastering Excel you can give yourself an edge by completing your work faster and better than your peers. Many jobs today also require an Excel test as part of the application and interview process. Whether you're applying for an internship or you're already an executive, Excel mastery is a tangible and noticeable skill that can help you get the offer, earn more money, and make yourself indispensable.
Today's job market demands strong spreadsheet skills like never before. Everything from simple data entry to advanced data analysis will require proficiency with Excel in order to pass the interview process and perform with the speed and quality necessary to thrive in your new job. Luckily, there are now more resources than ever available to help you learn Excel online. Excel Exercises is the first web-based Excel practice resource that simulates real Excel practice exercises right in your browser. Let Excel Exercises be your new secret weapon to master Excel and get a new job or move up in your current role.
No sign up necessary. If you love it, you can create an account and join thousands of others who are already using their new Excel skills to stand out and get ahead in their careers.
![assignment for ms excel Excel Exercises Keyboard Shortcuts](https://excelexercises.com/excelImages/icon2.webp)
Hands-on Exercises
Most people can't learn new skills simply by watching. There's a reason you hear that the best way to learn Excel is just to use it at work for a few years. But when you don't have years to learn Excel, your best option is the curated simulations offered by Excel Exercises. We walk you through new skills and let you write the actual formulas and tap out the keyboard shortcuts to build muscle memory and learn by doing. By focusing on one skill at a time, you'll get enough reps to commit the skill to memory before moving on.
![assignment for ms excel Excel Practice Exercises](https://excelexercises.com/excelImages/icon1.webp)
Excel Exercises for Beginners and Experts
Whether you already have some Excel experience or you've never written a "sum" function in your life, this site will teach you the tools to stand out at work as the Excel Master. It starts easy with simple functions to build a solid foundation. Then it becomes more challenging as the lessons incorporate new concepts, shortcuts, and advanced functions to build your skills, boost your efficiency, and expand on what you thought was possible with Excel. Whether you're a beginner or advanced, there is always a new Excel skill you can learn.
![assignment for ms excel Excel Exercises practice](https://excelexercises.com/logo2.png)
Practice And Learn Excel Online For Free
Here you can practice dozens of Excel exercises with full solutions and explanations. If you are new to excel, please check out our Excel Basics Tutorial!
The explanations can be found in the Answer tab in each of the exercises. Have fun 🙂
New! Excel Self Assessment – Test your Excel skills and understand what to learn next to be even better!
- Basic Math and Percentages Exercise
SUM Function
- SUM Tutorial and Practice
- SUM Function – Exercise 1
- SUM Function – Exercise 2
- SUM Function – Exercise 3
COUNT, COUNTA & COUNTBLANK Functions
- COUNT Tutorial and Practice
- COUNTA Tutorial and Practice
- COUNT & COUNTA Functions – Exercise 1
- COUNT & COUNTA Functions – Exercise 2
- COUNT, COUNTA & COUNTBLANK Functions – Exercise 3
AVERAGE Function
- AVERAGE Tutorial and Practice
- Average Function – Exercise 1
- Average Function – Exercise 2
- Average Function – Exercise 3
MIN/MAX Function
- MIN Tutorial and Practice
- MAX Tutorial and Practice
- MIN/MAX Function (combined with AVERAGE)
- MIN/MAX Function (combined with IF)
IF Function
- IF Tutorial and Practice
- IF Function – Exercise 1
- IF Function – Exercise 2
- IF Function – Exercise 3
- IF Function – Exercise 4
Nested IF Function
- Nested IF Tutorial and Practice
- Nested IF – Exercise 1
VLOOKUP Function
- VLOOKUP Tutorial and Practice
- VLOOKUP Function – Exercise 1
- VLOOKUP Function – Exercise 2
- VLOOKUP with Approximate Match – Exercise 3
HLOOKUP Function
- HLOOKUP Function – Exercise 1
SUMIF Function
- SUMIF Tutorial and Practice
- SUMIF Function – Exercise 1
- SUMIF Function – Exercise 2
COUNTIF Function
- COUNTIF Tutorial and Practice
- COUNTIF Function – Exercise 1
- COUNTIF Function – Exercise 2
SUMIFS Function
- SUMIFS Tutorial and Practice
- SUMIFS Function – Exercise 1
- SUMIFS Function – Exercise 2
COUNTIFS Function
- COUNTIFS Tutorial and Practice
- COUNTIFS Function – Exercise 1
- COUNTIFS Function – Exercise 2
Pivot Table
- Pivot tables Tutorial and Practice
- Pivot Table basics – Exercise 1
Practice Excel Exams and Tests
Want to test yourself? check out our Excel Practice Tests Page
Terms and Conditions - Privacy Policy
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 VLOOKUP in Excel: 4 Easy Steps (For Beginners)
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 Combine Rows in Excel (Without Losing Data)
How to Combine Rows in Excel (Without Losing Data) Combining rows in Excel is a common task when you need to merge data from multiple rows into a single row. Excel has a dedicated tool to merge & center rows and columns. However, you can use it to merge cells, but it won't [...]
How to Find Coefficient of Variation in Excel
How to find the Coefficient of Variation in Excel The Coefficient of Variation (CoV) is a statistical measure of the relative variability of data points in a data series around the mean. It is a handy comparative measure for evaluating the degree of variation between different datasets. It is widely used [...]
How to Separate Date and Time in Excel (Example)
How to Separate Date and Time in Excel (Example) Excel has a specific format that allows you to populate date and time together in a cell. Here’s how it looks. While this is a more comprehensive format, sometimes might not be something you desire. If you have such data at your disposal [...]
How to Sort by Last Name in Excel (Fast & Easy)
How to Sort by Last Name in Excel (Fast & Easy) When sorting names, Excel uses the first character of the full names, and sort data in alphabetical order. It’s quite easy. But what if you need to sort data by their last names? 🤔 It’s not a straightforward process but it can [...]
How to Change Axis Range in Excel (Step-by-Step)
How to Change Axis Range in Excel (Step-by-Step) Charts are one of the most powerful features of Excel that help to visualize data and recognise trends and patterns. The axis ranges of a chart are fixed by default and sometimes, they don’t align with our presentation needs. Luckily, you can easily change axis [...]
How to Keep a Cell Constant in an Excel Formula
How to Keep a Cell Constant in an Excel Formula Excel is known for its ability to handle complex formulas. And once you’ve put in all your brain to write up a formula, you can drag the fill handle to take it across multiple rows and columns in less than a second. But [...]
How to do Exponents in Excel (The Easy Way)
How to do Exponents in Excel (The Easy Way) Microsoft Excel is a powerful spreadsheet application that offers various methods for performing exponent calculations (essential for many mathematical, financial, and scientific tasks). You can use the simple caret symbol, or Excel functions like the POWER of EXP function for exponential calculations in MS [...]
How to Insert & Embed Excel into PowerPoint (Easy Method)
How to Insert & Embed Excel into PowerPoint (Easy Method) Inserting Excel sheets into PowerPoint is crucial if you work with Microsoft Apps regularly. It enhances the visual appeal and clarity of your presentations as you add tables, charts and data. PowerPoint lets you integrate an Excel sheet easily whether you want to [...]
How to Use the SLOPE Function in Excel (Examples)
How to Use the SLOPE Function in Excel (Examples) The SLOPE function in Excel is a powerful statistical function that lets you calculate the linear regressing through a set of data points 🧾 It essentially helps you understand how the changes in one variable are related to the changes in another variable. You [...]
How to Copy Excel Table Into Word (Works Every Time)
How to Copy Excel Table into Word (Works Every Time) Integrating data between Excel and Word can enhance efficiency and professionalism in a report. By copying Excel’s tables into Word, you get the chance to leverage Excel’s astounding data cleaning and calculation powers combined with Word’s robust document formatting 🎨 In this tutorial, [...]
![assignment for ms excel ExcelDemy](https://www.exceldemy.com/wp-content/uploads/2023/12/exceldemy-logo.png)
Excel Practice Exercises PDF with Answers
![assignment for ms excel Avatar photo](https://www.exceldemy.com/wp-content/uploads/2023/07/cropped-RAFIUL-HAQ-48x48.jpg)
To solve the following exercises, 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. You can use Excel 2010 or later, except for the UNIQUE function, which is only available in Excel 2021 .
Download the 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
Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet.
![assignment for ms excel](https://www.exceldemy.com/wp-content/uploads/2022/09/Excel-Practice-Exercises-PDF-with-Answers-1.png)
- 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.
![assignment for ms excel Excel Practice Exercises PDF with Answers](https://www.exceldemy.com/wp-content/uploads/2022/09/Excel-Practice-Exercises-PDF-with-Answers-3.png)
What is ExcelDemy?
![assignment for ms excel Rafiul Haq](https://www.exceldemy.com/wp-content/uploads/2023/07/cropped-RAFIUL-HAQ-69x69.jpg)
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
![assignment for ms excel Avatar photo](https://www.exceldemy.com/wp-content/uploads/2023/03/Shamima-Sultana-50x50.png)
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
![assignment for ms excel trustpilot review](https://www.exceldemy.com/wp-content/uploads/2023/11/Trustpilot_3-300x138.png)
- Create Basic Excel Pivot Tables
- Excel Formulas and Functions
- Excel Charts and SmartArt Graphics
- Advanced Excel Training
- Data Analysis Excel for Beginners
![assignment for ms excel DMCA.com Protection Status](https://images.dmca.com/Badges/dmca_protected_sml_120l.png?ID=04446b3b-bfd2-422f-8476-1ec7750afa0a)
Advanced Excel Exercises with Solutions PDF
![assignment for ms excel ExcelDemy](https://www.exceldemy.com/wp-content/uploads/2023/12/exceldemy-logo.png)
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.
![assignment for ms excel Get Certified](https://www.w3schools.com/images/img_summersale24_up_300.png)
COLOR PICKER
![assignment for ms excel colorpicker](https://www.w3schools.com/images/colorpicker2000.png)
Contact Sales
If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: [email protected]
Report Error
If you want to report an error, or if you want to make a suggestion, send us an e-mail: [email protected]
Top Tutorials
Top references, top examples, get certified.
![assignment for ms excel AutomateExcel Logo](https://www.automateexcel.com/assets/img/automateexcel-com-logo-151x55.webp)
Learning Center
Excel tutorials and practice tests.
Welcome to Automate Excel! Here you will find the best free Excel & VBA resources anywhere on the web. This page will direct you to all of our best content.
Scroll down the page to find detailed descriptions of our 100% FREE interactive tutorials, but you can use this top section to easily jump to our cornerstone resources.
![icon vba icon vba](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/icon-vba.png)
Our VBA Tutorial and our VBA Code Generator as well as over 100 free VBA Code Examples .
![icon excel icon excel](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/icon-excel.png)
Our VBA Formulas Tutorial and Excel Boot Camp as well as Formulas and Functions lists.
![icon shortcuts icon shortcuts](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/icon-shortcuts.png)
Our Excel ShortCut Training App , our popular ShortCut Coach Excel add-in and over 200 free Shortcuts .
![steve steve](https://www.automateexcel.com/excel/wp-content/uploads/2018/01/steve.jpg)
Automate Excel and Steve Rynearson
Hi I’m Steve, The Chief Excel Officer at AutomateExcel. I'm here to help you "Excel" at Excel.
![gears gears](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/gears.png)
Courses and Examples
Get started with excel.
To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials. These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.
The tutorials cover at least 80% of what most Excel users would ever need to know. Beginners love our tutorials because they’re the fastest (and easiest) way to learn Excel or VBA. We also receive many emails from experienced Excel users who report learning new tricks and brushing up on knowledge.
Our tutorials are completely free, but you will need to create an account to save your progress.
Our interactive tutorials also contain practice tests that allow you to test what you've learned. The practice tests also let you define a custom set of questions in which to test yourself.
Testimonials
100% free and interactive, excel practice tests and tutorials, formulas and functions.
Learn 30 of Excel's most powerful functions with 60 interactive exercises and many more examples:
- Intro to Formulas
- Logical & Comparison
- Statistical
Also learn about other formula essentials including:
- Formula Shortcuts
- Comparisons and Boolean Values
- How to use Text in Excel
![excel-function-app-sample excel exercises](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/excel-function-app-sample.png)
Keyboard Shortcuts
Learn 77 of Excel's most powerful shortcuts.
- Selecting Cells
- Rows & Columns
- Data & Other Tools
'Learn' section teaches you shortcuts. Then you can develop shortcut "muscle memory" with the Practice section and test your knowledge with the Test section
VBA for Excel
100 interactive exercises and many more examples, covering everything you need to become a VBA expert:
- Conditional Logic
- Adv Cell References
- Msg & Input Boxes
- Adv Procedures
![vba-tutorial-example4 practice vba macros](https://www.automateexcel.com/excel/wp-content/uploads/2018/03/vba-tutorial-example4.png)
Learn VBA Tutorial
Excel automation examples.
Have a specific need? We have hundreds of pages with specific tutorials, walk-throughs, and examples. All of our examples are listed in easy to search lists:
Get Excel Help!
Do you have a problem you can’t solve? Do you need an Excel Automation expert? Learn more about our Excel / VBA consulting services:
![](http://rss3.fun/777/templates/cheerup/res/banner1.gif)
Excel and VBA Consulting
More free help, free spreadsheets, tutorials and add-ins, premium excel & vba tools and tutorials.
![assignment for ms excel Spreadsheet Center](https://spreadsheetcenter.com/wp-content/uploads/2020/02/SpreadsheetCenterLogoSmall-1-e1582122685313.png)
Excel Beginner Exercises
In this article, I’m going to walk you through a couple of Excel exercises that are perfect for beginners. We will slowly ramp up the difficulty from beginner to advanced so if things are too easy for you, just scroll down a bit.
Getting started with formulas
‘Formulas?!’ You may be thinking. ‘That’s way too advanced for a first Excel beginner exercise.’ It’s not really. Let me explain why: formulas and functions are the bread and butter of Excel. If you want to work with Excel, it is wise to at least know what a formula looks like and why a formula is handy. That’s why we’re starting with this. Don’t worry, they are really not as complicated as they sound.
So let’s jump into it. We will be calculating the result of 32+57. However, we won’t be doing that ourselves, we will be making Excel do the hard work for us.
To start with a formula in Excel, we have to fill in the equals sign = into a cell. After that, we add our formula, so 32+57 in this case. The resulting cell content becomes =32+57 .
![assignment for ms excel Formula](https://spreadsheetcenter.com/wp-content/plugins/j-custom/img/function_icon.png)
Note: all of our exercises have a Show answer button in the top-right that you can click if you cannot figure out what the answer has to be. After clicking Show answer , you can click on the cell to see the formula that was used in the formula bar. You can also reset the editor back to its default contents using the Reset button.
I hope the number 89 is showing in cell A1 of the spreadsheet editor above. The cool thing about this is that you can substitute the + for a minus – and it will also work. Or you can use the asterisk * to multiply. Or the slash / to divide. You can try all of these different calculations in the editor above if you want.
And just like that, you have learned how Excel formulas work! You can now get rid of your calculator 😉
Using Excel beginner functions: SUM
Now that we’ve seen how to include formulas in Excel spreadsheets, we can get to the real deal: functions. Functions are basically formulas with names. It’s easiest to understand with an example:
The SUM function will sum the values that you give it. We can recreate the formula that we created in the exercise above ( =32+57 ), but using the SUM function. That would look like this:
=SUM(32,57)
If you write this in a cell, it will show 89 . Exactly as you may expect. But you can add more numbers (separated by commas) to the function: =SUM(32,57,1) will result in 90, for example.
In this next exercise, we will combine the SUM function with another interesting Excel feature: references. So what are references? Once again, an example will explain this very quickly. Look at the following formula:
=SUM(A1,A2)
What do you think the result will be? The answer is: it depends. That’s because the formula uses references to cells A1 and A2 .
We know the SUM function will sum the values that you give it, but in this case we give it references to cells. When you do that, it will instead sum the contents of the cells that you reference. So the result will be different depending on the values in cells A1 and A2 . If cell A1 contains 1 and cell A2 contains 2 , then the result will be 3 .
These references can be super handy because they update automatically if the contents of the cells change. Whenever you edit the value in cell A1 , the result of =SUM(A1, A2) will also automatically update! And that’s why references are so ridiculously useful.
Now, let’s get to the exercise. We will be using the SUM function to calculate our total monthly income after expenses.
Calculating income using SUM
I hope that wasn’t too difficult. Or if it was a little difficult, that when you looked at the answer, it made sense.
Note about the answer: if you looked at the answer to the above exercise, you saw a notation that you may not have seen before. =SUM(B2:B5) . The colon : is used to mean a cell range . In this case, that means cells B2 up to and including B5 . So it is equivalent to using =SUM(B2,B3,B4,B5) . In Excel, there are often multiple ways of solving the same problem. I’d encourage you to use the solution that is most intuitive to you.
A step up: Average
Calculating the average of a group of numbers is quite simple: you sum them all up and divide by how many number you have. For example, the average of the number 1, 2, 3, 4 and 5 is: 1 + 2 + 3 + 4 + 5 divided by 5, because there are 5 numbers.
You could do this in Excel by typing =SUM(1,2,3,4,5)/5 into a cell. But there is an easier way. You can simply use the AVERAGE function. Let’s do so in an Excel exercise.
Note: you may have noticed by now that both of these functions are written in all-caps. That’s just the way function names in Excel are. So it may look like I’m screaming SUM at you, but that’s just how it is written.
More practical: Concatenate
We’ve seen functions that use numbers, now let’s look at another type of function: text functions. They are functions that take text as input or that result in text output (or usually both).
Before we get to the exercise, you need to know something about text in Excel formulas. Texts in Excel formulas are almost always surrounded by double quotes “. That’s just the way to let Excel know that it is a text.
Concatenate first and last names exercise
For the fourth of our Excel beginner exercises, we will be combining the contents of two cells. The first cell will have a first name, the second cell will have a last name in it. We would like to fill the third cell with the first name, then a space and then the last name.
We can do this using the CONCATENATE function. The CONCATENATE function looks like this: =CONCATENATE("text1","text2","text3") . If we would run this function, it would result in text1text2text3 . So it just combines the texts that you give it.
More Excel Exercises
That was it for our Excel beginner exercises. I hope you’ve learned something new today. If you just can’t get enough of these types of exercises, we have an Excel exercises page filled to the brim with exercises to dig your teeth into.
5 thoughts on “Excel Beginner Exercises”
- Pingback: How to Learn Excel Fast: 3 Principles to Learn Excel Quickly
Helpful and clear for beginners.
Written with very clear instructions except with the CONCATENATE. Unfortunately I cannot figure this simple formula.
This is awesome
Leave a Comment Cancel reply
Save my name, email, and website in this browser for the next time I comment.
8 Excel Project Ideas To Improve Your Skills + Build Your Portfolio
![assignment for ms excel Travis Cuzick](https://images.ctfassets.net/aq13lwl6616q/3pDlsJEycpxhELPjYoeB5n/649b046d270bfb894766eea35fcaa0f3/Travis_Cuzick_Profile_Picture.png?h=150&fm=webp)
Travis Cuzick
![assignment for ms excel hero image](https://images.ctfassets.net/aq13lwl6616q/1eIRrhb23iuUt4YagSTqRC/0fb2af4f20eb1c98c4ae98045a1d20de/8_excel_practice_projects.png?w=700&h=394&q=50&fm=png&bg=transparent)
In This Post:
1: personal finance management tool, 2: employee scheduling planner, 3: inventory management system, 4: loan calculator, 5: student grade manager, 6: fitness tracker, 7: sales trend analysis, 8: dynamic dashboard, which will you solve first.
One thing I’ve found from working with Excel spreadsheets for well over a decade , is that regardless of how much you know about Excel, there’s always more to learn .
But just acquiring more knowledge has its limits, and oftentimes the best way to learn is by doing and applying what you've learned so far.
That’s why if you want to truly master Excel, then you need to solve messy, complex, real-world problems with it .
With that in mind, here are 9 Excel project ideas that will strengthen the skills you already have, AND inspire you to add plenty of new ones to add to your Excel toolbox .
However, there’s a slight caveat. I want to make this practice as realistic as possible.
What do you mean?
Well, in the real world, you’ll usually start off with raw data from sources.
It’s then up to you to:
- Figure out what's important
- Clean it up
- And extract insights from that data to meet your goals
That's why I’m not going to give you specific steps to follow like I would in a normal tutorial . That’s easy mode.
Instead, I’m going to assign tasks for you to figure out how to implement for yourself , as if you were a Data Analyst being assigned a project, or if you were sitting for an interview.
The goal is for you to go through each recommended task and try to figure out how you would apply each of the recommendations that I give you. (Like an exam question but with less pressure).
Don’t worry, as I’ll give some hints along the way.
The basic structure will be:
- You map out the problem
- Figure out a solution
- Then try to build it in Excel on your own
This proactive approach will not only help you to test out your skills but it’ll also push you beyond your comfort zone that you actually improve your skills by working on real world projects.
So let’s dive in!...
Sidenote: If you struggle to figure out how to solve some of these problems, are not sure how the features work, or simply want to improve your Excel skills, then check out my complete Excel course .
![assignment for ms excel learn excel](https://images.ctfassets.net/aq13lwl6616q/178GTaW4WXjKSsqH0fQHlH/45362f093666ba9a4a9a91effe5e0ce5/learn_excel.jpg)
It’s the only course you need to become an Excel and Data Analysis master. You’ll learn Excel from scratch including advanced topics like data analysis & modeling, pivot tables, and VBA. You'll build your own professional spreadsheets and charts, and have the skills to get hired as a Data Analyst in 2024! Check it out here , or watch the first videos for free . As an added bonus, not only do you get access to the course content, but you can also ask me, and other students questions in our private Discord channel .
With that out of the way, let’s dive into these Excel projects!
![assignment for ms excel budget and investment](https://images.ctfassets.net/aq13lwl6616q/1xxoumH4janCCmA64uq2JA/f158a4ddc5fd2497b05bd7d0d8d645b1/budget_and_investment.png?w=720&fm=webp)
Are you ready to up your finance game and take control of your money?
For this Excel project, you'll design and build a personal finance management tool to help you keep track of your investments, savings, and debts.
Recommended tasks
- Setting up a budget
- Tracking your income and expenses
- Analyzing your spending patterns
- Visualize your financial data
Next, you'll dive into managing investments by:
- Keeping track of stock prices, dividends, and portfolio performance
- And, of course, you'll be able to manage your savings and track your debts so you can see exactly where your money is going
Recommended skills
This project will give you the opportunity to practice and strengthen your Excel skills by leveraging:
- and many other Excel features
But beyond just technical skills, you'll also learn some pretty important life skills - like how to create a budget, track your spending, and make informed financial decisions.
And, by managing your investments, savings, and debts in one place ( hint ), you'll have a clear picture of your financial situation and be able to make more informed decisions about your money.
Again, if you're reading this and thinking... "I still have no idea where to start" then come take my Excel Bootcamp course where I take you step-by-step to build a project just like this.
![assignment for ms excel employee schedule](https://images.ctfassets.net/aq13lwl6616q/2x911tBDYzqSe8KtXVuzTX/a62275bf0efa02c12b6a563c97b5c669/employee_schedule.png?w=577&fm=webp)
Imagine you're the manager of a company and you need to create a weekly schedule for your employees.
Your mission here then will be to develop an employee schedule planning tool that can help you easily create a schedule that takes into account each employee's availability and preferred hours.
- You'll start by gathering information on your employees' schedules, including the days and hours they're available to work
- Then, using that information, you'll create an Excel spreadsheet that generates a weekly schedule for your team
- The schedule should be flexible and allow for changes, such as time off requests or shift swaps.
The end result should be a user-friendly and efficient schedule planner that saves time and reduces manual effort.
- Organizational planning
- Conditional formatting
![assignment for ms excel inventory management](https://images.ctfassets.net/aq13lwl6616q/5NpfX0u72LF36pfyz1znih/009260b0cc7c1b59e10a710a4273a4b6/inventory_management.png?w=667&fm=webp)
Looking for a practical, real-world project using Microsoft Excel? Try designing and building an inventory management spreadsheet for an ecommerce business.
There are millions of ecomm stores these days and any of them selling a physical good are likely having to manage inventory.
There are definitely tools out there that help track this for businesses but they can be expensive or might not be exactly what the business needs. Most people still rely on Excel.
So this is definitely something you could build for a business and deliver a lot of value.
The ultimate objective of this project is to:
- Track inventory levels
- Generate reports to help the business keep track of what they have in stock
- Bonus points if you can do some time-series analysis and estimate future sales volume.
- More bonus points if you set it up with alerts for when the business should replenish inventory (so they don't run out!)
You'll need to make sure the spreadsheet can update in real-time as inventory levels change, and provide an easy-to-read overview of what's going on with the business's inventory.
Building this out will give you a taste of what it's like to work on a realistic business problem. You'll learn about the different factors that go into managing inventory, like keeping track of stock levels, assessing customer demand, reordering products, and generating reports for management.
This is the kind of stuff that you'll use in your future career, no matter what industry you end up in .
So by completing this project, you'll add a valuable showpiece to your portfolio, that demonstrates to future employers that you not only know how to use Excel, but that you can apply your skills to real-world scenarios to create something useful for a business.
![assignment for ms excel loan](https://images.ctfassets.net/aq13lwl6616q/53vJho1tAnQDqhRnfZXWLc/97ef368eb020184c74e8176f1202eaa5/loan.png?w=720&fm=webp)
Another great way to challenge your Microsoft Excel skills is to build a loan calculator spreadsheet.
The idea is simple. You'll create a spreadsheet that helps calculate how much people will pay on a loan including the interest and amortization.
You'll need to think about what information you need from the user, like the loan amount, interest rate, and number of years.
Then you'll use that information to calculate the monthly payment, total interest paid, and the amortization schedule.
The end result should be a user-friendly spreadsheet that anyone can use to calculate their loan payments.
It's a great opportunity to boost your Excel skills, learn about personal finance, and develop your problem-solving abilities - all while having fun and creating a useful tool that you can actually use in real life!
![assignment for ms excel student test score](https://images.ctfassets.net/aq13lwl6616q/4xoOJXY8KtmQuISgzM8D9l/f4ff41e359e997bd8ece258cf732285e/student_test_score.png?w=660&fm=webp)
Another great way to hone your Excel skills while solving a real-world problem is to build a spreadsheet that makes it easy for teachers to track and manage students' grades.
With this tool, you'll be able to input grades for each student, across different classes, and then calculate their overall GPAs. (And no, you can’t make it automatically give you an A+ - sorry!)
- To start, you'll need to set up the basic structure of the spreadsheet, including columns for the student name, class name, individual grades, and GPA
- Then you'll get to work creating formulas that will automatically calculate the overall GPA for each student. This means that every time you add a new grade for a student, their GPA will be updated automatically
In the end, you’ll have created a tool that saves teachers time and makes it easy for them to keep track of their students' grades.
All your Excel skills, from formula and function wizardry to data management, will be that much sharper as a result.
![assignment for ms excel fitness tracker](https://images.ctfassets.net/aq13lwl6616q/7a9HsVA8L83kCGQsnHj5u5/78ab3dd29c1f4f7b0c3efb054ef16f20/fitness_tracker.png?w=577&fm=webp)
For your next Microsoft Excel project, try creating a fitness tracker spreadsheet.
(A good way to answer some of the questions to build this, is to imagine you’re creating this tool to help you set your own fitness goals).
Here are just a few ideas for features you could include in your project:
- A section to record all your workout details, including date, type of workout, duration, and any notes you want to include
- A way to calculate and track your progress, such as your total calories burned, miles ran, or weight lifted
- A section to set fitness goals and track your progress towards reaching them
- Any charts or graphs you want to include to visually represent your progress over time
- Visualization
You'll learn about many of the cool things you can do with Excel as you design this spreadsheet to meet your requirements, while also making it usable and visually appealing.
![assignment for ms excel sales trend analysis](https://images.ctfassets.net/aq13lwl6616q/6GAVz9OqlV9OxgBkA5Psbe/928846266df07a16802fd8ff0549fc6e/sales_trend_analysis.png?w=720&fm=webp)
If you're looking for a way to flex those analytical muscles, how about creating a spreadsheet to analyze sales trends for a business?
This project will give you the opportunity to dive deep into sales data to find meaningful insights that can help management make informed decisions.
You'll start by collecting sales data from a business and then organizing it in a spreadsheet. But that’s just a prelude to the fun stuff... leveraging Excel’s vast feature set to:
- Analyze the data
- Identify patterns and trends, and ultimately
- Make some recommendations
- Create charts and graphs to visualize the data
- Use conditional formatting to highlight important information
- Use PivotTables to summarize and aggregate data
- And you could even play around with the Excel Data Model . (The Data Model helps when working with huge datasets. Although you don’t technically have any data to work with, running your solution through there, is good practice)
Think of this as your chance to see what it would be like to be a Data Analyst for a day !
By the end of the project, you'll have a better understanding of how sales data can be used to make a real impact on a business.
And you’ll also get to flex your problem-solving muscles as you figure out how to turn raw sales data into meaningful insights, and present those findings in a clear and compelling way.
![assignment for ms excel power bi dashboard](https://images.ctfassets.net/aq13lwl6616q/1JrF2lwPBEwoR94s0k93vb/6bfa3d7e444fcaf923a0c251ff72f3e9/power_bi_dashboard.jpg?w=0&fm=webp?w=519&fm=webp)
The goal of this project is to create a dashboard that allows users to explore and interact with the data in different ways.
The end result will be a dynamic dashboard that provides valuable insights and helps users make informed decisions based on the data.
For example
The user should be able to specify a particular time period, or filter the data by any number of the attributes in the dataset. Helpful right?
Ok so some spoilers, as this is technically some more advanced features to standard Excel:
- You'll start by cleaning and transforming your data using Power Query
- Then you'll use DAX, Pivot Tables and formulas to create calculated fields and perform analysis on the data
- You'll then create charts and other visualizations that present the data in a way that makes it easy to understand
For this project, you use Excel's business intelligence tools to create a dynamic dashboard that presents data in an interactive and visually appealing way .
You'll be working with tools like:
- Pivot Tables
- Power Query, and
This project is a great opportunity for you to apply your advanced Excel skills, while also developing your business intelligence and data analysis skills .
BONUS: Create a retirement planning tool
One final project, and unlike the others on this list, this one is actually guided to help you improve your skills .
In fact, it's a new mini-course project that I just created for members of Zero To Mastery to test and improve their Excel skills.
Ideal for both intermediate and advanced users, this project combines practicality with complexity, enabling you to go beyond Excel's basic functionality to build a genuinely useful, interactive tool - a perfect way to keep those Excel muscles active and growing.
The goal of the project is for you to create a retirement planning tool using Excel, that you can use yourself and help you start planning that early retirement you've dreamed of.
The skills you hone in this project have real-world applications, enhancing your employability in roles that require data analysis, financial planning, and spreadsheet management. So get ready for a journey that combines education with excitement and practicality, as you transform a starter file into a fully-fledged Retirement Planning Tool.
You'll build charts and other visual elements that instantaneously update as you smoothly change inputs with slider controls and drop-down lists, reflecting the impact of different retirement ages on your projected retirement savings.
But as an equally important part of the project, you'll also engineer a formula-driven calculation engine that - while unseen to the end user - forms the heartbeat of the tool.
This project isn't just a learning exercise...it's a demonstration of your prowess with Excel and an asset for your portfolio.
- An intermediate to advanced knowledge of Excel
That being said, remember that this is a guided project, so you'll be able to also learn more of the intricacies and advanced methods as you go.
So there you have it - 9 practice project ideas that will help you level up your skills from spreadsheet All-Star to Excel MVP. Showing a potential employer any of these projects will definitley make you stand out as well.
- Do you have an idea which you’ll do first?
- How about the problems? Do you think you can solve them and set up the code in Excel to perform each task if you added in a dataset?
If so, then get to work and start creating these now! The best way to learn is to apply what you know in new situations and problems.
And if you’re struggling to figure out how to solve some of these problems, are not sure how the features work, or simply want to improve your Excel skills, then check out my complete Excel course .
It’s the only course you need to become an Excel and Data Analysis master.
You’ll learn Excel from scratch including advanced topics like data analysis & modeling, pivot tables, and VBA.
You'll build your own professional spreadsheets and charts, and have the skills to get hired as a Data Analyst in 2024!
Check it out here , or watch the first videos for free.
Don’t forget: Not only do you get access to the course content, but you can also ask me, and other students questions in our private Discord channel .
![assignment for ms excel The Excel Bootcamp: Zero to Mastery](https://images.ctfassets.net/aq13lwl6616q/2JT9VosnF480izRmFTbum/0c6ebf1c08f6b8e6e9d96c0a2791e0c9/Excel_-_FINAL_DESIGN__FINAL_.png?w=400&fm=webp)
The Excel Bootcamp: Zero to Mastery
Become a data wizard in Excel. Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or supplement your career with data analysis & science skills & get hired in 2024.
![assignment for ms excel Power BI Bootcamp: Zero to Mastery](https://images.ctfassets.net/aq13lwl6616q/55yI2ny6X0aeRLoOCom6bY/c3b2914defed6c5135af4dba768cce98/Course_Thumbnail_6_-_PowerBI.png?w=400&fm=webp)
Power BI Bootcamp: Zero to Mastery
Go from absolute beginner in Power BI to getting hired as a confident and effective Analyst. Learn Power BI (+ much more) by analyzing real-world datasets and building enterprise-level projects.
![assignment for ms excel VBA Programming Bootcamp: Zero to Mastery](https://images.ctfassets.net/aq13lwl6616q/2OveeW82JJeDKBTzT7X5H8/23d755dfe4dcace9338201c0daecca51/Course_Thumbnail_-_Excel_and_VBA.png?w=400&fm=webp)
VBA Programming Bootcamp: Zero to Mastery
Become a data analytics pro by using VBA (Visual Basic for Applications) Programming in Excel. Learn VBA Macros, Variables, Userforms, Loops, Arrays, and Pivot Tables. Build your career in data analysis & get hired.
![assignment for ms excel Advanced Excel Bootcamp: Data Analytics and Business Intelligence](https://images.ctfassets.net/aq13lwl6616q/2n1XBWfwVs3XyltFQ6ECzA/7c77783335cddcd14b40121417520d51/Course_Thumbnail_-_Business_Intelligence_with_Excel_-_Academy_2.png?w=400&fm=webp)
Advanced Excel Bootcamp: Data Analytics and Business Intelligence
Become a Data Professional. You'll learn to master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more.
More from Zero To Mastery
![assignment for ms excel Top 5 Reasons To Become A Business Intelligence Analyst preview](https://images.ctfassets.net/aq13lwl6616q/6EPPYABONWsOpiPzLLxRyX/c6a7911a681f9896cd487aff98fee221/top_5_reasons_to_become_a_bi_analyst.png?w=400&h=225&q=50&fm=png&bg=transparent)
If you enjoy numbers, problem-solving, and finding out WHY things happen, then becoming a Business Intelligence Analyst might be the perfect new role for you!
![assignment for ms excel Travis Cuzick](https://images.ctfassets.net/aq13lwl6616q/3pDlsJEycpxhELPjYoeB5n/649b046d270bfb894766eea35fcaa0f3/Travis_Cuzick_Profile_Picture.png?w=35&fm=webp)
This VBA tutorial will teach you 3 VBA loops that you can use in VBA for Excel to automate repetitive tasks. You'll learn For Next, Nested, and For Each Loops.
![assignment for ms excel Top 5 Reasons Why You Should Learn VBA For Excel preview](https://images.ctfassets.net/aq13lwl6616q/2mA5qerWFqEMI4AODTA9Qa/bd63058a373f429d2d56e0bd75f824f6/Top_5_reasons_to_learn_VBA.png?w=400&h=225&q=50&fm=png&bg=transparent)
Still not even sure if you should learn VBA for Excel? We break down our top 5 reasons why you should start learning VBA and how you can get started today.
- Ablebits blog
- Excel formulas
Basic Excel formulas & functions with examples
![Svetlana Cheusheva Svetlana Cheusheva](https://cdn.ablebits.com/_img-blog/authors/small/svetlana-cheusheva.jpg)
The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials.
Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. It enables you to total or average a column of numbers in the blink of an eye. Apart from that, you can compute a compound interest and weighted average, get the optimal budget for your advertising campaign, minimize the shipment costs or make the optimal work schedule for your employees. All this is done by entering formulas in cells.
This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel.
The basics of Excel formulas
Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?
- Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.
For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)
![Basic Excel functions Basic Excel functions](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-functions.png)
Clicking the function's name will turn it into a blue hyperlink, which will open the Help topic for that function.
Tip. You don't necessarily have to type a function name in all caps, Microsoft Excel will automatically capitalize it once you finish typing the formula and press the Enter key to complete it.
10 Excel basic functions you should definitely know
What follows below is a list of 10 simple yet really helpful functions that are a necessary skill for everyone who wishes to turn from an Excel novice to an Excel professional.
The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition:
In the syntax of all Excel functions, an argument enclosed in [square brackets] is optional, other arguments are required. Meaning, your Sum formula should include at least 1 number, reference to a cell or a range of cells. For example:
=SUM(B2:B6) - adds up values in cells B2 through B6.
=SUM(B2, B6) - adds up values in cells B2 and B6.
If necessary, you can perform other calculations within a single formula, for example, add up values in cells B2 through B6, and then divide the sum by 5:
=SUM(B2:B6)/5
To sum with conditions, use the SUMIF function: in the 1st argument, you enter the range of cells to be tested against the criteria (A2:A6), in the 2nd argument - the criteria itself (D2), and in the last argument - the cells to sum (B2:B6):
=SUMIF(A2:A6, D2, B2:B6)
![Using SUM formulas in Excel Using SUM formulas in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-sum-function.png)
Useful resources:
- Excel Sum formula examples - formulas to total a column, rows, only filtered (visible) cells, or sum across sheets.
- Excel AutoSum - the fastest way to sum a column or row of numbers.
- SUMIF in Excel - formula examples to conditionally sum cells.
- SUMIFS in Excel - formula examples to sum cells based on multiple criteria.
The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers. Its syntax is similar to SUM's:
Having a closer look at the formula from the previous section ( =SUM(B2:B6)/5 ), what does it actually do? Sums values in cells B2 through B6, and then divides the result by 5. And what do you call adding up a group of numbers and then dividing the sum by the count of those numbers? Yep, an average!
The Excel AVERAGE function performs these calculations behind the scenes. So, instead of dividing sum by count, you can simply put this formula in a cell:
=AVERAGE(B2:B6)
To average cells based on condition, use the following AVERAGEIF formula, where A2:A6 is the criteria range, D3 is he criteria, and B2:B6 are the cells to average:
![Using an Average formula in Excel Using an Average formula in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-average-function.png)
- Excel AVERAGE - average cells with numbers.
- Excel AVERAGEA - find an average of cells with any data (numbers, Boolean and text values).
- Excel AVERAGEIF - average cells based on one criterion.
- Excel AVERAGEIFS - average cells based on multiple criteria.
- How to calculate weighted average in Excel
- How to find moving average in Excel
MAX & MIN
The MAX and MIN formulas in Excel get the largest and smallest value in a set of numbers, respectively. For our sample data set, the formulas will be as simple as:
=MAX(B2:B6)
![Using MIN and MAX formulas in Excel Using MIN and MAX formulas in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-max-min-function.png)
- MAX function - find the highest value.
- MAX IF formula - get the highest number with conditions.
- MAXIFS function - get the largest value based on multiple criteria.
- MIN function - return the smallest value in a data set.
- MINIFS function - find the smallest number based on one or several conditions.
COUNT & COUNTA
If you are curious to know how many cells in a given range contain numeric values (numbers or dates), don't waste your time counting them by hand. The Excel COUNT function will bring you the count in a heartbeat:
While the COUNT function deals only with those cells that contain numbers, the COUNTA function counts all cells that are not blank , whether they contain numbers, dates, times, text, logical values of TRUE and FALSE, errors or empty text strings (""):
For example, to find out how many cells in column B contain numbers, use this formula:
=COUNT(B:B)
To count all non-empty cells in column B, go with this one:
=COUNTA(B:B)
In both formulas, you use the so-called "whole column reference" (B:B) that refers to all the cells within column B.
![COUNT and COUNTA formulas in Excel COUNT and COUNTA formulas in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-count-counta-functions.png)
- Excel COUNT function - a quick way to count cells with numbers.
- Excel COUNTA function - count cells with any values (non-empty cells).
- Excel COUNTIF function - count cells that meet one condition.
- Excel COUNTIFS function - count cells with several criteria.
Judging by the number of IF-related comments on our blog, it's the most popular function in Excel. In simple terms, you use an IF formula to ask Excel to test a certain condition and return one value or perform one calculation if the condition is met, and another value or calculation if the condition is not met:
For example, the following IF statement checks if the order is completed (i.e. there is a value in column C) or not. To test if a cell is not blank, you use the "not equal to" operator ( <>) in combination with an empty string (""). As the result, if cell C2 is not empty, the formula returns "Yes", otherwise "No":
![Using an IF formula in Excel Using an IF formula in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-if-function.png)
- IF function in Excel with formula examples
- How to use nested IFs in Excel
- IF formulas with multiple AND/OR conditions
If your obviously correct Excel formulas return just a bunch of errors, one of the first things to check is extra spaces in the referenced cells (You may be surprised to know how many leading, trailing and in-between spaces lurk unnoticed in your sheets just until something goes wrong!).
There are several ways to remove unwanted spaces in Excel, with the TRIM function being the easiest one:
For example, to trim extra spaces in column A, enter the following formula in cell A1, and then copy it down the column:
![Excel TRIM formula Excel TRIM formula](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-trim-function.png)
- Excel TRIM function with formula examples
- How to delete line breaks and non-printing characters
- How to remove non-breaking spaces ( )
- How to delete a specific non-printing character
Whenever you want to know the number of characters in a certain cell, LEN is the function to use:
Wish to find out how many characters are in cell A2? Just type the below formula into another cell:
![Using a LEN formula in Excel Using a LEN formula in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-len-function.png)
Want to get the total count of characters in a range or cells or count only specific characters? Please check out the following resources.
- Excel LEN formulas to count characters in a cell
- Count the number of characters in cells and ranges
AND & OR
These are the two most popular logical functions to check multiple criteria. The difference is how they do this:
- AND returns TRUE if all conditions are met, FALSE otherwise.
- OR returns TRUE if any condition is met, FALSE otherwise.
While rarely used on their own, these functions come in very handy as part of bigger formulas.
For example, to check the test results in columns B and C and return "Pass" if both are greater than 60, "Fail" otherwise, use the following IF formula with an embedded AND statement:
=IF(AND(B2>60, B2>60), "Pass", "Fail")
If it's sufficient to have just one test score greater than 60 (either test 1 or test 2), embed the OR statement:
![IF formulas with embedded AND/OR statements IF formulas with embedded AND/OR statements](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-and-or.png)
- Excel AND function with formula examples
- Excel OR function with formula examples
CONCATENATE
In case you want to take values from two or more cells and combine them into one cell, use the concatenate operator (&) or the CONCATENATE function:
For example, to combine the values from cells A2 and B2, just enter the following formula in a different cell:
=CONCATENATE(A2, B2)
To separate the combined values with a space, type the space character (" ") in the arguments list:
![Using a CONCATENATE formula in Excel Using a CONCATENATE formula in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-concatenate-function.png)
- How to concatenate in Excel - formula examples to combine text strings, cells and columns.
- CONCAT function - newer and improved function to combine the contents of multiple cells into one cell.
TODAY & NOW
To see the current date and time whenever you open your worksheet without having to manually update it on a daily basis, use either:
=TODAY() to insert the today's date in a cell.
=NOW() to insert the current date and time in a cell.
![Using the TODAY and NOW functions in Excel Using the TODAY and NOW functions in Excel](https://cdn.ablebits.com/_img-blog/excel-formulas/excel-today-now-functions.png)
- How to insert today's date in Excel - different ways to enter the current date in Excel: as an unchangeable time stamp or automatically updatable date and time.
- Excel date functions with formula examples - formulas to convert date to text and vice versa, extract a day, month or year from a date, calculate the difference between two dates, and a lot more.
Best practices for writing Excel formulas
Now that you are familiar with the basic Excel formulas, these tips will give you some guidance on how to use them most effectively and avoid common formula errors.
Do not enclose numbers in double quotes
Any text included in your Excel formulas should be enclosed in "quotation marks". However, you should never do that to numbers, unless you want Excel to treat them as text values.
For example, to check the value in cell B2 and return 1 for "Passed", 0 otherwise, you put the following formula, say, in C2:
=IF(B2="pass", 1, 0)
Copy the formula down to other cells and you will have a column of 1's and 0's that can be calculated without a hitch.
Now, see what happens if you double quote the numbers:
=IF(B2="pass", "1", "0")
![Enclose text values in double quotes, but not numbers Enclose text values in double quotes, but not numbers](https://cdn.ablebits.com/_img-blog/excel-formulas/double-quote-text.png)
Don't format numbers in Excel formulas
Match all opening and closing parentheses, copy the same formula to other cells instead of re-typing it.
![Copying the formula to adjacent cells Copying the formula to adjacent cells](https://cdn.ablebits.com/_img-blog/excel-formulas/copy-formula-excel.png)
Note. After copying the formula, make sure that all cell references are correct. Cell references may change depending on whether they are absolute (do not change) or relative (change).
How to delete formula, but keep calculated value
When you remove a formula by pressing the Delete key, a calculated value is also deleted. However, you can delete only the formula and keep the resulting value in the cell. Here's how:
- Select all cells with your formulas.
- Press Ctrl + C to copy the selected cells.
- Right-click the selection, and then click Paste Values > Values to paste the calculated values back to the selected cells. Or, press the Paste Special shortcut: Shift+F10 and then V .
Make sure Calculation Options are set to Automatic
If all of a sudden your Excel formulas have stopped recalculating automatically, most likely the Calculation Options somehow switched to Manual . To fix this, go to the Formulas tab > Calculation group, click the Calculation Options button, and select Automatic .
This is how you make and manage basic formulas in Excel. I how you will find this information helpful. Anyway, I thank you for reading and hope to see you on our blog next week.
You may also be interested in
- How to make formulas in Excel
- Microsoft Excel formulas with examples
- Excel formulas not working, not updating, not calculating
Table of contents
![assignment for ms excel Ablebits.com website logo](https://cdn.ablebits.com/_img23/-design/ablebits-logo-white-2x.webp)
410 comments
A VERY BIG THANKS .
I need the Excel formula number combination
One hundred and ten units (HTF) : 345,345,678,890,567
Summary of analysis results from 5 data If there is no incorrect information 036-037-046-047-056-057-058-158-258-358 368-369-378-379-458-468-469-478-479-558 568-569-578-579-588-589 (26 sets / total 26 sets)
Sorry, I have no idea exactly what the task is. It's hard to tell exactly what you're asking for as it's currently written.
For me personally It's clear that actually "seeing" something written down is easier to understand and remember than "hearing" it, but both together is even better.
Post a comment
![TrumpExcel Logo – Online Excel Tips & Tricks TrumpExcel Logo - Online Excel Tips & Tricks](https://trumpexcel.com/wp-content/uploads/elementor/thumbs/TrumpExcel-Logo-Online-Excel-Tips-Tricks-oyfxtw7p1udmps67cqb07c8xljsj6v7issl2nne5gg.png)
LEARN EXCEL - FREE ONLINE EXCEL TRAINING
26 Lessons, 12+ hours of Free Excel Training (Videos)
Absolutely FREE | No Sign-up Needed | Scroll Down and Start Learning
If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.
This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning).
You don’t need to sign-up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel.
To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. I have also divided these into 7 modules.
NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen)
In case you’re an intermediate or advanced user, feel free to pick the lessons you want to watch.
Also, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).
In case you find the videos useful and would like to support me, you can buy me a coffee ☕
Modules Covered in this Free Excel Training
Module 1 - excel basics (for beginners).
This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area.
In this video, you’ll learn about the following topics:
- Structure of the Excel working area,
- How to navigate in Excel,
- Ribbons and tabs,
- Quick Access Toolbar (QAT)
- Dialog Box & Task Panes,
- Customizing ribbons and QAT,
- What is an active cell
- How to use ALT shortcuts
Related Excel Articles:
- Creating Groups in Quick Access Toolbar
Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.
You can enter three types of data in Excel – numeric, text, and formulas.
To enter data in any cell, just select the cell and start typing. Once done, press enter to move to the cell below. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01/01/2020).
This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).
Apart from this, it also covers the auto-fill in Excel as well as number formatting.
- Fill Numbers in Cells without dragging
- 10 Excel Data Entry Tips for Beginners
- Excel Data Entry Forms (Advanced)
- Custom Number formatting in Excel (Advanced)
Click here to download the example Excel file
This video covers the basics of data formatting in Excel.
You can format data in Excel to make it look better and to highlight some data points. For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.
Here are some of the common formatting I use to make my data look better and more readable
- Applying borders to all cells
- Making headers bold
- Giving a background cell color to headers.
- Center align the headers
You can find these options in Home tab in the Font category.
- 5 Useful Excel Formatting Shortcuts
- How to Remove Cell Formatting in Excel
In this video of this Free Online Excel Training, you’ll learn how to work with cells and ranges in Excel.
Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.
And this video will teach you exactly that.
It covers the following topics:
- Cell address nomenclature
- Selecting cell/ranges in Excel
- Copying and moving cells/ranges in Excel
- Using paste special
- Selecting special cells
- Using find and replace to select cells
- Adding comments and
- Using quick analysis
- Find and Replace in Excel
- How to move Rows / Columns in Excel
- Insert New Columns in Excel
- Excel AUTOFIT: Make Rows/Columns Fit the Text Automatically
In this video of this Free Online Excel Training, you’ll learn how to manage worksheets in Excel.
- Navigating through worksheets in Excel
- Changing worksheet name and color
- Adding/deleting worksheets
- Hiding/Un-hiding worksheets
- Moving/copying worksheets
- Comparing worksheets side by side
- Splitting worksheet into panes
- Freeze panes
- Saving and opening workbooks
- Freeze Panes in Excel
- Hide Worksheets in Excel
In case you’re looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course , VBA course , Power Query Course .
Module 2 - EXCEL ESSENTIALS
In this video of this Free Online Excel Training, you’ll learn how to use Excel tables.
Excel tables are amazing, especially if you plan to work with a lot of data/ dashboards /models.
In this video, I cover the following topics:
- Creating an Excel Table
- Excel Table features
- Structured references
- Table slicers
Note that table slicers became available only from Excel 2013 version onward.
- Overview of Excel Tables
- How to Remove Table Formatting in Excel
In this video of this Free Online Excel Training, you will learn about tools that can help you when working with data in Excel.
In this lesson, I cover the following topics:
- Autofill : This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
- Custom Lists : Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
- Flash Fill : Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern
- Fill Handle in Excel
- Flash Fill in Excel
- Create your own sorting criteria (with custom lists)
- Separate First and Last Name in Excel (Using Flash Fill)
In this video of this Free Online Excel Training, you will learn all about number formatting in Excel.
This video covers the following topics:
- How to access number formatting options
- Using number formatting options using a dialog box
- Using custom number formatting
Remember that formatting a number in Excel only changes how it’s displayed, but the underlying value remains the same.
- Custom Number Formatting
- Format Numbers as Text in Drop Down Lists
- Convert Text to Numbers
- Make Negative Numbers Red
MODULE 3 - EXCEL FORMULAS
In this video of this Free Online Excel Training, you will learn how to get started with Excel formulas.
- Constituents of Excel formula
- Operators in formulas
- Entering a formula in Excel
- Editing a formula
- Absolute/relative cell references
- Copying/pasting formulas in Excel, and
- Formula auditing and debugging.
- Excel Formula Debugging
- 100+ Excel Functions (explained with examples)
- Absolute, Relative, and Mixed Cell References in Excel
- Excel Formulas Not Working: Possible Reasons and How to FIX IT!
- Function vs Formula in Excel
In this video of this Free Online Excel Training, you will learn about the following logical formulas:
- AND function
- OR function
- NOT function
- TRUE function
- FALSE function
- IF function
- IFERROR function
- IS function
- Avoid Nested IF with VLOOKUP
- Using IFERROR with VLOOKUP
In this video of this Free Online Excel Training, you will learn about the MATH formulas
- INT function
- MOD function
- RAND function
- RANDBETWEEN function
- ROUND function
- SUM function
- SUMIF function
- SUMIFS function
- SUMPRODUCT function
- Random Team Generator Template
In this video of this Free Excel Training, you will learn about the following LOOKUP and REFERENCE formulas:
- VLOOKUP function
- HLOOKUP function
- INDEX function
- MATCH function
- OFFSET function
- INDIRECT function
- ROW function
- ROWS function
- COLUMN function
- COLUMNS function
- VLOOKUP Vs INDEX MATCH
- VLOOKUP with multiple criteria
- Case sensitive VLOOKUP
- Use VLookup to Get the Last Number in a List in Excel
- Lookup the Second, the Third, or the Nth Value in Excel
- Find the Last Occurrence of a Lookup Value a List in Excel
In this video of this Free Excel Training, you will learn about the following STAT formulas:
- AVERAGE function
- AVERAGEIF function
- AVERAGEIFS function
- COUNT function
- COUNTA function
- COUNTBLANK function
- COUNTIF function
- COUNTIFS function
- LARGE function
- SMALL function
- RANK function
- MAX function
- MIN function
- Weighted Average in Excel
- Standard Deviation in Excel
- AVERAGEIFS in Excel
In this video of this Free Excel Training, you will learn about the following TEXT formulas:
- LEFT function
- RIGHT function
- MID function
- LEN function
- LOWER function
- PROPER function
- UPPER function
- FIND function
- REPLACE function
- SUBSTITUTE function
- TEXT function
- Word Count in Excel
- Split Cells in Excel
- Extract a Substring in Excel
- Concatenate Excel Ranges
- Find Position of the Last Occurrence of a Character in a String in Excel
In this video of this Free Excel Training, you will learn about the following DATE and TIME formulas:
- DAY function
- HOUR function
- MINUTE function
- DATE function
- DATEVALUE function
- TODAY function
- NOW function
- WEEKDAY function
- NETWROKDAYS function
- NETWORKDAYS.INTL function
- WORKDAY function
- WORKDAY.INTL function
- Calculate Number of Days between two dates
- Calculate Time in Excel (Time Difference, Hours Worked, Add/ Subtract)
- Excel DATEDIF Function
- Excel Holiday Calendar Template
- Calculate Age in Excel
- Insert Date and Time Stamp in Excel
- Convert Time to Decimal Number in Excel
- How to Remove Time from Date/Timestamp in Excel
In this video of this Free Excel Training, I will show you some advanced formula examples that involves using one or more than functions.
I cover the following topics this video:
- Compare Lists, Get Unique List
- Get the Closest Match
- Get Last Value in the List
- Find Last Occurrence of an Item in a List
- 2 Way and 3 Way Lookup using Index/Match
- Count the Number of Words
- Extract Username from Email Id
- Find the First Monday of the Month
- Extract Data using Drop Down List
- Compare two columns in Excel
- Extract Username from Email
- INDEX MATCH (Examples)
- How to Compare Two Excel Sheets (for differences)
- 20 Advanced Excel Functions and Formulas (for Excel Pros)
MODULE 4 - DATA ANALYSIS
In this video of this Free training, you will learn about using Named Ranges in Excel.
- Creating Named Ranges
- Managing Named Ranges
- Important Keyboard Shortcuts
- Creating Dynamic Named Ranges using OFFSET and INDEX formulas
- Named Ranges in Excel
- Picture Lookup in Excel
- Excel OFFSET Function
In this video of this Free training, you will learn about using data validation and drop-down lists.
- Data Validation Criteria
- Input Message
- Customizing Error Messages
- Circle Invalid Entries
- Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List)
- Drop Down list in Excel
- Dependent Drop Down List in Excel
- Extract Data from Drop Down List Selection in Excel .
- Select Multiple Items from a Drop Down List in Excel .
- Creating a Dynamic Excel Filter Search Box .
- Display Main and Subcategory in Drop Down List in Excel .
- How to Insert Checkbox in Excel .
- Using a Radio Button (Option Button) in Excel
In this video of this Free training, you will learn about data sorting and filtering in Excel. It covers the following topics:
- Data Sorting
- Multi-Levels of Sorting
- Data Filtering
- Advanced Filtering
- Filtering and Sorting in Excel Data Tables
- Data Sorting in Excel
- Multiple Level Data Sorting in Excel
- Sort Worksheets in Excel (VBA)
- Sort Data in Alphabetical Order Automatically
- Sort by Color in Excel
- Sort Data using VBA
- Delete rows based on cell value in Excel
In this video of this Free training, you will learn about the amazing conditional formatting.
- Introduction to Conditional Formatting
- Using Formula in Conditional Formatting
- Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)
- Conditional Formatting in Excel
- Find Duplicates using Conditional Formatting
- Search and Highlight Data Using Conditional Formatting
- Highlight Every Other Row in Excel
- Highlight Blank Cells in Excel
- Creating Heat Maps in Excel
Here are some additional tutorials about Data Analysis:
- One Variable Data Table
- Two Variable Data Table
- Goal Seek in Excel
- Scenario Manager in Excel
- Using Solver in Excel
MODULE 5 - INTRODUCTION TO EXCEL CHARTING
In this video of this Free training, you will learn about Excel charting and how to make useful charts quickly.
Excel has a lot of inbuilt charts that you can use instantly to visualize your data. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.
- Excel Chart Types
- Chart Editing
- Formatting Chart Elements
- Combination Charts
- Handling Gaps in Charts
- Combination Charts in Excel
- Add Trendlines in Excel Charts
- Add Secondary Axis to Charts in Excel
- Excel Area Chart
In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.
The following advanced charts are covered in this video:
- Multi-Category Charts
- Gauge Chart
- Thermometer Chart
- Milestone Chart
- Water Fall Chart
- Gantt Chart
- Chart with Trend Arrows in Data Labels
- Actual Vs. Target Values
- Spotting Data in a Scatter Chart in Excel
- Dynamic Target Line in Excel Bar Charts
- Sparklines in Excel
- Step Chart in Excel
- Sales Funnel Chart in Excel
- Waffle Chart in Excel
- Pareto Chart in Excel
- Histogram in Excel
In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.
Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button.
This video covers two detailed examples of creating dynamic charts from scratch
Example 1 – Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value. Example 2 – Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a drop-down list that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis
- Creating Dynamic Chart Range in Excel
- Dynamic Chart with Selection Box
- Dynamic Target Line in Bar Charts
- Creating Dynamic Chart Titles
MODULE 6 - PIVOT TABLE
In this video of this Free training, I will show you how to create and use Pivot Tables in Excel.
The video covers the following topics:
- Introduction to Pivot Tables
- Creating a Pivot Table in Excel
- Formatting the Pivot Table
- Grouping data in an Excel Pivot table
- Calculated Field/Items in Pivot Table
- Pivot Table Slicers
- Pivot Charts
Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. Even if you’re using Excel for the first time, you can quickly get a hang of it. In this video, I try to cover a lot about the Pivot Table. In case you want to learn more, click here to check out all my Pivot Table tutorials .
This is a fairly long video, and if you want to deep dive into any of the topics covered in this video, have a look at the recommended articles section.
- Creating a Pivot Table in Excel – A Step by Step Tutorial
- Preparing Source Data For Pivot Table
- How to Filter Data in a Pivot Table in Excel
- How to Group Dates in Pivot Tables in Excel
- How to Group Numbers in Pivot Table in Excel
- How to Apply Conditional Formatting in a Pivot Table in Excel
- Using Slicers in Excel Pivot Table – A Beginner’s Guide
- How to Add and Use an Excel Pivot Table Calculated Field
- How to Refresh Pivot Table in Excel
- Delete a Pivot Table in Excel
- Pivot Cache in Excel – What Is It and How to Best Use It
MODULE 6 - EXCEL EXTRAS
In this video of this Free Excel training, I will show you how you can lock cells or protect worksheets and workbooks in Excel.
You can protect cells, worksheets, and workbooks in Excel with a password (or without one). Once a worksheet is protected, you’ll need to enter the password to access it (in case a password has been applied).
Note that Excel in-built security feature is not very strong and you can easily open worksheets/workbooks that have been locked. However, if you want to quickly protect it before sending it to your manager/client (so they don’t end up changing anything by mistake), it works well.
- Lock cells in Excel
- Lock formulas in Excel
In this video, I will give you a quick introduction to Excel macros and the VB Editor in Excel.
By recording a macro in Excel, you can easily automate a lot of tasks. And the best part is that you don’t need to know any coding or VBA to do this. When you record a macro, Excel simply follows whatever you do in the workbook and create a code for it. Now you can run this code and Excel will automatically follow all the steps you showed it.
If you’re a VBA beginner, recording a macro and understanding the code using it can be a great way to learn.
This video lesson covers the following VBA topics :
- How to record a macro in Excel
- Absolute and Relative Cell References
- Introduction to the Visual Basic Editor.
- Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit)
- Working with Worksheets using Excel VBA
- Using Workbook Object in Excel VBA (Open, Close, Save, Set)
- Understanding Excel VBA Data Types (Variables and Constants)
- Excel VBA Loops – For Next, Do While, Do Until, For Each (with Examples)
- If Then Else Statement in Excel VBA (explained with examples)
- For Next Loop in Excel VBA – A Beginner’s Guide with Examples
- How to Assign a Macro to a Button in Excel
Here are some additional useful basic Excel tutorials:
- Clean Data in Excel
- Excel Interview Questions (with answers)
- Working with Gridlines in Excel
- Inserting a Watermark in the Worksheet
- Setting the Print Area in Excel
- Best Excel Books
ABOUT THE INSTRUCTOR
![assignment for ms excel Sumit Bansal Excel MVP Trump Excel](https://trumpexcel.com/wp-content/uploads/2015/10/Sumit-Bansal-Excel-MVP-Trump-Excel.png)
I am Sumit Bansal, your instructor for this Excel Training. I have been training people in basic/advanced Excel and dashboards for more than 10 years now.
I have also been honored with the Microsoft Excel MVP status for my expertise in Excel.
Learning Excel becomes a cake walk when you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.
In this Excel course, I’ve focussed on giving you a structured and comprehensive learning experience. It makes sure you have a rock-solid foundation and then covers advanced Excel concepts that will make you an Excel Wizard.
When you’re done with the course, I guarantee you’ll be able to do a lot more in Excel in a fraction of the time.
FAQs about this FREE Online Excel Training
Yes, it is! You can just scroll up and start watching the videos and learn Excel .
You don’t need to sign up for anything or pay for anything. This training is completely free and covers most of the Excel topics you need to get started and become a pro.
You get to watch each and every lesson absolutely free (and as many times as you want).
All you need is a decent internet connection.
No, you can only watch the videos online. These videos can not be downloaded.
However, this FREE Excel training is available to watch as many times as you want.
I have used the Excel 2013 to record these videos.
Almost everything covered in this free course will work for all the Excel versions (2007, 2010, 2013, 2016, and the upcoming 2019) .
There are a few things missing in the prior versions, and I call it out in the videos (for example, flash fill is only available in versions after 2013)
My name is Sumit Bansal and I am your instructor throughout this FREE online Excel training.
I have practically been in a relationship with Excel since 2007. My aim in this course is to give you the best possible Excel learning (absolutely free).
I have been highly passionate about learning and teaching Excel and have trained thousands of Excel enthusiasts to use Excel the most efficient way.
I have also been recognized as an Excel MVP by Microsoft for my passion to learn and teach people on using Excel the right way.
591 thoughts on “FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)”
Dear Sumit, I truly appreciate all what you have done in these videos. Indeed you are an incredible and wonderful person, which of course in today’s world is rare. It is not everyone who would share their knowledge for free in this generation, thus i am sincerely grateful. Keep the good work
Thank you so much for the kind words Marion
dear, how to draw a pair of lines to the x-axis and y-axis from a point along a curve?
Where are the links??? I click on a heading, get the description, but there are no ACTUAL links to watch the video!
The videos are embedded. Check your browser settings and/or disable ad blockers if you don’t see them.
Señor Bansal!
Thank you for your shared knwoledge!
Very hepful to increase my knwoledge on Excel.
Very strightforward and very good pace!.
Fidel (Monterrey México)
Good explanation
The material and videos are excellent, thanks. I do have a problem when downloading the example file for practice. It downloads but the data is missing will you please help.
Hello Deepak here and I am a beginner
Will we get certificate
Sir theory is not give me
Highly Beneficial
mene ap se excel ki training leni hai
Dear Mr Bansal
I want to take this opportunity in thanking you for offering your services free to all. I am very grateful to you. Not very many people will offer their services for free in this day and age. May you be abundantly blessed Sir.
Thank you once again
Fantastic! I’ve been a programmer for 30+ years and this is a wonderful site for a refresher or a quick reminder of how to do things in Excel.
Want to learn.
Seekhna chahta hu
Very much interested in the courses
How do I start the course on my smart phone
Apne phone me ms excel kaise suru karu
Can I get a certificat when I will finish this cours?
Thank you Sumit for your efforts for making these courses completely FREE of cost. Absolutely great videos and your style of teaching is amazing and easy to follow. Thank you for sharing your knowledge with everyone.
Would like to learn
would like to start
Sir you are teaching in a very simple and cool way . I liked it very much. Iam sure no would have any doubts after hearing. Thank You soo much for providing this free course.
it is really helpful to us
It is really amazing to see this.Throug this platform we surely increase our knowledge about excel
It is really helpfull
I get the training best however I need certificate after completing the training for cpd. how can I get it?
Wow I love learning opportunities as this hope to really know this Excel.
BEST BEST BEST TRAINING
Dear Sumit Bansal,
I am trying to learn Microsoft Excel. I have been using it for years but know very little about it full power. I am watching your videos on YouTube. In the video “10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course” in the session on “Milestone” charts when I enter the data as shown in the video I get a “#FIELD!” error. Do you have a solution for this?
it was good and understandable excel course.
Really helping a lot.. thank u
Was very helpful
Thank you so much sir you helped us alot
I just purchased Microsoft Home@Student and one of the things I wanted to do was learn Excel. I’m only on the third lesson so far but I find your instruction clear and logical in it’s presentation. Thank you for all the time and work you’ve put into making it.
Do you get a certificate upon completion?
how i join class?
Really helpful sir
Thanku so much ❣️❣️❣️
I have been struggling to learn excel but with these videos definitely will get a better result, at the movements, Just would like to say to you ” well done and Good job “. Thanks
I want do that. Anybody can cll me… How’s will be start.
How do I get the certificate after completing the videos?
michael adeoye wonderful. May God bless your excel training.
Are you qualified? Have you got experience? I may have a Freelance job for you in our firm of Chartered Accountants & Property Tax Consultants in London UK
It was a helpful session.Thank you
So I get a certificate for Thai training?
Do I get a certificate for this training?*
Hi, I know Excel basics, may not be fluent. I need to learn online 1 to 1 and complete the course in 2 weeks max. Pls advise how can we do it, daily how much time required & what’s the charge
Do you receive a certification for completing the course?
Thank you so much, this is very helpful.
I am not receiving the tips ebook you are offering
I have used Excel for years and had no idea about all the functionality! You are a wonderful teacher and have made it so easy for me to grow my knowledge of Excel — Thank you for these wonderful videos and instruction! You’re Excel-lent!
Did u learnt online one to one or just by watching the videos ? How long it takes to complete the course
Can i get certificate for this?
Can I get certificate after I finished the course?
Thank you for the training
The best, simplest and eastist way of learning excel ….lot of thanks .
This is the best online course i have ever found. Thank You and best regards from Bosnia.
Do we get certificate at the end of this course?
Excel courses provide certificate & job
Hi Sumit. Wonderful contribution you are making. Kudos. Can we use these on our company LMS? We are not going to do that for Commercial purposes
Is it this course will provide me certificate?
Thank you is what I can say only. I have not still started but I am aware about excel and topics, this is a true help to everyone, great work sir.
This is truly the best Excel training I have come across and am actually learning and utilizing what’s taught. The lay out and process is very well put together. Sumit’s style of teaching gives you exactly what you need w/o all the extra talk. No wasted time just good content clearly and usable. EXCELLENT WORK Sumit and THANK YOU!
yes I want to learn Microsoft excel
REALLY LOOKING FORWARD TO LEARNING EXCEL…
Interesting video. Thank u !!!
SO HOW DO IGET STARTED THEN HEHEHE IM SCROLLING DOWN AN DOWN AN DOWN WHER DO I ACTUALLY START THIS EXCEL COURSE FROM
Wow, I just loved this training. The wonderful thing is you can keep going back to refresh things you may have forgotten. Thank you!
Sir aapka smjhane ka way bot best hai kya Excel video hindi version mai avilabel hai….if yes please send me link on my email id…..sharma,[email protected]
I want to know everything in excel.
thank Trump Excel for so many help
Osm Guidance in this video, Thank you so much to learning lots of new features.
Dear Palak, Siri connected me to your excel Tutorial program and many thanks. I hope to learn the program soon though it is a bit too fast for me but you are very clear.
interedsted in excel
Interested in excel
I have not been able to access video, How do I do that? Do you also provide certificate after conplication of this course
Grate work Mr. Sumit, I planed to take up an online program in Data Analytics next semester but indeed hope these videos would help me a lot. Bravo my brother.
Is this really free
Does this course come with a certificate?
Do this course provide completion certificate.
May I download video
Can we get certificate?
Where are the exercises for each module to practice the lessons?
can i get the certificate?
I am interested for learning ms excel
I am interested learning in excel
Excellent video Sir I really very thank full to you for bringing useful videos that to free of cost. One can become a expert in excel by watching your video. Sir how you made thia video means which equipments you have used without showing the face only you have given voice. Because I am also a lecturer I want to teach online without showing the face
Need to be part
Sounds interesting
Watched the introductory video and it was amazingly comprehensive .. Would love to continue with d other modules..will i get a certificate after completion?!
This is an excellent online course for any level Excel users. Great Instructor! Above all these, its free for anyone! Thank you so much!
Can I get certificate after finishing the whole excel course?
Boy I never knew anywhere near all this was so available! You are a great instructor and make it all learnable, even if I do have to back up and replay often (at least in VBA course, your workbooks on Excel formulas are wonderful). I’m finally learning where before I’ve always just cussed VBA and Excel. Thank you Very Much for all your hard work!
How can I sign up for this free offer?
I’m interested in free training
Learning excel
I will strive to learn and excel and after some expertise, I would definitely spread it to those who are in need of it, obviously free. I think this could be one way to pay you back. My sincere regards to you Sumit Bansal.
sounds good will give it a go
Sumit, as I mentioned in an earlier comment, I am fully retired 5 years now. In my day was considered an advance Excel user – VBA programmer. But I must confess I have learned things in your tutorials I knew about but never mastered. You tutorials say things in simple terms. I just finished lesson 8: Number Formatting in Excel. I used this function often in my work but now have a better understanding of how to use the different formats of number, dates and times. Thank you for EXCELLENT tutorials. Can’t wait to learn more. Thanks again.
Will there be any certification given at the end of the course?
Can it be used better than tally for inventory management
this is a great Excel training program. I thanks Mr.Sumit Bansal give to opportunity develop our Excel side.
thank you , very helpful
It will be my joy to start this training and finish to become a pro in no distant time. Thanks for this offer and opportunity.
This video is helping a lot!
No problem.
very useful and I am are learning very short cut formulas for faster execution of work in excel
Thank you Sumit for making learning Excel for me a piece of cake. All this while, I was under confident when it has come to Excel. You entire Module is a collection of all the lessons and I do not have to go anywhere else to find video. I practice these everyday. Thank you once again. And yes I would like to treat you with coffee sometime as a gesture for your help!
How to login and start training..
Amazing! This is so useful, so clear. I wish I found you long time ago 🙂 Thank you so much.
Hi and thank you for all the content. I had a question regarding the countifs function. I had the quiz question how many times does the number 3 appear between the integers 300-400. I know the answer is 120 after looking into it further I was wondering if there’s a way to get to this answer using countifs, if so how? I thought it would look something like this =countifs(b1:b100, “3**”, b1:b100, “*3*”, b1:b100, “**3”) but clearly have it wrong.
I’m interested to do this course
I must appreciate you ,you have prepared all the videos and that available for all. Regarding printing I want to know how can I print bill format using data of various cells
Can’t wait to get started, an 81 year old.
Just like excel You are an Excellent instructor. Thanks for helping!
it is really helpful
I just love this free online excel.
EXCELLENT TRAINING
My,my,my…I know we still have kind souls, we have just lost our way a bit in the world today. Knowledge is no good unless you share it. I will be taking your course. I sincerely thank you for your kindness.
Is there a free certificate after completion
No there isn’t , but you can share the knowledge you’ll gain with your peers and employers as proof of your completion 🙂
I don’t know about this I am just doing first time so after i start I’ll comment
Thankyou so much Sir for providing us such a valuable course free of cost. Your Teaching style and way of explanation is Fabolous. It helps me alot.
Hello Sir, I am not able to play the videos. They seems to be freezed.
It may be your connection, try to hook to WiFi and try again. Hope that helps
Total how many hours does the course is?Can I get certificate?
I am now 65. I like to convey my thanks to you for your philanthropic activity as a teacher in real sense. I was a teacher and hope to be a student of you very soon. Live long.
Hi! Are these courses still available? I’ve clicked on several of the training courses and cannot access.
Yes they are, try to connect to WiFi and try again to access
Do you get a certificate for this course?
Hi I would like to attend this class
Hi, access anytime 24/7 for free 😉
simply excellent
Does this course provide certificate?
Waaw Mr. Sumit! This is a fantastic gift to all the human race. Bravo my brother. I planned to take up an online course in Data Analytics next semester,2020 and hope this would help me a lot. Thanks.
I’m a complete beginner hoping to start a data analysis Open University Course in October. Your service is invaluable to me and I will be studying for 2 hours a week until October. Many thanks for sending me emails. Kind regards, Jeanne
Will you provide Certificate after completion. How much time it will take to complete. I am in intermediate status.
We will get certificate?
Do we get a certificate for the course?
IS THIS COURSE PROVIDE CERTIFICATE ALSO
Thank you so much !!! I’m a Nutrition student in college and excel is extremely useful <3
Thank you so much Sumit for such a comprehensive course, I really appreciated it!
Great Job and I am learning every day as I watch one video per day.
Very nice way of give training with so much examples & practicality. I am v. much impressed.
Hi I would like to start study excel When the course start ? Thank you
When can I expect to start the free excel cour
Will a certificate be provided by the end of the course?
THANKS SO MUCH FOR THIS FREE COURSE I LOVE YOUR VOICE TOO❤❤❤
CAN I GET A CERTIFICATE FOR THIS COURSE?
thanks for this complete course on excel learned a lot…
Out of my tight schedule and extra working hours, I took out some time to complete this course and it helped me tremendously to manage and analyse my data, along with it I could save 2-3 hours per day. I am grateful to you for making it available free and help people like me who struggle working efficiently without good knowledge of excel. I have recommended this course to my colleagues now. Many many thanks again.
Want to learn excel
Hi sumit, thanks for giving such wonderful learnings at no cost. Will u please guide me for certification stages in excel and also best link to go for it. I would really appreciate ur response. Thanks in advance
is there a book covering this course? If not what books do you recommend to learn Excel for work?
It’s very useful course. Thank you sir.
Is there any assessment that I need to give after completing the training?
The courses offered and the way these are structured are meant to lay a firm and solid foundation to build upon. Everybody builds their own home on a foundation. When it is a good, properly laid, will make one’s home sitting on a solid foundation.
Mr. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way. With an average enthusiasm to learn, one can learn from these videos and lay a firm and solid foundation to one’s career, using this excellent program called Excel.
Like air we breathe, Sunshine we enjoy, moonlight we adore, his free teachings are GOD’s gift to any body that want learn a new skill.
The organisation, time, effort and passion has to be really appreciated.
I see lot of people asking for a pat in the back ( like looking for a certificate of completion ), this is a SELF-HELP course, and I am not sure I will have as much information given to me even if I attended a PAID COURSE.
And again, since I am learning this on my own to improve MY understanding of spreadsheet program, I can understand and appreciate why some persons want to squeeze a CERTIFICATE out of this as a ticket for a future job.
Mr. Bansal, Pranam to you, as a teacher who put in all this time into these video courses and offering it for free. I bow to you for your kind heart.
Goddess Saraswathi has blessed you, may her blessings be showered upon you into the future, so we all get at least a part of those blessings.
Is this course provide certificate also?
Will we be getting certificate after completion
Sir after completing this …can I have a certificate of this or not..
Sir I completed the course so would you please give me a certificate
Awesome course I learn lots of thing Thank you sir
It really lovely course thank you very much
Hi Sumit! Thank you for this! Question …is there a file to download to follow along with the videos ?
Nevermind! You don’t need it in these videos…I got it . I’m looking for tutorials on what to do say when you run a SQL query and have a huge data dump in excel . Will start with your videos here , thank u!
Very helpful course
Khupch chan information dili ahe purn upyukt asa course ahe excelcha.
hello i’m new here and i would like to learn excel then after i can learn more about computer.
Thank you soooooo much for the effort Really appreciated
I AM A BEGINNER IN EXCEL IS THIS A CERTIFIED COURSE AND HOW MANY COURSES ARE ALSO AVAILABLE
This is really good way to taught I really liked
hi, is this a certificated course?
Please I am interested in taking thefree Excel class
This is so user friendly. For someone who has never been able to use Excel, your training is just so simple and easy to understand.
Hi. I wanted to chat.
can you go to insert I am on a mackair
How to enroll ?
This is beautiful. I enjoyed the training and with this excel training, i can say that i now understand excel at some extent. Many thanks to the instructor.
sir all are very nice i love it
Thank you very much, this really helped me a lot
CAN YOU PROVIDE ME WITH A HARD COPY OF THE LECTURE WHICH YOU ARE SPEAKING SO THAT IT MAY BE EASY TO UNDERSTAND FOR A PERSON WHO IS NOT THAT PROFICIENT IN ENGLISH.
Am new how do i get started and do you anything to show that someone did this training.
sir after completion of this course i will get a trained certificate or not ?
Yes. I am interested in the free excel course
Sir please tell us some assignments so we can practice after every lecture
Thanks you so much ,sir. I am from Pakistan. I learned a lot from your videos. Kindly share me the procedure to get excel notes if you prepared according to the video you published. Thanks in advance
May i learn the Macros in this Excel Program as well
It is very helpful app
Worth watching these videos, it’s really very helpful.
Good effort. Contains are clear and crisp. Course is Advanced, I will highly recommend this to Computer teachers who wants to clarify their doubts in excel.
Sir can u tell us some assignments so we can practice after every lecture?
Does one get a certificate after completion?
It’s a very healp full to excell. I have to learnt data entry and number formatting with excell. In module 2 I learn to auto fill , custom list. And excell is spread sheet program include in the Microsoft office suite of applications it is also soft ware program .
I have watched your course “How to do a Picture Lookup in Excel – A Step-by-step Guide” and I still can’t get it to work. Is there any way to help me? I am desperate.
The language is so easy to understand the lesson.
Thank u sir it is very useful training I had been advance Excel classes but I had not more about Excel I had learn only basic concepts and also I had try job outside I didn’t found the same MIS executive job. May be if start watching this video daily I will learn more new about the excel thank you so much for providing this free of cost course.
It is very useful
First check it.
First check it
Are we getting any certification after the course completion.
Why is Trump name on this course? How is President Trump associated with this course? If he is not, why did you put his name on it?
It’s a common English verb. This course and the site has nothing to do with anything except Excel
I think this was an excellent video on excel I really appreciate the efforts who had made so easier to learn excel. Contains are clear and chrisp.i am impressed the way they present the advance excel. I will also recommend to my office staffs, senior’s, collegiate, friends and our business partners. Now after learning so many things through video I feel so confident and happy now I have to rush to take help of anybody, I will keep practicing and learn more and more to enhance my excel as a superb skill. Thanks you so much to all those who had given great platform to learn the Excel and various things…..
Hello, Thanks for training and good experience and thanks a lot .
Good experience and thank you for your help.
Great videos
I want to learn advance course
Thank you Sir, it is very useful for me to know about Excel as I am working on Excel in my office and it will be very useful for me.
best course
Hello sumit sir, I am writing this to Thank you for providing such great lessons. They are very few people left around us who provide education and great learnings for free. I am disappointed for finding this site a bit late. But I’m glad i am finally here and can get the best out of this learnings. Thankyou so much for your knowledge and efforts Sir.
Good knowledge …Data Entry,Data editing,Number Formating
Good knowledge & Information
HI Sumeet Sir, Can you please explain the basic difference between between Vlookup & Hlookup as both looks same and Syntex are also same just =vlookup has been changed to =Hlookup .
Hi I am an intermediate in excel…
Dear Sumeet Sir, Can you explain a bit more about Vlookup for the last example in the given where you were T is higher lower, Really I got confused ,It has been asked for T why it is giving data for jane ?
very well explained ,very useful
It is very well explained & has been very useful to me Thank you
I like all the videos and I have easily understood everything. Thank you
Hi is there a certificate once completed?
It is very useful. Excellent videos & courses and easy to understand.
Very nice coaching and class
Excellent courses
Thank you for the great work, Sumit – I’ve found it very useful and comprehensive.
I will give you tip at the end of the course.
Do they provide certificate?
This is amazing tutorial and excellent instructor, I loved, thank you so much it’s absolutely life saving.
This excel work is essential
This is what I was looking for to learn in my life.
It is really helpful. Thanks.
Very useful
so clear and very helpful
It should be useful
I enjoy and learn a lot from your Excel course. Wonder you have free online course for Microsoft word training just like this excel course.
Hi Sumit – i need to know how to become MVP in excel as I know it at advance level.
Excellent Videos
Excellent course
very useful for me.
thank you sumit
chindeh fally
for example : 3126.76 is the number I want this in the form ####.## how can I do this plz tell sir.
May God bless you my brother. Thanks for sharing your knowledge. My name is yunus be in touch 7624885184 (Kerala)
Thanks i learn alot think here
is it necessary to have certification of excel when you have an aim of pursuing a job in future?
Online excel learning
I am very interested to learn excel , well done good lesson it’s very useful for so many people’s thank you…
Thank you very much . This training has helped me a lot and I am so grateful. I have been looking for an Excel training , tried to buy from Udemy several times but could not complete the transaction due to some restrictions in their payment system which does not allow a credit card issued in a different country. What’s is point of having a credit card if the thing would not work across regions ? Well, this was before I came across your page and started learning . Having gone through several videos and other trainings, I can honestly say that your training is one of the best structured and delivered. Thanks a lot.
Module 3 lesson 9
as in the video to find out answer only to Average (Sum +Sum +Average) u select the Average with associated cells and click F9 but i my excel when i tried i am not able to get that answer. do we need to press shift+f9 or it is something else
Module 3, lesson 9. Mixed reference
I understood how to keep one number consistent while dividing or any other signs by adding ($) sign before the letter and after the letter but
in mixed reference moving from $A$12 to $B$12, considering different column (i.e from A to B) but same number cell i,e (12) in this case i tried on my excel but i am not able to move from A to B by removing the ($) sign before A by pressing only (F4).
Could you help.
Which course in excel
Please send me link, I am interested on it
very much interested to start the course, coz I like excel spreadsheet.
Do we have to sit in one go or we have can do per day per video
Thanks for your excellent tips on Excel.
Want to learn all the basics of xl
I finish my course can I get certificate.
I have learnt formulas in this online course… Usefull course
I was literally looking for an excel training opportunity for teacher professional development. I had my wallet out ready to pay. Your training is above and beyond structured and easy to follow. I would have paid hundreds of dollars for this training. Thank you for sharing your knowledge and talents!
I am very eager to learn this and don’t see the tutorials yet.
Can I get a Certificate after course completion
It’s very interesting And very useful
I am using excel. I need to improve…….
Thank you for the course Sir, it is really useful.
I found it very useful, really appreciating Mr.Sumit for your valuable contribution. Its very effective way of teaching in simple way to explain the logic’s and uses of each functions. Keep it up……
Good course
This courses is truly useful.
this may help a lot of people just by watching
Had learned a lot
I found this Course very useful for me and suggest to others also. Thank you.
Course Modules are very usfull
This course is Best and very helpful course
Best courses very helpful course
do we have any test after the course
Learn something new through online session
What about a sertificate after finishing for cv for work purpose
I find your tutorials quite useful for many excel formula. I have a unique situation. I would like to seek your help. Is there any way that I can reach out to you and share the soft data(Dummy) and seek solution. This is related to vlookup.
Hello. These courses sound great. However, nothing happens when click on any module. Is this because there may be high traffic? Do I need to access via google or IE? thanks
Great excel learning
I am using your free 26 lessons program to learn Excel. Thank you for the very informative videos. Is there anywhere I can do practice exercise?
Regards, Louloua
Thanks a lot sir for making it available now for free.
Excel learning
Which excel courses are paid in your site.
I have always wanted to learn excel so I am very interested in taking this course
I have always wanted to learn excel so I am very interested in taking this course.
did u started? is this really useful?
How do I get access to the worksheets used in the videos?
I thank Mr. Sumeet Bhansal for giving me such a lucid training where in got to know the easiness in understanding the excel formats quickly.
Do I get a certificate for this training?
Very Useful courses
Is there any certificate after completion?
Nicely Explained in Detail
How do I get the Free video?
Very useful course for the excel learner’s. Good Job… Thanks a lot…
Sir I know about excel a little bit I want to learn excel in deep.
Sumit, you have provided the clearest teaching I’ve found thus far online. I appreciate the downloads you provide with each lesson so that I can switch screens and practice while you are teaching. Also, you have organized these beautifully in small sections so that anyone can take a quick lesson in between other projects. EXCELLENT!
I was to change shape of chart element column chart. Please guide.
Sumit -the way you explained formulas its amazing. I am your fan nowonwards. thank you dear.
Thank you so much.. !
Cn we get certificate after complete the course?
Thank You for sharing your knowledge to us.This courses is very useful.
Hi Sumit, approximately how long will it take a beginner to complete this course? Thank you
great job. Thanks
I have one doubt in the Excel Sir like automating the data from one sheet to another sheet.
Dear Sir, I need help in conditional formatting. In a column A there are a number like for different row 302,213,556,070,111,560, … I would like to high lite the number for 302 value is red( either if it is 023 or 320 for all combination) ,556 is yellow(similar like all combination655,565) and 070is green( 007or700). Please help. Thank you.
It is a pleasure to have the opportunity of learning this courses free and I hope it will be a successful experience. Thanks
Dear Mr.Sumit, I need a small solution for my Xl Table I need to change the Data (Rate of Interest in the cells) in one column for a particular period in another column (01-04-2019 to 31-03-2020)only Kindly help me solve this problem Regards S D N Murthy
Hi, can you provide some sort of evidence if I complete the 12 hours course
It is Useful for me
It is very usefull for me
Hi Sumit, Can use google sheet for this training?
What I have seen so far (I’m on lesson 4) is absolutely amazing!
Really thankful for your knowledge sharing. It’s really helped me . Sreeraj C
Thanks for good knowledge sharing .
any certificate from your side after free training
Do we get a certificate or something to show that we have completed the course?
will I receive a certificate once I complete the course? Where is the company located? Is there a phone number where I can contact anyone if necessary? How long have your company been in business? What is the name of your company?
Since this is a free course available for all, you won’t be given a certificate. This site is run by Sumit Bansal (that’s me). I am an Excel trainer who shares tutorials and videos online. This isn’t a company, just me trying to help people learn Excel. You can reach out to me at [email protected]
are these courses really free? I will not be billed later on down the line will I?
Hello Kimberly… Yes, the course is free. You won’t be charged for anything. You don’t need to enter you credit card or any other detail. Just click on the video and watch.
Am I gonna get a certificate for the course
why do you want to give free lecture?
I need something for kitchen porter please if available
It’s not for a kitchen Porter course
Would like to know how helpful the course is
Is there any free online course work that can be done by the person on hands learning to be learning by doing ?
hi Sumit, This is really an awesome excel class and is it free training, really appreciate your effort and sharing. Many thanks.
Just wanted to say–Sumit, Big thank you for taking time for providing these free online training courses. God bless you
Thanks for commenting… Glad you are finding the videos useful!
Hi sumit..hope u r doing fine..would u able.to.send these same.sheets for practice
Thank you for putting this out there for free, bless your heart ❤️
Thanks for the kind wors Kristin… Glad you’re finding this Excel course useful!
Thanks for the courses. This courses is very useful for me.
Glad you’re finding the Excel course useful
one of the best excel course i have ever seen.
Just awesome Sumit, wasn’t expecting such detailed explanation of everything Excel.
This is the best course on the internet!! At the moment, I’m trying to learn how to take out the external links from excel and I found this post at the top of the search results. Then, I found this course just in the menu and it’s exactly what I’ve been wanting to do, like literally at the top of my list but just did not ever know when or where I could because of the time and just trying to learn so much such as Command Prompt and what that can do you for you.
Thanks heaps for this whole website, it’s the best!
Thanks for the tutorial video. Is there a video for Power BI.
Thanks for the Excel tutorial. It helped me a great deal at my present job.
Good afternoon., I want to be Expert in Excel. What can i do for…?
I just want to know can I get any certification for this Exel online tutorial
I need to develop a tactical crime analysis matrix using a spreadsheet. The matrix will contain 10 records(rows) and 16 variables (columns). I have a list of crimes. Would you please demonstrate a sample of this
Congratulations Sumit Bansal for this exceptional work! It is really fantastic to have access at this great content. I’m a fan of Excel. There are so many things you can do by just using excel properly! Do you mind if I make a post regarding your site on LinkedIn or on twitter? Thank you!
Thank you very much for giving me the opportunity. It’s amazing Vedio’s
I took this course before and I didn’t do well cause I was working full time I did’t have time to study.
Hi Sumit, i cannot see videos for Lesson 8 – Number Formatting in Excel,Lesson 9 — Excel Formula Basics and many more. Though i have viewed those videos in the past but they aren’t available currently. is there a restriction in the number of times that once can view a particular video lesson?
Hi Pooja… There was some minor update going on which prevented the videos from loading. You can watch these now. There is no restriction
Watched the first video and it’s wonderful. Thank you. However the second video doesn’t show. I will jump to the third and hope the 2nd returns. Thanks again
Hello Morgan, There was some minor update going on which prevented the videos from loading. You can watch all the videos now.
That’s great. Thank you. This is a great site
THANK YOU IT HELPED ME LOT TO USE EXCEL
Most valuable help I ever received from internet. Great Work
I have really found you to be clear and concise in your presentation. It is very easy to follow and is a great brush up for my rusty skills. Thanks you!!!
Thank you for doing this. Very selfless of you to share your knowledge for free.
Can i down load and go through later
There used to be a feature in excel that let you send the sheet to a list of people to add data in a sequence – is this still available?
I really want to build a carrier in Excel. I will be glad I get it here.
Can I zoom in on training to make it larger
it’s great to help & service to people.
We glad to have this guide for our reference to learn the Excel free. I have got this link when ‘am searching for some relevant topics, I’ve gone through it and the exact required knowledge is you shared.
Appreciated for your efforts keep rocking more like this.
Thank you in advance… I am working in excel from last 7 years, wanted to learn more 1) passionate about excel 2) need a better career growth, let me start with this, if require will take help further.
I have a small problem with vlookup i am getting few errors on few cell and i am unable to solve the issue can u pls help me
Hello I want to create a business cards alphabetical file Is there any tips you can give me to make it easier
Do i need to enrol to be part of this training-iam interested!!!
No, you don’t need to enroll. Just click on a video and start watching. It’s completely free to access
I am not able to download the EBook sir, can you pls help me
Really it’s awesome,, how generous you are in giving these crucial knowledge for free to who wants to learn excel. I feel you are doing charity on the behalf of excel. Sir I salute you . It’s bravo and majestic. God may bless you through your ahead intiatives. Thank you, sumit bansal
Hello sir, thankyou so much for free excel online training materials. This will gonna really helpful to people who want to learn excel online for free. I would like to know is there any Certificate available after compilation of this course?
A1 AHU – 9 A2 AHU – 15 A3 Boiler – 20 A4 Boiler – 33 A5 Boiler – 5 A6 Chiller – 8 A7 Chiller – 7 A8 Chiller – 9 A9 Chiller – 8 A10 Chiller – 9
How to count that How much AHU, Chiller & Boiler’s point in my sheet. I Have 1000 Data in sheet.
You can get it from pivot table, select d whole data, go to insert (top left side) you will get pivot table option.drag the name in column table and value in value table. ( just check in table value is in sum format or count format, accordingly you can change)
AHU – 9 AHU =LEFT(A1,FIND(“– “,A1,1)-2) AHU – 15 AHU =LEFT(A2,FIND(“– “,A2,1)-2) Boiler – 20 Boiler =LEFT(A3,FIND(“– “,A3,1)-2) Boiler – 33 Boiler =LEFT(A4,FIND(“– “,A4,1)-2) Boiler – 5 Boiler =LEFT(A5,FIND(“– “,A5,1)-2) Chiller – 8 Chiller =LEFT(A6,FIND(“– “,A6,1)-2) Chiller – 7 Chiller =LEFT(A7,FIND(“– “,A7,1)-2) Chiller – 9 Chiller =LEFT(A8,FIND(“– “,A8,1)-2) Chiller – 8 Chiller =LEFT(A9,FIND(“– “,A9,1)-2) Chiller – 9 Chiller =LEFT(A10,FIND(“– “,A10,1)-2)
hello sumit, thanks for your videos, they are really nice and it really helped me to learn from scratch.
Hey sir I wll be starting Excel training course great opportunity with me
Hi Sumit..The content and the communication are nothing less than excellent. Thanks.
I Want to Join.
Hello sir, I will start by thanking you greatly for this opportunity, the module are so powerful and I don’t want to miss a thing . I promise to recommend it to friends too.
After I finished the course can I have any certificate or what
Thank you very much dear Sumit 🙂
Thank you Summit, I do self-study and it gives me confident day by day.
Dear Sumit Sir,
Thanks a lot for this free excel training course. Never thought that i can learn so many things in this course. My confidence level has gone up now.
The way you explain the tutorials are very easy to understand.
You are Truly MVP. Hats off
I was looking for a way to learn Excel for free. I just lost my job and I see that most of the companies require knowledge of using Excel. I will let you know my results when I am done here!
Excel video
How can i enroll this course ?
Nothing to do enroll. All things are in front of your finger tips, start with praying to sumit bansal and keep going, rock on
Thanks Sumit for your excellentwell-paced method of teaching the basics in excel. I am an older adult who ‘missed the train’ on this kind of information. I was just asking my son for some assistance when I found your video. This has given me hope that I may be able to pursue your advanced Excel course if I master the basics. O I am so excited!
Really appreciable sir, you are extremely brilliant, and really doing good work for helping student in excel tutorial, each and everything you are making clear to student in each video even tiny things you are covering and your voice is so clear and very simple way to make understand. thank you so much
Thanku sir for this wonderful excel videos but sir i want certificate with this so can you provide certificate of this or not?
For certificate you can go through udemy! Course,, if you are willing to get certificate, thank you, rock on!
I’m looking for a procedure that will allow my to put a date and image on one tab, and show the image in a calendar on the calendar date tab on the images birthday
This is the most helpful teaching website regarding excel I have come across online. Your teaching style is really passionate, your way of explanation is very clear and you obviously deserve a load of respect and appreciation. It helps me a lot in better understanding excel, and also motivates me to dive deeper into further learning.
Excellent. Explanation is brilliant.
Thanks very much for tutorials, I like to know if there is a way to make just a cell behave as a normal calculator. i.e this cell should be capable of summing figures that appears in another cell, while keeping last cumulative figure visible. This other cell will be the key-in cell or active cell. Example: Cell 1: =2*5, Answer appears in Cell 2, Cell 1: =3*6.8, Answer is added to the previous value resulting from (2*5) and still appears in cell 2. Kindly share a video if this is possible. Thank you.
Excellent Course. Really useful. Thanks!
I have searched online and came across your youtube video tutorial on how to count color using function and macro module programing in excel. I am traying to count the highlighted cell that contains a specific numbers inside of the cell highlighted in color using your code. Can you help me to verify the changes that I have to make to count and add the cell value instead of adding “TotalCount = TotalCount +1” use “TotalCount = TotalCount + “Cell value”” ? What should I change to add the values inside of the cell instead of 1? Your or anyone’s help is deeply appreciated.
Hey! in lesson4, almost at the start of the video, you select a group of cells and address them together with the help of a colon, and as you type the no. 1, it appears in every cell. when I do the same, it isn’t happening. why?
highlight the cells you want to enter the information in, type the information then press CTRL+Enter
I would like to learn the importance of this course which helps me in resume as an addon and can be fast in computer operations with Latest knowledge
Excellent for beginners
Excellent platform and tutorials for beginners.
Yes, Sumit it is exciting to Join with your Free Excell training videos. I learnt a lot and appreciate your Teaching skills. It is so easy to understand each step as you move forward. Thanks and Blessings. Great work.
Hello I am reviewing your free excel training course. Does your course offer practice after watching the videos?
I am trying to give this to my employees. However, I would like to give them a practical test to be sure they went through all training modules. Could you help with this?
I tried to clean data by using the methods suggested by you in one of your lesson. But could not successfully clean certain data sets. How can I send it to you for your help?
how can send a query in excel
Thanks a lot. I receive more about Excel.
wonderful teaching and lessons.Thanks Lot. I learnt Lot
I receive more knowledge related Excel thinks you if you have other levees of excel send me linked
Can I get any kind of proof that I completed the modules at the end?
Thank uuuuuu
Excellent, learnt what I needed to. Easy to understand
I am unable to open the lessons???
I feel very happy not only to be enriched with learning Excel tips by you but also to be enjoyed by your way of imparting training.I express my thanks & gratitude to your contributions to us. But one fact is that I am unable to download ebook “Excel The Smart Way”. How can I be able to download the book? Please suggest me.
Cannot open your lessons for Excel Basics. Any direction appreciated. Thanks
Excellent Sumit! I truly wish to appreciate your way of teaching and effort you put in while creating these videos. I learnt a lot
is there any thing by which I can search old photos, through newly clicked photo. I have a folder in which I have approx 1000 photos and want to search old photos of same person i clicked today.
Hi, Im subscribed to a mail list for 31 videos ([Excel Video 8 of 31] today) buy i want to subscribe a friend but I dont see where he has to click to subscribe to the list. Can you tell me what he neds to do? thanks in advance
Thank you Sumit for giving us your time and teaching us Excel. I am subscribed to your YouTube channel. The Excel in two minutes series contains nine parts. I am unable to access parts five through nine because they are listed as private. If this is in Error will you correct it so I can view those videos please?
I have so many row and column and all Cell have Filled with Like ‘Pradeep’. and I want to remove all Single quotes from all cell
Thanks in advance .
You can do this with Find and Replace
Fantastic videos Mr. Sumit, very appreciate I feel like i am in a good value class of excel
Thanks for commenting Alkozai! Glad you found the videos useful 🙂
thank you soooo much!!! Very appreciate for all you have done.!!!
Thanks for commenting! Glad you found the videos useful
Thank you so much, very helpful videos. you are awesome.
Thanks for commenting Rachid! Glad you found the videos useful
I Click on the lessons and they do not open???
Can you try again Rose? If you still don’t see the videos, you can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Thanks you summit for your knowledge.
Good Morning, I am having a problem with finding the video’s to watch. Can you help me with this Any suggestions? Thanks
Hello Courtney.. You can find the videos as soon as you click on the gray bar. If you still don’t see the videos, you can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Thanks you Sumit for your knowledge.
Thanks for commenting Zayar! Glad you found the videos useful
Good morning. I am having the problem where no video pops up when gray bar is clicked. I tried ctrl+F5. It didn’t help. Any suggestions? Thanks.
You can also access these from this link – https://www.youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Thank you Sumit for all your knowledge, so expertly delivered.
I am glad this excel training is free. Thank you very much for this helpful information!
Thanks for commenting Rachael! Glad you found the videos useful
Hi I have hundreds of rows and I want to multiple select rows over 10 columns with bold fonts only, I saw you video on filtering cells that contain bold font, do you have similar for rows with bold font instead of cells?
if want learn advance excel how much charge i pay
I need to learn more about excel
Hi… your videos are very detailed and very helpful…thank you for all your efforts in sharing your knowledge..
Would like to learn about complete advance excel.I feel it is difficult n little complicated
HI Sumit these are really useful videos. Do you have similar trainings for google sheets?
Do you provide a certificate of completion?
Do you get a certificate on completion of the course
Just seen 4 of them today intial ones and its superb, no need to go anywhere. Simply and Easiest way to learn excel from Sumit Bansal
I want to know If i want to create a data for my students in which i have name ,address,phone and email And categories them using Drop down feature according to their subject
And automatically update them in DIFFERENT EXCEL DATA AS PER SUBJECT
LIKE MASTER SHEET Having All Students
And different sheets having name and address according to subject like
Maths students Science students English students
hello, i used your video for the indirect drop downs and it was very helpful. The only problem that I am having is that some of them work and others do not. Is there an easy fix for this?
This is nice I m a engineer so plz teach me only chart, diagram,engineering related video
Thanks for the videos, your method of explanation is very superb. God bless you
As a beginner with Excel, I really enjoy your tutorials and it helps a lot…… thank you Mr Simit, Hope to learn more from you as I go along with more free tutorials.
Truly appreciate the time and effort you put in to this for free! Maybe add a donate button or something so people that want to can show their appreciation with moolah! I haven’t even watched one video yet just had to comment.
Today is Thursday, August 8, 2019 and I used these videos to relearn how to use excel. They were extremely helpful. Even more happy this training was free.
Thank you Summit! (From CT)
You are a miracle. Created vids, summaries for free. More than just an average youtuber. Thank you so much. Greetings from Long Beach CA
Can you please upload a video on mail merge particularly with many-to-one option.
I chanced upon this website and felt the absolute need to thank you for sharing your knowledge.
After successful completion, will you give certificate to show when required?
Thank you so much for this course it is really helping me you are such a good person to do this for us all.
Thank you Sumit for an excellent training course!
Now I have a question, not about your course, but if you coluld solve this problem I would be grateful. Do you know how to get rid of the usernaume in comments? I know I could go via Alternative/Genereral/Microsoft Office/Username etc. but that does not solve the problem. If I put a space instead of my name, or my initials, it still writes “:” in bold character and I want a empty comment when I start writing in it.
I think it must be solved by VBA code? And I don’t know how to write it, so if you know, and if you can help me, I would appreciate that.
I think it is very annoying that I have to delete my name (or initials) in everey new comment I make. Must be a way to get around it?
Kind regards, Leif Norinder
Dear Sumit Bansal, I am really appreciate you concern to teach people without any interest. that is a really surprised me in this current mindset of the people. again thank you for your kindness.
This is so helpful- thank you so much!
Will I be graded/ receive a certificate of completion?
Hello Connie.. Since this is a free training, there is no certificate for completion or grading
I Got Stuck That You Just Told Us IN a Video… Kindly Tell Me How Can I Connect With You For Solution
Thank you Mr Summit. You are the bomb.
Glad you found the training useful!
By learning this course would I have completed advanced level or just basic or intermediate?
This course will make you an intermediate Excel user. If you’re looking for more advanced courses, check these – https://trumpexcel.com/learn-excel/
Hello Sumit, Can I share your youtube videos on my Facebook Page. I will write credit to your name and mention your website any other services you offer. Thanks.
Sure.. Feel free to share
As a student who needs additional time to truly grasp the concepts of Excel, this site is an absolute LIFE SAVER! Thank you so much Sumit!
Thank you for the kind words Mujeeb.. Glad you find the site useful 🙂
Cant believe so much detailed training and guidance for free. Thank you so much Sumit.
Glad you’re finding the training useful Darren 🙂
Thank you so much -your tutorials have been a great help!
Glad you’re finding the training useful Fran
Great job! One question, I am calculation the available FTE per month with Excel Leave Tracker Template, I have to use the # of work days, how I am going to calculate this value and use it in the summary table. Thank you
so nice easy to understand
Hello. Hira
Thank you so much for this structured and comprehensive Excel Tutorials which I found very informative, and the best part of it is that it is totally free. I really appreciate your time and effort giving an opportunity for those who need this materials, including myself. I believed this free Excel Tutorials will help me a lot to land my home-based job.
Thanks once again and God bless your knowledge and expertise.
This is awesome!!!!!!!!!!!!!!
Hello Sumit, I like how you have divided the course into different modules and videos. I have done accounting and finance in the past so I feel this is really needed for my growth and career. If I complete all these videos and practice, will I be able to operate basic to intermediate excel ?
Hello Shriya.. Glad you found the course useful. Yes, you would be able to handle basic to intermediate tasks in Excel after watching the videos and going through the practice files.
Thank you Sumit. Also wanted to ask you, I use Macbook so there are few things which are different in Excel in Macbook. If possible can you upload a video where you mention those few differences. For eg. I can’t find a dialogue box in Excel on Mac. Can you help me with that.
Thank you for the great help.
Wonderful! Thank you!
Sounds good to me!!
I want and NEED a good part-time office job but don’t have the computer skills that many jobs require and have liked working with numbers in the past.
Hello Lisa.. Good working knowledge of Excel should definitely help you get a job
You are a fantastic man to offer your services to educate those that need to learn about excel …. for free. How refreshing it is to hear you speak (not too fast, nor too slow) in a manner that is clear and understanding. Thank you most kindly.
Thank you so much for the kind words Fiona.. Happy you found the course useful 🙂
Hi, none of the videos are working… I tried several times in vain
Working alright at my end. You can also watch the course videos here – https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Hello Mr. Sumit,
I am unable to find “Developer tab” and “Customizing Ribbon and QAT” options in Excel 2007 . Kindly help me how can I access these options ?
Have a look at this – https://trumpexcel.com/excel-developer-tab/
Sorry, unable to find the ‘customize the ribbon’ toolbar in 2007 excel. I guess I need to upgrade excel with 2013 version.
Is this a certification course ? If not, then what should we do to get a certificate for our learnings ?
Hello Dhiraj.. This is a free course so no certificate is issued for completing it
Will I receive a certificate of completion for this training?
Hello Terri.. This is a free course so no certificate is issued for completing it
I created some data in Sheet 1, Cell A1 (in Excel 2016), and I linked these contents of Sheet 1 to Sheet 2, Cell A1. I created a link to enable the contents of Sheet 1 (Cell A1) to appear automatically in Sheet 2 so that whenever I change the contents of Sheet 1, the same automatically changes in Sheet 2. To quickly go back to Sheet 1 (where the original data is contained), I used DOUBLE-CLICK method and, as expected, Excel immediately moved back to Sheet 1, Cell A1.
However, when I use my laptop at home (also Excel 2016) and try to DOUBLE-CLICK when I am in Sheet 2 in order to quickly go back to Sheet 1, Cell A1, instead of linking me to Sheet 1, the cursor is just blinking in Sheet 2.
Question: How do I change the settings of my laptop at home to enable me jump from Sheet 2 to Sheet 1 upon double-clicking the link in Sheet 2, Cell A1, to enable me to go to the actual location of my data in Sheet 1? Thank you.
Hi Sir! Thank you for this three tutorial. Unfortunately, I don’t see any video to watch. What should I do?
When you click on the gray bars on the page above, you will get the video that you can watch. Are you not getting any videos when you click on the gray bar?
No, I don’t see any videos. Just a list of what we will learn in the section.
Can you please try now? Also, refresh the page (hold the control key and then hit the F5 key). This should fix the issue
That’s perfect! Thank You Sumit.
Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….
no. not getting any videos
Sumit You are truly an MVP. Your videos and instructions are fantastic, they are easy to understand, not cumbersome or a burden to watch and your instruction is simple and precise. I have used Excel for a very long time but each time I need an answer you are my go to search and instructor and it goes without saying I always find what I am looking for. Are you as good in other aspects of the MS Suite or Master of one? Let me know. Thanks for your support. Paramveer Sidhu
Thank you so much for the kind word Paramveer 🙂 I only focus on MS Excel. While I use most of MS apps, I am not as deep into it as I am in Excel.
Are you on linkedin?
Wonderful learning tool for work experience
Hi Sumit Bansal,
I don’t find any video link in this page…
Video links?
Hi, the links to your videos disappear. Could you please fix it?
Where are the links to start the course – videos??
Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area….
Bro where is the link to videos????
Your website provides excellent insight in Excel which is very useful for every type of end user.
I am struggling with an issue, I am unable to resolve myself and I hope you can give me right direction: In my first worksheet “dataentry” I have a column A and B, where column A is a dropdown list with numbers and column B is a dependent dropdown list related to column A. On my second worksheet “datalists” I created the value lists related to column A and B. The problem lies in the fact that on the “datalist” worksheet Column A defines the value list which should be displayed when selecting the value for Column A on the “dataentry” but that I want to see the full description from Column B from the “datalist” sheet in my dropdown list. Similarly, on the “datalist” worksheet Column C defines the value list which should be displayed when selecting the value for Column B on the “dataentry” but that I want to see the full description from Column D from the “datalist” sheet in my dropdown list.
I hope I made my problem clear and really hope you are able to help me out here.
Thanks in advance!
really helpful pls post some course on advance excel such as vlookup & hlookup, data validation
Do they give a certificate on completion of course too?
I enjoy your courses, you make learning Excel easy !!
Need your support on power query. I have gone through the video of merging multiple workbooks into one workbook. That was an interesting feature. However need to know one thing. In case we have two worksheets on three workbooks with similar names, is it possible to merge into one having the end result as a combined workbook with two worksheets
Thank you Sumit. Your sessions are awesome and its a great learning for all of us
do i get any certificate after completing this course?
I have 1 to 20different amount & m No10fdeleted how to shift up 11 to 20 up
Thank You Sumit, you have a heart for people and an understanding of their needs, I honour you for the gift that you are sharing with us, I pray blessings over any venture that you set your heart on.
Great Job Sumit
Thanks a lot Sumit
its a really helpful for people who will not spend money to learn that course.. thank you so much sir…. if it is possible please make these videos to downloadable ….
Thanks sumit … all videos are great and very helpful…. And again thank you so much, making this course free so that more people engaged to learn excel.
Thank you so much, making this course free will get more people engaged to learn excel the right way
Great learnng excell.
thank you so much, you are very generous.
Where can I download the videos used in the course? Thanks
You can’t download them…
Thank you Sir, I am delighted with your work. Your hard work and dedication have brought positive changes in learning excel. Though i could not yet prepared excel sheet for fetching the fund mutual fund units from nse mf fund for my portfolio. I am trying to prepare requisit worksheet in excel 2007. Thanks again.
When you click on the gray bars on the page above, you will get the video that you can watch
I can’t find any links to the videos. When I click on a grey bar, it expands with a detail of the contents of the lesson, but I can’t see any video or link to same.
Just discovered the cause of this problem: my Adguard blocker was stopping the display of the video. AOK now. Thanks.
Aha! My adblocker was preventing the videos from appearing. When I turned it off, the videos appeared. Thank you.
Leave a Comment Cancel reply
BEST EXCEL TUTORIALS
Best Excel Shortcuts
Conditional Formatting
Excel Skills
Creating a Pivot Table
Excel Tables
INDEX- MATCH Combo
Creating a Drop Down List
Recording a Macro
© TrumpExcel.com – Free Online Excel Training
![assignment for ms excel DMCA.com Protection Status](https://trumpexcel.com/wp-content/uploads/2018/08/Free-Online-Excel-Training-DMCA-Protected.png)
Privacy Policy | Sitemap
Twitter | Facebook | YouTube | Pinterest | Linkedin
![assignment for ms excel Free-Excel-Tips-EBook-Sumit-Bansal-1.png](https://trumpexcel.com/wp-content/uploads/2024/03/Free-Excel-Tips-EBook-Sumit-Bansal-1.png)
FREE EXCEL E-BOOK
Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster
![assignment for ms excel Free Excel Tips EBook Sumit Bansal](https://trumpexcel.com/wp-content/uploads/2024/02/Free-Excel-Tips-EBook-Sumit-Bansal.png)
![assignment for ms excel Logo for South Puget Sound Community College](https://spscc.pressbooks.pub/app/uploads/2020/07/SPSCC-Swoosh-white-edge-e1595977111925.png)
Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
Excel Practice 1
![assignment for ms excel Practice It Icon](https://spscc.pressbooks.pub/app/uploads/sites/49/2021/02/Practice-It-FINAL-300x99.png)
Since Microsoft Excel is widely used in industry, and we are using Microsoft Windows, we will focus on Excel going forward. There are many similarities across spreadsheet software, so the skills we are learning can be translated to other software and apps. The following ‘Practice It’ assignments are designed to be completed using Microsoft Excel in Office 365 on a PC with Windows 10 or higher.
![assignment for ms excel](https://spscc.pressbooks.pub/app/uploads/sites/49/2021/04/Chapter3_PracticeIt1_pexels-mentatdgt-1569076-scaled-1.jpg)
We will use Excel to perform complex calculations, analyze data so that we can make intelligent decisions, and create visually interesting charts and graphs that help us understand the data. Since Excel is used for Data Analysis, it is best to use a keyboard and mouse or touchpad rather than the touchscreen.
In Excel, data is stored in a cell . Cell content is anything that is stored in the cell and can be either a constant value or a formula. The most commonly used values are text values and number values . Values can also be a date or time. A text value is also referred to as a label.
Here is a video demonstrating the skills in this practice. Please note it does not exactly match the instructions:
Complete the following Practice Activity and submit your completed project.
For our first assignment in Excel, we will create a spreadsheet with monthly expenses. This spreadsheet will provide us with an overall picture of our financial health by helping us understand where we are spending our hard-earned money. We will start with a new blank Excel Spreadsheet.
- Start Excel. Click Blank Workbook.
- Select File, Save As, Browse, and then navigate to your Excel folder on your flash drive or other location where you save your files. Name the workbook as Yourlastname_Yourfirstname_Excel_Practice_1.
![assignment for ms excel image](https://spscc.pressbooks.pub/app/uploads/sites/49/2021/05/image8.png)
- Notice the vertical and horizontal scroll bars. Use the arrows to practice scrolling on the page.
- In cell A1, type My Budget By Month and press Enter.
- In cell A2 Type For the First Quarter and press Enter.
- In the Name Box, change A3 to A4 and then press Enter. Notice how the active cell changed to A4.
- Misc Expenses
- Monthly Total
- In cell B3, type January and press Enter.
- Select cell B3 and use the fill handle to drag to cell D3. Notice how the names of the months automatically generate. The fill handle enables auto fill , which generates and extends a series of values into adjacent cells based on the value of other cells.
![assignment for ms excel image](https://spscc.pressbooks.pub/app/uploads/sites/49/2021/05/image15.png)
- Adjust the column width for column A to 136 pixels by dragging the right boundary (between columns A and B) to the right.
- Select the range B3:D3 and center the text.
- In cell B4, type 1200 and enter the remaining numbers as shown:
| January | February | March |
Housing | 1200 | 1200 | 1200 |
Groceries | 200 | 250 | 275 |
Utilities | 85 | 80 | 90 |
Misc Expenses | 20 | 50 | 30 |
- In cell B8, type =b4 + b5 + b6 + b7 and press Tab.
- In cell C8, type =c4 + c5 + c6 + c7 and press Tab.
- A quicker way to enter in a formula is with a function . We will use the SUM function next. In cell D8, click AutoSum on the Home Tab, Editing Group and press Enter.
- In cell E3, type Total and then press Enter.
- Click in cell E4, Press Alt + =. This is a keyboard shortcut that enters the Sum function. If the keyboard shortcut does not work (this is common due to variations in keyboards), use the AutoSum technique from step 16.
- Click the Enter button on the Formula Bar which is the green or blue check mark.
- With Cell E4 selected, drag the fill handle in cell E4 down through cell E8.
- Click in cell F3, type Trend and press Enter.
- Click in cell A1, and drag your cursor to the right to select the range A1:F1. On the Home tab, in the Alignment Group, choose Merge and Center . The title should be Merged and centered in the range A1:F1.
- Using the same technique, Merge and Center the title in the range A2:F2.
- Apply the Title style to cell A1 and the Heading 1 style to cell A2. Cell styles are on the Home Tab, Styles Group, then choose the arrow next to cell styles .
- Apply the Heading 4 style to the ranges B3:F3 and A4:A8. You can select the first range, hold down the CTRL key, and select the second range, then apply the cell style. Or apply, one at a time.
- Apply the Accounting number format to the ranges B4:E4 and B8:E8. The number format is located on the Home Tab, Number Group. Select the arrow to view a drop down list of all number formats.
- Apply the Comma number style to the range B5:E7. This is located on the Home Tab, Number Group, and select the comma.
- Apply the Total number style to the range B8:E8. Cell styles are on the Home Tab, Styles Group, then choose the arrow next to cell styles.
- AutoFit column D. Select column D by clicking on the D Column Header. Then, double click the line between the D and E. Or, with Column D selected, on the Home Tab, Cells Group, click the arrow next to Format and choose auto fit for the Column.
- Apply the Slice theme to the Workbook. On the Page Layout Tab, in the Themes Group, choose Slice. If necessary, adjust the total cells, or any other cells to ensure you can see all of the cell content.
- Select the range A3:D7.
- On the Insert tab, in the charts group, click Recommended Charts, click All Charts, select Clustered Column chart and then click OK.
- With the chart selected, under the Chart Design Tab, in the Chart Layouts Group, Choose the Add Chart Element and ensure the Chart Title is ‘Above Chart’. Change the Chart Title to My Budget.
- Drag the chart by clicking and holding any of the chart outer lines using the four-sided arrow mouse pointer. Move the chart so that the upper left corner is inside cell A10.
- Ensure the chart is still selected, and apply Chart styles, Style 6. Chart styles are located on the Chart Design Tab, under Chart Styles. Click the down arrow (“more” button, which is the upside-down triangle with the line above it) to see all of the Chart Styles.
- Using Change Colors select Colorful Palette 4. The Change Colors button is located on the Chart Tools, Design Tab, under Chart Styles
- Select the range B4:D4 and insert a Line sparkline in cell F4. Be sure to not include the totals in the sparkline range. Sparklines are located on the Insert Tab, Sparklines group, then choose Line. The sparkline will display in cell F4. For the location range, click in cell F4.
- With cell F4 selects, on the Sparklines, Design Toolbar, in the Show group choose the checkbox next to Markers.
- Apply the Dark Green, Sparkline Style Colorful #4 style (or similar). Styles are located on the Sparkline Design toolbar in the Style group. Choose the down arrow to view more styles.
- With cell F4 selected, use the fill handle to fill the sparkline to cells F5:F7.
- On the Page Layout Tab, Sheet Options Group, click the arrow to launch the Page Setup Dialog Box. Notice how it opens to the Sheet tab. Go to the Margins tab and click the checkbox to center the data and chart horizontally on the page.
- With the Page Setup Dialog Box still open, go to the Header/Footer tab. Choose Custom Footer and insert the File Name in the left section of the footer. The file name will show in the Print Preview and also when the spreadsheet is printed. This is a field , so if the file name is changed, it will automatically update the footer with the new file name.
- Title: Excel Budget
- Subject: OFTEC 108 and Section #
- Author: Your First and Last Name
- Keywords: Sums, Charts, Budget, Excel
- Click the back arrow to exit backstage view. Click the Save shortcut button and ensure your file is saved in a safe location.
- Select the range A2:F5 and then press Ctrl + F2. This is the keyboard shortcut that displays Print Preview . If you do not have the shortcut key, click File to enter Backstage View, Print and view the Print Preview.
- Change the print settings option to Print Selection and notice how the Print Preview changes. Printing of this assignment is not required, but if you needed to print a copy, you would click Print.
- Exit Backstage view and Save your file.
- On the Formulas tab, in the Formulas Auditing group, Show the Formulas. This is a toggle button, so press it once to show the formulas. Press it again to remove show formulas. Notice how row 8 and column D display the formulas rather than the result when the show formulas is turned on. Turn show formulas off.
- On the Page Layout tab, in the Page Setup group, Change to Landscape orientation and Scale the data to fit on one page. This is on the Page Tab of the Page Layout Dialog Box.
- Run spelling and grammar check from the Review tab using the Spelling button in the Proofing group, making any spelling corrections as necessary. Compare your file to the image below and make all necessary corrections.
![assignment for ms excel Image of sample budget](https://spscc.pressbooks.pub/app/uploads/sites/49/2021/05/image43.png)
Intro to Microsoft Office Copyright © 2021 by Abby Rusu & Maricopa Millions is licensed under a Creative Commons Attribution 4.0 International License , except where otherwise noted.
Share This Book
![assignment for ms excel Python and Excel Projects for practice](https://practity.com/wp-content/uploads/2021/05/Sin-titulonuevo_logo380.png)
Real Excel Exercises with Solutions
![assignment for ms excel](https://practity.com/wp-content/uploads/2019/01/img-2-1-740x493.jpg)
Description
Additional information, reviews (0), excel exercises for practice, description.
A real Excel project focused on data validation and data manipulation in Finance. It includes 15 Excel exercises for practice based on the daily routines that banking analysts and finance consultants have to carry out in order to prepare worksheets before doing their analysis. This Excel assignment is split into three main parts: 1) Clean, edit and prepare the worksheet to execute the validation. Easy. 2) Analysis and validation/reconciliation of data. You will have to compare columns to find differences or retrieve data from one sheet to another: Advanced 3) Modification and data manipulation: Intermediate. It consists of the classic reconciliation and validation tasks every finance professional has to carry out on a daily basis. All Excel practice questions included in the project are real, very common while working with spreadsheets. The advantage of working with real Excel projects like this one, is that you learn how to use Excel to solve specific problems and what formulas or functions are the most suitable in each scenario. That is the main difference with regular exercises. It is a simulation of what you will confront in the real world.
WHAT YOU WILL LEARN
1) Data querying formulas, in particular Vlookup . You will learn about the business applications of Vlookup as well as the different situations where you may execute it. The second part of the project is all about vlookup. 2) Commonly used functions: IF statements, nested formulas, concatenate(), exact(), etc. 3) Cell editing and formatting features. 4) Navigation on the spreadsheet, keyboard shortcuts, filters, etc. 5) Page set up: Insert/delete rows/columns, copy, paste options, etc. 6) Print out spreadsheets.
REQUIREMENTS
These Excel exercises for practice are aimed at beginners, but it requires a minimum knowledge of Excel. Students must have attended an introduction course of Excel . All spreadsheets included in the project have been done in Excel 2013. It is compatible with Excel 2007, Excel 2010 and Excel 2016.
DIGITAL DOWNLOAD / CONTENT
You will receive a Zip folder in the confirmation email sent after purchase. It is also available on your Practity account. The file includes 2 PDFs and 5 Excel files: 1) PDF with the instructions. 2) PDF (20 pages) with the project solutions. You will receive detailed explanations about the formulas required to complete each exercise. You will also see images showing where the requested features and tools are located in the Excel layout. 3) Three Excel files with data. 120 rows and 19 fields. 4) Two spreadsheets with the Excel exercises solved.
- Email Address *
IMAGES
VIDEO
COMMENTS
Download our 100% fre e Excel Practice Workbook. The workbook contains 50+ automatically graded exercises. Each exercise is preceeded by corresponding lessons and examples. Download.
Practice And Learn Excel Online For Free. Welcome to Excel Practice Online! On this website, you will learn and practice Excel functions and tools! 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 ...
Try it now! Click to learn Excel for free. Free online Excel training for beginners and experts (all skill levels). 3 lessons (30 minutes total), free assignments & much more.
Excel Exercises Solves the "Boring Video" Problem. We walk you through all the Excel functions that you need to know, forcing you to type through practice exercises to get hands-on and commit them to memory. You'll also practice keyboard shortcuts on your own keyboard to build muscle memory and get faster at manipulating spreadsheets.
Here you can practice dozens of Excel exercises with full solutions and explanations. If you are new to excel, please check out our Excel Basics Tutorial! The explanations can be found in the Answer tab in each of the exercises. Have fun.
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!
Import a population table then tidy up the data. Tidy up exchange rate and investment data in Power Query, splitting columns and replacing values. Create a query to import a table of tall buildings, create new columns and then pivot the data. You can search our full list of Excel exercises here .
Excel Practice Exercises PDF with Answers. To solve the following exercises, 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. You can use Excel 2010 or later, except for the UNIQUE ...
Intermediate Microsoft Excel Worksheet: Practice 1. Objectives: The Learner will be able to: Enter data into a Spreadsheet. Use AutoFill with labels, data, and formulas. Format Cell Borders and Contents. Calculate the total across the rows. Calculate the total for each column. Use Conditional Formatting.
##### 50 Ms Excel Assignments Pdf For Practice Free Download ##### Assignment - Use of Formulas Sum, Average, If, Count, Counta, Countif & Sumif. Roll No Student Name Hindi English Math Physics Chemistry Total Average Grade 1 RAM 20 10 14 18 15 77 15 A 2 ASHOK 21 12 14 12 18??? 3 MANOJ 33 15 7 14 17???
Excel Case Case: Poke Mart Case: Poke Mart, Styling Excel Functions AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR Excel How To Convert Time to Seconds Difference Between Times NPV (Net Present Value ...
Get Started with Excel. To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials. These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.
Concatenate first and last names exercise. For the fourth of our Excel beginner exercises, we will be combining the contents of two cells. The first cell will have a first name, the second cell will have a last name in it. We would like to fill the third cell with the first name, then a space and then the last name.
Assignment. 1. Open the workbook you created in Part One, if it is not already. 2. As shown below: (Lesson 2: 4,5) a. To enter new rows or columns, simply click on the row or column header to select the whole. row or column. Then right click with the mouse and choose insert.
6: Fitness Tracker. For your next Microsoft Excel project, try creating a fitness tracker spreadsheet. (A good way to answer some of the questions to build this, is to imagine you're creating this tool to help you set your own fitness goals).
This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video. You'll learn ...
The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials. Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems.
This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning). You don't need to sign-up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel. To make the most of this free training, please go through these Excel training videos in the ...
The following 'Practice It' assignments are designed to be completed using Microsoft Excel in Office 365 on a PC with Windows 10 or higher.. We will use Excel to perform complex calculations, analyze data so that we can make intelligent decisions, and create visually interesting charts and graphs that help us understand the data.
It includes 15 Excel exercises for practice based on the daily routines that banking analysts and finance consultants have to carry out in order to prepare worksheets before doing their analysis. This Excel assignment is split into three main parts: 1) Clean, edit and prepare the worksheet to execute the validation. Easy.
Unlock the power of ranking data in Microsoft Excel with our tutorial on using the RANK function. Join us to learn how to effectively use this function to assign ranks to data based on criteria, enabling you to analyze and compare values with ease, and make informed decisions in your spreadsheets.
Assign tasks to others from you email in Outlook. If you need a reminder to respond to a message in Outlook, create a task with the My Day pane. With the To Do integration in new Outlook, you can create tasks from Mail when your My Day pane is displayed. Drag an item from Mail to create a task.Show calendar and tasks with My Day in Outlook
Excel; Microsoft 365 and Office; Search Community member; ... Excel Formula: Calculate age then assign Group Name I help to run a local group which has different sub-groups depending on the age of the member attending. I'd like to have a spreadsheet that is more automated. I know the DOB of each member - is there a formula that I can use that ...
On July 18, CrowdStrike, an independent cybersecurity company, released a software update that began impacting IT systems globally. Although this was not a Microsoft incident, given it impacts our ecosystem, we want to provide an update on the steps we've taken with CrowdStrike and others to remediate and support our customers. Since this event began,...