Cloud Computing Center



book microsoft excel 2019 for beginners and intermediates by jan zitniak for webThe book Microsoft Excel 2019 for beginners and intermediates

The Microsoft Excel 2019 for beginners and intermediates book is a condensed and yet effective manual explaining the functions most commonly used in both the private and corporate sector. It focuses on practices suitable for users wishing to “brush up” on the basics of Excel and to learn about the program up to the intermediate or advanced level.

Download all examples from that book clicking here.

You can purchase Microsoft Excel 2019 for beginners and intermediates book by Jan Zitniak on Amazon clicking here.

In this book for the beginners you find:
-----------------------
Important introductory terms
Description of the Microsoft Excel 2019 environment
Entering data into a worksheet
Entering numerical and test data
Insert a simple formula
Inserting a function
Inserting a simple function
Calculations in the status bar
Cursor types in Excel
Working with data and sheets
Formatting data
Changing the appearance of cell contents
Formatting numbers
Formatting columns, rows and sheets
Copying data
Pasting data
Automatic copying and filling of data
Absolute reference – working with a constant
Moving data
Adding a column and row
Deleting a column and row
Inserting, deleting, renaming and changing the color of a sheet
Locking rows and columns in a table (Freeze Panes)
Printing recurring titles
Scaling
Inserting headers and footers, page numbering
Comments
Data filter
Searching for data
Replacing data

For intermediates you find:
---------------------------
Advanced searching

Sharing a workbook
Sharing a document through a link
Sending a workbook as an attachment

Version history
Restricting entry into cells – protected sheets
Protecting a workbook
Flash fill
Quick analysis
Ideas

Inserting more complex formulas (functions)
Editing function

Mathematical and statistical functions
ROUND, SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS, SUBTOTAL

Search functions
VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE

Text string functions
CONCAT, FIND, FINDB a SEARCH

Date functions
DAYS

Logical functions
IF, AND, OR, IFS, IFERROR

Nesting functions
Converting formulas to values

Formula errors
How to correct the error

Linking data in sheets and workbooks
Tip for quick summing
How to use a value in another workbook

Viewing data flow in a sheet
Trace Precedents
Trace Dependents

What a chart is
Chart description
Creating a chart
Design
Format
Chart actions
Move chart
Resize chart
Aditional changes in chart

Conditional formatting
Rule types
Finding duplicates
Top and last N items
Managing rules

Formatted tables
Adding a row
Adding a column and a calculation to a column
Removing a row or column
Inserting a formula

Pivot table
How to create a pivot table
Grouping dates
Updating pivot table data
Changing source data
Changing functions in a pivot table – sum to average, count, maximum, minimum and more
Displaying values in a pivot table as a calculation
Filter data
Visual data filter - slicers
Timeline
Formatting slicers and timelines
Removing slicers and timelines
Pivot chart
Dashboard

--------------------------------------------------
Practical tips and examples + examples to download.

Prihlásenie

About Jan Zitniak

Jan ZitniakFor over 11 years Jan Zitniak has been a professional instructor concentrating on Microsoft Office. He holds an international Microsoft Excel – Office Excel ® 2010 Expert certificate and has written several books discussing Microsoft Office.

book microsoft excel 2019 for beginners and intermediates by jan zitniak for web

I'm author of Microsoft Excel 2019 for beginners and intermediates book.

The information mentioned in the book comes from practical experience he obtained at such large companies as T-Systems, BSH Bosch and Siemens, Veolia, Magneti Marelli, Coavis, National Bank of Slovakia and many others.

If you like my website you can support me by buying my book on Amazon clicking here.

Príručka Microsoft Word, Excel, PowerPoint zadarmo na stiahnutie

Certifikáty

banner-kontakt-janzitniak-ponuka-pocitacovych-kurzov