The Premium A to Z Microsoft Excel Bundle Ft

The Premium A to Z Microsoft Excel Bundle FtThe Premium A to Z Microsoft Excel Bundle Ft. Alan Jarvis & Chris Dutton.

Decode the True Power of Excel! Get Lifetime Access to 43 Hours of Basic to Advanced Instruction on Functions, Formula, Tools & More from Top Instructor Alan Jarvis.

What’s Included.

Product Details.

Excel Pro Tips: Productivity Tools.

Save Time & Get More Done with Excel’s Most Powerful Productivity Tools.

Description Instructor Specs.

The Excel Pro Tips: Productivity Tools course will improve your current productivity. This 2-hour course will cover a range of topics to help you save time and work more efficiently, including keyboard shortcuts, autofill and flash fill, data validation, cell protection, named ranges, multi-level sorting, advanced filters, and much more. By the end of this course, you’ll be ready to supercharge your productivity and absolutely revolutionize your Excel workflow.

63,046 positive reviews from 248,923 students.

Access 21 lectures & 1 hour of content 24/7 Learn & practice Excel’s productivity tools using keyboard shortcuts, autofill & flash fill, and data validation Easily sort your data using cell protection, named ranges, multi-level storing, advanced filters & more Supercharge your productivity & improve your Excel workflow.

Note: Software NOT included.

«I must say that I was extremely impressed with how well the course was presented. I was pleasantly surprised to see just how much was covered in this one course by an exceptional instructor. » – Daulton Brent Cotten.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Microsoft Excel 2007-2019 or Office 365 recommended Designed for Windows users (some tools may not be available for Mac)

Course Outline.

Getting Started Course Structure & Outline — 1:41 DOWNLOAD: Course Resources Setting Expectations — 1:45 Productivity Tips Introduction — 0:29 Customizing the Footer — 4:03 CTRL Shortcuts — 8:01 ALT Key Tips — 6:53 «Go To» Special Options — 4:36 Removing Blank Rows — 3:17 Data Validation Drop-Downs — 7:11 Autofill & Flash Fill — 8:26 Customizing the Ribbon — 6:53 Splitting Text to Columns — 7:39 Synchronous Scrolling — 2:58 Extracting Unique Values — 4:06 Named Range & Table References — 8:12 Protecting Cells & Formulas — 8:09 Multi-Level Row & Column Sorting — 10:54 Advanced Filter Criteria — 9:27 QUIZ: Productivity Tips Wrapping Up Resources & Next Steps.

Excel Pro Tips: Data Visualization.

Think Outside the Pie Chart & Explore Some of Excel’s Most Powerful Visualization Tools.

Description Instructor Specs.

This Excel Data Visualization course is all about bringing data to life, using some of Excel’s most powerful visualization tools. The 18 lectures of this course won’t be talking about your basic pie charts and line graphs. You will be introduced to Excel’s unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more. If you want to create clear and effective charts and graphs and interactive reports and dashboards, this course is for you.

63,046 positive reviews from 248,923 students.

Access 18 lectures & 1 hour of content 24/7 Explore Excel’s most powerful visualization tools Know about Excel’s unique features like filled maps, sparklines, custom templates. dynamic visuals, interactive form controls & more Create clear & effective charts and graphs as well as interactive reports and dashboards Note: Software NOT included.

«Yes, it was a good match for me. I enjoyed being able to practice applying what I was learning on the spreadsheets provided and that I had the ability to go at my own pace replaying sections if needed.» – Jodi Ming.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Microsoft Excel 2007-2019 or Office 365 recommended Designed for Windows users (some tools may not be available for Mac)

Course Outline.

