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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Excel Basics for Beginners: Workbooks, Formatting, Charts and Core Skills · LearnSpace
Назад в каталог
courseraАнализ данных

Excel Basics for Beginners: Workbooks, Formatting, Charts and Core Skills

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

О курсе

Unlock the power of Excel—your gateway to smarter data management and analysis. • Microsoft Excel is the world’s most widely used spreadsheet tool, relied on by over 750 million users globally. Whether you're managing budgets, tracking inventory, or preparing reports, Excel is a must-have skill across industries. • Excel proficiency is one of the top 5 most requested skills in job postings across business, finance, and operations roles. Learning Excel basics boosts productivity and opens doors to data-driven decision-making. We help you get started quickly. Career Impact • Around 82% of business analyst roles require Excel • Entry-level professionals with Excel skills on average can earn up to 15% more (according to launch • Excel is foundational for careers in data, finance, and admin What You’ll Learn • Navigate the Excel interface and create workbooks • Organize, sort, and filter data using tables and formulas • Apply formatting and build charts to visualize insights What Makes This Course Unique ✅ Designed for true beginners—no prior Excel experience needed ✅ Bite-sized lessons with hands-on practice using real datasets ✅ Learn in just 90 minutes with focused, interactive modules ✅ Builds a foundation for advanced Excel and Power BI courses ✅ Includes downloadable practice files and auto-graded assignments Who Should Take This Course • Students and recent graduates building job-ready skills • Business professionals across roles in operations, sales, and support • Small business owners and retail managers • Anyone ready to start working with data confidently This course is intended as the first in a specialization of three courses—beginning with building basic data literacy skills in Excel and culminating with building data literacy in Power BI through our course "From Excel to Power BI." Start your Excel journey today and transform how you work with data—one cell at a time. *Please note: A Microsoft 365 subscription is required to access all features used in this course.*

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

Data ScienceProject ManagementData ProcessingOrganizational SkillsData PresentationProductivity SoftwareFinancial AnalysisCustomer Data ManagementEvent PlanningRecord KeepingProductivityData EntryMarketing PlanningData ManagementBusiness IntelligenceBusiness AnalyticsMicrosoft 365

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

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

01Get Started with Workbook Basics11 материалов

Lesson: Launch Excel and Jump into Building Your First Workbook

Intro: Get Started with Workbook BasicsВидеоNavigate the Excel Application InterfaceВидеоOpen a New Blank WorkbookВидеоEnter Data in a CellВидеоSave a New File

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

Keith Gibson

CEO

Excel Basics for Beginners: Workbooks, Formatting, Charts and Core Skills
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 1.7 ч

3 модулей

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

Субтитры: Арабский, Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Казахский, Венгерский

Часть программы вашего университета
Видео
Check-In: Review Excel and Workbook BasicsЗадание

Lesson: Format and Organize Your Data

Change the Number FormatВидеоFormat the Text as Bold, Italic, or UnderlinedВидеоSort DataВидеоFilter DataВидеоGive It a Try: Enter and Format Data in a WorkbookЗадание
02Work with Data Using Functions and Tables18 материалов

Lesson: Perform Basic Arithmetic and Aggregation Functions

Intro: Work with Data Using Formulas, Functions, and TablesВидеоCreate a FormulaВидеоAdd Cell Values Instantly with AutoSumВидеоUse the COUNT Function in ExcelВидеоCalculate Numerical Averages in Excel ВидеоReading: Common Formula Errors and What They MeanЧтениеCheck-In: Review Working with Data Using Basic Formulas and FunctionsЗадание

Lesson: Apply Statistical and Conditional Functions

Use the MAX Function in ExcelВидеоUse the MIN Function in ExcelВидеоGive It a Try: Work with Statistical FunctionsЗаданиеUse the IF Function ВидеоGive It a Try: Work with Conditional FunctionsЗадание

Lesson: Perform Counting Functions

Add the Numbers Based on One Condition Using SUMIFВидеоCount Cells with Specific Criteria Using COUNTIFВидеоUse the SUMIFS FunctionВидеоUse the COUNTIFS Function ВидеоCheck-In: Review Working with Counting FunctionsЗаданиеReading: Excel Operators GuideЧтение
03Make Data Presentable with Charts and Formatting12 материалов

Lesson: Organize and Structure Data

Intro: Make Data Presentable with Charts and FormattingВидеоRemove Duplicate ValuesВидеоFreeze the Panes to Lock Specific Rows or ColumnsВидеоSplit Panes in a WorksheetВидеоCreate a Table ВидеоGive It a Try: Streamline Your DatasetЗадание

Lesson: Visualize and Highlight Data

Create a ChartВидеоApply Conditional Formatting to CellsВидеоFormat the Cells by Using a Two-Color ScaleВидеоWhich Chart Tells Your Story Best?DIALOGUEGive It a Try: Highlight Important Data in Your Workbook ЗаданиеCheck-In: Review Data Visualization BasicsЗадание