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

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

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

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

Excel and Google Sheets for Data Analysis Training

Курс от Simplilearn
Начальный≈ 15.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This comprehensive Microsoft Excel & Google Sheets for Data Analysis Training course builds essential skills in spreadsheet management, data preparation, business reporting, and data visualization using Microsoft Excel and Google Sheets. Learn to organize, clean, analyze, and visualize data using advanced Excel functions, PivotTables, dashboards, and Google Sheets collaboration features to support data-driven business decisions. By the end of this course, you will be able to: - Master Spreadsheet Management: Create, organize, and manage workbooks and worksheets in Microsoft Excel - Prepare and Clean Data: Format, validate, and clean datasets for accurate business analysis - Analyze Data with Advanced Excel: Use XLOOKUP, INDEX, MATCH, OFFSET, PivotTables, and advanced formulas - Build Reports and Dashboards: Create PivotTables, dashboards, and visual reports to uncover business insights - Collaborate with Google Sheets: Manipulate, analyze, visualize, and share data using Google Sheets collaboration tools - Apply Practical Business Skills: Demonstrate spreadsheet management and data analysis skills through hands-on activities and real-world business challenges Ideal for beginners, students, job seekers, business professionals, office administrators, analysts, and anyone looking to build practical Microsoft Excel, Google Sheets, business reporting, data analysis, and data visualization skills.

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

Data AnalysisGoogle SheetsMicrosoft ExcelSpreadsheet SoftwareDashboard CreationExcel FormulasData VisualizationData CleansingData ManipulationPivot Tables And ChartsStatistical ReportingData TransformationGoogle WorkspaceStatistical AnalysisInteractive Data VisualizationBusiness ReportingData WranglingData PresentationDashboardCollaborative Software

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

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

01Microsoft Excel Fundamentals Recap15 материалов

Introduction to Microsoft Excel

Course SyllabusЧтениеIntroductionВидеоBasics of Microsoft ExcelВидеоPrinciples of Microsoft ExcelВидео

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

Priyanka Mehta

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

Excel and Google Sheets for Data Analysis Training
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 15.2 ч

4 модулей

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

Часть программы вашего университета
Features of a WorkbookВидео
Process of Structuring DataВидео
Quiz on Introduction to Microsoft ExcelЗадание

Working with the Excel Interface

Navigating Through the Excel InterfaceВидеоProcess of Navigating Within the SpreadsheetВидеоCreating and Managing WorksheetsВидеоReorganizing and Merging WorksheetsВидеоPage Layout, Navigation, and Data SafeguardingВидеоOrganizing and Managing Data with Microsoft ExcelDIALOGUEQuiz on Working with the Excel InterfaceЗаданиеAssessment for Microsoft Excel Fundamentals RecapЗадание
02Data Preparation in Microsoft Excel17 материалов

Formatting Data in Excel

Excel Interface NavigationЧтениеCell Formatting and Styles: Font and Number Formatting TechniquesВидеоCell Formatting and Styles: Indentation, Alignment, Borders, and Conditional FormattingВидеоCell Formatting and Styles: Creating Custom Formats and Effective Formatting RecommendationsВидеоDifferent Forms of Data AnomaliesВидеоIdentifying Data Anomalies and Conditional FormattingВидеоQuiz on Formatting Data in ExcelЗадание

Data Cleaning and Analysis

Data Cleaning TechniquesВидеоStatistical Analysis of the DataВидеоRegular Data MonitoringВидеоCell Formatting and Styles: Eliminating Duplicates, Handling Missing Values, and Cleaning Text DataВидеоEffective Data Cleaning Techniques in ExcelВидеоData Cleaning TasksЧтение
03 Advanced Excel Functions and Analysis27 материалов

Excel Functions

IntroductionВидеоInformation FunctionsВидеоError CodesВидеоError Codes: Information FunctionВидеоLogical FunctionsВидеоLOOKUP FunctionВидеоVLOOKUP and HLOOKUP FunctionsВидеоXLOOKUP FunctionВидеоIndex, Match, and Offset FunctionsВидеоFinancial FunctionsВидеоAdvanced Formula for Data Analysis: Textjoin and Sumproduct FunctionsВидеоQuiz on Excel FunctionsЗадание

PivotTables and Dashboards

Introduction to PivotTableВидеоKey Features of PivotTablesВидеоAdvantages of PivotTablesВидеоFunctionalities of PivotTablesВидеоCreating PivotTableЧтениеCustomize PivotTable for AnalysisЧтение
04Google Sheets for Data Analysis22 материалов

Getting Started with Google Sheets

IntroductionВидеоIntroduction and Importance to Google SheetsВидеоComprehensive Overview of Google SheetsВидеоAdvanced Features and Integrations of Google SheetsВидеоInstructions to Analyze Data Using Google SheetsВидеоSignifiance of Documentation in Conducting Data AnalysisВидеоReal-Time Collaboration Tools in Google SheetsВидеоLive ChatВидеоComments and AnnotationsВидеоTracking Changes with Google Sheets' Version HistoryВидеоQuiz on Getting Started with Google SheetsЗадание

Data Manipulation and Visualization

Manipulation of DataВидеоBasic Data Manipulation TasksВидеоData Manipulation Tools and Statistical Functions in Google SheetsВидеоPower of Regex in Data ManipulationВидеоCreating Tables for Data VisualizationЧтениеVisualization with ChartsЧтение
Quick RecapВидео
Prepare Analysis-Ready Data: Clean and Format Excel Data for Accurate Business InsightsDIALOGUE
Quiz on Data Cleaning and AnalysisЗадание
Assessment for Data Preparation in Microsoft ExcelЗадание
Role of Dashboards in Data VisualizationВидео
Strategic Role of Dashboards in Modern ManagementВидео
Dashboard Design: Audience Understanding, Simplicity, and Strategic VisualizationВидео
Creating Effective Dashboard DesignВидео
Creating Dynamic DashboardsЧтение
Quick RecapВидео
Analyzing Business Data with Advanced Excel Functions and DashboardsDIALOGUE
Quiz on PivotTables and DashboardsЗадание
Assessment for Advanced Excel Functions and AnalysisЗадание
Quick RecapВидео
Collaborate on Business Data: Analyze and Visualize Information with Google SheetsDIALOGUE
Quiz on Data Manipulation and VisualizationЗадание
Assessment for Google Sheets for Data AnalysisЗадание
Course-End ProjectЗадание