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
Size : 10,235.75 Kb
File type : pdf
Downloads: 13759
Created: 2017-09-24

Others Excel 2013 Tutorials

Microsoft Excel 2013

Microsoft Excel 2013 for beginner

Microsoft Excel 2013 course

Others related eBooks about Advanced Microsoft Excel 2013

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

Basic Formulas in Excel

Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....

Microsoft Excel 2007 : Essential Guide

The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....

Microsoft Excel 2013 Tutorial

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

Microsoft Word 2103 Step by Step

This PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training document under 576 pages for download....

Download Publisher 2016 PDF tutorial

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

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

How to Create Professional Reports and Documents in Microsoft Word

This is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...

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