Microsoft Excel Tips & Tricks: Prevent and Control Duplicate Entries
Want to Learn More Excel Shortcuts?
Try this On-Demand Webinar! Free with STAR12
Discover powerful time-savers for Excel that you don’t want to be without!
Looking at Excel spreadsheets all day can make anyone’s eyes glaze over. Like most Excel users, you probably spend hours navigating through your documents, entering repetitive information, editing formulas gone wrong, and formatting so they’re easy on everybody else’s eyes.
The good news is that with just a handful of Excel power tips you can save yourself a ton of frustration and hours of time. With Time-Saving Microsoft® Excel® Tips & Shortcuts for Every User you’ll receive more than just a handful of tips — you’ll uncover Excel secrets with an Excel master instructor!
What You’ll Learn:
- Navigate rapidly through workbooks and worksheets with keystroke and mouse shortcuts
- Keystroke shortcuts for entering dates and times
- Flawless copy and data movement with the touch of a button!
- Tricks to creating numerical series without commands or typing
- A single keystroke shortcut that instantly displays all your worksheet formulas
- One simple function key that debugs your formulas
- How to instantly locate all of a cell’s dependencies
- Creating eye-catching on-sheet charts and graphs in just two clicks
- Select just visible data from a range containing hidden rows and columns
- Increase or decrease values in a range without using formulas
- Create special formulas to display numbers in thousands or millions
- A simple dragging technique that turns formulas into values
- And much, much, more!