The Premium A to Z Microsoft Excel Bundle Ft. Alan Jarvis & Chris Dutton for $49 March 30, 2020 at 02:00AM
KEY FEATURES
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
PRODUCT SPECS
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
THE EXPERT
Alan Jarvis has almost thirty years of experience in teaching various subjects and has held senior management positions at several blue-chip and Times Top 100 companies. He now specializes in consultancy, interim work, and teaching on Udemy. Alan Jarvis has 80,000 happy students across 194 countries enrolled in his courses.
KEY FEATURES
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
PRODUCT SPECS
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
THE EXPERT
Alan Jarvis has almost thirty years of experience in teaching various subjects and has held senior management positions at several blue-chip and Times Top 100 companies. He now specializes in consultancy, interim work, and teaching on Udemy. Alan Jarvis has 80,000 happy students across 194 countries enrolled in his courses.
KEY FEATURES
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
PRODUCT SPECS
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
THE EXPERT
Alan Jarvis has almost thirty years of experience in teaching various subjects and has held senior management positions at several blue-chip and Times Top 100 companies. He now specializes in consultancy, interim work, and teaching on Udemy. Alan Jarvis has 80,000 happy students across 194 countries enrolled in his courses.
KEY FEATURES
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
"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
PRODUCT SPECS
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)
THE EXPERT
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
"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
PRODUCT SPECS
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)
THE EXPERT
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
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)
THE EXPERT
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
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)
THE EXPERT
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
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)
THE EXPERT
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
This Intermediate Microsoft Excel training class is meant for students using Excel 2019 or Excel 365 who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. Learn to streamline and analyze data and to keep data organized by managing large data sets with lists and tables. Learn to use filters to save time, as well as great ways to group and summarize data.
9.3/10 rating based on 30,389 reviews
- Access 96 lectures & 1 hour of content 24/7
- Learn to use formulas & functions
- Convert, sort, filter & manage lists
- Insert & modify illustrations in a worksheet
- Learn to use conditional formatting & styles
Note: Software NOT included.
"I have done an "at your own pace" and a live "on-line" course - both are excellent and I would highly recommend. Great instructors! – Debbi Doris
PRODUCT SPECS
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
- Basic Excel
- Pre-requisite course: Introduction to Microsoft Excel 2019 Training
THE EXPERT
Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).
KEY FEATURES
Already comfortable using Microsoft Excel 2019 or Excel 365 and ready to become an Excel expert? Take your skills to the next level in this Advanced Excel course. Learn Excel's most powerful and advanced tools, including PivotTables, PivotCharts, Macros, and more. You will gain skills for better collaboration, including password protection and tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel.
9.3/10 rating based on 30,389 reviews
- Access 78 lectures & 1 hour of content 24/7
- Create pivot tables & charts
- Learn to trace precedents & dependents
- Convert text & validate and consolidate data
- Collaborate w/ others by protecting worksheets & workbooks
- Create, use, edit & manage macros
- Import & export data
Note: Software NOT included.
"The class was very practical and relatable. The instructor created a positive atmosphere." – Jennifer Araujo-Bray
PRODUCT SPECS
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: advanced
Requirements
- Basic & intermediate Excel experience
Believe it or not, it is the type of information I’ve long been trying to find. It matches to my requirements a lot. Thank you for writing this information. 2ms office 2016 product key
ReplyDeleteThanks for sharing the best information and suggestions, If you are looking for the best Marketing Analytics Services, then A for Analytics IT solutions Pvt Ltd. Highly energetic blog, I’d love to find out some additional information.
ReplyDeleteWow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also ms office 2016 free download full version
ReplyDeleteI found your blog on Google and read a few of your other posts. I just added you to my Google News Reader. You can also visit Data Management Consulting for more Dotvision Analytics related information and knowledge, Keep up the great work Look forward to reading more from you in the future.
ReplyDelete