Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial, course tutorial training, a PDF file in 87 pages for beginners.

This lesson went over many of the advanced features in Excel. We started with timesaving interface customization features which included the ability to add a tab in the ribbon, customize the status bar, navigate to multiple files simultaneously using multiple windows, and use static columns or rows. We then looked at how referencing across sheets.

Table of content

  • Objectives
  • Interface Customization
  • Adding a Tab in the Ribbon
  • Status Bar Customization
  • Navigating in Multiple Windows and Panes
  • Referencing Across Sheets
  • Advanced Formatting
  • Custom Lists
  • Using Groups to Format Multiple Worksheets
  • Transposing Table
  • Advanced Formulas and Features
  • Formula Tools
  • Range Names
  • Lookup, If, and Time Functions
  • Data Validation
  • Conclusion
  • Advanced Excel Activity
Size10,235.75 Kb
File typepdf
Downloads14180
Created2017-09-24
Cover of Advanced Microsoft Excel 2013
Preview PDF

Download

  • Excel 2016 Functions Tutorial

    Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....

  • 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....

  • Advanced Word 2013

    With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word 2013 and you will learn how to write document with ease....

  • Quick guide to Microsoft Excel 2016

    Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....

  • Excel Data Analysis

    Download free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....

  • Excel Basics: Microsoft Office 2013

    This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....

  • Full list of Excel functions

    Download the complete list.of Microsoft Excel functions, free training document in pdf....

  • Microsoft Word 2013

    Download courses Microsoft Word 2013 in PDF ,a free training document under 15 pages for beginners....

  • PowerPoint Presentation

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

  • Excel 2016 PivotTables and PivotCharts

    Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....