Sometimes you need to print a document in Excel but instead of a vertical orientation, you want your cells to be spread horizontally over your print sheet. … continue reading »
How to print your Excel file on one page
Often times printing Excel files will cause a lot of trouble because it will look different than what you see in your screen. … continue reading »
How to view two or more workbooks in Excel at the same time
If you have multiple workbooks open and you need to work in two worksheets at the same time, it’s super convenient to be able to see them both next to each other.
Formulas and Functions
If there is one tutorial you must read when learning about Excel, I’d probably say it’s this one about Excel formulas and functions. This topic will introduce you to the most powerful feature Excel has – I promise you, after reading this, your world will never be the same again. … continue reading »
Format Cells
Excel formatting is changing the way a cell or it’s contents look. There are two ways you can format cells in Excel: you can format the content type of the cell or format the visual look of the cell. … continue reading »
How to make columns and rows in Excel the same size
Sometimes you have worked in a file for so long that you have made multiple changes to your Excel sheets column and row sizes.
Often your sheets looks very messy if columns or rows aren’t the same size. … continue reading »
Rows and Columns
A worksheet in Excel is basically a grid and each cell has it’s own coordinates. Every cell in Excel is named by it’s row number and column letter, for example the first cell in top-left of a sheet is called A1, the one to the right of that is B1 and below it is A2.
In this tutorial I’ll teach you all you need to know about manipulating rows and cells in Excel. … continue reading »
Cells and Ranges
Cells are the basic building blocks of your Excel work – everything you do in Excel you do in your cells.
In this tutorial I’ll teach you all the basics about cells and ranges in Excel. … continue reading »
Video Tutorial: How to use Excel Workbooks
Read more about this topics in my Excel workbook tutorial.
… continue reading »