...
Tutorials
These links are (mostly) to Excel 2013 video tutorials. Most of these instructions will apply to later versions of Office as well. Some of the options will have different locations in the menus/ribbon in other versions of Excel (especially between Mac and Windows products).You can see what version(s) of Excel each video/article applies to at the top of each pagepoint to support articles and videos from Microsoft. If they apply to a specific edition of the software, they will identify that near the top.
- Basic tasks in Excel for Windows
- Creating and Editing a WorkbookCreate a workbook in Excel
- Freeze or lock rows/columns
- Printing Excel Sheets and WorkbooksPrint a worksheet or workbook
- Tutorial: Import Data into Excel, and Create a Data Model
- Tables and charts
- Mail Merge using an Excel spreadsheet
- IF AND OR Formulas and Functions
- Logical functions - a list of the logical functions (IF, AND, OR, etc) with links to articles on each one
- Conditional Formatting, and Advanced Conditional Formatting
- VLOOKUP
- XLOOKUP function
- PivotTables
- Password protect workbooks and worksheets
- Require a password to open or modify a workbook (Note: Please be careful with both setting and saving the password.)
- Create a macroWork with macros
DataCamp offers a free course on Data Analysis with Spreadsheets that you may also find useful.
...
Microsoft Exel is a spreadsheet program. Other spreadsheet programs include Calc (OpenOffice.org - Mac and PC platforms), Numbers (iWorks for the Mac), Lotus 1-2-3 (IBM for PCs, though this will no longer be supported after September 30, 2014), and many others. The most important information to know about spreadsheets is that they have limits and a spreadsheet is not the right tool for every for every project. Spreadsheets are great for doing calculations for small data sets, tracking small data sets over the short term, and visually presenting data. Databases are better at tracking large data sets with complex relationships and are meant to be used over long periods. They can also perform calculations on large data sets.Penn State University Libraries Technology Training's has created a set of guidelines for determining whether or not your project is suitable for a spreadsheet or a database.
Helpful Excel Tutorials
- Arithmetic in Excel
- Excel Basics: Formulas and Functions (YouTube)
- Excel Basics: Formulas Using Cell Data (YouTube)
- Transferring Tables from Excel to Word (YouTube) Transferring Graphs and Charts from Excel to Word (YouTube)