Excel 2019 in easy steps

This guide provides easy steps to help you get started with Excel 2019, covering creating, editing, manipulating worksheets, formulas, functions, pivot tables, templates, macros, charts, linking workbooks, and using the Excel Online app to share and collaborate on spreadsheets. It also includes adding images and illustrations to impress your colleagues.

\n Format: Paperback / softback
\n Length: 192 pages
\n Publication date: 20 December 2018
\n Publisher: In Easy Steps Limited
\n

Are you looking to master Excel 2019? Look no further! This comprehensive guide will help you get to grips with the latest version of this popular spreadsheet application. Whether you're a seasoned user or a beginner, we've got you covered.

Creating, editing, and manipulating worksheets:

Excel 2019 offers a range of tools to help you create, edit, and manipulate worksheets. You can easily add, delete, and rearrange columns and rows, format cells, and apply conditional formatting to make your data more visually appealing.

Formulas, functions, and pivot tables:

Formulas, functions, and pivot tables are essential tools in Excel 2019 for analyzing and manipulating data. You can use them to perform complex calculations, create dynamic charts, and generate reports.

Handy templates to give you a head start:

Excel 2019 comes with a range of pre-designed templates that can help you get started quickly. These templates cover various industries and tasks, such as financial analysis, project management, and marketing.

Macros for everyday tasks to save time:

Macros are small programs that automate repetitive tasks in Excel. They can save you a lot of time and effort, especially when dealing with large datasets.

Charts to get an overview of your data:

Charts are a powerful tool in Excel 2019 for visualizing your data. You can use them to identify trends, patterns, and outliers, and make informed decisions based on your data.

Linking workbooks for automatic updates:

Excel 2019 allows you to link workbooks together, enabling automatic updates whenever changes are made to one workbook. This is useful for collaborating on projects and keeping your data up-to-date.

Using the Excel Online app to share and collaborate on spreadsheets and workbooks:

The Excel Online app allows you to share and collaborate on spreadsheets and workbooks with others. You can access your files from anywhere, and collaborate with your colleagues in real-time.

Adding images and illustrations to your spreadsheet to impress your colleagues:

Images and illustrations can add visual interest and professionalism to your spreadsheet. You can use them to illustrate data, create charts, and make your spreadsheet more visually appealing.

Whether you're upgrading to Excel 2019 or new to the spreadsheet concept, this guide will help you learn the key features constructively and get more out of Excel 2019. In easy steps, you'll be creating, editing, and manipulating worksheets, using formulas, functions, and pivot tables, creating handy templates, using macros for everyday tasks, creating charts, linking workbooks for automatic updates, using the Excel Online app to share and collaborate on spreadsheets and workbooks, and adding images and illustrations to your spreadsheet. So, what are you waiting for? Start mastering Excel 2019 today!

\n Weight: 438g\n
Dimension: 186 x 225 x 10 (mm)\n
ISBN-13: 9781840788211\n \n