Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
#8 Shortcuts. • Ctrl+Z: Undo the last action you took. Same as the backward arrow in the upper left-hand corner. • Ctrl+F: Find text. F2: edit the cell.
Typology: Exams
1 / 21
This page cannot be seen from the preview
Don't miss anything!
Alicia Bartosch, Financial Services Assistant Controller - Compliance
Jennifer Hurlbert, OneIT Interim Executive Dir. of Digital Strategy for Academic Affairs Support Services
Hosted by: UNC Charlotte Alumni Association andAlumni Campus Employees (ACE) Network
Software that can be used to store and organize many data sets.
One thing almost every Excel user has in common: not knowing enough. If you encounter a situation where you need to manually update your data, you're probably missing out on a formula that can do it for you.
You do not have to remember (or even know) every formula in Excel
Look under the formula menu Use the Wizard box to prompt each entry, versus writing it out
IF: searches a list and returns values that match
COUNTIF: counts how many meet a certain condition
=IF(A2>0, B2-C2,0)
Logical test
What toreturn if true
What toreturn if false
SUMIF: sums the values that meet a certain condition
Use to Summarize Data
How can we quickly aggregate this data in various ways?
Use to Summarize Data w/o Formulas What to Remember: Use Filters!
Use to Extract Text
Use to Combine Data
Use to Present Data. What to Remember:
#8 Shortcuts continued & Autofill
**- Breakout Discussion (5-10 Minutes)
