Skip to main content

The Essential 2021 Advanced Excel Expert Bundle for $19 June 10, 2021 at 02:00AM



Checkout Now

Expires June 10, 2121 23:59 PST
Buy now and get 95% off

Excel for Business Analysts


KEY FEATURES

Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises to immediately put into practice the new data analysis techniques that you learn.

5.0/5 average rating: ★ ★ ★ ★ ★
  • Access 49 lectures & 5 hours of content 24/7
  • Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, & XLOOKUP
  • Use IF, IFS, IFERROR, SUMIF, & COUNTIF to apply logic to your analysis
  • Split data using text functions SEARCH, LEFT, RIGHT, MID
  • Standardize & clean data ready for analysis
  • Use the PivotTable function to perform data analysis
  • Use slicers to draw out information
  • Display your analysis using Pivot Charts
  • Learn about forecasting & using the Forecast Sheets
  • Conduct a Linear Forecast & Forecast Smoothing
  • Use Conditional Formatting to highlight areas of your data
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Power Pivot, Power Query & DAX in Excel


KEY FEATURES

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This Excel function suite allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You'll first learn how to bring your data together, merge, and clean it using Power Query. You'll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files to build your data models as you learn.

4.2/5 average rating: ★ ★ ★ ★
  • Access 47 lectures & 4 hours of content 24//7
  • Get started with Power Query
  • Connect Excel to multiple workbooks
  • Merge & append queries using Power Query
  • Set up & manage relationships in a data model
  • Create a PivotTable to display your data
  • Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Advanced PivotTables


KEY FEATURES

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

4.7/5 average rating: ★ ★ ★ ★
  • Access 48 lectures & 7.5 hours of content 24/7
  • Do a PivotTable (a quick refresher)
  • Combine data from multiple worksheets for a PivotTable
  • Group, ungroup & deal with errors
  • Format a PivotTable, including adjusting styles
  • Use the Value Field Settings
  • Learn Advanced Sorting & Filtering in PivotTables
  • Use Slicers, Timelines on multiple tables
  • Create a Calculated Field
  • Learn all about GETPIVOTDATA
  • Create a Pivot Chart & add sparklines and slicers
  • Use 3D Maps from a PivotTable
  • Update your data in a PivotTable & Pivot Chart
  • Learn all about Conditional Formatting in a PivotTable
  • Create a basic macro to refresh PivotTable data
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Excel Advanced 2019


KEY FEATURES

Get beyond the basics and supercharge your current skill level in Excel. With this 8-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

4.4/5 average rating: ★ ★ ★ ★
  • Access 57 lectures & 8 hours of content 24/7
  • Learn advanced charting & graphing in Excel 2019
  • Use detailed formatting tools
  • Use lookup & advanced lookup functions
  • Know financial functions including calculating interest & depreciation
  • Connect to other workbooks & datasets outside of Excel
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Advanced Formulas in Excel


KEY FEATURES

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, you'll focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analyses. The course will look at how to filter a dataset and sort using formulas. After that, you'll learn how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles, and so much more! We end by looking at how to use XLOOKUP.

4.4/5 average rating: ★ ★ ★ ★
  • Access 12 lectures & 2.5 hours of content 24/7
  • Filter a dataset using a formula
  • Sort a dataset using formulas & defined variables
  • Create multi-dependent dynamic drop-down lists
  • Perform a 2-way lookup
  • Make decisions with complex logical calculations
  • Extract parts of a text string
  • Create a dynamic chart title
  • Find the last occurrence of a value in a list
  • Look up information with XLOOKUP
  • Find the closest match to a value
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Macros & VBA for Beginners


KEY FEATURES

This course teaches you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). It starts by giving an overview of Marcos. After that, you'll move on to some VBA basics and how to edit and debug Macros. Finally, the course will look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon. This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced-level Excel course; intermediate knowledge of Excel is required to get the most from this course.

4.5/5 average rating: ★ ★ ★ ★
  • Access 15 lectures & 2 hours of content 24/7
  • See examples of Excel Macros
  • Record your first macro
  • Record a macro using relative references
  • Record a complex, multi--step macro, & assign it to a button
  • Set up the VBA Editor
  • Edit Macros in the VBA Editor
  • Fix issues with macros using debugging tools
  • Write your own macro from scratch
  • Create a custom Macro ribbon & add all the Macros you've created
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

THE EXPERT

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel




Checkout Now

Comments

Popular posts from this blog

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code - January 01, 2019 at 01:18AM

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! Make 2019 the year you rise to your potential and achieve all your New Year resolutions, with the most popular courses from leading instructors, for as low as $9.99 each! *New Year’s Sale: Get Udemy courses for as low as $9.99 […] The post 2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code appeared first on CouponRim . from CouponRim https://cpr.im/2An4ERS

Heroic Public Speaking for $19 December 30, 2018 at 02:00AM

Checkout Now Expires June 28, 2019 23:59 PST Buy now and get 61% off KEY FEATURES Public speaking can seem intimidating, but chances are you'll have to deliver a speech or presentation at some point in your career. So, it's in your best interest to get the hang of it now. Led by New York Times bestselling business author Michael Port and seasoned actress Amy Port, Heroic Public Speaking takes you through engaging, persuading, and inspiring your audience, no matter the size. You'll treat your presentation like a performance and develop the skills to handle pre-show nerves, engage your audience in real-time, and much more as you make your way through the course. Access 23 lectures & 10.5 hours of content 24/7 Craft an engaging presentation that feels more like a performance rather than a speech Discover a system for engaging, persuading & inspiring your audience, no matter the size Walk through structuring a presentation w/ tips on incorporating clif

The Complete Big Data Master Class Bundle for $35 March 10, 2019 at 03:00AM

Checkout Now Expires March 10, 2024 23:59 PST Buy now and get 96% off Learn By Example: Plotly KEY FEATURES You don't need to be a programming prodigy to get started in data science. Easy to use and highly accessible, Plotly is library in Python that lets you create complex plots and graphs with minimal programming know-how. From creating basic charts to adding motion to your visualizations, this course will walk you through the Plotly essentials with hands-on examples that you can follow. Access 28 lectures & 2 hours of content 24/7 Learn how to build line charts, bar charts, histograms, pie charts & other basic visualizations Explore visualizing data in more than two dimensions Discover how to add motion to your graphs Work w/ plots on your local machine or share them via the Plotly Cloud PRODUCT SPECS Important Details Length of time users can access this course: lifetime Access options: web and mobile streaming Certification of completion in