9. [Date and Time Exercise] | Microsoft Excel Formulas | Educator.com

Mathematics
No. of
Lectures
Duration
(hrs:min)
High School Level
Basic Math
Mary Pyo, M.A.
80
35:18
Pre Algebra
Nancy Fung, M.Ed.
62
19:30
Algebra I
Eric Smith
61
18:58
Algebra I
Dr. Carleen Eaton, M.D.
63
22:45
Algebra II
Dr. Carleen Eaton, M.D.
72
34:11
Geometry
Mary Pyo, M.A.
89
58:08
Trigonometry
Dr. William Murray, Ph.D.
23
15:23
Precalculus
Prof. Vincent Selhorst-Jones
89
58:54
Math Analysis
Prof. Vincent Selhorst-Jones
89
58:54
AP Calculus AB
Prof. Raffi Hovasapian
66
44:00
AP Calculus BC
Prof. John Zhu, M.B.A.
33
8:39
AP Statistics
Prof. Sandahl Nelson
18
15:04
No. of
Lectures
Duration
(hrs:min)
College / University Level
Gen. Statistics
Dr. Ji Son, Ph.D.
49
36:33
Gen. Statistics
Dr. Philip Yates, Ph.D.
44
16:23
Probability
Dr. William Murray, Ph.D.
35
30:47
College Calculus: Level I
Dr. Jenny Switkes, Ph.D.
39
15:13
College Calculus: Level II
Dr. William Murray, Ph.D.
23
12:09
Multivariable Calculus
Prof. Raffi Hovasapian
43
23:37
Linear Algebra
Prof. Raffi Hovasapian
34
23:32
Differential Equations
Dr. William Murray, Ph.D.
30
26:33
Science
No. of
Lectures
Duration
(hrs:min)
Chemistry
General Chemistry
Dr. Franklin Ow, Ph.D.
24
16:21
Gen. Chemistry
Dr. Harold Goldwhite, Ph.D.
34
35:20
AP Chemistry
Prof. Raffi Hovasapian
70
60:26
Biochemistry
Prof. Raffi Hovasapian
63
46:39
Organic Chemistry
Dr. Laurie Starkey, Ph.D.
42
54:03
Organic Chemistry Lab
Dr. Laurie Starkey, Ph.D.
16
17:07
Physical Chemistry
Prof. Raffi Hovasapian
93
67:52
Physics
Physics – High School (Theory & Application)
Prof. Vincent Selhorst-Jones, M.F.A.
34
22:46
AP Physics 1 & 2
Prof. Dan Fullerton, M.S.
92
24:35
AP Physics C: Mechanics
Prof. Dan Fullerton, M.S.
29
15:28
AP Physics C: Electricity & Magnetism
Prof. Dan Fullerton, M.S.
26
14:27
AP Physics B
Dr. Radi Jishi, Ph.D.
35
86:03
AP Physics C: Mechanics
Dr. Radi Jishi, Ph.D.
40
48:11
AP Physics C: Electricity Magnetism
Dr. Radi Jishi, Ph.D.
32
41:08
No. of
Lectures
Duration
(hrs:min)
Biology
Life Science (Middle School)
Nehlia McIntyre, M.Ed.
34
12:36
Regular Biology
California Regents
69
21:01
Anatomy & Physiology
Prof. Bryan Cardella, M.Ed.
27
19:01
General Biology
Prof. Bryan Cardella, M.Ed.
37
24:56
AP Biology
Dr. Carleen Eaton, M.D.
60
55:40
AP Environmental Science
Prof. Bryan Cardella, M.Ed.
29
23:21
Microbiology
Dr. Catherine Carpenter, Ph.D.
44
20:01
Molecular Biology
Dr. Michael Philips, Ph.D.
14
14:49
Psychology
Intro to Psychology
Prof. Michael Wheeler
31
12:04
AP Psychology
Charles Schallhorn, M.Ed.
68
39:04
View all courses
AP US History
Prof. Elizabeth Turro
63
48:20
AP World History
Prof. Ronald Schooler
70
37:05
Programming
No. of
Lectures
Duration
(hrs:min)
HTML Training
Prof. Brenton Strine, M.S.
20
9:14
HTML 5
Prof. Jim Hague, M.S.
30
6:49
Intro to Ruby Programming
Prof. Justin Mui
22
11:24
Web Design & E-Commerce
Prof. Steven Echavarria, M.S.
18
8:36
Introduction to C++
Prof. Alvin Sylvain, M.S.
16
9:20
Intermediate Level C++
Prof. Alvin Sylvain, M.S.
16
12:30
CSS Intro
Prof. Brenton Strine, M.S.
23
12:20
Java
Prof. Maury Hillstrom, M.S.
10
5:30
AP CompSci: Intro to Java
Prof. Tom Quayle, M.S.
25
12:34
JavaScript
Prof. Maury Hillstrom, M.S.
10
5:54
Introduction to PHP
Prof. Matthew M., M.Eng.
42
22:47
Advanced PHP Training w/ mySQL
Prof. Matthew M., M.Eng.
47
23:43
C#
Prof. John Snape
59
23:49
Visual Basic
Prof. John Snape
62
26:29
XML Training
Prof. Scott Anderson, M.S.
15
4:34
Software Training
No. of
Lectures
Duration
(hrs:min)
QuickBooks (How-To Guide)
Prof. Aaron Woolley
25
8:29
MATLAB
Prof. Arash Vafanejad
28
5:46
Excel Power Query
Bryan Hong
12
3:12
Excel VLOOKUP Fundamentals
Bryan Hong
6
1:13
Microsoft Excel Formulas
Bryan Hong
18
0:51
Microsoft Excel Keyboard Shortcuts
Bryan Hong
6
0:20
Microsoft OneNote
Bryan Hong
14
0:55
Microsoft Outlook Fundamentals
Bryan Hong
10
0:31
Microsoft Power BI
Bryan Hong
6
1:34
Microsoft PowerPoint Fundamentals
Bryan Hong
10
0:23
Microsoft Teams
Bryan Hong
11
1:32
Microsoft Word Fundamentals
Bryan Hong
10
0:27
SQL - Master SQL Database Queries
Bryan Hong
14
1:38
Zoom - Master Video Conferencing
Bryan Hong
9
0:37
No. of
Lectures
Duration
(hrs:min)
Adobe Dreamweaver CC
Prof. Candyce Mairs (Adobe Certified)
152
22:32
Adobe Dreamweaver CS6
Prof. Candyce Mairs (Adobe Certified)
132
18:50
Adobe Photoshop CS6
Prof. Michael Brown (Adobe Certified)
59
19:21
Photoshop Designs to Code
Prof. Candyce Mairs (Adobe Certified)
55
6:55
Edge Animate CC
Chris Grover
66
6:10
jQuery Mobile
Prof. Candyce Mairs (Adobe Certified)
52
5:25
Adobe Illustrator CS6
Prof. Howard Simpson
20
7:31
Adobe Premiere Pro CS6
Prof. John Snape (Adobe Certified)
29
15:25
Adobe Premiere Elements 11
Prof. John Snape (Adobe Certified)
15
6:36
ColdFusion 9
Prof. Candyce Mairs (Adobe Certified)
38
4:15
ColdFusion 9: Application Framework
Prof. Candyce Mairs (Adobe Certified)
40
4:55
Fireworks CS6: Web Workflow
Prof. Candyce Mairs (Adobe Certified)
43
4:19
Adobe Photoshop Elements 11
Prof. Michael Brown (Adobe Certified)
47
15:51
Adobe, Apple, Sibelius, Wordpress and other corporate brand names and logos are registered trademarks of their respective owners.
Language
No. of
Lectures
Duration
(hrs:min)
English Language
English Grammar
Prof. Rebekah Hendershot
32
8:55
Advanced English Grammar
Prof. Rebekah Hendershot
28
6:01
English Composition
Prof. Joel Gonzaga
32
11:18
Application Essays
Prof. Rebekah Hendershot
10
2:28
AP English Language & Composition
Prof. Rebekah Hendershot
28
6:38
AP English Literature & Composition
Prof. Rebekah Hendershot
35
18:14
Shakespeare: Plays & Sonnets
Prof. Rebekah Hendershot
17
7:16
Reading Comprehension
Prof. Joel Gonzaga
29
7:13
Spanish Language
AP Spanish
Prof. Patricia Ponce de Leon
18
9:58
Art & Music
No. of
Lectures
Duration
(hrs:min)
Art & Music
AP Studio Art 2-D
Jessica Spinella
21
3:46
Music Theory
Music Composition
Prof. Laura Ryan, M.A.
20
9:31
Music Theory
Prof. Laura Ryan, M.A.
27
10:56
Music History & Appreciation
Dr. Cory Hills
29
7:22
Music Production
Learn Piano for Beatmakers and Producers
Riley Weller (GratuiTous)
25
2:07
FL Studio Beginners Course
Riley Weller (GratuiTous)
19
4:13
Essential Gear Needed to Make Beats
Riley Weller (GratuiTous)
19
2:09
Advanced Music Production Secrets
Riley Weller (GratuiTous)
29
2:41
FL Studio Intermediate Course
Riley Weller (GratuiTous)
17
4:35
Song Structure and Arrangement Music Course
Riley Weller (GratuiTous)
15
2:29
Foundational Drum Loop Basics
Riley Weller (GratuiTous)
6
2:40
Sample Your Own Music
Riley Weller (GratuiTous)
5
0:34
A Specific Music Production Folder
Riley Weller (GratuiTous)
8
0:58
No. of
Lectures
Duration
(hrs:min)
Creating Organic Beats
Riley Weller (GratuiTous)
24
1:33
How to Use EQ Effectively In Your Songs
Riley Weller (GratuiTous)
27
2:52
Why Do We Producers Use Audio Compression
Riley Weller (GratuiTous)
20
2:23
How to Release a Professional Beat Tape
Riley Weller (GratuiTous)
26
4:26
Music Theory and Chords for Beatmakers
Riley Weller (GratuiTous)
9
1:50
FL Studio Mixer Workflow
Riley Weller (GratuiTous)
15
2:11
Safe Spots: Create Amazing Drum Loops
Riley Weller (GratuiTous)
10
1:10
Musical Rhythms
Riley Weller (GratuiTous)
13
1:27
AP & Test Prep
No. of
Lectures
Duration
(hrs:min)
AP (Advanced Placement)
AP US History
Prof. Elizabeth Turro
63
48:20
AP World History
Prof. Ronald Schooler
70
37:05
AP Language and Composition
Prof. Rebekah Hendershot
28
6:38
AP English Literature & Composition
Prof. Rebekah Hendershot
35
18:14
AP Studio Art 2-D
Jessica Spinella
21
3:46
AP Spanish
Prof. Patricia Ponce de Leon
18
9:58
No. of
Lectures
Duration
(hrs:min)
AP (Advanced Placement)
AP Psychology
Charles Schallhorn, M.Ed.
68
39:04
AP Biology
Dr. Carleen Eaton, M.D.
60
55:40
AP Chemistry
Prof. Raffi Hovasapian
70
60:26
AP Physics 1 & 2
Prof. Dan Fullerton, M.S.
92
24:35
AP Physics B
Dr. Radi Jishi, Ph.D.
35
86:03
AP Physics C: Mechanics
Prof. Dan Fullerton, M.S.
29
15:28
AP Physics C: Electricity/Magnetism
Prof. Dan Fullerton, M.S.
26
14:27
AP Physics C: Mechanics
Dr. Radi Jishi, Ph.D.
40
48:11
AP Physics C: Electricity/Magnetism
Dr. Radi Jishi, Ph.D.
32
41:08
AP Computer Science
Prof. Tom Quayle, M.S.
25
12:34
AP Environmental Science
Prof. Bryan Cardella, M.Ed.
29
23:21
AP Calculus AB
Prof. Raffi Hovasapian
66
44:00
AP Calculus BC
Prof. John Zhu, M.B.A.
33
8:39
AP Statistics
Prof. Sandahl Nelson
18
15:04
Test names are the registered trademarks of their respective owners.
Said owners are not affiliated with Educator.com.

