Edition |
2017 edition. |
Description |
1 online resource (xx, 553 pages) : color illustrations |
Physical Medium |
polychrome |
Description |
text file |
Note |
"Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis"--Cover. |
|
Includes index. |
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. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Electronic spreadsheets.
|
|
Electronic spreadsheets. |
|
Business -- Computer programs.
|
|
Business -- Computer programs. |
Genre/Form |
Electronic books.
|
ISBN |
9781615472321 (electronic book) |
|
1615472320 (electronic book) |
|
9781615473557 |
|
1615473556 |
|