Multiplying a column by a single number in Excel
#powerquick
This video explains how to automatically multiply an entire column by a number in Excel, as well as how to divide a column by a number. You'll learn how to do these actions much faster in the PowerQuick add-in, how to quickly divide/multiply an entire column by 1000, as well as by the VAT rate, and how to multiply columns row by row. You can even automatically multiply a row by a column, as well as multiply a column by a single number or a range of factors using Excel keyboard shortcuts.
Download the PowerQuick add-in to speed up your work in Excel: https://xn----btbktgundek1hji.xn--p1ai/download.html
Join the VK group:
Timecodes:
0:35 How to multiply a column by a single number in standard Excel functionality
1:10 How to multiply a column row by row by a list of factors
1:30 How to quickly multiply a column by a number in the PowerQuick add-in
2:09 How to quickly multiply/divide a column by 1000
2:20 How to multiply/divide a column by the VAT rate
2:50 How to quickly multiply a column by a number using keyboard shortcuts keys)
====================================================
The location of the commands from this video in new versions of the PowerQuick add-in can be found in the add-in menu "Settings and Tools" - "Command Help"