Cargando…

Power Excel with MrExcel : 567 Excel mysteries solved /

Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Uniontown, OH : Holy Macro! Books, [2015]
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 i 4500
001 EBOOKCENTRAL_ocn913752612
003 OCoLC
005 20240329122006.0
006 m o d
007 cr cnu||||||||
008 150713s2015 ohua o 001 0 eng d
040 |a LGG  |b eng  |e rda  |e pn  |c LGG  |d B24X7  |d OCLCF  |d TEFOD  |d YDXCP  |d EBLCP  |d DEBSZ  |d IDEBK  |d LIV  |d IDB  |d OCLCQ  |d MERUC  |d OCLCQ  |d OCLCO  |d CUY  |d ZCU  |d ICG  |d VT2  |d DKC  |d OCLCQ  |d COO  |d K6U  |d D6H  |d LOA  |d G3B  |d CNCEN  |d S8J  |d COCUF  |d CNNOR  |d OCLCQ  |d OCLCO  |d UKCRE  |d BRF  |d LVT  |d S2H  |d INARC  |d OCLCO  |d OCLCQ  |d AU@  |d OCLCO  |d OCLCL 
019 |a 935256097  |a 966372455  |a 1136578060  |a 1153470520  |a 1179533372  |a 1225829447  |a 1229338947  |a 1257386648  |a 1276758129  |a 1276820856  |a 1287180556  |a 1354559463 
020 |a 9781615473489  |q (electronic bk.) 
020 |a 1615473483  |q (electronic bk.) 
020 |a 9781615471256  |q (electronic bk.) 
020 |a 1615471251  |q (electronic bk.) 
020 |z 9781615470389 
020 |z 1615470387 
029 1 |a DEBSZ  |b 454931700 
029 1 |a AU@  |b 000064558892 
035 |a (OCoLC)913752612  |z (OCoLC)935256097  |z (OCoLC)966372455  |z (OCoLC)1136578060  |z (OCoLC)1153470520  |z (OCoLC)1179533372  |z (OCoLC)1225829447  |z (OCoLC)1229338947  |z (OCoLC)1257386648  |z (OCoLC)1276758129  |z (OCoLC)1276820856  |z (OCoLC)1287180556  |z (OCoLC)1354559463 
037 |a 7CBBC72F-0CA4-491C-AD8D-08FF909AD2F0  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a HF5548.4.M523  |b J45433 2015 
082 0 4 |a 650.0285/554  |2 23 
049 |a UAMI 
100 1 |a Jelen, Bill,  |e author. 
245 1 0 |a Power Excel with MrExcel :  |b 567 Excel mysteries solved /  |c Bill Jelen. 
264 1 |a Uniontown, OH :  |b Holy Macro! Books,  |c [2015] 
264 4 |c Ã2015 
300 |a 1 online resource (xviii, 538 pages :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
500 |a "Master pivot tables, subtotals, charts, VLOOKUP, IF, data analysis in Excel 2010-2013"--Cover 
500 |a Includes index. 
588 0 |a Print version record. 
505 0 |a Front Cover; Title Page; Copyright; Table of Contents; About the Author; Dedication; Acknowledgments; Foreword; What is Office 365? Do I have to work in a Browser?; Why Do I Have to Sign in to Excel 2013?; Why Facebook, LinkedIn and Twitter?; How Can I Use Excel on Dual Monitors?; Find Icons on the Ribbon; Seriously, I Really Can't Find This; Where Are My Macros?; What Happened to Tools, Options?; Customizing the Ribbon; Go Wide; Minimize the Ribbon to Make Excel Feel a Bit More Like Excel 2003; Use a Wheel Mouse to Scroll Through The Ribbon Tabs. 
505 8 |a Why Do The Charting Ribbon Tabs Keep Disappearing?Use Dialog Launchers to Access the Excel 2003 Dialog; Icon, Dropdowns, and Hybrids; All Commands Start at the Top (Except for 2 Controls at the Bottom); Make Your Most-Used Icons Always Visible; The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough); Use New Keyboard Shortcuts to Access the Ribbon; Why Do I Have Only 65,536 Rows?; Which File Format Should I Use?; Why Does The File Menu Cover The Entire Screen?; How Do I Close The File Menu?; Increase the Number of Workbooks in the Recent Files List. 
505 8 |a Change All Print Settings in ExcelI Just Want The Old Print Preview Back; Use Live Preview; Get Quick Access to Formatting Options Using the Mini Toolbar; What Is Protected Mode?; Use a Trusted Location to Prevent Excel's Constant Warnings; My Manager Wants Me to Create a New Expense Report from Scratch; Open a Copy of a Workbook; Excel's Obsession with Security Has Hampered Linked Workbooks; Open Excel with Ctrl+Alt+X; Have Excel Always Open Certain Workbook(s); Set up Excel Icons to Open a Specific File on Startup; Use a Macro to Customize Startup. 
505 8 |a Control Settings for Every New Workbook and WorksheetAutomatically Move the Cell Pointer in a Direction After Entering a Number; Return to the First Column After Typing the Last Column; Enter Data in a Circle (Or Any Pattern); How to See Headings as You Scroll Around a Report; How to See Headings and Row Labels as You Scroll Around a Report; Why is the Scrollbar Slider Suddenly Tiny?; Jump to the Edge of the Data; Jump to Next Corner of Selection; Zoom with the Wheel Mouse; Copy a Formula to All Data Rows; Copy the Characters from a Cell Instead of Copying an Entire Cell. 
505 8 |a A Faster Way To Paste SpecialQuickly Turn a Range on Its Side; Quickly Rearrange Rows Or Columns; Copy Cells from One Worksheet to Many Other Worksheets; Quickly Copy Worksheets; Find Text Numbers; Why Can't Excel Find a Number?; Mix Formatting In A Single Cell; Enter a Series of Months, Days, or More by Using the Fill Handle; Have the Fill Handle Fill Your List of Part Numbers; Teach Excel to Fill A, B, C; Use Excel as a Word Processor; Add Excel to Word; Use Hyperlinks to Create an Opening Menu for a Workbook; Arrange Windows to See Two or More Open Workbooks. 
520 |a Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Electronic spreadsheets. 
650 0 |a Business  |x Computer programs. 
650 6 |a Tableurs. 
650 7 |a Business  |x Computer programs  |2 fast 
650 7 |a Electronic spreadsheets  |2 fast 
758 |i has work:  |a Power Excel with MrExcel (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGRJb8MqW6wKJY4kWqXYpq  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Jelen, Bill.  |t Power Excel with MrExcel.  |d Uniontown, OH : Holy Macro! Books, [2015]  |z 9781615470389  |w (DLC) 2014915530  |w (OCoLC)892461512 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=4306969  |z Texto completo 
938 |a Books 24x7  |b B247  |n bko00086111 
938 |a EBL - Ebook Library  |b EBLB  |n EBL4306969 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis33443793 
938 |a Internet Archive  |b INAR  |n powerexcelwithmr0000jele_h2o4 
938 |a YBP Library Services  |b YANK  |n 12779959 
938 |a YBP Library Services  |b YANK  |n 302199111 
994 |a 92  |b IZTAP