Getting Started Course Structure & Outline — 1:41 DOWNLOAD: Course Resources Setting Expectations — 1:45 Visualization Tips Introduction — 0:24 Chart Properties (Move & Size) — 5:08 Hidden Chart Source Data — 2:43 Filled Maps (Excel 2016+) — 5:10 Customizing Charts to Tell a Story — 8:53 Adding Sparklines — 7:44 Custom Chart Templates — 6:06 Heat Maps with Color Scales — 7:11 Analyzing Distribution with Histograms — 9:28 Goal Pacing with Gauge Charts — 10:26 Highlighting Time Periods — 8:05 Dynamic Source Ranges — 12:08 Interactive Form Controls — 11:48 QUIZ: Visualization Tips Wrapping Up Resources & Next Steps.

Excel Pro Tips: PivotTables.

Explore & Analyze Your Data with Advanced PivotTable Tools and Techniques.

Description Instructor Specs.

This Excel Pro Tips: PivotTables course will be focusing on one of Excel’s most powerful and flexible analytic tools—PivotTables. The 1-hour course will start with some common topics like slicers, table layouts, and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from a cache, defining custom sort lists, and more. This course will help you work smarter and not harder. By the end of this course, you’ll be ready to slice, dice, and filter your data like a PivotTable pro.

63,046 positive reviews from 248,923 students.

Access 20 lectures & 1 hour of content 24/7 Understand the use of Excel slicers, table layouts & field list options Learn grouping values, enabling multiple filters, reviving source data from the cache, defining custom sort lists & more Slice, dice & filter data like a PivotTable pro Practice & master PivotTables techniques used by professionals Note: Software NOT included.

«Everything you need to get started using Excel pivot tables (a little bit of pivot charts as well). The amount of content and pacing was perfect for me. The real gem is the last session where you use what you learned. » – Craig Day.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Microsoft Excel 2007-2019 or Office 365 recommended Designed for Windows users (some tools may not be available for Mac)

Course Outline.

Getting Started Course Structure & Outline — 1:41 DOWNLOAD: Course Resources Setting Expectations — 1:45 PivotTable Tips Introduction — 0:18 Customizing the Field List — 4:07 Autofitting Column Width — 4:21 Outline & Tabular Layouts — 7:46 Counting Non-Numerical Fields — 6:05 Grouping Dates — 8:03 Enabling Multiple Filters — 5:00 Grouping Values — 6:50 Adding Value Calculations — 9:01 Showing Empty Items — 6:22 Configuring Slicers & Timelines — 10:23 Conditional Formatting — 8:23 Removing & Reviving Source Data — 8:19 Adding Custom Sort Lists — 5:23 Solve Order & List Formulas — 6:16 QUIZ: PivotTable Tips Wrapping Up Resources & Next Steps.

Microsoft Excel: Advanced Formulas & Functions.

Master 75+ Excel Formula & Functions with Hands-On Demos.

Description Instructor Specs.

It’s time to show Excel who’s boss! Whether you’re starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you’ll learn why these formulas are awesome and how they can be applied in a number of ways.

63,046 positive reviews from 248,923 students.

Access 103 lectures & 6 hours of content 24/7 Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data Go rogue & design your own formula-based formatting rules Join datasets from multiple sources in seconds w/ lookup, index, & match functions Pull real-time data from APIs directly into Excel Manipulate dates, times, text, & arrays Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel.

Note: Software NOT included.

«In general the course is well organized in my opinion, the topics bring together all the necessary functions, and if one has willingness to learn deeper after the course all the other alternative functions will be quite easy to understand and apply.» – Abuzar Talibov.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Microsoft Excel 2007 — 2019 or Office 365 (Some features may not be available in earlier versions)

Course Outline.

Getting Started Course Structure & Outline — 1:28 Downloading the Homework Exercises — 1:42 Setting Expectations — 3:36 Excel Formulas 101 Introduction — 1:06 The Formula Library & Auditing Tools — 4:37 DEMO: Evaluate Formula — 1:25 Basic Formula Syntax — 3:31 Fixed & Relative Cell References — 4:57 Common Errors & IFERROR — 7:25 Function, CTRL & ALT Shortcuts — 6:36 BONUS: Mac Shortcuts — 2:08 Data Validation Rules — 3:28 Fixed vs. Volatile Functions — 3:21 QUIZ: Formulas 101 HOMEWORK: Formulas 101 — 0:46 Conditional Statements & Logical Operators Introduction — 1:23 Anatomy of the IF Statement — 4:01 Nested IF Statements — 4:53 AND/OR Operators — 8:47 NOT (<>) Operators — 3:17 Addressing Errors with IFERROR — 4:03 Common IS Statements — 4:00 QUIZ: Conditional Statements & Logical Operators HOMEWORK: Conditional Statements & Logical Operators — 0:44 Statistical Functions Introduction — 1:12 Basic Stats Functions — 5:17 SMALL/LARGE & RANK/PERCENTRANK — 6:19 RAND() & RANDBETWEEN — 2:12 The SUMPRODUCT Function — 3:55 COUNTIFS/SUMIFS/AVERAGEIFS — 4:49 DEMO: Basic Dashboards with Stats Functions — 8:09 QUIZ: Statistical Functions HOMEWORK: Statistical Functions — 0:35 Lookup & Reference Functions Introduction — 1:23 Named Arrays — 3:30 ROW/ROWS & COLUMN/COLUMNS — 3:18 VLOOKUP & HLOOKUP — 5:54 DEMO: Joining Data with VLOOKUP — 6:23 Combining IFERROR & VLOOKUP — 4:30 VLOOKUP Range Options — 6:18 The INDEX Function — 1:59 The MATCH Function — 2:32 Combining INDEX & MATCH — 6:08 Combining MATCH & VLOOKUP — 4:47 UPDATE: VLOOKUP Correction — 5:05 The OFFSET Function — 2:05 Combining OFFSET & COUNTA — 2:58 DEMO: Building a Scrolling Chart with OFFSET — 9:51 QUIZ: Lookup & Reference Functions HOMEWORK: Lookup & Reference Functions — 0:54 Text Functions Introduction — 0:57 UPPER, LOWER, PROPER & TRIM — 3:32 CONCATENATE (&) — 3:26 LEFT, MID, RIGHT & LEN — 3:31 TEXT & VALUE — 4:20 SEARCH & FIND — 5:04 Categorizing Data with IF(ISNUMBER(SEARCH)) — 5:39 Combining RIGHT, LEN & SEARCH — 5:43 The SUBSTITUTE Function — 2:21 QUIZ: Text Functions HOMEWORK: Text Functions — 0:59 Date & Time Functions Introduction — 2:13 Understanding DATEVALUE — 5:05 Date Formatting & Fill Series — 3:39 TODAY() & NOW() — 2:16 YEAR/MONTH/DAY & HOUR/MINUTE/SECOND — 3:04 The EOMONTH Function — 6:17 The YEARFRAC Function — 2:27 WEEKDAY, WORKDAY & NETWORKDAYS — 7:24 The DATEDIF Function — 4:23 DEMO: Budget Pacing Tool — 11:07 QUIZ: Date & Time Functions HOMEWORK: Date & Time Functions — 0:35 Formula-Based Formatting Introduction — 1:30 Creating and Managing Formula-Based Rules — 4:39 DEMO: Highlighting Rows with MOD — 3:50 DEMO: Formatting Cells Based on Values — 3:29 DEMO: Formatting Cells with Stats Functions — 5:28 DEMO: Formatting Cells with Text & Conditional Functions — 5:08 QUIZ: Formula-Based Formatting HOMEWORK: Formula-Based Formatting — 0:34 Basic Array Formulas Introduction — 1:26 Rules of Array Formulas — 3:24 Pros & Cons of Array Formulas — 2:15 Vertical, Horizontal & 2-D Array Constants — 6:26 Using Array Constants in Formulas — 3:38 Named Array Constants — 4:31 The TRANSPOSE Function — 4:21 Linking Data: Array vs. Non-Array Comparison — 2:36 DEMO: Returning the «X» Largest Values — 3:09 DEMO: Counting Characters Across Cells — 1:52 DEMO: Creating a «MAX IF» Function (Part 1) — 3:09 DEMO: Creating a «MAX IF» Function (Part 2) — 6:54 The Double Unary Operator («—«) — 3:49 QUIZ: Array Formulas HOMEWORK: Array Formulas — 2:09 Extra Bonus Functions Introduction — 1:41 The INDIRECT Function — 10:55 The HYPERLINK Function — 6:19 WEBSERVICE & FILTERXML: Weather Underground — 7:16 WEBSERVICE & FILTERXML: Open Weather Map — 9:14 QUIZ: Badass Bonus Functions Wrapping Up Resources & Next Steps — 0:41.

Microsoft Excel: Intro to Power Query, Power Pivot & DAX.

Get Up & Running with Excel’s Data Modeling & Business Intelligence Tools.

Description Instructor Specs.

This course will introduce you to Microsoft Excel’s powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you’re looking for.

63,046 positive reviews from 248,923 students.

Access 90 lectures & 7 hours of content 24/7 Use sample data from a fictional supermarket chain to get hands-on w/ Power Query Practice shaping, blending, & exploring project files Cover the fundamentals of database design & normalization Explore & analyze your data model using Power Pivot & DAX Cover basic DAX syntax & learn some of the most powerful and commonly used functions.

Note: Software NOT included.

«This has been an excellent course — Chris knows his stuff, and presents it well. I never knew there was so much power in Excel — I considered myself pretty good at Excel, but Power Query and the Data Model has blown me away.» – Ian Watts.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.) Designed for PC users (Power Pivot is currently unavailable with Excel for Mac)

Course Outline.

Getting Started Course Structure & Outline — 1:22 IMPORTANT: Versions & Compatibility — 3:15 Exploring the Course Project Files — 1:16 Setting Expectations — 1:53 Intro to «Power Excel» The «Power Excel» Workflow — 3:50 «Best Thing to Happen to Excel in 20 Years» — 8:18 When to use Power Query & Power Pivot — 0:44 QUIZ: Intro to «Power Excel» HOMEWORK: Intro to «Power Excel» Connecting & Shaping Data with Power Query Introduction — 0:27 Meet Power Query (aka «Get & Transform») — 2:40 The Query Editor — 3:17 Data Loading Options — 1:40 IMPORTANT: Regional Formatting Basic Table Transformations — 8:06 Text-Specific Tools — 10:17 Number-Specific Tools — 7:41 Date-Specific Tools — 7:39 PRO TIP: Creating a Rolling Calendar — 5:02 Adding Index & Conditional Columns — 7:44 Grouping & Aggregating Data — 7:10 Pivoting & Unpivoting — 8:52 Modifying Workbook Queries — 4:18 Merging Queries — 7:43 Appending Queries — 5:49 Connecting to a Folder of Files — 9:32 Power Query Best Practices — 2:44 QUIZ: Power Query HOMEWORK: Power Query Data Modeling & Normalization Introduction — 0:28 Meet Excel’s «Data Model» — 3:38 Data vs. Diagram View — 2:33 Database Normalization — 4:14 Data Tables vs. Lookup Tables — 5:40 Relationships vs. Merged Tables — 2:07 Creating Table Relationships — 6:54 Modifying Table Relationships — 2:06 Active vs. Inactive Relationships — 3:55 Relationship Cardinality — 5:46 Connecting Multiple Data Tables — 5:59 Filter Direction — 5:08 Hiding Fields from Client Tools — 4:59 Defining Hierarchies — 3:53 Data Model Best Practices — 1:38 QUIZ: Data Modeling 101 HOMEWORK: Data Modeling 101 Power Pivot & DAX 101 Introduction — 0:29 Creating a «Power» PivotTable — 5:27 «Power» Pivots vs. «Normal» Pivots — 2:48 Intro to Data Analysis Expressions (DAX) — 1:12 Calculated Columns — 8:39 DAX Measures = Supercharged Calculated Fields — 2:24 Creating Implicit Measures — 1:59 Creating Explicit Measures (AutoSum) — 7:08 Creating Explicit Measures (Power Pivot) — 7:42 Understanding Filter Context — 9:18 Step-by-Step Measure Calculation — 12:06 RECAP: Calculated Columns vs. Measures — 2:29 Power Pivot Best Practices — 1:50 QUIZ: Power Pivot & DAX 101 HOMEWORK: Power Pivot & DAX 101 Common DAX Functions Introduction — 0:27 DAX Formula Syntax & Operators — 4:05 Common DAX Function Categories — 3:54 Basic Math & Stats Functions — 12:45 COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS — 10:35 HOMEWORK: Math & Stats Functions Logical Functions (IF/AND/OR) — 16:49 SWITCH & SWITCH(TRUE) — 10:33 Text Functions — 10:53 HOMEWORK: Logical & Text Functions The CALCULATE Function — 14:39 Adding Filter Context with FILTER (Part 1) — 9:20 Adding Filter Context with FILTER (Part 2) — 14:23 Removing Filter Context with ALL — 9:06 HOMEWORK: CALCULATE, FILTER & ALL Joining Data with RELATED — 3:39 Iterator («X») Functions: SUMX — 12:20 Iterator («X») Functions: RANKX — 5:33 HOMEWORK: Iterator Functions Basic Date & Time Functions — 4:58 Time Intelligence Formulas — 17:02 HOMEWORK: Time Intelligence Speed & Performance Considerations — 3:02 DAX Best Practices — 2:03 QUIZ: Common DAX Functions Wrapping Up Introduction — 0:53 Data Visualization Options — 4:35 SNEAK PEEK: PowerBI — 5:55 Resources & Next Steps — 2:25.

