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
Excel Essentials
Excel Essentials

Excel Essentials: Master Data Analysis and Advanced Formatting in Excel

Arrow left icon
Profile Icon Skillshub Ltd
Arrow right icon
AU$137.99
Video Sep 2024 1hr 21mins 1st Edition
Video
AU$137.99
Subscription
Free Trial
Renews at AU$24.99p/m
Arrow left icon
Profile Icon Skillshub Ltd
Arrow right icon
AU$137.99
Video Sep 2024 1hr 21mins 1st Edition
Video
AU$137.99
Subscription
Free Trial
Renews at AU$24.99p/m
Video
AU$137.99
Subscription
Free Trial
Renews at AU$24.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

  • Comprehensive coverage of Excel data analysis and formatting
  • Techniques for efficient workbook and worksheet management
  • Hands-on exercises to reinforce learning and ensure practical application

Description

Dive into Excel Essentials and transform your data analysis skills. Starting with Conditional Formatting, you will learn how to highlight key data points, manage rules, and visualize data with color scales and icon sets. The course then explores advanced filtering techniques, including text, number, and date filters, ensuring you can quickly sift through large datasets. Learn to remove duplicates, outline data, and find unique values, enhancing your data accuracy and presentation. Progressing to sorting techniques, you’ll discover how to organize data by various criteria, use custom sort orders, and even randomize lists. The course also covers essential cell formatting, including merging cells, wrapping text, and adjusting decimal places for precise data presentation. Printing essentials such as setting page breaks and formatting print areas are also detailed, ensuring your spreadsheets are print-ready. In workbook management, you’ll master the ribbon, protect your files with passwords, and safeguard specific sheets and cells from unauthorized changes. Learn to use the Quick Access Toolbar, understand workbook themes, and recover unsaved work. The final sections focus on worksheets, covering viewing multiple sheets, spell checking, freezing panes, and consolidating data across sheets for comprehensive data management.

Who is this book for?

This course is designed for professionals and students who have a basic understanding of Excel and want to advance their skills. Prerequisites include familiarity with basic Excel operations such as entering data, using simple formulas, and basic navigation of the Excel interface.

What you will learn

  • Apply conditional formatting to enhance data visualization
  • Use advanced filters to refine data selection
  • Sort and organize data using various criteria
  • Format cells for better data presentation
  • Protect and manage workbooks and worksheets
  • Consolidate data from multiple sheets effectively

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 03, 2024
Length: 1hr 21mins
Edition : 1st
Language : English
ISBN-13 : 9781836646297
Category :
Concepts :
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 : Sep 03, 2024
Length: 1hr 21mins
Edition : 1st
Language : English
ISBN-13 : 9781836646297
Category :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
AU$24.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
AU$249.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 AU$5 each
Feature tick icon Exclusive print discounts
AU$349.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 AU$5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total AU$ 151.98
Practical Data Analysis
AU$75.99
Python Data Analysis
AU$75.99
Total AU$ 151.98 Stars icon

Table of Contents

10 Chapters
Data Analysis - Conditional Formatting Chevron down icon Chevron up icon
Data Analysis - Filter Chevron down icon Chevron up icon
Data Analysis - Sort Chevron down icon Chevron up icon
Essentials - Find & Select Chevron down icon Chevron up icon
Essentials - Formatting Cells Chevron down icon Chevron up icon
Essentials - Print Chevron down icon Chevron up icon
Essentials - Protect Chevron down icon Chevron up icon
Essentials - Ribbon Chevron down icon Chevron up icon
Essentials - Workbooks Chevron down icon Chevron up icon
Essentials - Worksheets 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.