DOWNLOAD
Description
Product Description
This 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.
The steps outlined in this book (unless otherwise mentioned) also apply to Excel 2007, 2010, 2013, 2016 and 365, and come from the author's many years as a certified Microsoft Office Excel® Expert instructing at both smaller firms and at larger, transnational companies.
For 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
--------------------------------------------------
Practical tips and examples.
The steps outlined in this book (unless otherwise mentioned) also apply to Excel 2007, 2010, 2013, 2016 and 365, and come from the author's many years as a certified Microsoft Office Excel® Expert instructing at both smaller firms and at larger, transnational companies.
For 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
--------------------------------------------------
Practical tips and examples.
About the Author
For 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.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.
Features & details
Product Details
- Publication date: December 3, 2018
- Publisher: IT Education
- Language: English
- ASIN: B07L42GTBQ
- Amazon.com Sales Rank: 966699
About the author
Follow the author to get new release updates and improved recommendations.
Jan Zitniak
For 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.
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.
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.
Hi, I'm Mr KING Admin of KINGEXCEL.INFO .Thank you so much and I hope you will have an interesting time with KINGEXCEL.INFO. Mail: quantriexcel@gmail.com - PHONE : +84779313987.