Microsoft Excel Pro Tips Go from Beginner to Advanced Excel
What you’ll learn
Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
Explore 75+ unique tips, tools and case studies that you won’t find in ANY other Excel course, guaranteed
Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support
Master Excel’s powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak
Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
Become an absolute Excel POWER USER
Requirements
Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel)
Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required)
This course is designed for PC users (some tips & tools may not be available for Mac)
Description
This course is designed to transform everyday people into Excel POWER USERS.It’s not about comprehensive, 101-style deep dives into Excel’s core capabilities, or about showing off cheesy, impractical Excel “hacks”. It’s about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.The best part? I’m including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.The Excel tips and techniques covered in this course fall into six core categories:Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)Excel Pivot Table Tips (slicers & timelines, custom layouts, value calculations, etc.)Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.) While the level of difficulty varies considerably, the Excel 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 the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).It’s time to start working smarter, not harder. If you’re looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.Join today and get immediate, lifetime access to the following:10+ hours of high-quality videoDownloadable PDF ebookExcel project files & solutionsExpert-support and Q&A forum30-day money-back guaranteeHappy learning!-Chris (Founder, Maven Analytics)NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)__________Looking for the full business intelligence stack? Search for “Maven Analytics” to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!See why this is one of the TOP-RATED Excel courses on Udemy:”At first I just said to myself, “Wow, Excel is capable of that? It’s amazing!” Then as I continued through the course I told myself “This guy is doing magic!”, and now I feel like I’m capable of doing the same. I’m definitely buying his other Excel courses!”- Judit Bekker”One of the very best Excel classes I’ve taken – great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!”- Ernie Atkins”I’ve been using Excel for over 20 years and consider myself to be an Excel “power user”. As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different — I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!”-Ryan Hughes
Overview
Section 1: Getting Started
Lecture 1 Course Structure & Outline
Lecture 2 READ ME: Important Notes for New Students
Lecture 3 DOWNLOAD: Course Resource Files
Lecture 4 Setting Expectations
Section 2: Excel Productivity Tips
Lecture 5 Introduction
Lecture 6 Customizing the Excel Footer
Lecture 7 Navigating Workbooks with CTRL Shortcuts
Lecture 8 Accessing Ribbon Tools with ALT Key Tips
Lecture 9 Accessing Excel’s “Go To” Special Options
Lecture 10 Removing Blank Rows in Excel Worksheets
Lecture 11 Creating Drop-Down Menus with Data Validation
Lecture 12 Filling Patterns with Autofill & Flash Fill
Lecture 13 Customizing the Excel Ribbon Tools
Lecture 14 Splitting Text to Columns in Excel
Lecture 15 Synchronous Scrolling Across Multiple Workbooks
Lecture 16 Extracting Unique Values from a List in Excel
Lecture 17 Using Named Range & Table References in Excel Formulas
Lecture 18 Protecting Cells & Formulas in Excel Workbooks
Lecture 19 Multi-Level Row & Column Sorting
Lecture 20 Configuring Advanced Filter Criteria in Excel
Section 3: Excel Formatting Tips
Lecture 21 Introduction
Lecture 22 Excel Formatting Shortcuts
Lecture 23 Snapping Objects to the Excel Grid
Lecture 24 Hiding Excel Workbook Elements
Lecture 25 Replicating Formats & Styles with Excel’s Format Painter
Lecture 26 Color & Border Design Tips in Excel
Lecture 27 Freezing Panes in Excel Worksheets
Lecture 28 Centering Across a Selection
Lecture 29 Creating an “Invisible” Format
Lecture 30 Zip Codes & Phone Numbers
Lecture 31 Grouping Worksheet Columns & Rows
Lecture 32 Formatting Excel Errors with IFERROR
Lecture 33 Converting Excel Text to Dates
Lecture 34 Creating Dynamic Formats with Excel Formulas
Lecture 35 Advanced Excel Number Formats
Section 4: Excel Formula Tips
Lecture 36 Introduction
Lecture 37 Manual vs. Automatic Calculation Modes in Excel
Lecture 38 Adding Line Breaks to Excel Formulas
Lecture 39 Converting Units of Measurement with Excel Formulas
Lecture 40 Building Real-Time Tools with TODAY & NOW Functions
Lecture 41 Excel Formula Auditing Tools
Lecture 42 Designing Pivot-Style Reports with Excel Formulas
Lecture 43 Counting Words in Excel with LEN & SUBSTITUTE Functions
Lecture 44 Configuring Dependent Drop-Down Menus with INDIRECT
Lecture 45 Creating Custom Hyperlinks Between Excel Worksheets
Lecture 46 Using Approximate Match VLOOKUP Functions
Lecture 47 Randomizing a Selection with OFFSET & RANDBETWEEN Functions
Lecture 48 Combining INDEX & MATCH Functions
Lecture 49 Finding Matching Items Across Lists in Excel
Lecture 50 Counting Duplicate Values with SUMPRODUCT
Lecture 51 Using Many-to-Many Lookups in Excel
Section 5: Excel Visualization Tips
Lecture 52 Introduction
Lecture 53 Configuring Excel Chart Properties (Move & Size)
Lecture 54 Managing Hidden Chart Source Data in Excel Worksheets
Lecture 55 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365)
Lecture 56 Customizing Excel Charts to Tell a Story
Lecture 57 Adding Sparklines to Worksheet Cells
Lecture 58 Designing Custom Chart Templates in Excel
Lecture 59 Building Excel Heat Maps Using Color Scales
Lecture 60 Analyzing Distribution with Histograms
Lecture 61 Goal Pacing with Custom Excel Gauge Charts
Lecture 62 Highlighting Time Periods with Combo Charts
Lecture 63 Configuring Dynamic Chart Source Ranges
Lecture 64 Creating Interactivity with Excel Form Controls
Section 6: Excel Pivot Table Tips
Lecture 65 Introduction
Lecture 66 Customizing the Pivot Table Field List
Lecture 67 Autofitting Column Width in Pivot Tables
Lecture 68 Pivot Table Outline & Tabular Layouts
Lecture 69 Counting Non-Numerical Fields Using Pivots
Lecture 70 Grouping & Ungrouping Dates with Pivot Tables
Lecture 71 Enabling Multiple Pivot Table Filters
Lecture 72 Grouping Values into Buckets with Pivot Tables
Lecture 73 Adding Value Calculations to Pivot Tables
Lecture 74 Configuring Pivot Table Errors & Empty Items
Lecture 75 Configuring Pivot Table Slicers & Timelines
Lecture 76 Advanced Pivot Table Conditional Formatting
Lecture 77 Removing & Reviving Pivot Table Source Data
Lecture 78 Adding Custom Sort Lists in Excel
Lecture 79 Solve Order & List Formula Reports
Section 7: Excel Analytics Tips
Lecture 80 Introduction
Lecture 81 Excel Quick Analysis Tools
Lecture 82 Comparing Outcomes Using the Scenario Manager
Lecture 83 Solving Simple Optimizations with Goal Seek
Lecture 84 Creating Basic Forecasts in Excel
Lecture 85 Building an Outlier Detection Tool in Excel
Lecture 86 Generating Automated Data Tables
Lecture 87 Connecting & Transforming Data with Power Query
Lecture 88 Creating Relational Data Models in Excel
Lecture 89 Accessing the Data Model with CUBE Functions
Lecture 90 Building a Monte Carlo Simulation in Excel
Lecture 91 Advanced Optimization with Solver
Lecture 92 Excel Analysis ToolPak (Preview)
Section 8: Wrapping Up
Lecture 93 BONUS LESSON
Excel users looking to level-up and master the same tools and techniques used by Excel MVPs,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,Students looking for an engaging, hands-on, and highly interactive approach to Excel training,Anyone looking to pursue a career in data analysis or business intelligence,This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged)
Course Information:
Udemy | English | 10h 31m | 7.10 GB
Created by: Maven Analytics
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com