LGHRINI - Microsoft Excel 2019 In 1 DAY: for beginners

Microsoft Excel 2019 In 1 DAY: for beginners — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Microsoft Excel 2019 In 1 DAY: for beginners" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

1234567...30

Microsoft O ffi ce EXCEL 2019 IN 1 DAY

AYOUB LGHRINI Section 3: Excel

Technical requirements Introducing the interface and setting options 7Identifying rows, columns, and cells 7Workbooks and worksheets 9Name Box and Formula Bar 11Status bar 12Setting view options 12Using the help facility 14Proofing tools 15Changing default options 16Changing the default username 16Changing the default documentlocation 17Changing the default number of workbooks 17Saving automatically

Aligning text 26Changing text orientation 26Wrapping text 27Merging cells 28Hiding and showing rows and columns 29Inserting and deleting rows and columns 30Setting column widths and row heights 32Using the Format Painter 32Creating and applying cell styles 34Applying number formats 34 Working with worksheets and sheet tabs Inserting worksheets 36Deleting worksheets 36

Renaming worksheets 40Applying coloring to worksheet tabs 41 Sorting and filtering data 42Finding and replacing data 42Sorting ascending or descending 43Filtering data 44Defining a filter 44Applying a filter 45Removing a filter 46Applying conditional formatting 46Icon sets, data bars, and color scales 47 Setting print options 49Adjusting breaks in the worksheet 51 Inserting manual breaks into the worksheet

Setting the worksheet scale 56Checking the paper size 57Setting page margins 57Aligning data horizontally and vertically 58Printing a single worksheet 58Printing selected worksheets 59 Creating charts based on worksheet data 59Plotting non-contiguous data 60Selecting a chart 62Resizing a chart 63Changing chart placement 64Changing the chart type

Changing the chart and axis titles Displaying gridlines 68Displaying the legend 69Adding data labels 70Adding a data table 70Deleting a data series 70Adding a data series 71Changing the chart scale 71Formatting the chart background 72Adding objects to a chart 74Using the sunburst chart type 75Using funnel charts 75 Summary

Chapter 9: Applying Formulas and Functions
Technical requirements
Learning basic formula operations
Order of evaluation 8
Constructing a formula
Learning Excel functions
Using the Show Formulas command
Converting values and percentage increase
Working out the percentage change
Working out a percentage increase or decrease
Percentage increase
Percentage decrease
Getting results using the status bar
Using the Function Library
Using the formula composer (Insert Function icon)
Editing formulas
Understanding relative versus absolute
Applying dates in calculations0
To insert the current date
To insert the current date and time
To separate the day from a date
To calculate the number of days, years, and months between two dates
Using mathematical functions A0 3
The INT and ROUND functions
The ROUNDUP and ROUNDDOWN functions
The SUMIF function
Using the COUNTIF statistical function
Using financial functions - PMT7
Applying conditional logic in a formula9
The IF function
The AND function

The OR function 116 Using text functions7 The CONCAT function

The TRIM function 118 Investigating formula errors9
Applying named ranges in a formula 2
Defining a named range 3
Naming a range of cells
Editing a named range
Creating a named range from selected cells
Using range names in a formula
Summary 9

Chapter 10: Analyzing and Organizing Data 0
Technical requirements 1
Consolidating data and investigating macros 1

Creating a summary sheet
Creating a macro
Adding a macro to the ribbon for easy access
Adding a macro to the QAT
Adding the macro to the ribbon tab
Removing a macro from the personal macro workbook
Creating and managing PivotTables and PivotCharts
Creating a PivotTable
Adding PivotTable fields
Grouping with PivotTables
Using slicers and timelines
Creating a PivotChart in Excel
Working with the 3D Maps feature
Using tools for analysis in Excel 165Analysis ToolPak 166What-if analysis 169 Understanding data models Summary

Section 1: Excel

Excel 2019 is a very powerful application with most audiences only using a small fraction of its capability. In this part of the book, you will learn how to navigate around the interface, creating, formatting, and manipulating data. The heart of Excel 2019 is the ability to calculate and analyze data, which you will master through this part of the book. You will be introduced to new and improved functions, namelyCONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN; and learn how to visualize and analyze data and create data models.

