Microsoft Excel Intermediate: Formulas & Functions and More

4.2 (18)
Microsoft Excel Intermediate: Formulas & Functions and More
Обучение платное
Not set
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!
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Комментарии (18)
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»