Autore	Walkenbach John
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : Wiley Pub., Inc., 2010
Descrizione fisica	1 online resource (1081 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's Bookshelf
Soggetto topico	Electronic spreadsheets Computer software - Development
ISBN	0-470-62550-3 1-62198-427-3 1-282-68504-X 9786612685040 1-118-25761-8 0-470-62548-1
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	pt. 1. Some essential background -- pt. 2. Excel application development -- pt. 3. Understanding Visual Basic for applications -- pt. 4. Working with UserForms -- pt. 5. Advanced programming techniques -- pt. 6. Developing applications -- pt. 7. Other topics -- pt. 8. Appendixes.
Record Nr.	UNINA-9910140589303321

Autore	Harvey Greg
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : J. Wiley & Sons, Inc., 2013
Descrizione fisica	1 online resource (795 p.)
Disciplina	005.54
Collana	--For dummies
Soggetto topico	Electronic spreadsheets Business - Computer programs
Soggetto genere / forma	Electronic books.
ISBN	1-118-55018-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel® 2013 All-in-One For Dummies®; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Conventions Used in This Book; Icons Used in This Book; Where to Go from Here; Book I: Excel Basics; Contents at a Glance; Contents at a Glance; Chapter 1: The Excel 2013 User Experience; Excel 2013's New Look and Feel; Excel's Start Screen; Excel's Ribbon User Interface; Getting Help; Launching and Quitting Excel; Chapter 2: Customizing Excel 2013; Tailoring the Quick Access Toolbar to Your Tastes; Exercising Your Options; Using Office Apps; Add-In Mania Book II: Worksheet DesignContents at a Glance; Chapter 1: Building Worksheets; Designer Spreadsheets; It Takes All Kinds (Of Cell Entries); Data Entry 101; Saving the Data; Document Recovery to the Rescue; Chapter 2: Formatting Worksheets; Making Cell Selections; Adjusting Columns and Rows; Formatting Tables from the Ribbon; Formatting Tables with the Quick Analysis Tool; Formatting Cells from the Ribbon; Formatting Cell Ranges with the Mini-Toolbar; Using the Format Cells Dialog Box; Hiring Out the Format Painter; Using Cell Styles; Conditional Formatting Chapter 3: Editing and Proofing WorksheetsOpening a Workbook; Cell Editing 101; A Spreadsheet with a View; Copying and Moving Stuff Around; Find and Replace This Disgrace!; Spell Checking Heaven; Looking Up and Translating Stuff; Marking Invalid Data; Eliminating Errors with Text to Speech; Chapter 4: Managing Worksheets; Reorganizing the Worksheet; Reorganizing the Workbook; Working with Multiple Workbooks; Consolidating Worksheets; Chapter 5: Printing Worksheets; Printing from the Excel 2013 Backstage View; Quick Printing the Worksheet; Working with the Page Setup Options Headers and FootersSolving Page Break Problems; Printing the Formulas in a Report; Book III: Formulas and Functions; Contents at a Glance; Chapter 1: Building Basic Formulas; Formulas 101; Copying Formulas; Adding Array Formulas; Range Names in Formulas; Adding Linking Formulas; Controlling Formula Recalculation; Circular References; Chapter 2: Logical Functions and Error Trapping; Understanding Error Values; Using Logical Functions; Error-Trapping Formulas; Whiting-Out Errors with Conditional Formatting; Formula Auditing; Removing Errors from the Printout; Chapter 3: Date and Time Formulas Understanding Dates and TimesUsing Date Functions; Using Time Functions; Chapter 4: Financial Formulas; Financial Functions 101; The PV, NPV, and FV Functions; The PMT Function; Depreciation Functions; Analysis ToolPak Financial Functions; Chapter 5: Math and Statistical Formulas; Math & Trig Functions; Statistical Functions; Chapter 6: Lookup, Information, and Text Formulas; Lookup and Reference; Information, Please . . .; Much Ado about Text; Book IV: Worksheet Collaboration and Review; Contents at a Glance; Chapter 1: Protecting Workbooks and Worksheet Data; Password-Protecting the File Protecting the Spreadsheet
Altri titoli varianti	Microsoft Excel 2013 all-in-one for dummies
Record Nr.	UNINA-9910452467003321