C J Benton

Learn Excel By Example - Updated for Office version 2019 Ready to learn Microsoft Excel(R), but not sure where to start? This user-friendly and practical resource is tailored for beginners and will teach you how to navigate Excel and 30 of the most frequently used formulas & features. Each example includes step-by-step instructions with screenshots. Organized into 3 step-by-step sections, allowing you to grow your knowledge of Excel at your own pace: Exercise Files Included Section 1 - Basic CommandsOpening Excel and the Toolbar (Ribbon)Customizing the Ribbon & Quick Access ToolbarHow to create and save a new spreadsheet The segments of a worksheetPrinting tipsHow to add Headers & Footers to your spreadsheetsSection 2 - Toolbar (Ribbon) Navigation Review of the various Copy, Cut, & Paste optionsFont & number formatting, including currency examples for the British Pound and Euro Inserting chartsConditional formattingSorting & filtering data based on specific criteriaProtecting workbooks & worksheetsSection 3 - FormulasSum (addition), Subtraction, Multiplication, & DivisionAverage, Min, & MaxToday, Now, & NetWorkDaysText, Len, Trim, Concat, & MidThe VLOOKUP with 2 step-by-step examplesIF, SumIF, AverageIF, CountIF, & CountIFS How to create and format a Pivot TableAnd More

Learn Pivot Tables By Example - Updated for 2019 With this practical and to-the-point guide on Pivot Tables and basic Dashboards, you'll develop the skills to build and modify reports with step-by-step examples and screenshots including how to: Organize and summarize data Format & filter Pivot Table resultsCreate Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesUse Slicers, Timelines, and SparklinesRank resultsApply calculated fieldsUse Power Query to create and combine Pivot Table reports from imported files And more In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data: Incorporate Pivot Charts, Sparklines, and performance symbols into your reportingRefresh and protect your Pivot Table data A great resource for: Business Analysts Data AnalystsFinancial Analysts Administrative and Support staff Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features

The VLOOKUP formula made easy This in-depth and practical training guide will walk you through the basic and advanced VLOOKUP functionality in easy to follow step-by-step exercises. Saving you time and allowing you to grow your skill level at your own pace. ****Includes downloadable exercise files****The VLOOKUP and More: The 4-parts of the VLOOKUP explainedPublishing VLOOKUP resultsHow to manage error messages using the IFERROR function with the VLOOKUPWhat is wildcard functionality and how can it help me with my VLOOKUP formulas?How can the INDEX and MATCH functions be used instead of the VLOOKUP? 9 step-by-step exercises with downloadable files, including: How to apply a basic VLOOKUPHow to use the VLOOKUP to Categorize DataHow to use the VLOOKUP to Calculate TotalsHow to apply the VLOOKUP formula across multiple workbooks and worksheetsUsing the IFERROR and VLOOKUP functions together to manage error messages In addition to the above, you will also learn how to troubleshoot and resolve common VLOOKUP errors, saving you hours of frustration: What is causing the #N/A error messageReasons why you may be getting the #REF error messageWhy your VLOOKUP formula was working, but now you're getting the wrong values

Learn the VLOOKUP functionality in 30 minutes or less Updated for Excel(R) 2016 This comprehensive book offers easy to follow examples with screenshots demonstrating how to use the VLOOKUP formula. Organized into 3 step-by-step sections, allowing you to grow your knowledge of the VLOOKUP formula at your own pace: ****Exercise Files Included **** VLOOKUP Basics: What the VLOOKUP formula does The parts of a VLOOKUP formula Detailed examples on how to use the VLOOKUP formula Incorporating the IFERROR functionality into your VLOOKUP formula And when you have more than 30 minutes... How to apply the VLOOKUP formula across multiple worksheets How to apply the VLOOKUP formula across multiple workbooks How to use the VLOOKUP function to look-up and calculate a number based on specific criteria In addition to the above, you will also learn how to troubleshoot and resolve common VLOOKUP errors, saving you hours of frustration Reasons why you may be receiving the #N/A error message Reasons why you may be receiving the #REF error message Reasons why your VLOOKUP formula was working, but now you're getting the wrong values And more... Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features.

