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”
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.
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”