К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Excel Charts, Sharing, Automation, and VBA · LearnSpace
Назад в каталог
courseraБизнес

Excel Charts, Sharing, Automation, and VBA

Курс от John Wiley & Sons
Средний≈ 10.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course is designed to teach you the essential skills for working with Excel, focusing on charting, sharing, and automating tasks using VBA. Excel is a critical tool for professionals across industries, and mastering these capabilities will significantly enhance your productivity and data management skills. Throughout this course, you'll learn how to protect and share workbooks, visualize data through charts, and integrate graphic objects to make your reports more insightful. You will also explore how to automate tasks using macros and customize Excel functionality with basic VBA programming, equipping you to solve real-world business challenges efficiently. This course stands out by combining practical knowledge with real-world examples, ensuring that you can apply what you learn directly in your work. Whether you’re preparing reports, building dashboards, or managing workflows, the techniques covered will make you more effective with Excel in your day-to-day tasks. Ideal for professionals who want to elevate their Excel skills, this course is perfect for those with basic Excel knowledge looking to move toward automation and more advanced functionality. If you're ready to improve your workflow and automate repetitive tasks, this course will provide you with the tools and knowledge to do so. This course is part three of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. Copyright © 2022 by John Wiley & Sons, Inc., Hoboken, New Jersey Published simultaneously in Canada. Used by arrangement with John Wiley & Sons, Inc.

Навыки, которые вы освоите

Excel MacrosVisual Basic (Programming Language)Spreadsheet SoftwareTrend AnalysisExcel FormulasDiagram DesignPivot Tables And ChartsForecastingFinancial ForecastingMicrosoft ExcelAutomationData VisualizationGraphical Tools

Программа курса

7 модулей · 69 учебных материалов

01Adding Graphic Objects11 материалов

Lesson 1

Adding Graphic Objects - Overview VideoВидеоIntroductionЧтениеMoving Graphic Objects to New LayersЧтениеGrouping Graphic ObjectsЧтение

Учитесь у экспертов

Wiley Skills Network

Преподаватель курса

Excel Charts, Sharing, Automation, and VBA
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 10.8 ч

7 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Корейский, Пушту, Индонезийский, Испанский, Дари, Японский

Часть программы вашего университета
Inserting Different Types of GraphicsЧтение
Making Changes to GraphicsЧтение
Drawing Predefined ShapesЧтение
Formatting a Text BoxЧтение
Adding an Arrow to a Text BoxЧтение
Adding Images to a SmartArt PictureЧтение
Graphic Object Manipulation and FormattingЗадание
02Building and Maintaining Tables9 материалов

Lesson 1

Building and Maintaining Tables - Overview VideoВидеоIntroductionЧтениеConverting a Range to a Table (and Back Again)ЧтениеAdding New Records with the Data FormЧтениеDeleting Records with the Data FormЧтениеSorting Records on a Single FieldЧтениеSorting a Table on Font and Fill Colors and Cell IconsЧтениеSubtotaling Table DataЧтениеMastering Table Operations in ExcelЗадание
03Filtering and Querying a Table13 материалов

Lesson 1

Filtering and Querying a Table - Overview VideoВидеоIntroductionЧтениеDoing Basic Filtering by Selecting Specific Field EntriesЧтениеUsing the Number Filters OptionsЧтениеCustom AutoFilter at Your ServiceЧтениеOnly the Unique Need ApplyЧтениеSetting Up Logical AND Logical OR ConditionsЧтениеUsing the AND, OR, and NOT Functions in Calculated CriteriaЧтениеQuerying External DataЧтениеRetrieving Data from Access Database TablesЧтениеRetrieving Data from the WebЧтениеQuerying Data from Other Data SourcesЧтениеMastering Excel Table ManipulationЗадание
04Performing What-If Analysis10 материалов

Lesson 1

Performing What-If Analysis - Overview VideoВидеоIntroductionЧтениеCreating a One-Variable Data TableЧтениеCreating a Two-Variable Data TableЧтениеCreating New ScenariosЧтениеProducing a Summary ReportЧтениеUsing SolverЧтениеSolving the ProblemЧтениеSaving and Loading a Model ProblemЧтениеMastering Excel's What-If Analysis ToolsЗадание
05Performing Large-Scale Data Analysis10 материалов

Lesson 1

Performing Large-Scale Data Analysis - Overview VideoВидеоIntroductionЧтениеCreating Recommended PivotTablesЧтениеCustomizing the PivotTable Fields Task Pane DisplayЧтениеUsing Timeline FiltersЧтениеChanging the PivotTable OptionsЧтениеSwitching Between the Data View and Diagram ViewЧтениеUsing the 3D Maps FeatureЧтениеUsing Power BI with Excel Worksheet DataЧтениеMastering Excel and DAX for Data AnalysisЗадание
06Recording and Running Macros7 материалов

Lesson 1

Recording and Running Macros - Overview VideoВидеоIntroductionЧтениеRecording MacrosЧтениеRunning a MacroЧтениеAdding Your Macros to a Custom Tab on the RibbonЧтениеMacro SecurityЧтениеExcel Macro FundamentalsЗадание
07VBA Programming9 материалов

Lesson 1

VBA Programming - Overview VideoВидеоIntroductionЧтениеEditing Recorded MacrosЧтениеFinding and Replacing Code in the MacroЧтениеGetting Macro Input by Adding a Dialog BoxЧтениеWhy Not Type in the Arguments of the Inputbox FunctionЧтениеCreating Custom Excel FunctionsЧтениеUsing a Custom Function in Your WorksheetЧтениеVBA Programming EssentialsЗадание