excel basic assignments for practice pdf

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 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.

excel basic assignments for practice pdf

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.

Excel Practice Exercises PDF with Answers

What is ExcelDemy?

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

You really help me alot thanks

Hello, Aleem!

Thanks for your appreciation. stay in touch with ExcelDemy .

Regards ExcelDemy

Thanks a lot

Dear Rashmi ,

You are most welcome.

This is very helpful. You are God send

Thanks for your appreciation.

Excel Practice Worksheets

Excel practice exercises.

Download our 100% fre e Excel Practice Workbook.

The workbook contains 50+ automatically graded exercises . Each exercise is preceeded by corresponding lessons and examples.

Excel Boot Camp

Excel Boot Camp: Learn Excel inside Excel

The ultimate Excel tutorial - learn efficiently with the "boot camp" approach.

Practice Online

Instead of practicing inside Excel, you can practice online with our interactive Formulas & Functions Tutorial !

Practice Shortcuts or VBA

You can also practice online with our interactive Shortcuts and VBA tutorials:

Practice And Learn Excel Online For Free

Welcome to Excel Practice Online!

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

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

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

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

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

Formulas/Functions

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

Intermediate

Conditional.

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

Pivot tables

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

Text Formulas

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

Date functions

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

Index & Match lookup

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

Other advanced tools

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

Power Query

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

Secret Excel Functions

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

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

Financial Functions

Learn how to use Excel to make financial calculations!

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

Excel Macros – VBA (Visual Basic for Applications)

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

Excel Data Sheets for Practice

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

Excel-Online Blank Worksheet
Excel Practice Data

How to Calculate in Excel – Excel-Online Calculators

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

Terms and Conditions - Privacy Policy

Excel Exercises helps regular people learn Excel as quickly as possible.

Our bite-sized, interactive lessons make excel skills easy to learn and remember..

"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.

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.

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.

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 .

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

Real Excel Exercises with Solutions

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 *

Specification: Real Excel Exercises with Solutions

Difficulty
Time Estimate	12 Hours

User Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related Products

Solar System Calculator

Excel Exercises for Job Interview

25 Real Pivot Table Exercises

Excel Data for Practice

Excel Templates Practice

Excel Dashboard Challenge

Terms of Use

Shopping cart

Free Excel Training

Finally, a free Excel course that adapts to your skill level.

Trusted by 100,000+ students.

Three 10-minute lessons

Free exercises

Easily apply what you learn

Fits any skill-level

For beginners and experts

What you learn

New to Excel?

3 lessons on formulas and functions (the basics of Excel).

Learn what a formula is and how to write one

Make your spreadsheets look professional

How to use SUM, COUNT, and AVERAGE (and all other simple functions)

Not your first time?

INTERMEDIATE

3 lessons on data cleaning and advanced functions

IF and SUMIF

Making decisions with functions

Cleaning data

How to effectively clean and organize data

The world’s most popular Excel functions (for a reason!)

Experienced Excel-user?

3 lessons on automating your workflows using macros

Record and edit a macro to make Excel imitate your actions

This is where the magic happens

Your first macro

Let’s automate your first task!

Excel-nerd?

3 lessons on unlocking Excel’s full potential with VBA code

Objects, Properties, and Methods

The basics of (VBA) programming

Using and declaring variables

Implementing logic with If statements

Meet…

Your instructor

Spreadsheeto co-founder

KASPER LANGMANN

Certified microsoft office specialist.

Get advice you can trust

+100,000 students

Among the world’s most-popular instructors

Excel consultant

Applying Excel to real-world situations every day

The most ambitious students and organizations have already joined

Join +100,000 students

I am so happy I decided to learn more in Excel with Spreadsheeto. The lessons are taught in segments which is so great because you can go back and repeat what you needed to view again. You get assignments to complete and the practice helps you retain what you learned. All lessons are clear and easy to understand. There is no way you can’t improve your Excel skill level if you take the lessons and do the assignments.

The curriculum flows very well through all of the training. Kasper keeps the information moving which keeps you engaged. I would highly recommend this training!

I went from being a hesitant and clumsy user of Excel , to being able to do so many things that saved so much time and energy .

Spreadsheeto is saving me hours and hours! Kasper is clear in his directions, it is in short segments with practice in between each, and a review at the end where I find out what I need to practice more. So nice I can go back any time to review. This was an investment in myself and it is paying off beautifully and quickly. Also, I decide when I do the course; I love that flexibility. I highly recommend this course to anyone who uses Excel regularly.

Frequently asked questions

Got other questions? Get in touch!

Why is this training free?

By giving you this free training, you get a feeling for how we teach Excel. We hope you like our style and decide to continue your journey by enrolling in our more elaborate Excel-courses “ Zero to Hero ” or “ VBA Masterclass “.

When and how do I get the course?

The training is delivered straight to your inbox. Right after you’ve signed up, you’re going to receive the first lesson. From there, you receive the lessons 24 hours apart (or faster if you choose to).

Do I need Microsoft Excel for Windows?

