Microsoft Office Excel Advanced
R 100.00
Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel is used globally and used by businesses of all sizes.
Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel is used globally and used by businesses of all sizes.
Topics covered in this course are:
- Add the Current Date to a Cell
- A Faster Way to Use the Fill Handle
- Two Ways to Use the Format Painter
- A Shortcut to AutoSum
- Quick Access Toolbar Shortcuts
- How to Quickly Duplicate a Sheet
- Jump to Any Sheet with a Shortcut
- Select an Entire Row or Column
- Find a Sum Without Using a Formula
- Why You Should Avoid Merging Cells
- Using the Quick Analysis Tool
- How to Make Charts Auto Update
- Use Transpose to Flip Data on its Side
- Absolute References with the F4 Key
- Add a New Row with a Shortcut
- Use an Entire Column as a Cell Range
- What are Named Ranges?
- A Trick for Finding Inconsistent Data
- How to Use Excel's VLOOKUP Function
- Use SUMPRODUCT to Calculate Weighted Averages
- Use the PROPER Function to Capitalize Names in Excel
- How to Count Cells with COUNTA
- CONCATENATE: Excel's Duct Tape
- Intro to PivotTables
- Doing More with PivotTables
- What-if Analysis
- 5 Tips for Printing Excel Spreadsheets
- How to Use Fractions in Excel
- How to Add Line Breaks in Excel
- Understanding Regional Differences in Excel
