Skip to content
PEPA Knowledge Hub Logo
Results for {phrase} ({results_count} of {results_count_total})
Displaying {results_count} results of {results_count_total}
Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
  • Home
  • About Us
  • Spending Reviews
    • Technical Spending Reviews
    • Student Spending Reviews
  • Personnel Analysis
  • Resources
    • Excel Tips
    • Excel Support
    • Introductory Videos
    • Infographics
  • Costing Course
    • Step 1 Institutional Map
    • Step 2 Process Maps & Log Frame
    • Step 3 Indicators and Performance Analysis
    • Step 4 Expenditure Analysis
    • Step 5 Cost Modelling
    • Step 6 Spending Review Report
  • Results for {phrase} ({results_count} of {results_count_total})
    Displaying {results_count} results of {results_count_total}
    Generic filters
    Exact matches only
    Search in title
    Search in content
    Search in excerpt
Excel Tipsconor@bromedia.co.za2021-11-19T16:44:37+02:00
  • Excel Tips
  • Excel Support
  • Introductory Videos
  • Infographics

TIPS & TRICKS

  • 7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel
  • Top 15 Advanced Excel 2016 Tips and Tricks
  • Advanced PivotTables: Combining Data from Multiple Sheets
  • The top 15 Advanced Excel Tips and Tricks

EXCEL TIPS & TRICKS

  • Autofit Columns and Rows
  • Keyboard Shortcut: Control+Shift+Arrow (Easy Fast Excel)
  • What Is the Find Tool? | Microsoft Excel
  • How to Make a Totaling Column Formula in Excel : Using Microsoft Excel
  • How to Create Filter in Excel
  • Excel: Using Find and Replace
  • How To Find and Remove Duplicates Records in Microsoft Excel 2016 Tutorial
  • Excel: Sorting Data
  • How to Do a VLOOKUP in Excel – Video Tutorial
  • Learn Pivot Tables in 6 Minutes (Microsoft Excel)
  • Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
  • How to create a Pareto Chart in Excel – 80/20 Rule or Pareto Principle
  • Excel 2016 Regression Analysis
  • Excel 2016 – Links – Working with Hyperlinks
  • How to build Interactive Excel Dashboards that Update with ONE CLICK!
  • How to use the INDEX function in Excel
  • How to use the IF function in Excel
  • How to use the SUMIF function in Excel
  • How to Use the SUMPRODUCT Function in Excel
  • How to Create a Drop Down List in Excel

GTAC Home | Contact Us | © 2025 GTAC. All rights reserved.

Page load link