Excel is often underrated when it comes to data analysis. Data is important for any type of decisions you want to make. Without data, you might end up making the wrong decision, which is why having an understand of data is extremely important. So, what the best way to analyze data? Excel.
For a lot of people Excel is a simple table that is often used for data storing, but there is so much more that you can do with this brilliant software. From simple to more complex calculations to even analysis and creating visual charts, Excel has the ability to do it all.
If you want to master Excel and all that it can do for you, then this is the perfect course for you!
From beginners to advanced data analysis, this course has something for everyone! The amazing course breaks down Excel into easy and simple to understand segments, where you will learn exactly how to can use do calculations, work with formulas, filter text, and even create effective reports.
This course is great if you want to boost your Excel skills and even learn how to maximize your productivity by using tables, conditional formatting and formulas in an easy and efficient manner. If you are scared of numbers and tables or if making charts see difficult, then you definitely need this course! The course will help you learn all of this and so much more in simple and easy to understand steps.
What this course includes:
How to create and format Tables
How to easily filter data in text, numeric and date fields
Easily Sum, Average, Count and use Max and Min in your tables
Use Slicers to easily filter Table data
How to apply conditional formatting rules
How to easily highlight the Top 10
Learn to use Data Bars and Color Scales
Learn to apply icons
Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS
Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay
Learn Text formulas such as LEFT, MID, RIGHT and TRIM
Learn to use the IF formula to create powerful 'IF Then' logic
Learn the HLOOKUP and VLOOKUP]
The course is created using Excel 2013, but Excel 2007 and 2016 will also work with the same formulas.
So, what are you waiting for? Enroll now and find how Excel can change your life!
Excel Power Tools, Power BI and Google Data Studio Trainer
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio.
Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.
People interested in this course also viewed
Frequently Asked Questions
It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.
A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.
A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.
We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.
How it works
The offer includes all live courses, Deals and E-Degrees.
Bogo Offer will be applied automatically upon adding 2nd Course, Deal or E-degree in the Cart. Offer Price will be reflected in Checkout Total
You can buy multiple courses or deals using your cart but they have to be in combo of 2 to get benefit of the offer.
We are free to withdraw any product from this offer based at our own discretion.
Review and Rating
Your Rating :
B: Very Good
Please complete your profile for better search results