Start learning today, and be successful in your academic & professional career. Start Today!

Table of Contents

Section 1: Excel Formulas Introduction

Getting the most of the course

57s

Section 2: Top 50 Excel Formulas

Text

7m 53s

Text Exercise

21s

Text Exercise (answers)

1m 9s

Mathematical

4m 2s

Math Exercise (answers)

1m 1s

Math Exercise

16s

Date and Time

5m 5s

Date and Time Exercise

17s

Date and Time Exercise (answers)

1m

Logic

12m 20s

Logic Exercise

16s

Logic Exercise (answers)

41s

Financial

5m 54s

Financial Exercise

14s

Financial Exercise (answers)

2m 15s

Informational

3m 59s

Informational Exercise

41s

Informational Exercise (answers)

1m 26s

Loading...

This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of Microsoft Excel Formulas

Next Lecture

Previous Lecture

Discussion
Table of Contents

Please login to ask a question and view discussion.

Start Learning Now

Our free lessons will get you started (Adobe Flash^® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

Unlimited access to our entire library of courses.
Search and jump to exactly what you want to learn.
*Ask questions and get answers from the community and our teachers!
Practice questions with step-by-step solutions.
Download lesson files for programming and software training practice.
Track your course viewing progress.
Download lecture slides for taking notes.
Learn at your own pace... anytime, anywhere!

Microsoft Excel Formulas

Section 1: Excel Formulas Introduction
	Getting the most of the course		0:57
Section 2: Top 50 Excel Formulas
	Text		7:53
	Text Exercise		0:21
	Text Exercise (answers)		1:09
	Mathematical		4:02
	Math Exercise (answers)		1:01
	Math Exercise		0:16
	Date and Time		5:05
	Date and Time Exercise		0:17
	Date and Time Exercise (answers)		1:00
	Logic		12:20
	Logic Exercise		0:16
	Logic Exercise (answers)		0:41
	Financial		5:54
	Financial Exercise		0:14
	Financial Exercise (answers)		2:15
	Informational		3:59
	Informational Exercise		0:41
	Informational Exercise (answers)		1:26

© 2021 Educator, Inc. All Rights Reserved.
Terms of Service
Privacy
Course Index

Educator®

Please sign in to participate in this lecture discussion.

Sign-In

Sign in with Google

OR

Resetting Your Password?

Membership Overview

Available 24/7. Unlimited Access to Our Entire Library.

Over 100+ comprehensive high school, college, and university courses taught by passionate educators.
Searchable Lessons

All lessons are segmented into easily searchable and digestible parts. This is to save you time.
Get Answers & Community Support

Ask lesson questions and our educators will answer it.
Downloadable Lecture Notes

Save time by downloading readily available lectures notes. Download, print, and study with them!
Study Guides, Worksheets and Extra Example Lessons

Practice makes perfect!

Create Account

Sign up using Google

OR

I agree to the Terms of Service

OR

Activate Account

Start Learning Now

Our free lessons will get you started (Adobe Flash^® required).
Get immediate access to our entire library.

Membership Overview

Available 24/7. Unlimited Access to Our Entire Library.
Search and jump to exactly what you want to learn.
*Ask questions and get answers from the community and our teachers!
Practice questions with step-by-step solutions.
Download lecture slides for taking notes.
Track your course viewing progress.
Accessible anytime, anywhere with our Android and iOS apps.