Skip to Main Content

Excel Workshop: Hone Your Skills

Even if you have been an Excel user for years, there are likely features or approaches that could make you excel at Excel even more. This workshop video was prepared for AgGateway’s fall 2020 conference and is now available to all via YouTube.

 

This workshop video is under one hour, but if you watch and then do (as you should do in order to reinforce the learning), it might take 90-100 minutes from top to bottom. If you are a complete novice with spreadsheets, this may not be the best place to start. In that case, I suggest the Excel portions of the “Digging into the Data Pipeline” webinar series.

But if you can do algebra, you have used spreadsheets before, and want to grow your skills for problem solving, this workshop is for you.

What will you learn? Logical spreadsheeting in a time-tested format that lends your spreadsheet decision or design tools to be intuitive to any user, fully documented, and structured in a way that will never need a user’s manual. You will see (& practice) how to incorporate data validation, intrinsic functions regarding rounding and lookup, and generate and use trendlines. You’ll see how to use names rather than cell references (for readability), insert forms for user friendliness, and enable protection to avoid inadvertent changes to your precious formulas. Data tables are introduced and will enable you to do what if analyses without redoing the math. You will get a glimpse of how you might link different spreadsheet tools together to reduce development overhead. Links to other examples and resources are also provided.

logicalspreadsheetingexample.png

What won’t you learn? Anything related to data analysis in spreadsheets … that just wouldn't’t fit within the time frame. Sorry. However, that is covered briefly in this one.

This is the workshop file (starter kit)

Digital Agriculture Posts

Close-up of Hunsoo Song in front of the pink blossoms of a crabapple tree
Hunsoo Song, the civil engineer who speaks (in algorithms) for the trees

Fire, metal, water, earth and wood. In South Korean tradition, these five elements explain...

Read More
Tomi Lori Ankita looking at tomato
Purdue-led TOMI project receives $3.5M grant to turn a decade of data into new tools and strategies for tomato farmers

Indiana ranks third in the nation for tomato production. Lori Hoagland, a professor in Purdue...

Read More
Purdue research team uses a computer on top of a drone to gather data
Purdue researchers acquire and analyze data through AI network that predicts maize yield

Artificial intelligence (AI) is the buzz phrase of 2024. Though far from that cultural spotlight,...

Read More
Siddhartho Paul and his students use a RTK GPS in a soybean field to get precise location information
Satellites and soils: NIFA and AgSEED grants fund remote sensing data collection and machine-learning models to predict soil properties at farm-to-landscape scales

The few inches of soil you pick up on the tip of your shovel are part of a much bigger picture....

Read More
uav data on a monitor
Data-Driven Seminar Series

Purdue College of Agriculture presents a seminar series featuring experts in data science,...

Read More
two students lean over a counter as the tinker on a remote controlled car together
Digital Ag Club’s Scarecrow-bot making its debut at Boiler Gold Rush

Thumping hind legs. Two pointed ears. White, fluffy cottontails. The markers of an enemy to...

Read More
To Top