Free Office Application Guides: From Basics to Advanced

Office Applications covers productivity software suites like Microsoft Office and LibreOffice, including tools for document creation, spreadsheets, presentations, and more.

91 Courses
138,847 Total Downloads

Excel Formula & Functions Quick Reference

Description: Discover how to build and use Excel formulae effectively. Learn key functions, tips, and techniques to enhance your spreadsheet skills.

Size: 251.55 KB Downloads: 13,471

Excel How To Use VLOOKUP

Description: Learn how to use Excel’s VLOOKUP function with this comprehensive guide—step-by-step instructions, key concepts, use cases, and expert tips.

Size: 554.99 KB Downloads: 13,907

MS Excel Using the IF Function

Description: Unlock the power of Excel 2016 with our guide on IF and VLOOKUP functions. Enhance your data analysis skills today!

Size: 373.29 KB Downloads: 8,104

Excel Functions Full List

Description: Learn essential Excel functions for IT, data analysis, and automation. Boost your productivity with this comprehensive guide to Excel's powerful formulas and tools.

Size: 136.09 KB Downloads: 18,468

Formulas & Functions in Microsoft Excel

Description: Unlock the power of Excel with our guide on formulas and functions for effective data analysis. Perfect for beginners and advanced users alike.

Size: 109.44 KB Downloads: 9,102

Excel 2016 Large Data Final Report

Description: Learn Excel 2016 techniques for handling large data: PivotTables, logic functions, dashboards, vLookup, and data cleanup in this comprehensive guide.

Size: 798.10 KB Downloads: 3,681

Excel 2016 Large Data vLookups

Description: Learn how to use Excel 2016 VLOOKUP and Data Validation to efficiently manage large datasets. Step-by-step guide, practical exercises, real-world applications.

Size: 379.43 KB Downloads: 3,110

Excel 2016 Large Data PivotTables

Description: Learn to create, customize, and analyze large datasets with Excel 2016 PivotTables and PivotCharts. Boost your data skills with expert tips and exercises.

Size: 890.29 KB Downloads: 3,167

Excel 2016 Large Data Sorting and Filtering

Description: Learn Excel 2016 sorting, filtering, and summary tools to manage large datasets efficiently. Includes practical exercises and tips for data analysis.

Size: 849.65 KB Downloads: 3,485

Excel 2016 Math with Dates and Times

Description: Learn how to master Excel 2016 date and time math, custom formats, shortcuts, and functions to build timesheets and calculate workdays easily.

Size: 314.98 KB Downloads: 2,421

Excel 2016 Formatting Beyond the Basics

Description: Learn to enhance your spreadsheets with Excel 2016’s advanced formatting, tables, themes, and conditional formatting for efficient data management and insights.

Size: 996.16 KB Downloads: 5,384

Excel 2016 Linking Worksheets

Description: Learn advanced Excel 2016 techniques for linking worksheets, managing multiple sheets, printing, and workbook organization with this comprehensive guide.

Size: 640.24 KB Downloads: 3,365

Excel 2016 Charts and Graphs

Description: Enhance your Excel skills with our comprehensive guide on creating and formatting charts for effective data visualization.

Size: 1.09 MB Downloads: 4,892

Excel 2016 Printing and Setup

Description: Learn how to optimize Excel 2016 printing with page setup, headers, footers, scaling, page breaks, and more for perfect printouts every time.

Size: 676.23 KB Downloads: 2,202

Excel 2016 Basics Math and Functions

Description: Learn core Excel 2016 math functions, formulas, and data management techniques to boost your spreadsheet skills. Practical guided exercises included.

Size: 802.09 KB Downloads: 4,633

Yammer Getting Started

Description: Learn how to use Yammer for workplace collaboration, messaging, groups, file sharing, and notifications with our comprehensive beginner’s guide.

Size: 1.00 MB Downloads: 1,840

Microsoft SharePoint 2016

Description: Explore Microsoft SharePoint 2016 with this comprehensive guide covering document management, site navigation, editing, searching, and practical use cases.

Size: 2.46 MB Downloads: 10,856

Creating a Website with Publisher 2016

Description: Discover how to save your published website project for easy access and updates. Follow our step-by-step guide for seamless website management.

Size: 1.51 MB Downloads: 9,973

Microsoft Excel - Pivot Table

Description: Learn how to create and use Excel pivot tables for powerful data analysis. Step-by-step guide with tips, functions, and formatting ideas included.

Size: 996.46 KB Downloads: 11,256

Conducting Data Analysis Using a Pivot Table

Description: Learn to conduct powerful data analysis using Excel pivot tables. This guide covers basics to advanced techniques with practical exercises for all skill levels.

Size: 1.21 MB Downloads: 5,530