![Complete guide to Excel 2016 (Part 15): Relative and absolute reference cells](https://tipsmake.com/img/no-image.png)
there are two types of cell references: relative (relative) and absolute (absolute). relative and absolute references work differently when copying and filling in different fields.
![Guide to full Excel 2016 (Part 7): Format spreadsheet data](https://tipsmake.com/img/no-image.png)
if you have seen the article about microsoft word, then you also have some basic knowledge about text alignment. please refer to the article of formatting spreadsheet data in
![Guide to full Excel 2016 (Part 8): Learn about Number Formats](https://tipsmake.com/img/no-image.png)
the data in the excel spreadsheet when you perform the import always have the default mode, general format, for excel formats to display and calculate in accordance with the actual
![Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets](https://tipsmake.com/img/no-image.png)
excel workbook file is a collection of spreadsheet types (can contain from 1 to 255 spreadsheets) such as: data, graphs, macro, . and often related to each other.
![Complete guide to Excel 2016 (Part 10): Use the Find and Replace function](https://tipsmake.com/img/no-image.png)
when working with a lot of data in excel 2016, you may find it difficult and time-consuming to determine the specific location of the information.
![Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet](https://tipsmake.com/img/no-image.png)
let's tipsmake.com refer to the spell check tutorial on excel 2016 worksheet in this article!
![A complete guide to Excel 2016 (Part 4): How to store and share spreadsheets](https://tipsmake.com/img/no-image.png)
whenever you create a new spreadsheet in excel, you need to know how to save to access and edit later. like previous versions of excel, you can save local files to your computer.
![Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges](https://tipsmake.com/img/no-image.png)
whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the
![Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells](https://tipsmake.com/img/no-image.png)
by default the width of the column and the height of the row in excel may not match the data you entered. therefore, you want to change the width, height of rows and columns so
![Summary of shortcuts for Microsoft Excel 2016-P1](https://tipsmake.com/img/no-image.png)
in the process of working with excel 2016 spreadsheets, if you know the shortcut keys, your actions will be much faster in the process of using, greatly reduced compared to
![Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel](https://tipsmake.com/img/no-image.png)
microsoft excel is a spreadsheet processing program designed to record, present processing information in tabular form, perform calculations and build visual statistics in the
![Guide to full Excel 2016 (Part 2): Learn about OneDrive](https://tipsmake.com/img/no-image.png)
in the introduction in excel 2016, tipsmake.com helped you get acquainted with microsoft excel. today, we continue to share with you about things to know about onedrive. invite
![Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets](https://tipsmake.com/img/no-image.png)
today, we continue to share with you how to create and open spreadsheets available in excel 2016.
![Instructions for installing and using Office 2016](https://tipsmake.com/img/no-image.png)
along with windows 10 operating system, office 2016 is the latest version of microsoft office with a beautiful graphical interface, giving users many new and exciting experiences.
![Summary of shortcuts for Microsoft Excel 2016-P2](https://tipsmake.com/img/no-image.png)
while performing spreadsheet operations, if you know some of the shortcuts will save you time, the process will be greatly shortened.
![Instructions for using Pareto, Histogram and Waterfall charts in Excel 2016](https://tipsmake.com/img/no-image.png)
excel 2016 has improved some new features. among them, there are 6 new charts that are waterfall, histogram, pareto, box & whisker, treemap and sunburst.
![Instructions for deleting empty lines and columns in Excel 2016](https://tipsmake.com/img/no-image.png)
sometimes your spreadsheet has too many blank lines and empty columns look very messy and lose aesthetics. to make the spreadsheet look better you can delete these blank lines and
![How to change the default save file format in Word, Excel and Powerpoint 2016?](https://tipsmake.com/img/no-image.png)
if you are using word, excel or powerpoint 2016. suppose in the case of sharing documents and documents for people who are using older versions of word, excel or powerpoint, in
![Test your understanding of Excel](https://tipsmake.com/img/no-image.png)
in the article below, network administrator will send you more useful information about excel software through the following quiz. let's see how much you know about excel.