Using the Get Data Feature in Excel 2016

Excel has a great feature for importing data directly into your Excel worksheet.  You can import data from files (Excel, CSV, HTML), databases (Access, SQL), tables, Web, ODBC, etc., making it quicker and easier to share information.  Below are the step by step instructions for using the Get Data feature in Excel 2016. Continue reading “Using the Get Data Feature in Excel 2016”

Excel Custom Lists

Learn about Excel Custom Lists — 1) Creating Custom Lists using the Options Feature; 2) Creating Custom Lists Using a Range of Cells; 3) Deleting Custom Lists; 4) Using Custom Lists within Spreadsheets

Excel custom lists can be used to fill or sort data within the defined order.  By default, Excel provides s few built-in lists – Day of the Week and Day of the Month.  You can also create your own custom lists. Excel Custom Lists

Below are the step by step instructions for working with Excel Custom Lists, including Creating. Deleting and Using Custom Lists. Continue reading “Excel Custom Lists”