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

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

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

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

Excel Formulas and Data Analysis Essentials

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

О курсе

This course focuses on mastering Excel formulas and data analysis techniques, which are essential skills in today’s data-driven professional world. Excel's powerful functions enable users to automate calculations, analyze trends, and gain insights efficiently. By learning how to build and apply formulas, you'll streamline workflows and make better decisions based on data. In this course, you'll learn how to construct formulas for a variety of tasks, including financial, statistical, and date/time analysis. You'll also become proficient in applying logical functions and error-handling techniques to ensure reliable results. As you progress, you'll gain the skills to filter, query, and perform large-scale analysis on complex datasets. What sets this course apart is its hands-on approach, which combines in-depth theoretical explanations with practical, real-world applications. You'll learn how to use Excel tools to solve common business and analysis challenges and improve decision-making processes. This course is designed for professionals and individuals who want to advance their Excel skills. Whether you're in finance, business, or data analysis, this course will help you unlock Excel’s full potential. Basic familiarity with Excel is recommended, but no prior expertise in data analysis is required. This course is part two 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.

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

Microsoft ExcelData PresentationStatistical MethodsFinancial AnalysisExcel FormulasData ScienceSchedulingData AnalysisData VisualizationFinancial DataData IntegrityData ManipulationData SecurityFinancial ModelingSpreadsheet SoftwareData ManagementExcel Macros

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

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

01Building Basic Formulas16 материалов

Lesson 1

Building Basic Formulas - Overview VideoВидеоIntroductionЧтениеEditing FormulasЧтениеUsing Quick Analysis to Add NumbersЧтение

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

Wiley Skills Network

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

Excel Formulas and Data Analysis Essentials
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 14.4 ч

10 модулей

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

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

Часть программы вашего университета
Order of Operator PrecedenceЧтение
Using the Insert Function ButtonЧтение
Copying FormulasЧтение
Copying with Mixed Cell ReferencesЧтение
Creating an Array FormulaЧтение
Building Old-Fashioned Array FormulasЧтение
Naming Cells and RangesЧтение
Naming Constants and FormulasЧтение
Managing NamesЧтение
Adding Linking FormulasЧтение
The Calculation Options in ExcelЧтение
Excel Formula EssentialsЗадание
02Logical Functions and Error Trapping10 материалов

Lesson 1

Logical Functions and Error Trapping - Overview VideoВидеоIntroductionЧтениеUsing Logical FunctionsЧтениеEvaluating the Many Talents of the IFS FunctionЧтениеError-Trapping with IFЧтениеWhiting-Out Errors with Conditional FormattingЧтениеTracing PrecedentsЧтениеError CheckingЧтениеError TracingЧтениеMastering Logical Functions and Error Trapping in ExcelЗадание
03Date and Time Formulas3 материалов

Lesson 1

Date and Time Formulas - Overview VideoВидеоDate and Time Formulas - The ReadingЧтениеMastering Date and Time Calculations in ExcelЗадание
04Finagling Financial Formulas7 материалов

Lesson 1

Finagling Financial Formulas - Overview VideoВидеоIntroductionЧтениеCalculating the Present ValueЧтениеThe PMT FunctionЧтениеDepreciation FunctionsЧтениеExcel's Advanced Financial FunctionsЧтениеMastering Excel Financial FormulasЗадание
05Math and Statistical Formulas2 материалов

Lesson 1

Math and Statistical Formulas - The ReadingЧтениеExcel Math and Statistical FunctionsЗадание
06Lookup, Information, and Text Formulas7 материалов

Lesson 1

Lookup, Information, and Text Formulas - Overview VideoВидеоIntroductionЧтениеOld-Fashioned Lookups with VLOOKUP and HLOOKUPЧтениеPerforming an Old-Fashioned Two-Way Lookup with MATCH and INDEXЧтениеGetting Cell Reference Info with the Reference FunctionsЧтениеThe T FunctionЧтениеMastering Excel Lookup and Text FunctionsЗадание
07Protecting Workbooks and Worksheet Data8 материалов

Lesson 1

Protecting Workbooks and Worksheet Data - Overview VideoВидеоIntroductionЧтениеAssigning a Password to Open from the Info ScreenЧтениеSetting Up Worksheet Data ProtectionЧтениеSelecting What Actions Are Allowed in a Protected SheetЧтениеEnabling Cell Range Editing by Certain UsersЧтениеDoing Data Entry in the Unlocked Cells of a Protected WorksheetЧтениеExcel Data Protection FundamentalsЗадание
08Preparing a Workbook for Distribution5 материалов

Lesson 1

Preparing a Workbook for Distribution - Overview VideoВидеоIntroductionЧтениеAnnotating WorkbooksЧтениеMarking Up a Worksheet with Digital InkЧтениеExcel Workbook Distribution EssentialsЗадание
09Sharing Workbooks and Worksheet Data10 материалов

Lesson 1

Sharing Workbooks and Worksheet Data - Overview VideoВидеоIntroductionЧтениеCopying a Sharing LinkЧтениеSharing Excel Data with Office ProgramsЧтениеHappily embedded afterЧтениеSharing Data Between Excel and PowerPointЧтениеAdding Alternative Text to GraphicsЧтениеExporting Workbooks to Other Usable File FormatsЧтениеSaving Worksheets as HTML FilesЧтениеCollaborative Data Management and IntegrationЗадание
10Charting Worksheet Data11 материалов

Lesson 1

Charting Worksheet Data - Overview VideoВидеоIntroductionЧтениеEmbedded Charts Versus Separate Chart SheetsЧтениеInserting Charts with the Quick Analysis ToolЧтениеEditing the Source of the Data Graphed in the ChartЧтениеAdding Data Labels to the Series in a ChartЧтениеFormatting Elements of a ChartЧтениеFormatting Chart Axes with the Format Axis Task PaneЧтениеCategories in Reverse OrderЧтениеAdding Sparkline Graphics to a WorksheetЧтениеMastering Chart and Data Visualization ToolsЗадание