skip to content
Power Excel with MrExcel : 617 Excel mysteries solved Preview this item
ClosePreview this item
Checking...

Power Excel with MrExcel : 617 Excel mysteries solved

Author: Bill Jelen
Publisher: Merritt Island, FL : Holy Macro! Books, [2017]
Edition/Format:   eBook : Document : English : 2017 editionView all editions and formats
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Bill Jelen
ISBN: 9781615472321 1615472320 9781615473557 1615473556
OCLC Number: 972092284
Notes: "Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis"--Cover.
Includes index.
Description: 1 online resource (xx, 553 pages) : color illustrations
Contents: Cover; Title Page; Credits; Table of Contents; About the Author; Dedication; Foreword; Acknowledgments; Why Does Office 365 Have Better Features?; Which Version of Office 365 Has Power Pivot?; Why Do I Have to Sign in to Excel?; How Can I Use Excel on Dual Monitors?; How Can I Open The Same Workbook Twice?; Find Icons on the Ribbon; Where is File, Exit?; Where Are My Macros?; Customizing the Ribbon; Go Wide; Minimize the Ribbon to Free Up a Few More Rows; Use a Wheel Mouse to Scroll Through The Ribbon Tabs; Why Do The Charting Ribbon Tabs Keep Disappearing? Use Dialog Launchers For More ChoicesIcon, Dropdowns, and Hybrids; Zoom is at the Bottom; Make Your Most-Used Icons Always Visible; The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough); Use 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; Change All Print Settings in Excel; I Just Want The Old Print Preview Back; 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; 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; Control Settings for Every New Workbook and Worksheet; Excel Says I Have Links, But I Can Not Find Them; Automatically Move the Cell Pointer After Enter; 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 ReportHow to See Headings and Row Labels as You Scroll Around a Report; Why is the Scrollbar Slider Suddenly Tiny?; Why Won't My Scrollbar Scroll to My Charts?; Jump to the Edge of the Data; Jump to Next Corner of Selection; Ctrl+Backspace brings the Active Cell into View; Zoom with the Wheel Mouse; Copy a Formula to All Data Rows; Copy the Characters from a Cell ƯInstead of Copying an Entire Cell; A Faster Way To Paste Values; Quickly Turn a Range on Its Side; Quickly Rearrange Rows Or Columns; Quickly Copy Worksheets. Use Group Mode to Change All WorksheetsFind 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; Add Total to the End of Jan, Feb ... Dec; Put Date & Time in a Cell; Use Excel as a Word Processor; Add Excel to Word; Use Hyperlinks to Create an Opening Menu for a Workbook; Spell check a Region; Stop Excel from AutoCorrecting Certain Words; Use AutoCorrect to Enable a Shortcut.
Responsibility: Bill Jelen.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/972092284> # Power Excel with MrExcel : 617 Excel mysteries solved
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "972092284" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/flu> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'https://img1.od-cdn.com/ImageType-100/0427-1/{E4BD3366-7239-49F6-81C6-2AD56A1225BF}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_computer_programs> ; # Business--Computer programs
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#Topic/electronic_spreadsheets> ; # Electronic spreadsheets
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_skills> ; # BUSINESS & ECONOMICS--Skills
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_reference> ; # BUSINESS & ECONOMICS--Reference
    schema:about <http://dewey.info/class/650.0285554/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_management> ; # BUSINESS & ECONOMICS--Management
    schema:author <http://experiment.worldcat.org/entity/work/data/2092885923#Person/jelen_bill> ; # Bill Jelen
    schema:bookEdition "2017 edition." ;
    schema:bookFormat schema:EBook ;
    schema:datePublished "2017" ;
    schema:description "Cover; Title Page; Credits; Table of Contents; About the Author; Dedication; Foreword; Acknowledgments; Why Does Office 365 Have Better Features?; Which Version of Office 365 Has Power Pivot?; Why Do I Have to Sign in to Excel?; How Can I Use Excel on Dual Monitors?; How Can I Open The Same Workbook Twice?; Find Icons on the Ribbon; Where is File, Exit?; Where Are My Macros?; Customizing the Ribbon; Go Wide; Minimize the Ribbon to Free Up a Few More Rows; Use a Wheel Mouse to Scroll Through The Ribbon Tabs; Why Do The Charting Ribbon Tabs Keep Disappearing?"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/2092885923> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:name "Power Excel with MrExcel : 617 Excel mysteries solved"@en ;
    schema:productID "972092284" ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1465445> ;
    schema:url <http://www.myilibrary.com?id=992311> ;
    schema:url <https://library.smu.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <http://ezproxy.acadiau.ca:2048/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=4802108> ;
    schema:url <https://login.ezproxy.nscc.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <https://www.overdrive.com/search?q=E4BD3366-7239-49F6-81C6-2AD56A1225BF> ;
    schema:url <http://0-search.ebscohost.com.librarycatalog.vts.edu/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=4802108> ;
    schema:url <http://ezproxy.msvu.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <https://samples.overdrive.com/?crid=e4bd3366-7239-49f6-81c6-2ad56a1225bf&.epub-sample.overdrive.com> ;
    schema:url <https://nl.idm.oclc.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url "https://img1.od-cdn.com/ImageType-100/0427-1/{E4BD3366-7239-49F6-81C6-2AD56A1225BF}Img100.jpg" ;
    schema:url <https://login.ezproxy.cbu.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <https://hclib.overdrive.com/media/E4BD3366-7239-49F6-81C6-2AD56A1225BF> ;
    schema:url <http://ezproxy.viu.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1465445> ;
    schema:url <http://lib.myilibrary.com?id=992311> ;
    schema:workExample <http://worldcat.org/isbn/9781615473557> ;
    schema:workExample <http://worldcat.org/isbn/9781615472321> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/972092284> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2092885923#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Person/jelen_bill> # Bill Jelen
    a schema:Person ;
    schema:familyName "Jelen" ;
    schema:givenName "Bill" ;
    schema:name "Bill Jelen" ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_management> # BUSINESS & ECONOMICS--Management
    a schema:Intangible ;
    schema:name "BUSINESS & ECONOMICS--Management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_reference> # BUSINESS & ECONOMICS--Reference
    a schema:Intangible ;
    schema:name "BUSINESS & ECONOMICS--Reference"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_&_economics_skills> # BUSINESS & ECONOMICS--Skills
    a schema:Intangible ;
    schema:name "BUSINESS & ECONOMICS--Skills"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Topic/business_computer_programs> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2092885923#Topic/electronic_spreadsheets> # Electronic spreadsheets
    a schema:Intangible ;
    schema:name "Electronic spreadsheets"@en ;
    .

<http://lib.myilibrary.com?id=992311>
    rdfs:comment "Connect to MyiLibrary resource." ;
    .

<http://worldcat.org/isbn/9781615472321>
    a schema:ProductModel ;
    schema:isbn "1615472320" ;
    schema:isbn "9781615472321" ;
    .

<http://worldcat.org/isbn/9781615473557>
    a schema:ProductModel ;
    schema:isbn "1615473556" ;
    schema:isbn "9781615473557" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.