Curtis Frye – författare

The quick way to learn popular Microsoft 365 apps!

This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answers—brisk lessons and detailed screenshots show you exactly what to do, step by step.

Discover new time-savers and usability improvements for Word, Excel, PowerPoint, and Outlook Format and organize high-impact documents and use Word's enhanced coauthoring tools Build powerful, reliable Excel worksheets and analyze complex data sets Prepare highly effective presentations with PowerPoint's newest visual tools Improve your productivity with Outlook email, scheduling, and contacts Make the most of the latest Accessibility Checker and other new features Look up just the tasks and lessons you need

Download your Step by Step practice files at: MicrosoftPressStore.com/MSOfficeSBS365/downloads

The quick way to learn Microsoft Excel!

 

This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers—brisk lessons and detailed screenshots show you exactly what to do, step by step.

 

Quickly set up workbooks, enter data, and format it for effective visual impact Perform calculations and find and correct errors Manage, filter, summarize, validate, reorder, and combine data Identify trends, illustrate processes and relationships, and dynamically analyze data Build sophisticated forecasts, key performance indicators (KPIs), and timelines Visualize data with customized charts, 3D maps, and other powerful tools Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query Use powerful Excel Data Models for advanced business intelligence

Develop the Excel skills that you need to produce spreadsheet solutions to your business needs – instantly!

There are an estimated 400 million Excel users, but the majority of them haven’t worked out a way to effectively use Excel VBA (Visual Basic for Applications).

This book is for those that use Excel at work and who want to use the advanced features of Excel but don’t have the time to have extensive training. It takes you through each task (as all Brilliant books do) and describes everything you could want to find out, for example:

- how to use the macro recorder

- how to take that recorded code and turn it into something useful that will really help you day to day

- how to automate reports and design applications

Users will then improve their Excel skills so they can in the end save a lot of time and get more done.

Brilliantguides allow you to find the info you need quickly, easily and without fuss. It guides you through all the tasks using a highly visual, step-by-step approach – providing exactly what you need to know when you need it.

Now in full color!

The quick way to learn Microsoft Excel 2016! This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need

Quick and easy answers to the essentials of Excel, handy enough to keep you working without Internet searches or long videos. Our author and expert Curtis Frye owns a corporate training company specifically for Excel, is also a LinkedIn Learning video author (formerly Lynda.com) and a Microsoft author. The ability to choose what is covered in this reference comes from his vast experience working directly with users. This expertise is streamlined through clear and succinct answers provided to help accomplish tasks. Also includes labeled screen grabs and icons in a color-coded design. Durable and portable, this digital guide can be stored and accessed quickly so you can find what you need fast. Corporations ranging from Ford Motor Company to the FBI have purchased QuickStudy software guides for their employee’s workspace to improve productivity and reduce support calls. Digital guide includes: Main Window New Features The Ribbon Document File Formats Microsoft Accounts Entering & Editing Cell Data Undo & Redo Changes Managing Cells, Rows, Columns & Data Formatting Cell Data Creating Formulas Creating Formulas Using Functions Defining Excel Tables Managing Workbooks & Worksheets Sorting & Filtering Data

Quick and easy answers to the essentials of Excel, handy enough to keep you working without Internet searches or long videos. Our author and expert Curtis Frye owns a corporate training company specifically for Excel, is also a LinkedIn Learning video author (formerly Lynda.com) and a Microsoft author. The ability to choose what is covered in this reference comes from his vast experience working directly with users. This expertise is streamlined through clear and succinct answers provided to help accomplish tasks. Includes labeled screen grabs and icons in a color-coded design. Durable and portable, this digital guide can be stored and accessed quickly so you can find what you need fast. Corporations ranging from Ford Motor Company to the FBI have purchased QuickStudy software guides for their employee’s workspace to improve productivity and reduce support calls. Digital guide includes: Managing ExcelSelecting Cells & Navigating EfficientlySummarizing Data EfficientlyVerifying Data Entry Using Data Validation RulesAuditing FormulasOrganizing Data Using Named Ranges & TablesOptimizing Data DisplayApplying Cell FormatsManaging Lists of ValuesManaging HyperlinksManaging Worksheets & Workbooks