In just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide Updated for Excel(R) 2016 this book offers easy to follow examples with screenshots demonstrating how to use the 30 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace: Exercise Files Included In addition to the following, this book also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro . Part 1 - Excel(R) Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY, NOW, & NETWORKDAYS SUMIF, AVERAGEIF, COUNTIF, & COUNTIFS Part 2 - Introduction to Pivot Tables How to create a Pivot Table report Formatting Pivot Table results Adding Pivot Charts Part 3 - Excel(R) Features Data Sorting Conditional Formatting & Filtering Data Validation Text-To-Columns Formula Trace Part 4 - Text Functions LEN & TRIM CONCATE (CONCATENATE) & MID PROPER, UPPER, & LOWER Part 5 - Logic & Lookup Formulas IF AND VLOOKUP Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using Microsoft(R) Excel(R)

Learn Microsoft(R) Word(R) in just a few short hoursThis book is tailored for beginners and will quickly and easily guide you through the most useful features of Microsoft(R) Word(R). All examples include step-by-step instructions with screenshots demonstrating how to: Create professional looking documentsFormat and Highlight TextInsert and Format Tables (including a Table of Contents)Create Bulleted and Numbered ListsInsert Page Breaks, Headers, and FootersUse SmartArt, Shapes, & ScreenshotsUse Watermarks to convey a document is 'Confidential' or in 'Draft' formCreate Mail Merge Form letters Create Mail Merge Mailing labelsMicrosoft(R) Word(R) ShortcutsAnd More Imagine the time you'll save by not having to search the internet or help files to learn the most useful features of Microsoft(R) Word(R)

Learn how to create Pivot Tables quickly and easily with this step-by-step guide Updated for Microsoft(R) Excel(R) 2016 This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards.Version 2019 is now availableOrganize and summarize data Format & filter Pivot Table resultsCreate Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesUse SlicersRank resultsApply calculated fieldsCreate Pivot Table reports from imported filesAnd more In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting.A great resource for: Business Analysts Data AnalystsFinancial Analysts Administrative and Support staffImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features

Master Mail Merge in just a few short hours Mail Merge is a feature within Microsoft(R) Word(R) that allows you to create mass communications in which specific sections can be tailored to individuals or groups. You may utilize existing lists of customer or employee data and can customize the communication medium without having to manually change each correspondence. The Mail Merge feature saves time and reduces the chance of errors occurring when someone must physically type or modify each message.This book is tailored for beginners and will quickly and easily guide you through the Microsoft(R) Word(R) Mail Merge functionality. All examples include step-by-step instructions with screenshots demonstrating how to create Mail Merge Form letters Mailing labelsEmail messagesHow to use Excel(R) as the Data Source to create Mail Merge invoicesImagine the time you'll save by not having to search the internet or help files to learn one of the best features in Microsoft(R) Word(R)

An Excel(R) Macros and VBA book developed for business users Readers will be able to refer back to this book time and time again. Written with little technical jargon and divided into five easy to follow segments. Business users of all types will learn how to automate tasks, improve productivity, and reduce the occurrence of errors in standardized processes.The book begins by providing a foundation on how Macros & VBA (Visual Basic for Applications) work, followed by step-by-step examples on recording and troubleshooting macros. Continuing with how to enhance your code with Looping and Decision Structures. From the easy to the more complex, this book has something to offer all business users.Macro FundamentalsHow to record a macroHow to modify and test macrosHow to utilize the Personal Macro WorkbookHow to use the debugging tools Macro Examples IncludeReport formattingData analysis - Analyzing test resultsImporting and parsing text and .CSV filesMacro to save each worksheet as a separate workbook fileMacros to sort worksheets either alphabetically or numericallyPrinting all worksheets in a workbookDynamic Quarterly and Year-To-Date reporting Intermediate Topics An introduction to Looping with easy to follow examplesHow to incorporate If...Then...Else statementsHow to incorporate Select...Case statementsProtecting macro code Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features.

