Tag

Samples Archives - Excel Basics In 30 Minutes: Official Site

More sample spreadsheet files from the Excel book

By | Blog

I am posting a bunch of new spreadsheet files (Excel .xlsx format) that I described in Excel Basics In 30 Minutes. The files are useful for recreating situations described in the Excel book, such as creating simple functions (chapter 1), projecting earnings scenarios for our three coworkers Jennifer, Curtis, and Kara (chapter 2), as well as the autofill and human resources sorting exercises.

The following Dropbox links will download to your computer (or prompt you to upload the .xlsx files to your own Dropbox account). If you are prompted to use a specific app to open them, choose Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007, or any recent version of the Excel app or Excel for Mac. You can also upload the files to a Google Drive account to open/convert in Google Sheets.

Chapter 1: Autosum example

Chapter 1: Formula example

Chapter 1: Creating a function

Chapter 1: Jennifer, Curtis and Kara in January

Chapter 2: Static earnings values for all three workers

Chapter 2: Alternate earnings scenario

Chapter 2: Total earnings, fixed

Ninja chapter: Autofill for all team members

Chapter 3: HR sorting example

Sample spreadsheet excel book .xlsx

Sample spreadsheet: AutoFill

By | Blog

The Second Edition of Excel Basics In 30 Minutes features a chapter on AutoFill, the Excel feature which lets users drag numbers, sequential text, or formulas across a row of cells to perform one of the following:

Copy the number (if one cell is selected). If a cell containing “3” is selected, AutoFill will place the number “3” in all cells which are included in the dragging action.

Increment the number or sequential text (if more than one cell is selected). If cell A1 contains “3”, and cell B1 contains “4”, AutoFill will place “5” in cell C1, “6” in cell D1, etc., until the mouse is released, ending the dragging action.

Repeat a formula but with shifted values relative to the cells which are included in the dragging action.

If this sounds confusing, or you want to try for yourself, open the following Excel spreadsheet (it will be downloaded from Dropbox), highlight a cell (or two adjacent cells), and then “grab” and drag the dot or square in the lower right corner of the cell to the right. Then let go to see the results.

You can also try the following Google Sheets version of the spreadsheet, right on the screen. Highlight cell B5 and drag to the right, and the monthly amounts will be totaled for each subsequent month!