Quick guide to Microsoft Excel 2016

Table of contents

  • The Excel 2016 screen
  • The fundamentals
  • Editing
  • Formatting
  • Keyboard shortcuts
  • Formulas and Functions
  • To total a cell range
  • To enter a formula
  • To insert a function
  • To reference a cell in a function
  • To use several operators or cell ranges
  • Workbook management
  • To insert a new worksheet
  • To delete a worksheet
  • To spleet a window
  • To freeze panes
  • To select a print area
  • To adjust page margins, orientation, size, and breaks
  • Charts
  • To create a chart
  • To insert a sparkline
Size : 988.51 Kb
File type : pdf
Downloads: 1502
Created: 2017-09-24
Quick guide to Microsoft Excel 2016

Others Excel 2016 Tutorials

Excel 2016 Math with Dates and Times

Microsoft Excel 2016 Course for Beginners

Excel 2016 PivotTables and PivotCharts

Microsoft Excel 2016 Academic Course

Excel 2016 Shortcuts

Others related eBooks about Quick guide to Microsoft Excel 2016

Microsoft Excel 2013 Tutorial

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages intended to beginners....

Introduction to VBA in Excel - PDF Tutorial

This is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel....

Essential PowerShell

This book written to provide clear and concise explanation of topics for programmers both starting to learn the PowerShell programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Quick guide to PowerPoint 2010

This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....

VBA API Tutorial

Download VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF....

Microsoft PowerPoint 2007

This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....

Guide Excel 2010

A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages....

Office 365: Migrating and Managing Your Business in the Cloud

Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...

Pivot Tables in Microsoft Excel

The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....

Microsoft Excel 2013

Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....