Getting Started course. offered by DataCamp for free (you do need to create an account). uses Google Sheets, but covers basics (how a spreadsheet works, cell references, and formulas) for both Sheets and Excel. you get a statement of accomplishment upon completion!
Microsoft Office documentation Excel 2016 - Windows. Excel 2016 - Mac.
Excel for Mac Quick Start » Download PDF. PowerPoint for Mac Quick Start » Download PDF. Outlook for Mac Quick Start » Download PDF. OneNote for Mac Quick Start » Download PDF. Other Quick Starts. Office Quick Starts (for Windows) Skype for Business Quick Start.
Tutorials These links are (mostly) to Excel 2013 video tutorials. Most of these instructions will apply to Office 2016 as well. Some of the options will have different locations in the menus/ribbon in other versions of Excel. You can see what version(s) of Excel each video/article applies to at the bottom of each page.
a list of the logical functions with links to articles on each one., and. DataCamp offers a free course on that you may also find useful. Excel 2013 for Windows. Excel 2011 for Mac. This page provides links to videos and articles walking you through the functions of Excel.pdf tutorial. Another page linking to both articles and videos guiding you through specific features of Excel.
Workshop Handouts What's the Difference between a Spreadsheet and a Database? 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. Helpful Excel Tutorials.
Arithmetic in Excel. Transferring Data Tables and Graphs to MS Word.