Using the Photo Album and Slide Master features in powerpoint
![](https://keatraining.com/wp-content/uploads/2023/12/032_paste_transpose_008.png)
If a table is made up of formulas, paste transpose with mess up the formulas, but there is a way around this.
![](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/028_google_mymaps_023.png)
MyMaps is part of Google Maps. You can import spreadsheets into MyMaps in order to plot your own locations.
![](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/map.png)
Plot data with latitude and longitude coordinates using Tableau software.
![](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