Master Excel Tips and Tricks for Enhanced Productivity
Unleash the power of Excel with this comprehensive guide covering a wide range of tips, tricks, shortcuts, and functions. Learn how to optimize your workflow and engage in fruitful discussions with other Excel enthusiasts. Explore topics like quick stats, formatting, formulas, and favorite keyboard shortcuts to excel in spreadsheet management.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Excel Tips and Tricks Excel Tips and Tricks
James L. Baldwin, Assistant Dean of Academic Affairs, Registrar, and Director of Science in Motion jlb20@pitt.edu University of Pittsburgh at Bradford 300 Campus Drive Bradford, PA 16701 814.362.7602
Objectives: Objectives: 1. Demonstrate some of my favorite aspects of Excel including tips, tricks, shortcuts, and commonly used functions. 2. Create an open dialogue for participants to share their best tips and tricks and ask questions.
TOPICS-1 Super quick stats Quick formatting Drag and drop Drag and copy tabs Tool handle fill Sort (numbers, letters, and colors) Conditional formatting SSNs
TOPICS-2 Merge and center alternative Better and easier to read graphs Sparklines PivotTables Speak Cells on Enter Remove Duplicates VLOOKUP
FORMULAS-1 =+ - * / and order of operations =End Value/Beginning Value -1 (% change) & (and multiple &s) =LEFT(Cell, Number) =RIGHT(Cell, Number) =FIND(Text, Cell, Number) =TRIM(Cell) =A1=A2 (True and False) =IF (formula, value if true, value if false) =IF (AND (formulas), value if true, value if false) =IF (OR (formulas), value if true, value if false)
FORMULAS-2 =COUNT(Range) =SUM(Range) =AVERAGE(Range) =MAX(Range) =MIN(Range) =COUNTIF(RANGE, CRITERIA ) =SUMIF(RANGE, CRITERIA , SUMRANGE) =SUMIF(RANGE, CRITERIA , SUMRANGE)
FAVORITE KEYBOARD SHORTCUTS-1 Ctrl+Shift+& Ctrl+semicolon Ctrl+colon Ctrl+Alt+v Ctrl+z Ctrl+y Ctrl+x Ctrl+c Ctrl+v Ctrl+b+u+i draws a thin boarder around your selection enters the current date enters the current time Paste Special Undo Redo (or do again) Cut Copy Paste Bold, Underline, Italicize
FAVORITE KEYBOARD SHORTCUTS-2 Ctrl+ Home Key Takes you to A1 Ctrl+ Arrow Keys Takes you to the top, bottom, far left or far right of columns and rows Ctrl+Shift+ $ or % Format cells in $ or % Forces text format
Questions Questions and Let s Share and Let s Share
James L. Baldwin, Assistant Dean of Academic Affairs, Registrar, and Director of Science in Motion jlb20@pitt.edu University of Pittsburgh at Bradford 300 Campus Drive Bradford, PA 16701 814.362.7602
