Microsoft Excel Advanced: the Data Analysis Tools You Need

4.2 (68)
Онлайн-курс
Microsoft Excel Advanced: the Data Analysis Tools You Need
Payment
Обучение платное
Language
Not set
Duration
3 часа курса
Курс от Udemy
Microsoft Excel Advanced: the Data Analysis Tools You Need
Чему вы научились?
Our EXCEL ADVANCED course will give you a solid understanding of the advanced data analysis tools and concepts in Excel
The course has its own workbook with exercises – downloadable within the first “General Introduction” module – so you are able to practice and reinforce what you have learned
You'll acquire a highly impressive array of data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros
What-If Analysis - Exploring Scenarios - Goal Seek and Data Tables - Using Solver
Grouping & Outlining and Subtotals - Outlining and Grouping Data - Using the Subtotals Tool
PivotTables - Getting Started with PivotTables - Displaying Data in a PivotTable - Formatting a PivotTable - Using the Classic PivotTable Layout - Slicers
Charting Pivoted Data - Getting Started with PivotCharts - Using the PivotChart Tools Tabs - Formatting a PivotChart
Advanced Excel Tasks - Excel and Hyperlinks - Using Custom AutoFill Lists - Sharing Workbooks
HLOOKUP and VLOOKUP Functions - Using the VLOOKUP Function - Using the LOOKUP Function
Introduction to Macros in Excel - Recording and Playing Macros - Copying and Deleting Macros - Visual Basic and Macros
О курсе

Are you looking to use Excel to analyze your data?

With this course you'll enter the world of analyzing your data, using your spreadsheets to interpret, illuminate and present your data in a whole new way.

With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the short “General Introduction” module at the start of each course). These are a great addition because they enable you to practice the skills you learn.

Our Microsoft instructors are seasoned professionals - they don't just know the software: they've used it commercially and taught it in a classroom environment for years. You won't be in better hands!

And we don’t woffle! Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time.

You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts.  Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!

You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too

Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view.

We’ll say it again: don’t forget the course workbooks and exercises – downloadable with the first “General Introduction” module in each course – which really enhance and deepen your learning. Remember that practice makes perfect!

So this course is genuinely much more than just a talk-through video. We don’t think you’ll find better value, so why not enrol with us now?

Требования
  • You should have a good working knowledge and understanding of the subjects covered in the Introduction and Intermediate courses.
  • In order to do the exercises we provide, you'll need a copy of Excel on your computer (any version from 2010 is fine).
Лекторы
ZandaX Training
ZandaX Training
47,000 students can't be wrong!
Платформа
/storage/img/providers/udemy.svg
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Рейтинг
4.2
(28)
(33)
(8)
(2)
(1)
Комментарии (68)
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»