Excel Tips & Tricks (Virtual)
Microsoft Excel isn’t just for spreadsheets—it’s a powerful tool for solving problems, analyzing data, and making informed decisions. At Alexandria Technical & Community College’s EDGE Center of Innovation, our Excel training helps employees move beyond the basics and into real-world applications that drive results.
What This Course Is About:
Learn how to quickly navigate in excel worksheets and tabs, create a chart with one keystroke, link charts to Word and PowerPoint files and use a feature called FlashFill that automatically fills your data when it senses a pattern. We will also talk about using an Excel feature called QuickAnalysis to create charts, tables, and totals automatically. Then, we will look at some common functions and work with Excel lists.
What You’ll Learn:
Quick Tips
- Selection Techniques
- Keyboard Shortcuts
- One Click Select All
- Navigate a list
- Autofill
- AutoSum Tricks
- Quick Analysis
- FlashFill
Using formulas
- Relative vs. Absolute
- Show Formulas
- Error Checking
- Evaluate Formula
- Watch Window
- Mixed Reference
Charting Tools
- Templates
- Keyboard Shortcuts
- Linking
Conditional Formatting
- Presets
- Formulas
Functions
- IF
- IFS
- IF, AND, OR
- VLOOKUP
- Now & Today Functions
Excel Lists
- Tables
- Filters
- PivotTable
Other
- Screenshot
- Paste Link
- Printing Tips