Power-user l Excel Features, by Power-user for PowerPoint, Excel & Word on YouTube. 10 min 17 s.
- Video length
- 10 min 17 s
- Time to do it
- 20 minutes
- Difficulty
- Easy
- Steps
- 10
What you need
Steps
Open Excel and check the Power-user tab appears on the ribbon. If it is missing, install the add-in and sign in with your account.
Set your default spreadsheet styles so new workbooks match your company fonts, colours and headers. Save it as the default template.
Open the Excel Library and pick a chart type such as Gantt, waterfall, Mekko or Sankey. Insert it and point it at your data range.
Select two ranges or charts and use the swap tool to exchange their positions without retyping anything.
Use Transpose to turn rows into columns or columns into rows in place.
Join several cells into one with Concatenate, and use Change Case to switch text to upper, lower or proper case.
Flip a range horizontally or vertically, and apply number, currency or date formats from the formatting menu.
Select similar cells to grab every matching value at once, then delete empty cells in the selection.
Apply a table style, add or remove characters from many cells, and copy only visible cells when rows are hidden.
Unpivot a cross table into a flat list for analysis, and try the calendar and advanced functions from the same tab.
Tips and common mistakes
Save a copy of your workbook before running bulk tools like transpose, flip or unpivot, since they change data in place.
Unpivot is the quickest fix for pivot-style tables that need to become a flat list for charts or pivot tables.
Copy visible cells only stops hidden rows from pasting into your report and breaking totals.
Check the chart library output against your source numbers, as Gantt and waterfall charts depend on correctly ordered data.
Questions
Do I need a paid licence for Power-user?
Yes, Power-user is a commercial add-in. Check the vendor site for current plans and trial options before installing.
Can I make a Gantt chart without the add-in?
Yes. You can build one with a stacked bar chart and a helper column, but the add-in's library does it in a few clicks.
Will the add-in work on Excel for Mac?
Support varies by version, so confirm Mac compatibility on the vendor page before you rely on it for daily work.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
