Excel Agility - Printing and Page Layout
Webinar Details $219
- Webinar Length: 100 Minutes
- Guest Speaker: David Ringstrom
- Topic:   Business Administration, Business Skills, Finance, Software, Taxation and Accounting
- Credit:   CPE 2.0
It doesn’t have to be complicated or time-consuming to lay out and print your Excel documents. Step-by-step, Excel expert David Ringstrom, CPA, demonstrates how to enable a full-screen print preview, use Excel’s Custom Views feature to apply different print settings, pick and choose worksheets you want to print, and more. David’s helpful tips will help you work faster and more efficiently in Excel.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Who Would Be Interested in This Course:
Practitioners who can benefit by utilizing multiple Excel features and functions to easily prepare and print documents.
- Creating a full-page printout of a chart that resides on a worksheet.
- Learning how to deal with annoying changes to Print Preview in Word 2010 and later.
- Incorporating a new feature that enables you to pick and choose the worksheets from any workbook you wish to print—with no programming knowledge or experience required.
- Selecting any aspect of a worksheet you’d like to print.
- Seeing how to print a spreadsheet on the fly via Windows Explorer instead of manually opening a workbook in Excel.
- Keeping an eye on how much your text is being reduced as you try to squeeze more on a page.
- Setting a print range that includes multiple noncontiguous areas of a worksheet.
- Printing a list of all cell comments on a worksheet or printing visible comments.
- Using Excel’s Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet.
- Streamlining the process of printing spreadsheets to .PDF format.
- Recall printing nuances, such as printing all comments from a worksheet.
- Define how to create a full-page printout of a chart that’s located in a worksheet.
- Describe how to select any aspect of a worksheet you’d like to print.
NASBA Field of Study:
Computer Software & Applications (2 hours)
Excel Versions 00:00:39
Set or Clear Print Range 00:03:18
Add Cells to Print Area 00:07:42
Modern Print Preview 00:11:44
Restoring Classic Print Preview 00:14:54
Page Break Preview 00:18:44
Page Breaks 00:22:53
Printing a Portion of a Worksheet 00:26:26
Print Just a Chart From a Worksheet 00:28:26
Control Whether Floating Objects Print 00:29:53
Quick Print 00:38:49
Print Titles 00:41:39
Print Row Numbers and Column Letters 00:44:19
Print Path, Workbook, and /or Sheet Name 00:46:15
CELL Function to Show Document Path 00:51:08
Header and Footer Tools 00:53:28
Printing Cell Comments 00:56:40
Maximize the Print Area with 3 Clicks 01:04:13
Streamlining PDF Creation 01:07:44
One-Click Access for Creating PDF Files 01:10:58
Emailing Spreadsheets as PDFs 01:13:28
Print a Spreadsheet without Launching Excel 01:15:31
Print Selected Worksheets 01:16:41
Creating a Custom View to Print Worksheets 01:20:12
Creating a Custom View to Print Worksheets (cont.) 01:25:10
Universal Print Dialog Box (Plug and Print) 01:27:55
Universal Print Dialog Box (Plug and Print) (cont.) 01:32:55
Universal Print Dialog Box (Plug and Print) (cont.) 01:34:26
Universal Print Dialog Box (Plug and Print) (cont.) 01:37:32
Save a Macro-Enabled Workbook 01:40:07
Presentation Closing 01:41:19
- .PDF 01:08:00
- .XLS 01:41:00
- .XLSB 01:40:57
- .XLSM 01:40:57
- CELL Function 00:51:26
- Chart 00:28:28
- Custom Views 01:20:17
- Dialog Box 01:27:59
- Header/Footer 00:53:32
- Macro 01:28:23, 01:29:06
- Macro Recorder 01:29:18
- Page Break 00:18:57, 00:22:56
- Page Break Preview 00:18:44
- Personal Macro Workbook 01:28:43
- Print Area 00:03:26
- Print Preview 00:11:47, 00:23:47
- Print Titles 00:41:39, 00:42:21, 00:44:34, 00:57:08
- Quick Access Toolbar 00:3:02, 01:11:16
- Slicer Feature 00:30:22
- Visual Basic Editor 00:33:11
- Workbook 00:46:25
Macro: One or more lines of programming code that automate tasks. The Macro Recorder allows users to automate tasks without seeing the underlying programming code.
Macro Recorder: A feature in Excel that allows you to transcribe actions you take in Excel into programming code.
Quick Access Toolbar: A customizable shortcut toolbar that appears above the ribbon in Office 2007 and later.
.XLSM : The .XLSM file extension signifies a Macro-Enabled Excel Workbook. Such workbooks may contain programming code that can automate repetitive tasks in Excel. If prompted, do not enable macros in .XLSM workbooks of unknown provenance because viruses and malware are sometimes transmitted by tricking users into opening such workbooks.
Visual Basic Editor : Excel’s development interface that can be used to edit and create macros, user forms, class modules, custom worksheet functions, and other enhancements to Excel’s functionality. The programming interface for Microsoft Excel that can be accessed by way of the Visual Basic command on Excel’s Developer tab or by pressing Alt-F11.
.PDF: Portable Document Format, a universal document format created by Adobe that allows cross-platform compatibility of documents.
Slicer Feature: A visual filtering feature available with pivot tables in Excel 2010 and tables and pivot tables in Excel 2013.
Custom Views: This feature stores a snapshot of the hidden/visible status of columns, rows, and worksheets, along with print settings and filter settings.
.XLS: Spreadsheets compatible with Excel 2003 and earlier have a .XLS extension. Such spreadsheets can be used in Excel 2007 and later, but certain features will be disabled unless you convert the document to a newer format, such as .XLSX, .XLSM, or .XLSB.
Print Preview : Print preview refers to formatting a document for the printer but then displaying it on the display screen instead of printing it.
CELL Function: The CELL function is a built-in function in Excel that is categorized as an Information Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CELL function can be entered as part of a formula in a cell of a worksheet.
Chart: In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts.
Dialog Box: A dialog box in Excel is a screen where you input information and make choices about different aspects of the current worksheet or its content, such as data, charts, and graphic images.
Print Area: A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed.
Page Break: Page breaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert.
Page Break Preview : You can see the range of cells that will be printed by selecting (View > Page Break Preview). This lets you see the print area clearly with all the page breaks identified. The White area denotes the area that will be printed.
Print Titles: Excel 2013's Print Titles feature enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related data spill over to other pages that no longer show the row and column headings on the first page.
Header/Footer : You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages.
.XLSB: A file with the XLSB file extension is an Excel Binary Workbook file. They store information in binary format instead of XML like with most other Excel files (like XLSX). Since XLSB files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets.