#Microsoft word for mac arithmetic for free

Databases are better at tracking large data sets with complex relationships and are meant to be used over long periods. Spreadsheets are great for doing calculations for small data sets, tracking small data sets over the short term, and visually presenting data. 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. Other spreadsheet programs include Calc ( - 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. Preparing an Excel Workbook for Presenting to OthersĮxcel Charts and Tables What's the Difference between a Spreadsheet and a Database? Password protect workbooks and worksheetsĭataCamp offers a free course on Data Analysis with Spreadsheets that you may also find useful.Conditional Formatting, and Advanced Conditional Formatting.Logical functions - a list of the logical functions with links to articles on each one.Prepare your Excel data source for a Word mail merge.Tutorial: Import Data into Excel, and Create a Data Model.You can see what version(s) of Excel each video/article applies to at the top of each page. Some of the options will have different locations in the menus/ribbon in other versions of Excel (especially between Mac and Windows products). Most of these instructions will apply to later versions of Office as well. These links are (mostly) to Excel 2013 video tutorials. You get a statement of accomplishment upon completion!.Uses Google Sheets, but covers basics (how a spreadsheet works, cell references, and formulas) for both Sheets and Excel.

#Microsoft word for mac arithmetic for free

Offered by DataCamp for free (but you do need to create an account).Getting Started Spreadsheet Basics course