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

Excel 2016 Shortcuts

Microsoft Excel 2016 Course for Beginners

Excel 2016 PivotTables and PivotCharts

Microsoft Excel 2016 Academic Course

Others related eBooks about Quick guide to Microsoft Excel 2016

Introduction to Excel VBA Macro programming

Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...

Excel VBA tutorial for professionals

Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

PowerPoint Presentation

This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

Microsoft Excel 2013 Tutorial

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

Basic Excel Skills

This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course....

Excel 2016 Shortcuts

With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners....

Beginning Microsoft® Excel®

This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and...

Download Publisher 2016 PDF tutorial

Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....

Commonly Used Excel Functions

Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....