Tag: excel
-
Excel Trick: Import Data From a Picture!
Have you ever looked at a table in a PDF file (or a picture) and wanted to import it into Excel? This video tells you how! As shown in the short video, this function is not perfect – but its usefulness far exceeds its imperfections! You may still need to edit the imported table a…
-
Excel Shortcut Keys (2020 Edition)
Every year I update my favorite shortcut keys. Here is the 2020 version. You can also download PDF here.
-
How to Draw a 3-D Chart
If you have 3-dimensional data, drawing a 3D chart can be very helpful in visualizing how the two variable jointly affect the outcome. In Microsoft Excel, such 3D charts are called “Surface Plots”. Here is a quick tutorial. Please note that your data will need to be in a table (Download Excel file here)in order…