The various methods discussed there are needed to fill in the current assets section of the balance sheet.
This chapter focuses on recording transactions in journals, cataloging transactions in ledgers, and summarizing the information in the balance sheet.
If you’re entering dates on an Excel worksheet, and there’s data in the adjacent column, you can use the Fill handle to make the job quick and easy.
Enter the first date in the date column, then point to the Fill handle, and double-click.
If you want all the dates the same, while the range of cells is still selected, press Ctrl D on the keyboard.
That’s the keyboard shortcut for Fill Down, and it copies the date from the first cell, into all the selected cells below.
Excel offers a variety of ways to include dates and times into your worksheets.
Apparently, through sheer volume of content on the page and some dumb luck with the post title, I consistently do well for searches for “Excel dynamic named ranges” (long live the long tail of SEO! The kicker is that I wrote that post before I’d discovered the awesomeness of Excel tables, and before Excel 2010 had really gone mainstream.
A dashboard’s visual nature simplifies complex data and provides an at-a-glance view of current status or performance in real time.
Dashboards are made up of tables, charts, gauges, and numbers.
I like to just have the first worksheet as the presentation layer — let’s name it Dashboard — and the second worksheets as the data layer — let’s call that Data.
(Note: I abhor many, many things about Excel’s default settings, but, to keep the example as familiar as possible, I’m going to leave those alone.