Skills for Success with Microsoft Excel 2016 Comprehensive
Book information
Description
Cover Title Page Copyright Page Contents in Brief Table of Contents Series Reviewers About the Authors Chapter 1: Common Features of Office 2016 Skill 1: Start Office Applications Skill 2: Open and Save Student Data Files Skill 3: Type and Edit Text Skill 4: Format Text and Save Files Skill 5: Apply Themes and Use the Mini Toolbar Skill 6: Use Backstage View Skill 7: Insert and Format Images Skill 8: Format Worksheets Skill 9: Copy and Paste Objects and Format Slides Skill 10: Format Access Reports Skill 11: Store Files Online Skill 12: Share Office Files Skill 13: Install Office Add-ins Skill 14: Customize the Ribbon and Options Introduction to Excel Chapter 1: Create Workbooks with Excel 2016 Skill 1: Create and Save Workbooks Skill 2: Enter Data and Merge and Center Titles Skill 3: Construct Addition and Subtraction Formulas Skill 4: Construct Multiplication and Division Formulas Skill 5: Adjust Column Widths and Apply Cell Styles Skill 6: Insert the SUM Function Skill 7: AutoFill Formulas and Data Skill 8: Format, Edit, and Check Spelling Skill 9: Insert Footers and Adjust Page Settings Skill 10: Display Formulas and Print Worksheets Skill 11: Set Print Areas Skill 12: Fill Data with Flash Fill Skill 13: Create Templates and Workbooks from Templates Skill 14: Manage Document Properties Chapter 2: Insert Summary Functions and Create Charts Skill 1: Align and Wrap Text Skill 2: Apply Absolute Cell References Skill 3: Format Numbers Skill 4: Insert the AVERAGE Function Skill 5: Insert the MIN and MAX Functions Skill 6: Create Column Charts Skill 7: Format Column Charts Skill 8: Create and Format Pie Charts Skill 9: Update Charts and Insert WordArt Skill 10: Preview and Print Multiple Worksheets Skill 11: Validate Workbooks for Accessibility Skill 12: Change Chart Types Skill 13: Copy Excel Data to Word Documents Skill 14: Create Line Charts Chapter 3: Manage Multiple Worksheets Skill 1: Organize Worksheet Tabs Skill 2: Enter and Format Dates Skill 3: Clear Cell Contents and Formats Skill 4: Move Cell Contents and Use Paste Options Skill 5: Enter Data in Grouped Worksheets Skill 6: Insert Multiple Math Operators in Formulas Skill 7: Format Grouped Worksheets Skill 8: Insert, Hide, Delete, and Move Worksheets Skill 9: Create Summary Worksheets Skill 10: Create Clustered Bar Charts Skill 11: Create SmartArt Organization Charts Skill 12: Create and Insert Screen Shots Skill 13: Modify the Quick Access Toolbar Skill 14: Create and Edit Hyperlinks Chapter 4: More Functions and Excel Tables Skill 1: Insert the TODAY, NOW, and COUNT Functions Skill 2: Insert the IF Function Skill 3: Move Functions, Add Borders, and Rotate Text Skill 4: Apply Conditional Formatting Skill 5: Insert Sparklines Skill 6: Use Find and Replace Skill 7: Freeze and Unfreeze Panes Skill 8: Create and Sort Excel Tables Skill 9: Filter Excel Tables Skill 10: Convert Tables to Ranges and Adjust Worksheet Print Settings Skill 11: Add and Remove Table Columns and Rows Skill 12: Insert the Payment (PMT) Function Skill 13: Customize Workbook Views Skill 14: Use Text and Lookup Functions Excel Capstone Project Excel Online (formerly Web App) Project Create Workbooks Using Excel Online Chapter 5: Format Cells and Worksheets Skill 1: Insert Symbols and Create Custom Number Formats Skill 2: Format Cells Using Format Painter Skill 3: Apply Icon Sets as Conditional Formatting Skill 4: Insert Formulas into Conditional Formatting Rules Skill 5: Insert and Delete Rows, Columns, and Cells Skill 6: Modify Cell Backgrounds and Borders Skill 7: Create and Apply Custom Cell Styles Skill 8: Customize, Save, and Apply Themes Skill 9: Add Watermarks and Modify Background Colors Skill 10: Hide Gridlines and Column and Row Headings Skill 11: Convert Comma-Separated Text into Columns Skill 12: Inspect Document Properties to Remove Personal Information Skill 13: Remove Duplicate Records Skill 14: Insert Shapes and Text Boxes Chapter 6: Insert Advanced Functions and Create Scenarios Skill 1: Modify Text Using Text Functions Skill 2: Use Paste Options to Change Underlying Values Skill 3: Look Up Data Using Lookup Functions Skill 4: Edit Conditions in Logical Functions Skill 5: Use COUNTA and COUNTIF Functions Skill 6: Perform What-If Analyses Using Scenario Manager Skill 7: Estimate Future Value Skill 8: Insert Array Formulas Skill 9: Calculate Conditional Sums Skill 10: Calculate Conditional Averages Skill 11: Use Lookup and Nested Functions Skill 12: Use Solver Skill 13: Update Calculations Manually Skill 14: Create Amortization Tables Chapter 7: Work with Data and Audit Formulas Skill 1: Import Data from Text Files Skill 2: Apply Advanced AutoFilters Skill 3: Sort Data Using Conditional Formatting Skill 4: Sort Data and Use the Subtotal Tool to Summarize Data Skill 5: Trace and Evaluate Formulas Skill 6: Audit Formulas Using Cell Watch Skill 7: Create One-Variable Data Tables Skill 8: Create Two-Variable Data Tables Skill 9: Generate Custom Table Styles Skill 10: Name Tables and Convert Tables to a Range Skill 11: Insert Names into Formulas Skill 12: Use Goal Seek Skill 13: Use MATCH and INDEX Functions: Part 1 Skill 14: Use MATCH and INDEX Functions: Part 2 Chapter 8: Manage and Present Data Visually Skill 1: Import and TRIM Data from Non-native Files Skill 2: Use LEFT, RIGHT, and MID Functions Skill 3: Add Legends and Data Series to Charts Skill 4: Enhance Charts with Trendlines and Text Boxes Skill 5: Modify Excel Worksheet Templates Skill 6: Consolidate Worksheet Data Skill 7: Construct Dual Axis Charts Skill 8: Create and Edit Custom Chart Templates Skill 9: Edit and Save Excel File Type Versions Skill 10: Send Workbook Files via Email and OneDrive Skill 11: Modify Charts and Graph Parameters Skill 12: Manage Workbook Versions Skill 13: Serialize Numbers Using Functions Skill 14: Modify the Excel Ribbon Chapter 9: Link and Analyze Data in PivotTables and PivotCharts Skill 1: Get and Transform Data Skill 2: Create PivotTable Reports Skill 3: Change PivotTable Report Views Skill 4: Change Calculation Types and Format PivotTable Reports Skill 5: Create PivotTable Report Calculated Fields Skill 6: Group and Filter PivotTable Reports Skill 7: Use Slicers to Filter PivotTable Reports Skill 8: Create PivotChart Reports Skill 9: Format PivotChart Reports Skill 10: Summarize Tables Using GETPIVOTDATA Skill 11: Use Power Pivot to Link Data to Access Databases Skill 12: Create PivotChart Reports Using Power View Skill 13: Add CUBE Functions Using Power Pivot Skill 14: Use the Inquire Add-In Chapter 10: Secure and Share Workbooks Skill 1: Modify Excel Options and Work with Comments Skill 2: Add Data Validation Rules Skill 3: Track Changes Skill 4: Accept and Reject Tracked Changes Skill 5: Merge Changes Skill 6: Save Workbooks as Web Pages and Embed Data in Web Pages Skill 7: Unlock Cells and Protect Worksheets Skill 8: Enable and Copy Macros Between Workbooks Skill 9: Record Macros Skill 10: Write Macros Using VBA Skill 11: Insert Form Controls Skill 12: Add Macro Buttons to the Quick Access Toolbar Skill 13: Prepare Workbooks for Internationalization Skill 14 Assign Macros to Command Buttons Excel Capstone Project Excel Online (formerly Web App) Project: Use Advanced Skills to Create Online Workbooks Glossary Appendix Index Back Cover
Similar books
MySQL® Notes for Professionals book
2018 · PDF
MrExcel 2022: Boosting Excel
2022 · PDF
MrExcel 2022: Boosting Excel
2022 · PDF
Session C11: Ancient Cultural Landscapes in South Europe – their Ecological Setting and Evolution, Session C22: Gardeners from South America, Session S04: Agro-Pastoralism and Early Metallurgy Sessions, Session WS29: The Idea of Enclosure in Recent Iberian Prehistory, Session C88: Rhytmes et causalites des dynamiques de l'anthropisation en Europe entre 6500 ET 500 BC: Hypotheses socio-culturelles et/ou climatiques: Proceedings of the XV UISPP World Congress (Lisbon 4-9 September 2006) / Actes du XV Congrès Mondial (Lisbonne 4-9 Septembre 2006) Vol.36
2010 · PDF
THE BRITISH ARMY IN INDIA: ITS PRESERVATION BY AN APPROPRIATE CLOTHING, HOUSING, LOCATING, RECREATIVE EMPLOYMENT, AND HOPEFUL ENCOURAGEMENT OF THE TROOPS. with AN APPENDIX ON INDIA : THE CLIMATE OP ITS HILLS ; THE DEVELOPMENT OF ITS RESODRCBS, INDUSTRY, AND ARTS ; THE ADMINISTRATION OF JUSTICE ; THE BLACK ACT ; THE PROGRESS OF CHRISTIANITY ; THE TRAFFIC IN OPIUM ; THE VALUE OF INDIA ; PERMANENT CAUSES OF DISAFFECTION, AND OF THE RECENT REBELLION ; THE TRADITIONARY POLICY; MISGOVERNMENT BY NATIVE RULERS ; ANNEXATIONS OF THEIR TERRITORY, ETC.
1858 · PDF
Idries Shah 27 Books Collection : A Perfumed Scorpion, A Veiled Gazelle, Caravan of Dreams, Darkest England, Destination Mecca, Evenings with Idries Shah, Knowing How to Know, Learning How to Learn, Letters and Lectures of Idries Shah, Neglected aspects of Sufi study, Observations, Oriental Magic, Reflections, Seeker after Truth, Special Illumination, Special Problems in the study of Sufi ideas, Sufi thought and action, Tales of the Dervishes, The Dermis Probe, The Elephant in the Dark, The Englishman Handbook, Idries Shah Antology, The Magic Monastery, The natives are restless, wisdom of the Idiots PDF.
2022 · PDF
The travels of Capts. Lewis and Clarke from St. Louis, by way of the Missouri and Columbia rivers, to the Pacific ocean; performed in the years 1804, 1805 & 1806, by order of the government of the United States. Containing delineations of the manners, customs, religion, &c. of the Indians, comp. from various authentic sources, and original documents, and a summary of the Statistical view of the Indian nations, from the official communication of Meriwether Lewis. Illustrated with a map of the country, inhabited by the western tribes of Indians
1809 · PDF
Professional Linux kernel architecture ''Wrox programmer to programmer''--Cover. - ''What you are reading right now is the result of an evolution over more than seven years: After two years of writing, the first edition was published in German by Carl Hanser Verlag in 2003. It then described kernel 2.6.0. The test was used as a basis for the low-level design documentation for the EAL4+ security evaluation of Red Hat Enterprise Linux 5, requiring to update it to kernel 2.6.18 (if the EAL acronym does not mean anything to you, then Wikipedia is once more your friend). Hewlett-Packard sponsored the translation into English and has, thankfully, granted the rights to publish the result. Updates to kernel 2.6.24 were then performed specifically for this book''--P. ix
2008 · PDF