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

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

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

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

Everyday Excel, Part 1

Курс от University of Colorado Boulder
Начальный≈ 25.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools. This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

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

Spreadsheet SoftwareData ManagementData ValidationData Analysis SoftwareData SharingProblem SolvingExcel FormulasData IntegrityData VisualizationMicrosoft ExcelMicrosoft OfficePlot (Graphics)Data EntryData CleansingData Import/Export

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

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

01Getting Started with Excel28 материалов

Welcome!

Course Updates and Accessibility SupportЧтениеInstructor Introduction and Welcome!ВидеоCourse IntroductionВидеоMicrosoft 365 is Required for This CourseЧтение

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

Charlie Nuttelman

Teaching Professor

Everyday Excel, Part 1
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 25.1 ч

6 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
The Power of Microsoft ExcelЧтение

Introduction to Excel

Basic Features of ExcelВидеоSaving and Opening FilesВидео

Navigating the Worksheet

Sheets, Cells, Rows and Columns: Part 1ВидеоSheets, Cells, Rows and Columns: Part 2ВидеоMoving Around the WorksheetВидеоEditing the WorksheetВидео

Formatting Basics

Cell FormattingВидеоIntro to Conditional FormattingВидеоFormats for Numbers, Currency, Dates, and TimesВидеоThe Format PainterВидеоAuto Fill and Fill SeriesВидеоConditional FormattingПрограммирование

Cell Referencing Basics

Cell Addressing ModesВидеоCell RangesВидеоQualified ReferencesВидеоNaming Cells and Cell RangesВидеоMixed Cell ReferencesПрограммирование

Other Tricks

Excel is Smart!ВидеоSetting Preferences and Customizing ExcelВидео

Examples

OPTIONAL Example: Gantt ChartВидеоExample: Multiplication TableВидео

Module 1 Quiz

Module 1 QuizЗадание

What's Next?

Module 2 PreviewВидео
02Formulas and Functions21 материалов

Getting Started with Formulas

Excel Syntax and Order of OperationsВидеоTroubleshooting Excel FormulasВидеоIntroduction to Functions in Excel (Part 1)ВидеоIntroduction to Functions in Excel (Part 2)Видео

Popular Excel Functions

Counting BasicsВидеоTotals, Averages, Highs, and LowsВидеоRounding and RemaindersВидеоExamples: Rounding and RemaindersВидеоNesting: Using Functions Inside Other FunctionsВидеоIF and IFSВидеоAND and ORВидеоLogical Equivalents to the AND and OR FunctionsВидеоConditional Logic and Data SummariesПрограммирование

More Tools in the Toolbox

The XLOOKUP FunctionВидеоThe INDEX FunctionВидеоMATCH and XMATCHВидеоThe OFFSET FunctionВидеоLookup and Reference FunctionsПрограммирование

Guided Example

Example: Leap YearВидео

Module 2 Quiz

Module 2 QuizЗадание

What's Next?

Module 3 PreviewВидео
03Excel Tables, Data Validation, and Conditional Formatting16 материалов

Dynamic Named Ranges and Excel Tables

Making Named Ranges DynamicВидеоExcel TablesВидеоStructured ReferencesВидео

Data Validation

Data ValidationВидеоExample: Data Validation to Prevent DuplicatesВидеоDrop-Down Lists (Data Validation)ВидеоExample: Employee Time SheetsВидеоData ValidationПрограммирование

More on Conditional Formatting

Conditional Formatting Using a FormulaВидеоExample: Conditional Formatting for Financial ReconciliationВидеоCheckboxes in ExcelВидеоCheckboxes and Conditional FormattingПрограммирование

Guided Examples

Example: Key Performance IndicatorsВидеоExample: OrdersВидео

Module 3 Quiz

Module 3 QuizЗадание

What's Next?

Module 4 PreviewВидео
04Diving Deeper Into Excel Functions15 материалов

Logical Functions

Advanced Logical FunctionsВидеоDetermining if an Item is on a ListВидеоConditional AggregationПрограммирование

Illustrative Examples

Example: Credit Card LookupВидеоExample: Room Reservation Sign-UpВидео

Working with Text

Flash Fill: Advantages and DisadvantagesВидеоText Functions in Excel (Part 1)ВидеоText Functions in Excel (Part 2)ВидеоExample: Using the SEARCH FunctionВидеоThe TEXT FunctionВидеоText Functions and LookupsПрограммирование

Specialized Functions

Introduction to Excel's Financial FunctionsВидеоDate and Time FunctionsВидео

Module 4 Quiz

Module 4 QuizЗадание

What's Next?

Module 5 PreviewВидео
05Data Management15 материалов

Data Preparation

The Find and Select ToolВидеоApplying a FilterВидеоRemoving BlanksВидеоExample: Applying a FilterВидеоCleaning Your DataВидеоIdentifying DuplicatesВидеоRemoving DuplicatesВидео

Consolidating and Sorting Data

Consolidating DataВидеоSorting DataВидеоSorting by a ListВидеоExample: Sorting to Remove DuplicatesВидеоExample: Sorting by ColumnsВидео

Programming Assignments

Consolidating and Sorting DataПрограммированиеFiltering and Custom Sorting TasksПрограммирование

Module 5 Quiz

Module 5 QuizЗадание
06Data Visualization and Output18 материалов

Basic Plotting

Line GraphsВидеоScatter PlotsВидеоColumn and Pie ChartsВидеоTarget ChartsВидеоProgress ChartsВидеоSparklinesВидеоFor Fun: Importing Geographic InformationВидеоExample: Phone Number MapВидео

Dynamic Charts and Pivot Charts

Dynamic ChartsВидеоSlicersВидеоUsing Slicers for Dynamic Charts ВидеоIntroduction to Pivot Tables and Pivot ChartsВидеоExample: Slicer for Multiple SeriesВидеоExample: Using a Timeline with a Pivot ChartВидео

Output and Printing

Sharing Worksheets and Charts in Word and PowerPointВидеоPrinting Excel Worksheets and WorkbooksВидеоExample: Sales Invoice as PDF FileВидео

Module 6 Quiz

Module 6 QuizЗадание