Links
- 5 essential tips for creating Excel macros
- 5 must-know Excel macros for common tasks
- 5 tips for creating macros perfectly in Excel
- 7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more
- Bet you didn't know Excel could do: graph paper, address labels, award certificates
- Create Excel reports from multiple spreadsheets with Multi-file Pivot Tables
- Excel 2016 charts: How to use the new Pareto, Histogram, and Waterfall formats
- Excel Add-Ins: How to find and use them
- Excel Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR
- Excel charts: Mastering pie charts, bar charts and more
- Excel databases: Creating relational tables
- Excel Date & Time functions tutorial: EDATE, YEARFRAC, EOMONTH, NETWORKDAYS.INTL
- Excel Date and Time functions: WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL
- Excel filters: How to use number, text and date filters to extract only the data you need
- Excel formula tips: How to troubleshoot by tracing dependents and precedents
- Excel functions: 7 ways to use Text functions to manage data
- Excel logical formulas: 12 simple IF statements to get started
- Excel macros: Essential rules, tips and tricks
- Excel percentage formulas: Percentage of total, percent increase or decrease, sales tax and more
- Excel Pivot Tables: How to create better reports
- Excel power tips: 3 handy ways to tame hyperlinks
- Excel pro tips: How to create, define, and use Named Ranges
- Excel pro tips: How to create, define, and use Named Ranges
- Excel pro tips: Importing and parsing data
- Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions
- Excel tips: 6 slick shortcuts, handy functions and random-number generators
- Excel tutorial: How to import and parse complicated data
- Excel Workbooks: Three-dimensional workbooks and other number-crunching powers
- Excel's best tricks: How to make a calendar
- Excel: 5 timesaving power tips
- Excel: How to create simple and dependent drop-down lists
- From data to doughnuts: How to create great charts and graphics in Excel
- How Excel can help with metric and American Standard conversions
- How to create 3D Worksheets in Excel 2013
- How to create and customize tables in Microsoft Word
- How to create and share custom Style Sheets in Word and PowerPoint
- How to create custom Input & Error Messages In Excel
- How to create relational databases in Excel 2013
- How to customize Excel Conditional Formatting
- How to edit PDFs in Microsoft Word
- How to get special characters using Alt key codes or the Word Symbols library
- How to make Word custom bullet points to enhance your documents
- How to track changes in Microsoft Word without going insane
- How to use fonts in Word, Excel, Powerpoint, and more
- How to use Microsoft Excel's Conditional Formatting
- How to use Word to create holiday cards and other projects
- How to use, modify, and create templates in Word
- Mail Merge master class: How to merge your Excel contact database with custom letters in Word
- Mastering Excel Date & Time: Date, Days, Days360, Time, and Weekday
- Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more
- Meet DATEDIF(), Excel’s secret Date & Time function that's still handy
- Meet Excel 2016: 9 of its best new features, from databases to handwriting tools
- Microsoft Excel: Why your spreadsheet is so slow
- Microsoft Word watermarks: How to customize them for business and personal use
- Microsoft Word: How to open or import other file formats
- Photoshop Presets, Styles & Effects
- Sorting text in Word: 3 tips and some secret tricks
- The 15 function-key strokes everyone should know to zip around Microsoft Office
- The top 10 keyboard shortcuts in Word and Excel that help you work faster
- Use INDEX and MATCH for simple database queries in Excel
- What to do with Excel 2016's new chart styles: Treemap, Sunburst, and Box & Whisker
- Why extracting images from Word is so hard, with 3 decent workarounds
- Word 2016: A guide to its desktop publishing tools
- Word macros: Three examples to automate your documents
- Word master class: How to make custom interactive forms
- Word newsletter tutorial: Using page layout features for professional results
- Word pro tips: Use Wildcards for faster, more accurate search-and-replace results
- Word resume tips: Using style sheets, shapes and text boxes for a professional look
- Word timesaving tips: Random text, quick definitions, formatting tricks and more
- Word tutorial: Clean up a messy document's formats and styles using macros
- Work faster in Word: How to customize the Ribbon menu just the way you want it
- Your Excel formulas cheat sheet: 15 tips for calculations and common tasks