For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classes
for the month of Jan, Feb, Mar, Apr 2022
Analyzing Data with Power BI
Microsoft Excel - Power Query (M365, 2021-2010)
Microsoft Excel - Power Pivot (M365, 2021-2010)
Copying & Pasting
There's more to it than just copy (Edit/Copy or ctrl C) & paste (Edit/Paste or ctrl V). You can copy and control exactly what you want to paste. Example you need to copy a total (where you used a formula) and when you pasted it get an error because of the formula. What you need to do is perform the copy (as normal), select your destination and Paste Special (click Edit/Paste Special) a dialogue box will appear, select the option Values and the value of the total will be pasted instead of the formula. Just like magic.
Likewise sometimes we just need to copy the formats (example just the borders), select the range, perform the copy as normal, select your destination and Paste Special (click Edit/Paste Special) a dialogue box will appear, select the option Formats and presto! Just the formats without the contents.