Quick and easy 6-page digital guide focuses on creating and using pivot tables efficiently and effectively in Excel. Whether you are a beginner or experienced user, pivot tables offer flexibility while doubling down on Excel's power. Curtis Frye, author of multiple books on Excel, creator of many LinkedIn Learning videos and an experienced corporate trainer uses his experience and knowledge to cover the most relevant use of pivot tables at different levels of complexity. As a corporate trainer, seeing what beginners need to start using pivot tables and what those with some pivot table skills can do to harness more power brings value to this targeted reference at an unbeatable price. Look for Excel 365 and Excel 365 Tips and Tricks QuickStudy guides to have a solid power-user reference set. 6 page digital guide includes: Introducing PivotTables GlossaryCreating & Pivoting PivotTables Arrange Data for Use in a PivotTableCreate a PivotTable from an Excel Table, Data List or from External DataCreate a Recommended PivotTableRefresh PivotTable Data, Update Cell References that Provide Data to a PivotTablePivot a PivotTable, Defer PivotTable UpdatesManaging PivotTables Show or Hide the Field List, Expand & Contract Buttons, Field HeadersSelect an Entire PivotTable, Move it, Copy a Configuration, Delete a PivotTableSummarizing PivotTable Data Show or Hide Subtotals, Grand TotalsChange the Data Field Summary OperationChange How PivotTable Data Values Are DisplayedSummarize More than One Data FieldCreate, Edit, Delete a Calculated FieldUse PivotTable Data in a FormulaDisplay Data Source RowsCreate an Excel table from a PivotTableSorting & Filtering PivotTable Data Sort a Column of PivotTable Data into Ascending or Descending OrderCustom ListsFilter a PivotTable Field by Selection, Rule, Using a Search FilterSlicersFilter a PivotTable Using Report Filter FieldsCreate Individual PivotTables Using Report Filter ValuesClear a PivotTable Filter Using the Field List PaneClear a Filter Using the Row or Column Labels, Clear All FiltersDefining Sets of Values Define a Set Based on Row Items, on Column ItemsDisplay a Set in the Rows or Columns AreaEdit a Set, Delete a SetFormatting PivotTables Apply a PivotTable StyleApply a PivotTable Style & Remove Existing FormattingApply or Remove Headers & BandingCreate a PivotTable StyleApply a Custom PivotTable StyleChange the Data Field Number FormatChange the PivotTable LayoutControl Whether PivotTable Lables Are Repeated at the Top of Each Printed PageDetermine How to Handle Blank RowsCreating & Manipulating PivotCharts Create a New PivotChart/from an Existing PivotTablePivot a PivotChartFilter a PivotChart by Selection/by RuleApply a Style to a PivotChartChange a PivotChart’s Layout/Chart TypeAdd a Trendline to a PivotChartMove a PivotChart to Another Worksheet/to a Chart SheetApply a Quick Layout to a PivotChartAdd or Remove a PivotChart ElementApply a PivotChart Style, Change the Color SchemeFormat a PivotChart Data Series, Format One Value in a PivotChart Data SeriesAdd an Annotation to a PivotChart, Format a PivotChart AnnotationPrinting PivotTables Print a PivotTable, Print Headers at the Top of Each Printed PagePrint Each Item on Its Own Page, Print a PivotChartEnabling & Adding Tables to the Data Model Create a Relationship between Two TablesCreate a PivotTable Using the Data ModelWork with a PivotTable Created Using the Data ModelEdit a Table Relationship, Deactivate, Activate, Delete a RelationshipFiltering PivotTables Using Timelines Create a TimelineFilter a PivotTable Using a TimelineFormat a TimelineClear a Timeline FilterRemove a Timeline

Quick and easy 6 page digital guide loaded with essential functions and how to perform them in Excel 365 (and Excel 2019). Beginners and experienced users, can find hundreds of the most popular and useful functions fast with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 365, Excel 365 “Tips and Tricks”, “Formulas” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.6 page digital reference guide includes:Conditional FormatsHighlighting RulesData Bar, Color Scale & Icon Set FormatsManaging Conditional FormatsFiler Data Using SlicersWhat-If AnalysisAnalyzing Data Using ScenariosCalculating Alternatives Using Data TablesCalculating Target Values Using Goal SeekFinding Optimal Values Using SolverPivot Tables & Pivot ChartsTimelinesExcel Data ModelData ValidationSparklinesSuggested uses: Workspace – flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use oftenCompany Training – reduce help-desk calls and keep productivity flowing for a team or for your entire companyStudents/Professors – make lives easier for students in many majors needing Excel for data management and calculation

Quick and easy 6 page digital guide loaded with essentials focusing on creating and using formulas efficiently and effectively. For beginners or experienced users, formulas are Excel's superpower that can be yours. Find hundreds of the most popular and useful functions for formulas fast and with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant use of formulas for users at different levels. Look for Excel 365, Excel 365 “Tips and Tricks”, “Advanced” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.6 page digital reference guide includes:Order of OperationsCreating FormulasUsing Tables in FormulasOrganizing Data Using Named RangesSummary & Statistical FunctionsCounting Values in Cell RangesPerforming Financial CalculationsPrincipal & Interest PaymentsCalculating Present & Future ValueCalculating Time to Reach an Investment GoalPerforming Conditional Calculations Using IF & IFERRORLogical ComparisonsError CodesProcessing Text Using FormulasExtracting Text From a CellCleaning Imported DataCombining Multiple Text StringsPerforming Date CalculationsFinding & Displaying Cell Values & Formula TextLook Up Cell ValuesDisplay Formula TextDivision, Decimals & RoundingDividing Values to Find Quotients & RemindersFinding the Integer & Decimal Parts of NumbersRounding Numbers Up & DownGenerating Random ValuesAuditing FormulasSuggested uses: Workplace – flat for easy storage and access at a moments notice to find a formula function you need to use, or to jog your memory for a function you do not use oftenCompany Training – reduce help-desk calls and keep productivity flowing for a team or for your entire companyStudents/Professors – make lives easier for students in many majors needing Excel for data management and calculation

The quick way to learn Microsoft Excel 2019!

This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step.

Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines Visualize data with 3D maps, funnel charts, and other powerful tools  Import, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power Query Build powerful data models and use them in business intelligence  Look up just the tasks and lessons you need