Excel: Tips and Tricks

43 Learners | 43 Completed Lessons | 14 Hours of Learning Time

Learning Activity

In this activity, you will explore the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. 

These include being able to move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pick out just the information you want from a column. 

Watch the videos and then describe your favorite tip/trick and explain why you find it useful. 

Resources


Transform Data into Opportunity with Excel on Alludo   Uncover game-changing insights from your school's data with Excel skills training on Alludo.  

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Excel: Create a Workbook

Points 25 | Time 00:10

Excel: Using Templates to create Spreadsheets

Points 25 | Time 00:10

Excel: Add, Sort and Delete Cells, Rows and Columns

Points 25 | Time 00:10

Excel: Conditional Formatting

Points 25 | Time 00:15

Excel: Using Formulas and Functions

Points 50 | Time 00:20

Excel: Charts and Graphs

Points 25 | Time 00:15

Excel: Create a Nested IF function

Points 50 | Time 00:30

Excel: Using Pivot Tables

Points 50 | Time 00:20

Excel: Using the new Take and Drop functions

Points 50 | Time 00:20

Excel: Create a basic gradebook

Points 25 | Time 00:15

Excel: Spreadsheet Vocabulary

Points 50 | Time 00:25

Excel: Create an Excel Assignment

Points 75 | Time 00:45

Top districts trust Alludo to train teachers and staff

El Segundo Unified School District San Ramon Valley Unified School District Antelope Valley Union High School District California Pacific Charter Schools Westmoreland IU7
Transform Data into Opportunity with Excel on Alludo   Uncover game-changing insights from your school's data with Excel skills training on Alludo.