Using the latest version of Excel 2021 for Windows is what I recommend. With a Microsoft 365 subscription, it’s very affordable as well. But, if you have Excel 2007 – or later – you can follow along.

How long does it take to complete?

You get three 10-minute lessons, so a total of 30 minutes.

Who's the instructor?

That’s Kasper Langmann. Co-founder and certified Microsoft Office Specialist. With +7 years’ experience teaching Excel to 1000s of students! Read more about Kasper and Spreadsheeto here.

What are the prerequisites?

None! This training fits all skill-levels. All you need is Excel!

Try it now!

IMAGES

SOLUTION: 50 ms excel assignments pdf for practice free download
Excel Practice Exercises PDF with Answers
Advanced Excel Exercises with Solutions PDF
50 Ms Excel Assignments Pdf For Practical Practices
SOLUTION: 50 ms excel assignments pdf for practice free download
Ms Excel Worksheet For Practice Pdf

COMMENTS

[PDF] 50+ MS Excel Assignments Practice Exercises PDF
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.
Excel Practice Exercises PDF with Answers
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 ...
Excel Practice Worksheets
Download our 100% free Excel Practice Workbook. The workbook contains 50+ automatically graded exercises. Each exercise is preceeded by corresponding lessons and examples. Download. Excel Boot Camp. Excel Boot Camp: Learn Excel inside Excel. The ultimate Excel tutorial - learn efficiently with the "boot camp" approach.
PDF Beginning Microsoft Excel: Practice 1
Microsoft® Excel: Practice 3. to: Enter labels and data into Excel at least 75% of the time Enter an equation at least 75% of the time Use Autofill (Fill Down) on a formula at least 75% of the time Format text as big, bold, and centered at least 75% of the time Apply Currency formatting to text at least 75% of the time.
PDF Exercise Part 1-3
Open a new workbook and enter the data as shown below. Follow the steps below. Insert two rows above row number 1. Enter the word "Grocery List" in cell A1. Change the font style to and size 24. Enter the word "DATE" in cell A2. Change the font style to In Cell F4, enter the formula to find the total cost for row 4.
Excel Assignment 1
Assignment. Open the workbook you created in Part One, if it is not already. As shown below: (Lesson 2: 4,5) 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.
PDF Intermediate Microsoft Excel
By the end of this class, you will be able to complete the following skills in Microsoft Excel 2016 and Microsoft Excel 365: • Use shortcuts to navigate and modify worksheets • Sort and filter data • Use VLOOKUP and HLOOKUP to look up information in your table • Use basic conditional formatting to highlight specific data
Excel Exercises
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 🙂.
PDF Microsoft Excel 2016
HINT: Open Excel File tab Open Browse Select KINGSTON (E:) Open "Excel Practice Exercise 1.xlsx". 2. Select cells A1 to F1. HINT: Point to middle of cell A1 When your cursor is a fat white cross , hold down the left mouse button and drag to cell F1. 3. Merge & Center the selected cells. HINT: Home tab Alignment group Merge & Center button.
Excel Practice Online
Learn and practice dozens of Excel functions and tools online for free - from beginners to pro level, without the need to download any files. ... Excel Basics - Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency! ...
Free Excel exercises
Free Excel exercises. You are welcome to try any of the 113 Excel exercises listed below, but please do not distribute them in any form without asking for our written permission first. Adding new data, editing and copying and changing column widths for customer services data. Use Excel to to calculate basic statiscs about the richest people in ...
Excel Exercises
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.
PDF Basic Mathematic Operations in Excel
Steps: To calculate sum, type =sum( in the cell F2 and click and drag the cells C2, D2 and E2 i.e., =sum(C2:E2) where : denotes the range to add maths physics and chemistry marks of student no1. For calculating sum for other students, click and drag the sum value of F2 till F6. Similarly calculate average as =average(C2,D2,E2) or =average(C2:E2).
Microsoft Excel Tutorials
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!
Excel Beginner Exercises
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.
Excel Exercises for Practice. Excel Beginners. Practity
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.
50 Ms Excel Assignments Pdf For Practice Free Download
excellent computer education(a professional training center) 50 ms excel assignments pdf for practice free download assignment use of formulas sum, average, if
PDF Microsoft Excel 2010
Practice Exercise 1. 1. Open "Excel Practice Exercise 1.xlsx" on your flash drive. (Open Excel File Tab Open Select KINGSTON (I:) Open "Excel Practice Exercise. xlsx") Select cells A1 to F1. (Click into cell A1 When your cursor is a fat white cross , hold down the left mouse button and drag to cell F1) Merge & Center the selected cells.
Free Excel Training: 30-Minute Course (100,000+ Students)
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.
PDF Excel Practice Spreadsheet
4b. Enter "Percent" in the column header of each new column. • To enter information into a spreadsheet, click the mouse on the cell where you want data to appear, then type. 4c. In the "Percent" columns, create a formula that will calculate the first. student's percentage for that assignment or exam (Raw Mark / Marked Out.