Advertisement

Microsoft Excel

  • Microsoft Excel
    Animated Spreadsheets: How to Make Pixel Animation in ExcelPreview
    37 shares
    Yes, it's possible to have fun using Excel. Here's how to make a traditional animated flip book with pixel art, using just an Excel workbook.Read More…
  • Microsoft Excel
    Advanced PivotTables: Combining Data from Multiple SheetsPt preview image
    21 shares
    How to use the Data Model in Excel 2013 to combine data from multiple sheets into one PivotTable.Read More…
  • Microsoft Excel
    How to Format Your Spreadsheets in Excel with StylesExcel styles preview
    20 shares
    Style is typically the last thing you think about with spreadsheets; they're business first tools that aren't designed to look nice. And yet, Excel Styles give you a way to quickly make your spreadsheets look a lot nicer. Here's how.Read More…
  • Microsoft Excel
    How to Run a Giveaway With a SpreadsheetSpreadsheet gift
    9 shares
    You don't need a fancy app to run a giveaway. Here's how you can run a giveaway and pick your random winners using any spreadsheet app.Read More…
  • App Training
    How to Extract Data from Tables in PDFs with Tabula and OpenRefineTabula logo
    43 shares
    There's tons of open data available that's locked away inside tables in PDFs. Here's how to extract the data with the free tools Tabula and OpenRefine to extract tour data and clean it up.Read More…
  • Office
    How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEXExcel icon
    23 shares
    There's easier ways to find and move data in a spreadsheet than copy and paste. Here's how to use the VLOOKUP, MATCH and INDEX functions to extract specific data from a spreadsheet automatically.Read More…
  • Office
    Getting Started with Microsoft Office for iPadOffice ipad icons
    51 shares
    Microsoft has finally released full-featured Office apps for the iPad. Here's a quick look at what each app offers, and how you can start using Office on your iPad.Read More…
  • Office
    How to get Microsoft Office for FreeOffice logo
    48 shares
    You really can get Microsoft Office for free, legally—as long as you only need the most basic features, and are willing to use it in your browser. Here's how to get the most out of Microsoft's best-kept secret: Office Online.Read More…
  • App Training
    Spreadsheets for Finance: Calculating Internal Rate of ReturnExcel logo
    11 shares
    If you're going to invest your money, you'll want to make sure you're getting the most from your investment. That's exactly what the internal rate of return calculations are for. They help you compare investments, and make sure you make your best financial decisions. Here's everything you need to know about calculating your investments' internal rate of return in any spreadsheet app.Read More…
  • App Training
    Spreadsheets for Finance: Calculating Present Value and Net Present ValueExcel logo
    16 shares
    Money in the future is worth less than money today. Or, perhaps, "a bird in the hand is worth two in the bush", as they used to say. But you're not trying to catch birds—you're wanting to make sure your investments are actually going to turn out to be valuable. That's what present value calculations are for. Here's everything you need to know about calculating present value in any spreadsheet app.Read More…
  • App Training
    Using Spreadsheets for Finance: How to Calculate Loan PaymentsExcel logo
    15 shares
    There's a lot more to your loan than just the original sticker price, or the base monthly payment. Here's how you can use spreadsheets to break down your loan payment info and figure out what's best for your budget, and take things further with Data Sheets in Excel.Read More…
  • App Training
    Using Spreadsheets for Finance: How to Calculate DepreciationExcel logo
    28 shares
    Getting ready for tax season? Here's how to calculate depreciation on your assets using Straight-line, Declining balance, Double-declining balance, and Sum of year's digits (SOYD) methods using Excel, Google Sheets, or any other spreadsheet app.Read More…
Advertisement
Apps
Suggested Tuts+ Course
Introduction to Spreadsheets$15
Advertisement