Microsoft Excel Intermediate: Formulas & Functions and More

4.2 (18)
Онлайн-курс
Microsoft Excel Intermediate: Formulas & Functions and More
Payment
Обучение платное
Language
Not set
Duration
3.5 часа курса
Курс от Udemy
Microsoft Excel Intermediate: Formulas & Functions and More
Чему вы научились?
Our EXCEL INTERMEDIATE course will give you a solid understanding of Excel Formulas & Functions, along with more advanced tools and concepts
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
Enhance your skills and the quality of your work with Formulas & Functions, using Tables, managing data, doing more with Charts and using SparkLines
Working with Formulas and Functions - Formulas with Absolute References - Autosum Functions (SUM & AVERAGE) - IF and Nested Functions - Working with Named Ranges - Array Functions (SUMIF & AVERAGEIF) - Formula Auditing - Text Functions
Advanced File Tasks - Saving and File Management - Converting and Encrypting Files - File Properties and Digital Signatures - File Accessibility and Compatibility
Managing Tables in Microsoft Excel - Creating Excel Tables - Working with Records and Filters - Advanced Filters
Data Tools in Excel - Text to Columns - Flash Fill - Remove Duplicates - Data Validation - Consolidate
Doing More with Charts in Excel - Trendlines - Error Bars - Working with Axis Options - Advanced Chart Formatting
Sparklines - Creating Sparklines - Editing Sparklines
О курсе

Do you want to be more productive with Excel?

Whether you’re a basic Excel user who wants to take your skills to the next level, or someone who’d like a “best practice” refresher, here's your way to learn a whole range of skills that will enhance the speed and quality of what you achieve with Excel..

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.

The course teaches you how to use formulas and functions - probably the most important step that everyone makes - but also shows you how to use tables, manage data in Excel and add to your work with enhanced chart options and SparkLines.

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 concepts covered in the Introduction course.
  • 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
(5)
(10)
(3)
(0)
(0)
Комментарии (18)
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»