If a table is made up of formulas, paste transpose with mess up the formulas, but there is a way around this.
Category: Excel
![](https://keatraining.com/wp-content/uploads/2023/12/031_weekdays_015-1.png)
Get the day of the week from a date in excel.
dddd = weekday
![](https://keatraining.com/wp-content/uploads/2023/12/030_closest_date_004.png)
In this example, I have two datasets with different dates, and I want to line them up, using a formula, with the closest date, either before or afterwards.
![](https://keatraining.com/wp-content/uploads/2023/12/029_bubble_map_011.png)
Plot latitude and longitude coordinates on a bubble chart in excel, and change the background of the chart to an image of a map.
![](https://keatraining.com/wp-content/uploads/2023/12/027_excel_map_019.png)
Microsoft Excel has a feature for making 3D maps using Bing, but you can also use this to make 2D maps.
![](https://keatraining.com/wp-content/uploads/2023/12/025_subscript_legends_010.png)
Excel doesn’t have a feature for adding subscripts and superscripts into legends in excel charts but there is a way around this using symbols.
![](https://keatraining.com/wp-content/uploads/2023/12/024_formatting_shortcuts_010.png)
How to apply number formatting to cells using shortcut keys in excel
![](https://keatraining.com/wp-content/uploads/2023/12/023_line_up_columns_008.png)
In Power Query the columns will automatically line up so long as they have the same column headings.
![](https://keatraining.com/wp-content/uploads/2023/12/021_conditional-chart_011.png)
How to make the bubbles in a bubble chart different colors based on there values, and make it appear as if the chart has conditional formatting, by using an IF formula and making multiple different series.
![](https://keatraining.com/wp-content/uploads/2023/12/020_chart_format_011.png)
Quickly copy the formatting from one chart to another in excel and save the formatting to use later.