Training: Excel 2019 for Windows

Excel 2019 is the spreadsheet

In Excel 2019, it

Excel contains a number of features

Formatting data makes it easier to

An Excel 2019 worksheet can contain

The power of Excel 2019 is the

Excel 2019 enables you to easily

To customize data, you can use the built-in formats in Excel 2019, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

Excel 2019 includes a number of

• The first step in analyzing the data in a worksheet is often

• with Excel's sorting and filtering tools. These tools help you to
• control what is displayed in your data range, and how the values
• are organized. See how to perform basic and more advanced sort
• operations, filter data using the Filter and column header tools,
• and manage color-tagged and duplicate entries.

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, and formula auditing in Excel 2019.

Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel 2019.

Analyze and present your data in a visually attractive manner in Excel 2019. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

Excel offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts.

Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data as well as change its appearance and formatting.

Excel includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables, sort, filter, and group data, and work with slicers and timelines.

Once your Excel PivotTables have been created you'll need to know how to manage and work with the data contained within. See how to analyze, calculate, collaborate and more with Excel PivotTables.

Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

There is a wide variety of tools that can be used to retrieve, return, and calculate data in Excel. See how to retrieve date information and rank values, retrieve, combine and separate data that is already available, and automate and simplify calculations using look-up tools and SUMPRODUCT.

Get more out of Excel by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar.

Excel offers a set of tools that allows you explore more in detail data analysis and complex formulae. If you need to work with data from other sources, you can import and edit data from a text and a .csv file.

In this course you'll see how to use different formulae to make calculations when you have multiple conditions imposed. You'll also be able to forecast data using the NPER function.

With complex formulae you can run calculations to discover the average numbers or the smallest or largest values depending on a settle of conditions, for example.

• If you have tasks in Excel 2019 that you do repeatedly, you can

• record a macro to automate those tasks. When you create a macro,
• you are recording your mouse clicks and keystrokes. After you
• create a macro, you can edit it to make minor changes to the way it
• works. Key concepts covered in this 10-video course include how to
• record macros and perform actions that can be implemented in Excel
• workbooks, how to save a workbook with macros and an Excel
• macro-enabled workbook, how to find and use macro tools that are
• available in multiple locations, and how to add macro recording to
• your status bar for easy access. Then learn how to navigate the VBA
• Editor interface, an application easily accessible via Excel, to
• manage your macros and workbook VBA code; how to manage macros,
• edit macros, and enable macros in a workbook; and how to access
• macro security settings and manage macro security options. Finally,
• you will observe how to use macros across multiple workbooks.

In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.

In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users.

Excel 2019 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others.