In this section, we will cover the following chapters:

Chapter 1 , Formatting, Manipulating, and Presenting Data Visually Chapter 2 , Applying Formulas and Functions
Chapter 3 , Analyzing and Organizing Data

Formatting, Manipulating, and Presenting Data Visually

In this chapter, you will be shown how to personalize the Backstage view, set various spreadsheet options, and also distinguish between spreadsheet elements. You will be taken on a journey, through formatting elements to manipulating data, and will also learn to print elements and set print options.

You can enhance Excel 2019 with decorative, professional-looking charts such as Sunburst and Funnel charts. You will gain all the skills you need to format, print, and present data professionally.

The following list of topics will be covered in this chapter:

Introducing the interface and setting options
Constructing and formatting an Excel worksheet
Working with worksheets and sheet tabs
Sorting and filtering data
Setting print options
Creating charts based on worksheet data

Introducing the interface and setting options

This topic will highlight the important elements that make up the Excel 2019 visual environment. You will be able to identify parts of the Excel 2019 application as a whole, set view zoom options, and explore the View tab. We will explore the help facility and some Review elements (such as Accessibility , Translate , and Smart Lookup ), as well as set customization options.

Microsoft Excel is an example of a spreadsheet program. Other types of spreadsheets are availablefor example, Calc from OpenOffice, and Sheets from Google Docs. A spreadsheet is used to perform mathematical calculations and financial decision makingfor example, for budgets, company reports, wage sheets, cash flowsto analyze data, and for graphical representation of data. You can process, summarize, sort, extract, analyze, and store information using a spreadsheet.

Identifying rows, columns, and cells

You work with rows and columns when using a spreadsheet program. The maximum number of rows and columns offered in a single worksheet in Excel 2019 is the following:

The Excel document window consists of the following:

Rows that are numbered vertically from to 1,048,576 on each sheet Columns marked horizontally from A-Z, AA-ZZ, up to XFD16,384 columns on each sheet
An example of a row and a column is provided in the following screenshot:

The number of columns displayed when viewing a worksheet on the screen depends on the column widths and computer screen size. You may need to scroll either to left or right to see anything that cannot fit into the screen display.

To view the number of columns and rows resident on a worksheet, proceed as follows:

Click on the Select All icon with the left mouse button and hold the mouse depressed to see the column and row indicators in the Name Box area, as illustrated in the following screenshot:

Next page

1234567...30

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «Microsoft Excel 2019 In 1 DAY: for beginners»

Look at similar books to Microsoft Excel 2019 In 1 DAY: for beginners. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

24 Excel MVPs

Excel Insights: A Microsoft MVP guide to the best parts of Excel

Abbey

MY EXCEL GUIDE; Beginners, Intermediate, Advanced : Microsoft Excel

Steven Jones

Excel: The Complete User’s Guide To Microsoft Excel; How To Become An Excel Expert In No Time! (Excel, Microsoft Office, Excel Shortcuts)

Humphrey

Excel 2019 PivotTables: Easy Excel Essentials 2019, #1

Noreen Brown

Beginning Excel 2019

JORDAN

EXCEL 2021 FOR BEGINNERS: THE COMPLETE DUMMY TO EXPERT PRACTICAL GUIDE WITH EXAMPLES THAT TEACHES EVERYTHING YOU NEED TO KNOW ABOUT MICROSOFT EXCEL 2021 (FORMULAS, FUNCTIONS, VBA & MACROS INCLUSIVE)

Korol

Microsoft Excel 2016: programming by example: with VBA, XML and ASP

Benton

2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide

Phuong Hoang

Microsoft Excel 2019 for Beginners Tips and Tricks in easy steps

Cane

Excel 2019: 3 in 1: Beginners Guide + Formulas and Functions + Advanced Methods to Learn Excel

Thanh Tran

Excel data analysis by examples: Excel data analysis for complete beginners, Step-By-Step Illustrated Guide to Mastering Excel data analysis (Excel advance Book 1)

Gerard Strong

How to Use Microsoft Excel 2010

Discussion, reviews of the book Microsoft Excel 2019 In 1 DAY: for beginners and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.