How to Separate Raw Data into Columns - Excel tutorial

Category: Excel tutorials > Basics - Difficulty:

The EOMONTH (end of month) function allows you to generate a month end date no matter what the original date (even taking into account leap years). Extremely useful when you want to report on standardized dates.

Let you see this tutorial of Micresoft Excel.

Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you to highlight cells that contain comments, constants or formula, blanks, Objects (pictures, buttons, etc), cells in rows or columns that are different from their neighbors, precedents and dependents, last cell in a sheet, and cells with conditional formatting or data validation.

Learn how you can easily manage addresses using mail merge through Excel and Word.

These elements included Office button, Quick Access Toolbar, Ribbon, Name box, Formula bar, Sheet tabs, Status bar, and Zoom control