Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro [Video]
Video
Video
$29.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$29.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterGetting Started
-
Excel Productivity Tips
- Introduction
- Customizing the Excel Footer
- Navigating Excel Workbooks with CTRL Shortcuts
- Accessing Excel Ribbon Tools with ALT Key Tips
- Accessing Excel's "Go To" Special Options
- Removing Blank Rows in Excel Worksheets
- Creating Drop-Down Menus in Excel with Data Validation
- Filling in Patterns with Autofill & Flash Fill
- Customizing the Excel Ribbon Tools
- Splitting Text to Columns in Excel
- Synchronous Scrolling Across Multiple Excel Workbooks
- Extracting Unique Values from a List in Excel
- Using Named Range & Table References in Excel Formulas
- Protecting Cells & Formulas in Excel Workbooks
- Multi-Level Row & Column Sorting
- Configuring Advanced Filter Criteria in Excel
-
Excel Formatting Tips
- Introduction
- Excel Formatting Shortcuts
- Snapping Objects to the Excel Grid
- Hiding Excel Workbook Elements
- Replicating Formats & Styles with Excel's Format Painter
- Colour & Border Design Tips in Excel
- Freezing Panes in Excel Worksheets
- Centering Across a Selection
- Creating an "Invisible" Format
- Zip Codes & Phone Numbers
- Grouping Worksheet Columns & Rows
- Formatting Excel Errors with IFERROR
- Converting Excel Text to Dates
- Creating Dynamic Formats with Excel Formulas
- Advanced Excel Number Formats
-
Excel Formula Tips
- Introduction
- Manual vs. Automatic Calculation Modes in Excel
- Adding Line Breaks to Excel Formulas
- Converting Units of Measurement with Excel Formulas
- Building Real-Time Tools with TODAY & NOW Functions
- Excel Formula Auditing Tools
- Designing Pivot-Style Reports with Excel Formulas
- Counting Words in Excel with LEN & SUBSTITUTE Functions
- Configuring Dependent Drop-Down Menus with INDIRECT
- Creating Custom Hyperlinks Between Excel Worksheets
- Using Approximate Match VLOOKUP Functions
- Randomizing a Selection with OFFSET & RANDBETWEEN Functions
- Combining INDEX & MATCH Functions
- Finding Matching Items Across Lists in Excel
- Counting Duplicate Values with SUMPRODUCT
- Using Many-to-Many Lookups in Excel
-
Excel Visualization Tips
- Introduction
- Configuring Excel Chart Properties (Move & Size)
- Managing Hidden Chart Source Data in Excel Worksheets
- Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365)
- Customizing Excel Charts to Tell a Story
- Adding Sparklines to Worksheet Cells
- Designing Custom Chart Templates in Excel
- Building Excel Heat Maps Using Colour Scales
- Analysing Distribution with Histograms
- Goal Pacing with Custom Excel Gauge Charts
- Highlighting Time Periods with Combo Charts
- Configuring Dynamic Chart Source Ranges
- Creating Interactivity with Excel Form Controls
-
Excel Pivot Table Tips
- Introduction
- Customizing the Pivot Table Field List
- Autofitting Column Width in Pivot Tables
- Pivot Table Outline & Tabular Layouts
- Counting Non-Numerical Fields Using Pivots
- Grouping & Ungrouping Dates with Pivot Tables
- Enabling Multiple Pivot Table Filters
- Grouping Values into Buckets with Pivot Tables
- Adding Value Calculations to Pivot Tables
- Configuring Pivot Table Errors & Empty Items
- Configuring Pivot Table Slicers & Timelines
- Advanced Pivot Table Conditional Formatting
- Removing & Reviving Pivot Table Source Data
- Adding Custom Sort Lists in Excel
- Solve Order & List Formula Reports
-
Excel Analytics Tips
- Introduction
- Excel Quick Analysis Tools
- Comparing Outcomes Using the Scenario Manager
- Solving Simple Optimizations with Goal Seek
- Creating Basic Forecasts in Excel
- Building an Outlier Detection Tool in Excel
- Generating Automated Data Tables
- Connecting & Transforming Data with Power Query
- Creating Relational Data Models in Excel
- Accessing the Data Model with CUBE Functions
- Building a Monte Carlo Simulation in Excel
- Advanced Optimization with Solver
- Excel Analysis ToolPak (Preview)
About this
video
This course is not an introduction to Excel. It features some of the most powerful and effective tools and techniques used by Excel professionals, and shares them through crystal-clear demos and unique, real-world case studies.
Unlike most Excel courses, this course is non-linear and constantly evolving, which means that you can jump to different sections or individual lectures freely. Each video is designed to be an independent and self-contained demo, to help you learn these tools and techniques in quick, bite-sized lessons.
The Excel tips and techniques covered in this course fall into six categories:
•Productivity tips (navigation, flash fill, cell protection, advanced sorting & filtering, and more)
•Formatting tips (freeze panes, row/column grouping, advanced custom formats, and more)
•Formula tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, and more)
•Visualization tips (sparklines, filled maps, custom templates, Excel form controls, and more)
•Pivot Table tips (slicers & timelines, custom layouts, value calculations, and more)
•Analytics tips (outlier detection, Monte Carlo simulation, forecasting, CUBE functions, and more)
While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of underlying Excel concepts (such as Pivot Tables or formulas, for example).
The codes are placed in the GitHub link as below-
https://github.com/sanjanapackt/PacktPublishing-Excel-Pro-Tips-75--Tips-to-go-from-Excel-Beginner-to-Pro
- Publication date:
- December 2019
- Publisher
- Packt
- Duration
- 10 hours 32 minutes
- ISBN
- 9781800203709