Microsoft Excel Essentials, Level 1 Basics: Excel Made Simple.

Build a Solid Foundation on the Excel’s Basic Functions, Tools & Formula.

Description Instructor Specs.

Excel is the most commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light. This is the level for Excel beginners, and all the Excel basics will be covered here. Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.

14,230 positive reviews from 81,504 students.

Access 56 lectures & 3 hours of content 24/7 Understand the most widely used business software in the world Build your own simple to complex formulas & use some of Excel’s built-in functions Build your own spreadsheets from scratch & actually understand how they work.

Note: Software NOT included.

«I needed Excel immediately for work and this course is about as perfect as can be as a beginner.» – Sharon Goldzweig.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: beginner.

Requirements.

Any device with basic specifications Copy of Excel 2007, 2010, 2013, or 2016.

Course Outline.

Your First Program.

Microsoft Excel Essentials, Level 2: Intermediate/Advanced.

Be an Excel Power User by Working on Projects that Showcase the Range of Excel’s Capabilities.

Description Instructor Specs.

So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, this is the course for you. What you will learn in this course will supercharge your skills and your career. You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. You will do this by creating multiple projects together, step-by-step, and in-depth to guarantee your understanding. Each project builds on the last, so your skills develop cumulatively. Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.

14,230 positive reviews from 81,504 students.

Access 97 lectures & 8 hours of content 24/7 Learn the fastest way to create powerful dynamic templates Build a fully functional complex relational database Create dynamic named ranges Create Macros & use them to automate your work Make project management simple w/ Gantt charting.

Note: Software NOT included.

«The course covers from basics to advanced material. Explanations are clear and easy to understand, despite the level of Excel one has.» – Paula Yankova.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: intermediate.

Requirements.

Any device with basic specifications Copy of Excel 2007, 2010, 2013 or 2016.

Course Outline.

