Buy Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive, 1st Edition PDF ebook by author Steven M. Freund; Joy L. Starks – published by Cengage Learning in 2020 and save up to 80% compared to the print version of this textbook. With PDF version of this textbook, not only save you money, you can also highlight, add text, underline add post-it notes, bookmarks to pages, instantly search for the major terms or chapter titles, etc.
You can search our site for other versions of the Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive, 1st Edition PDF ebook. You can also search for others PDF ebooks from publisher Cengage Learning, as well as from your favorite authors. We have thousands of online textbooks and course materials (mostly in PDF) that you can download immediately after purchase.
Note: e-textBooks do not come with access codes, CDs/DVDs, workbooks, and other supplemental items.
- Full title: Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive, 1st Edition
- Edition: 1st
- Copyright year: 2020
- Publisher: Cengage Learning
- Author: Steven M. Freund; Joy L. Starks
- ISBN: 9780357119259, 9780357119259
- Format: PDF
Description of Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive, 1st Edition:
Introduce your students to the latest advancements that Microsoft Office and Excel have to offer with MICROSOFT OFFICE 365 & EXCEL 2019 — new to the acclaimed Shelly Cashman Series. MICROSOFT OFFICE 365 & EXCEL 2019 continues the series’ strong history of innovation with a hallmark learning approach enhanced to address the varied learning styles of today’s students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought, and personalization. This new edition and accompanying resources are designed to engage readers and improve retention while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Table of Contents of Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive, 1st Edition PDF ebook:
Brief ContentsContentsGetting to Know Microsoft Office VersionsUsing SAM Projects and Textbook ProjectsMicrosoft Excel 2019Module 1: Creating a Worksheet and a ChartIntroductionProject: Real Estate Budget Worksheet and ChartStarting and Using ExcelSelecting a CellEntering TextEntering NumbersCalculating Sums and Using FormulasUsing the Fill Handle to Copy a Cell to Adjacent CellsCalculating Average, Maximum, and Minimum ValuesSaving the ProjectFormatting the WorksheetAdding a Pie Chart to the WorksheetChanging the Sheet Tab Names and ColorsDocument PropertiesPrinting a WorksheetViewing Automatic CalculationsCorrecting ErrorsSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 2: Formulas, Functions, and FormattingIntroductionProject: Worksheet with Formulas and FunctionsEntering the Titles and Numbers into the WorksheetFlash FillEntering FormulasOption ButtonsUsing the AVERAGE, MAX, MIN, and Other Statistical FunctionsVerifying Formulas Using Range FinderFormatting the WorksheetChecking SpellingPrinting the WorksheetDisplaying and Printing the Formulas Version of the WorksheetSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 3: Working with Large Worksheets, Charting, and What-If AnalysisIntroductionProject: Financial Projection Worksheet with What-If Analysis and ChartRotating Text and Using the Fill Handle to Create a SeriesCopying a Range of Cells to a Nonadjacent Destination AreaInserting and Deleting Cells in a WorksheetAbsolute versus Relative AddressingMaking Decisions-The IF FunctionAdding and Formatting Sparkline ChartsFormatting the WorksheetAdding a Clustered Column Chart to the WorkbookOrganizing the WorkbookChanging the View of the WorksheetWhat-If AnalysisInsightsAccessibility FeaturesSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 4: Financial Functions, Data Tables, and Amortization SchedulesIntroductionProject: Mortgage Payment Calculator with Data Table and Amortization ScheduleCreating Cell NamesUsing a Data Table to Analyze Worksheet DataCreating an Amortization SchedulePrinting Sections of the WorksheetProtecting and Hiding Worksheets and WorkbooksFormula CheckingSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 5: Working with Multiple Worksheets and WorkbooksIntroductionProject: Consolidated Expenses WorksheetCreating the Consolidated WorksheetFill SeriesDate, Time, and Round FunctionsFormat CodesCreating a Cell StyleWorking with Multiple WorksheetsReferencing Cells across WorksheetsFormatting Pie ChartsCreating Separate Files from WorksheetsConsolidating Data by Linking Separate WorkbooksSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 6: Creating, Sorting, and Querying a TableIntroductionProject: Rating Bank Account ManagersCreating a TableUsing a Lookup TableAdding Calculated Fields to the TableConditional FormattingWorking with Tables in ExcelSorting a TableQuerying a Table Using AutoFilterUsing Criteria and Extract RangesUsing Database FunctionsUsing the Sumif, Countif, Match, and Index FunctionsSummarizing DataTreemap ChartsSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots IntroductionProject: Meyor InsuranceCreating TemplatesImporting DataUsing the Quick Analysis GalleryUsing the Find and Replace CommandsInserting a Bar ChartWorking with SmartArt GraphicsPictures and IconsText BoxesAlternative TextObject Linking and EmbeddingUsing Screenshots on a WorksheetShapesSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 8: Working with Trendlines, PivotTables, PivotCharts, and SlicersIntroductionProject: Bell & Rodgers AccountingLine Charts and TrendlinesCreating and Formatting PivotTable ReportsCreating and Formatting PivotChart ReportsWorking with SlicersOther Excel ChartsSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 9: Formula Auditing, Data Validation, and Complex Problem SolvingIntroductionProject: Instrument Logistics AnalysisFormula AuditingData ValidationSolving Complex ProblemsCustomizing Excel Add-InsSolver RequirementsUsing Scenarios and Scenario Manager to Analyze DataSummarizing ScenariosInk AnnotationsSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 10: Data Analysis with Power Tools and Creating MacrosIntroductionProject: Business Decisions DemographicsGet & TransformPower PivotPower View3D MapsPower BIFormatting a Home Page with Hyperlinks and SymbolsMacrosSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabModule 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration FeaturesIntroductionProject: National Injection Molding Sales AnalysisCreating a Custom ThemeDesigning the User InterfaceSetting Form Control PropertiesSetting ActiveX Control PropertiesStoring User InputWriting Code for a Command ButtonPreparing, Protecting, and Testing WorksheetsSharing and CollaboratingUsing Comments to Annotate a WorksheetComparing WorkbooksFinalizing a WorkbookSetting Internationalization FeaturesSummaryApply Your KnowledgeExtend Your KnowledgeExpand Your WorldIn the LabIndex