Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
The Complete Excel Guide: Beginners to Advanced
The Complete Excel Guide: Beginners to Advanced

The Complete Excel Guide: Beginners to Advanced: Increase your daily productivity by becoming an expert in Microsoft Excel 2019

Arrow left icon
Profile Icon Simon Sez IT
Arrow right icon
€8.99 €37.99
Video May 2021 15hrs 35mins 1st Edition
Video
€8.99 €37.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Simon Sez IT
Arrow right icon
€8.99 €37.99
Video May 2021 15hrs 35mins 1st Edition
Video
€8.99 €37.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€8.99 €37.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Gain a solid understanding of Microsoft Excel 2019
  • Uncover amazing Microsoft Excel suite techniques and shortcuts to make your job easy
  • Learn how to add life to your Excel spreadsheets by creating stunning charts and graphs

Description

Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities. We’ll start with the basic topics and see what’s new in Excel 2019. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. We’ll also cover some advanced charts such as Surface, Radar, Bubble, and Stock Charts. By the end of this course, you’ll become proficient in using Microsoft Excel for your professional and personal needs. All the resources for this course are available at https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced

Who is this book for?

This course is designed for anyone who is interested in mastering Microsoft Excel 2019 and becoming an expert in Microsoft Excel. To get started with this course, you need to have basic computer skills and Microsoft Office installed on your computer.

What you will learn

  • Grasp techniques to back up and recover your Excel spreadsheets
  • Discover the essentials of using formulas and functions in Excel
  • Discover what's new or different in Excel 2019
  • Learn to effectively use autofill and flashfill
  • Discover how to create stunning charts and graphs in Excel
  • Learn practical methods to sort and filter your data in Excel

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 27, 2021
Length: 15hrs 35mins
Edition : 1st
Language : English
ISBN-13 : 9781801075763
Category :
Tools :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : May 27, 2021
Length: 15hrs 35mins
Edition : 1st
Language : English
ISBN-13 : 9781801075763
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total €26.97 €95.97 €69.00 saved
The Complete Excel Guide: Beginners to Advanced
€8.99 €37.99
VBA Automation for Excel 2019 Cookbook
€35.99
Learn Python Programming, 3rd edition
€35.99
Total €26.97€95.97 €69.00 saved Stars icon
Banner background image

Table of Contents

36 Chapters
Excel 2019: Introduction Chevron down icon Chevron up icon
Excel 2019 Beginner: Creating Workbooks Chevron down icon Chevron up icon
Excel 2019 Beginner: Saving Workbooks Chevron down icon Chevron up icon
Excel 2019 Beginner: Navigating Workbooks Chevron down icon Chevron up icon
Excel 2019 Beginner: Page Setup and Print Options Chevron down icon Chevron up icon
Excel 2019 Beginners: Working with Rows, Columns, and Cells Chevron down icon Chevron up icon
Excel 2019 Beginners: Moving Data Chevron down icon Chevron up icon
Excel 2019 Beginners: Formulas and Functions Chevron down icon Chevron up icon
Excel 2019 Beginners: Working with Sheets Chevron down icon Chevron up icon
Excel 2019 Beginners: Formatting Worksheets Chevron down icon Chevron up icon
Excel 2019 Beginners: Charts Chevron down icon Chevron up icon
Excel 2019 Beginners: Working with Names Chevron down icon Chevron up icon
Excel 2019 Beginners: Sorting and Filtering Chevron down icon Chevron up icon
Excel 2019 Beginners: Outlining and Subtotaling Chevron down icon Chevron up icon
Excel 2019 Beginners: Working with Views Chevron down icon Chevron up icon
Excel 2019 Beginners: Linking Files Chevron down icon Chevron up icon
Excel 2019 Beginners: Advanced Formula Creation Chevron down icon Chevron up icon
Excel 2019 Beginners: PivotTables Chevron down icon Chevron up icon
Excel 2019 Beginners: Additional Excel Features Chevron down icon Chevron up icon
Excel 2019 Beginners: Shortcuts Chevron down icon Chevron up icon
Excel 2019 Beginners: Closing Chevron down icon Chevron up icon
Excel 2019 Advanced: Introduction to Advanced Course Chevron down icon Chevron up icon
Excel 2019 Advanced: Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Date and Time Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Text Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Logical Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Lookup Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Financial Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Statistical Functions Chevron down icon Chevron up icon
Excel 2019 Advanced: Connecting to External Data Chevron down icon Chevron up icon
Excel 2019 Advanced: Tables Chevron down icon Chevron up icon
Excel 2019 Advanced: PivotTables Chevron down icon Chevron up icon
Excel 2019 Advanced: Data Analysis Chevron down icon Chevron up icon
Excel 2019 Advanced: Graphs and Charts Chevron down icon Chevron up icon
Excel 2019 Advanced: Excel Web App Chevron down icon Chevron up icon
Excel 2019 Advanced: Course Conclusion Chevron down icon Chevron up icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.