First Section First Lecture Welcome To The Course! — 2:05 Project 1 — Creating A Data Entry Screen To Populate Multiple Templates 1000 — Proof Of Concept — 4:49 Planning Ahead — 2:13 Creating Our Data Entry Screen — 4:08 (Custom) Formatting Dates And Time — 6:02 Simple Calculations With Time — 2:35 More (Useful) Calculations With Time — 8:06 It’s About Time (And Dates) — 8:28 Adding With Time — 3:39 Creating A Template From An Image — 11:34 Importing A Template From An Existing Excel File — 2:21 Converting Time To A Decimal — 5:41 A Little Bit Of Simple Data Entry — 3:11 Simple Conditional Formatting For A Cleaner View — 4:42 Calculating Time Out Of House Using Travel Time — 4:46 Simple Logical Testing And Nested Logical Testing — 8:28 Building Text Strings With A Formula — 12:10 Before We Move On. Accessing The Developer Ribbon — 1:05 A Tick Box Exercise (Of Sorts) — 7:11 Auto-populating Check Boxes — 11:48 PRACTICE EXERCISE 1 — Time To Add A New Entry — 1:40 Defining A Working Area, And Protecting Your Work — 4:40 PRACTICE EXERCISE 2 — Set Up A Working Area, And Limit User Entry — 1:06 Project 2 — Building A Database With Excel Simple VLOOKUPs — 4:16 Step 1 — Get Some Data In, And Split It — 3:54 Using Data Validation To Get The Right Input — 3:47 Let’s Build Our Database! — 6:12 Importing Data From A Text File — 2:01 Importing Data From A Word File — 2:37 Pulling Data From Multiple Sources — 3:33 Using OTHER Look-Ups To Look Up! — 5:25 LOOKUP From A LOOKUP With No Intermediary Step — 2:19 Data Arrays Don’t Have To Start At A1 — 2:58 Some Common Reasons VLook-Ups Fail — 6:02 One Inherent Flaw In VLOOKUP — 1:10 POWER USER — A Breakdown Of Looking Up Backwards — 6:44 The Other Way Of Looking Up Backwards — 6:49 Backwards Look-Ups In Action — 3:47 POWER USER — Dealing With Inconsistencies In User Entry — 8:19 POWER USER — Fuzzy VLOOKUPs — 3:33 Power User — VLOOKUPs With Multiple Inputs — 9:39 Power User — Looking Up Multiple Inputs Using An Array Formula — 4:45 VLOOKUP’s Brother. HLOOKUP — 5:04 POWER USER — The Holy Grail — How To Return Multiple Values From A Single Look Up — 13:33 What To Look For When THAT Formula Didn’t Work — 4:05 The Fastest Way To Modify Your Column Numbers — 7:24 POWER USER — Vlook-Ups With Moving Columns — 3:05 Putting It All Together — 9:52 The Finishing Touch — How Many Records Did I Find — 4:28 Project 3 — Named Ranges A Simple Static Named Range Using A Single Cell — 3:44 Creating A Named Range Using A Range Of Cells — 2:53 Using Row Labels To Name Multiple Ranges — 2:34 POWER USER — A Magic Trick Using Row And Column Labels — 4:55 POWER USER — Dynamic Named Ranges — 8:06 POWER USER — What To Do With Dynamic Names Ranges With Titles — 5:22 POWER USER — Dynamic Charts — 10:27 Horizontal Dynamic Named Ranges — 11:09 Project 4 — What Can I Have For Dinner Welcome to «What Can I Have For Dinner?» or. What Would I Use THAT for? — 1:25 Hyperlinking To A Different Sheet In The Same Workbook — 3:32 Creating Our First Macro — 5:37 Assigning A Macro To A Button — 4:13 Creating A List For Our Dropdown Using A Dynamic Named Range — 1:39 Using A Conditional Format To Know When A Value Is Missing — 4:34 Copying Conditional Formats And Creating Our Drop-Downs — 2:50 Building Our Formula. INDIRECT Function — 2:55 Building Strings For Indirect Sheet And Cell References — 7:16 It’s A One Or A Zero — 2:35 Working The Percentages And Adding Traffic Lights — 4:06 POWER USER — The HYPERLINK Function (And Problem) — 3:16 PRACTICE EXERCISE 1 — Fill In The Blanks — 0:59 PRACTICE EXERCISE 2 — Pretty It Up (With A Macro) — 1:45 PRACTICE EXERCISE 3 — Create A VLOOKUP Using A Built String With INDIRECT — 2:13 Project 5 — Using Excel For Gantt Charts. Timelines And Project Plans! Creating A Gantt Chart Using A Worksheet — 7:39 Building The First Part Of Our Logical Test — 4:20 Multiple Logical Tests At Once Using AND — 8:28 Conditional Formatting. Where The Magic Happens — 5:32 Gantt Charts Using The Built In Charting Tools — 4:51 Gantt Charts With Different Colors For Different Criteria — 7:47 Project 6 — Bonus Section — Just For Fun Bonus — How I Created Randomly Generated License Plate Numbers! — 7:14 Student Questions Answered! Level 2 SQA 01 — Calls Text Data — Or How To Return a Column Title If Value is 1 — 6:42 Level 2 SQA 02 — Calls Text Data 2 — This Time Using Text! — 9:02 Level 2 SQA 03 — Extracting Phone Numbers From A Cell — 2:39 Level 2 SQA 04 — What Is The CHOOSE Function Really Used For — 14:47 Level 2 SQA 05 — Casing And Text Functions — 6:35 Level 2 SQA 06 — Dynamic Charting From A Drop Down — 10:02 Level 2 SQA 07 — Extracting a Unique List, And Summing The Money! — 2:25 Level 2 SQA 08 — SUMIF With Dynamic Sum Range — 5:55 Level 2 SQA 09 — VLOOKUPs With Pictures! — 4:30 Level 2 SQA 10 — Data Validation With Dependent Dropdowns — 3:42 Level 2 SQA 11- Data Validation With Dependent Dropdowns (Dynamic Named Range Workaround) — 8:30 Level 2 SQA 12 — Using 2 Labels As A Lookup From Drop-downs — 6:47 Level 2 SQA 13 — Tiered Pricing — 9:00 Level 2 SQA 14 — Worksheet Protection — 4:39 Level 2 SQA 15 — The Middle Name Problem. and Solution! — 9:03 Level 2 SQA 16 — Finding Matches, And Counting Entries — 8:06 Level 2 SQA 17 — Fee Calculator, or LOOKUPs That Are True, Not False — 5:42.

Microsoft Excel Essentials, Level 3: Macros & VBA Programming.

Turbocharge Excel with VBA! From Simple Helper Programs to Complete Solutions with Excel Visual Basic for Applications.

Description Instructor Specs.

If you really want to harness the full power of Excel, then learning how to program in VBA (Visual Basic for Applications), the powerhouse, is essential. In this course, you will learn everything you need to know about coding in VBA, even if you’ve never looked at a line of code before! You will learn how to streamline your code for efficiency from the beginning. You’ll then go on to create 6 separate projects using those very tools and techniques, where you will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!

14,230 positive reviews from 81,504 students.

Access 181 lectures & 14 hours of content 24/7 Learn to program in VBA from scratch Fully automate Excel using Visual Basic for Applications Understand coding & the thought process behind it Develop complex full-blown applications from scratch.

Note: Software NOT included.

«Good, practical examples. Gaining experience through making mistakes. Real-life examples added from participants questions» – Andrew Hubbard.

Important Details.

Length of time users can access this course: lifetime Access options: web & mobile streaming Certification of completion included Redemption deadline: redeem your code within 30 days of purchase Updates included Experience level required: all levels.

Requirements.

Any device with basic specifications Copy of Excel 2007, 2010, 2013, or 2016.

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *