queen's excel assignment

Search type

University Wide

Faculty / School Portals

• Online Guides and Tutorials

Assignment Planner

The assignment planner is a tool to help you plan and complete assignments. Fill in your details below to receive a customized guide to working on every stage of an assignment.  Choose your assignment type, enter the start and due dates, and  download your step-by-step plan!

To begin , select an assignment type below: 

Research Essay

Literature Review

Standard Lab Report

Annotated Bibliography

Critical Review

Business/Case Report

Philosophy Essay

Keep in mind.

The assignment planner is a guide, not a set of hard and fast rules. Be flexible and don't forget you can always seek our support at appointments and events if your assignment or approach falls out of the box! 

The steps and timing provided by the calculator are only a starting point. Each step in the assignment planner comes with a time estimate, but some steps might take you longer, depending on how challenging the material is, how well you know the topic or process, and your other commitments.

How long any assignment may take to complete will vary. If you’re wondering how long you’ll need to spend on an assignment, take a guess based on your past experience—then add a little more time, just in case.

Although the planner’s output is straightforward, your process might be more messy. The step-by-step output of the calculator will make it seem like you can follow the steps one by one until you finish and submit your assignment. But research can be a messy process. Don't be afraid to move back and forth between stages.

More support is available. If you have any questions or challenges along the way, ask for help. Check with your prof or TA about their expectations.  Meet with a librarian for help  with research. You can also  make an appointment  with one of our writing or academic skills specialists.

While SASS developed the Assignment Planner just for Queen's students, we were inspired by a similar tool  developed by the University of Minnesota.

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

Search type

University Wide

Faculty / School Portals

Multi-Factor Authentication for Generic Accounts

Social media: protect your data, welcome to it services at queen's.

We strive to fulfil the technological needs of all faculty, staff, students and researchers at Queen’s University by providing IT-related strategy, applications, infrastructure, and support services. Browse our service catalog to see the full list of service offerings from IT Services, or use one of the buttons below to direct your inquiry.

Get IT Help

Need IT assistance? Submit an Incident Form in our ticketing system to get help. 

Service Offerings

Browse our service offerings to see how we can support you.

Browse Services

Browse Support Articles

Browse our support articles to find self-help guides and service information.

Browse Articles

Connecting, Collaborating, and Working Remotely

IT Services provides many resources to assist staff members who have opted to work remotely. Check out our Connecting, Collaborating, and Working Remotely guide for more information on how IT Services can help.

Available Tools and Software

In support of Queen’s Strategic Plan, the university has increased funding for enterprise-wide teaching and learning software. The increase in funding allows IT Services to provide the Queen's community access to tools and software  at no cost.

Service Catalog

IT Services provides many services to the Queen's community. Availability of services depends on your role within the university (i.e. student, faculty, staff or department). The catalog indicates who is eligible for what service.

Popular Services

Know where you're going? Log in or visit frequently used services using these quick links.

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

Find all ExcelR Data Analyst Assignment Solution Here 1. Advanced Excel 2. MySQL 3. Python 4. Tableau 5. Power BI

shanuhalli/Data-Analyst-Assignment

Folders and files, repository files navigation, excelr data analyst assignments, 1. advanced excel.

For more details on the Advanced Excel assignment, check out the Advanced Excel Assignment section.

For more details on the MySQL assignment, check out the MySQL Assignment section.

For more details on the Python assignment, check out the Advanced Excel Assignment section.

For more details on the Tableau assignment, check out the Tableau Public Profile .

Coming soon...

• Jupyter Notebook 100.0%