Power Excel with MrExcel : 567 Excel mysteries solved / Bill Jelen.

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...

Full description

Saved in:
Bibliographic Details
Main Author: Jelen, Bill (Author)
Format: eBook
Language:English
Published: Uniontown, OH : Holy Macro! Books, [2015]
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 i 4500
001 ocn913752612
003 OCoLC
005 20240909213021.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  |d SXB  |d OCLCQ 
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 
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 
049 |a HCDD 
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. 
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 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.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=4306969  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD