Learn your way! Get started

Excel 2013, Part 3: Printing and Formulas

with expert John Wiley & Sons

Watch trailer

Excel 2013, Part 3: Printing and Formulas Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 3/18/2015
Level Level Beginner
Runtime Runtime 1h 11m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Published eBooks Published eBooks Included
Hands-on labs Hands-on labs N/A
Sample files Sample files Included
Exams Exams N/A

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

In this seven part learning series you’ll see to use Microsoft Excel 2013 to organize, visualize and calculate your data. Get to know the Excel 2013 window and terminology, and create, edit, and manage cells, worksheets, and workbooks. Apply styles and themes to worksheets and adjust cell formatting with various fonts, colors, and borders. Work with formulas and functions to analyze data then present that data in a Pivot Table or visually with charts and graphs.


This course assumes some familiarity with Microsoft Excel. This course is part of 7 courses; Excel 2013: Introduction; Excel 2013: Formatting; Excel 2013: Printing and Formulas; Excel 2013: Formatting, Tables and Functions; Excel 2013: Functions; Excel 2013: Charts and Pivot Tables and Excel 2013: Workbooks and Security. Please be sure to view the courses in order if you are new to the material.

Meet the expert

John Wiley & Sons Our Creative Design courses are presented by experts from Wiley Publishing. Wiley is a global provider of knowledge and knowledge-enabled services that improve outcomes in areas of research, professional practice, and education. They are the publisher of award-winning journals, encyclopedias, books, and online products and services.

Course outline

Printing and Formulas

Pre-Print Adjustments (22:32)
  • Introduction (00:10)
  • Hide Elements (03:16)
  • Freeze Rows & Columns (04:57)
  • Pre-Print Adjustments (03:53)
  • More Pre-Print Adjustments (05:18)
  • Headers and Footers (04:45)
  • Summary (00:10)
Printing (21:40)
  • Introduction (00:10)
  • Print Area (03:36)
  • Print Area Cont. (03:11)
  • Print with Excel Elements (03:42)
  • Print Titles (04:06)
  • Print Previews (02:59)
  • Introduction to Math (03:44)
  • Summary (00:10)
Formulas (27:14)
  • Introduction (00:10)
  • Formulas (05:30)
  • Editing Formulas (06:08)
  • Cell References (04:22)
  • Copying Cell References (02:48)
  • Convert Formula to Value (02:06)
  • Data Ranges (05:58)
  • Summary (00:10)