Many of us live in the information space with the calculations performed with precise data expressed in cents or even more granular amounts. Still, it is advisable to present them in thousands or even millions in presentations and reports.
Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.
When you work with many graphical objects such as pictures, charts, text boxes, shapes, etc., it is sometimes challenging to select one of the objects - it can lay behind other objects, or it can be too small, etc.
Excel proposes an excellent feature named Selection pane to help navigate between different objects and groups.
When you create a presentation from a draft Excel spreadsheet, you might need to delete all notes and
comments. You can delete every note and comment one by one, but this will take some time. This tip shows the
quick way how to delete all notes and comments in your spreadsheet.
While the secondary vertical axis provides a way to display two different types of data for the one time range, the secondary horizontal axis allows you to create a chart showing two data series for different time ranges.
If you need to display two different data series for the one- or compatible-time ranges that have different value scales, you can add the secondary vertical axis.
Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a Text Import Wizard to import data from different text file formats:
When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a
Text Import Wizard to help you to import data correctly. Here you can import all or
some data from text files of different formats:
When you paste or import data into the Excel spreadsheet, you might notice unusual symbols like
a diamond with a question mark. The replacement character � (often a black
diamond with a white question mark or an empty square box) represents an unknown, unrecognized
or unrepresentable character: