Basic Excel links by Dawn Wright | Aug 4, 2016 Excel 2016 A. Getting Started What you’ll learn in this training Excel spreadsheet structure overview Creating and saving an Excel file Interface overview B. Work with Data and Datasets Enter data into a cell Create a dataset Auto-fill data Create simple calculations Referencing cells Auto-fill cell references Format cell data Cut and paste data C. Create Formulas Create multiple calculation formulas Use AutoSum Create an averaging formula Retrieve the min and max value Retrieve the number count Create a correlation Access and search for built in formulas D. Manage Data and Datasets Trace precedents Trace dependents Sort data Changing text to columns Setup data validation Delete and insert columns and rows E. Format Your Table Merge cells Label data Change cell background color Change table format Freeze panes Create conditional formatting Insert images and objects F. Work with Sheets Name and add sheets Reference cells in other sheets G. Work with Charts Insert a chart Edit a chart Change the chart type Change chart data H. Share and Secure Data Protect a sheet Hide and unhide columns and rows Add comments to a cell Save to OneDrive® Invite people to share I. Import and Export Data Import data from text Import data from Access® Import data from XML file Export Excel as CSV Export spreadsheets to PDF Export data as tab delimited text Printing spreadsheets Leave a Reply Cancel reply This site uses Akismet to reduce spam. Learn how your comment data is processed.