3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) Step-By-Step Training Guide Series This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft(R) Excel(R) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft(R) Excel(R) at your own pace. In addition to the following, this book bundle also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro . Part 1 - Excel(R) Formula Fundamentals SUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGE MIN & MAX TODAY & NETWORKDAYS SUMIF Part 2 - Pivot Tables & Dashboards Organize and summarize data Format results Insert Pivot Charts Display averages & percentages Group data into predefined ranges Rank results Insert calculated fields How to create and update a basic Dashboard using Pivot Table data Part 3 - Excel(R) Features Data Sorting Formula Trace Text-To-Columns Conditional Formatting & Filtering Part 4 - Text Functions LEN & TRIM CONCATENATE & MID PROPER, UPPER, & LOWER Part 5 - Logic Formulas IF Nested IF Part 6 - The VLOOKUP Formula What the VLOOKUP formula does The parts of a VLOOKUP formula Detailed examples on how to use the VLOOKUP formula Incorporating the IFERROR functionality into your VLOOKUP formula How to apply the VLOOKUP formula across multiple tabs & workbooks How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error

Learn VLOOKUP formulas quickly and easily with this step-by-step guide This comprehensive book offers easy to follow examples with screenshots demonstrating how to use the VLOOKUP formula. The book is organized into 3 step-by-step sections, allowing you to grow your knowledge of the VLOOKUP formula at your own pace.****Excel v2016 and v2019 are now available****VLOOKUP Basics: What the VLOOKUP formula does The parts of a VLOOKUP formulaDetailed examples on how to use the VLOOKUP formula Taking the VLOOKUP Formula to the Next Level: Incorporating the IFERROR functionality into your VLOOKUP formula How to apply the VLOOKUP formula across multiple tabsHow to apply the VLOOKUP formula across multiple workbooks In addition to the above, you will also learn how to troubleshoot and resolve common VLOOKUP errors, saving you hours of frustration Reasons why you may be getting the #N/A error messageReasons why you may be getting the #REF error messageReasons why your VLOOKUP formula was working, but now you're getting the wrong valuesAnd more... Imagine the time you'll save, by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features.Book 3 in The Microsoft Excel Step-By-Step Training Guide Series Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & FeaturesBook 2 - The Step-By-Step Guide To Pivot Tables & Introduction To DashboardsBook 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft ExcelBook 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle

Learn the 25 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace: ****Excel v2016 is now available, with 5 bonus formulas included****Part 1 - Excel(R) Formula FundamentalsSUM, SUBTRACTION, MULTIPLICATION, & DIVISION AVERAGEMIN & MAX TODAY & NETWORKDAYSSUMIF Part 2 - Introduction to Pivot TablesHow to create a basic Pivot TableFormatting Pivot Table resultsInserting Pivot ChartsPart 3 - Excel(R) FeaturesData SortingFormula TraceText-To-ColumnsConditional Formatting & FilteringPart 4 - Text FunctionsLEN & TRIMCONCATENATE & MIDPROPER, UPPER, & LOWERPart 5 - Logic & Lookup FormulasIFNested IFVLOOKUPImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft(R) Excel(R) Book 1 in The Microsoft Excel Step-By-Step Training Guide Series Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & FeaturesBook 2 - The Step-By-Step Guide To Pivot Tables & Introduction To DashboardsBook 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft ExcelBook 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle

Learn how to create Pivot Tables quickly and easily with this step-by-step guide This book contains several basic, intermediate, and advanced Pivot Table examples with screenshots demonstrating how to: Organize and summarize data Format resultsInsert Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesRank resultsInsert calculated fieldsIn addition to the above, you will also learn how to create and update a basic Dashboard using Pivot Table data.A great resource for: Business Analysts Data AnalystsFinancial Analysts Administrative and Support staffImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft(R) Excel(R) Book 2 in The Microsoft Excel Step-By-Step Training Guide Series Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & FeaturesBook 2 - The Step-By-Step Guide To Pivot Tables & Introduction To DashboardsBook 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft ExcelBook 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle