K2 Enterprises. Advanced Excel Tips

K2 Enterprises. – 34 p.
(Автор и год издания не указаны).Most accountants are very comfortable with Microsoft Excel and several consider themselves advanced users. Unfortunately, even the advanced users are frequently not aware of dozens of highly-useful features and techniques because they are self taught.
Based on over 20 years of using and teaching spreadsheets to Accountants, this session is packed with tips and techniques that will save you time and make you more effective.
Topics include using global rounding, using hyperlinks in Excel, standardizing spreadsheet design, 24/7 free support for Excel problems, using the camera feature to create reports that are separate from the Excel data and much, much more.Using Wildcards to Sum Cells in Sheets.
End Down and End Right with a Double Click of the Mouse.
Fill an Entire Column with One Double Click.
Using Internet Newsgroups for Excel Help.
Using the Google Web Site to Search Newsgroups.
Format Painter.
Creating Formula that Only Reference Non-Blank Cells.
Working with Styles.
Using Custom Views to Navigate Large Workbooks.
Embedding Objects in Excel.
Embedding a Word Object in Excel.
Embedding a.pdf (i.e., Adobe Acrobat) in Excel.
Auto Stuff.
Auto Fill.
Auto Fill with the Fill Handle.
AutoFill with the Fill Handle and the Control Key.
Absolute vs. Relative References Beyond the Basics.
Basics Reviewed.
Beyond the Basics.
Range Name and Sheet Name References.
AutoSum Drop Down Options.
Using the Accounting Format in Financial Statements.
Using Underlines with the Accounting Format.
Using the Accounting Format with Labels.
Selecting Non-Contiguous Ranges Simultaneously.
Quickly and Easily View all the Formula in Your Worksheet.
Using Passwords to Protect Files.
New Excel 2002/2003 Password Protection Features.
Data Subtotal and Select Visible Cells.
Global Rounding (Precision As Displayed).
Put Date and Time Stamps on Your Work.