20 Everyday Excel Formulas

Learn how to use 20 Excel formulas that will help you to save time and deliver on your tasks more efficiently.

20 Everyday Excel Formulas

Learn how to use 20 Excel formulas that will help you to save time and deliver on your tasks more efficiently.
79
views
1
Save
Share the link to this page
Copied

About the Class

This course is  targeted at all levels of users, from all works of life. If you're a beginner, follow each lesson in the listed order. If you're an experienced user you can navigate to your desired lesson. There are practical lessons at the end to test some of the lessons you have learned and a couple of tests are also included after sections. These lessons cut across all fields of endeavor whether you are a secretary, a data analyst, accountant, business manager, or perhaps you're a job seeker looking to develop skills to improve your CV. 

What will you learn in this course?

  • Introduction to Excel
  • Basic arithmetic tasks
  • Math template using addition, subtraction, multiplication, and division
  • Inserting and deleting rows and columns
  • Deleting cell contents
  • Undo, Redo function
  • Using cut, copy and paste
  • Optimizing paste functions
  • Using sort and filter
  • Linking sheets
  • Formatting cells and content
  • Date formatting
  • Creating tables
  • Pivot tables- beginner
  • Concatenate function
  • Find and replace function
  • Using the proper function
  • Countif
  • Using the VLOOKUP function
  • Using IF function
  • Using SUMIF function

Author

Akadamart

School

Segun Ekeleme's School

Requirements

There are no additional requirements.
One-time Fee
$19.99
€18.63
£15.98
CA$27.34
A$30.62
S$27.17
HK$156.49
CHF 18.25
NOK kr218.89
DKK kr139.02
NZ$33.55
د.إ73.42
৳2,190.73
₹1,665.69
RM95.50
₦25,327.72
₨5,557.40
฿740.14
₺649.73
B$102.89
R380.08
Лв36.46
₩27,473.33
₪75.88
₱1,155.25
¥3,109.35
MX$340.93
QR72.80
P276.85
KSh2,688.65
E£957.44
ብር1,135.01
Kz16,741.62
CLP$19,044.07
CN¥144.84
RD$1,173.99
DA2,685.29
FJ$45.81
Q155.16
GY$4,178.63
ISK kr2,797.80
DH202.56
L356.04
ден1,148.26
MOP$161.07
N$382.78
C$734.71
रु2,660.97
S/74.05
K75.88
SAR74.97
ZK521.49
L92.75
Kč469.63
Ft7,315.99
SEK kr217.16
ARS$17,456.10
Bs137.94
COP$77,796.30
₡10,012.36
L492.76
₲148,289.05
$U766.61
zł80.42

What's Included

Language: English
Level: All levels
Skills: Complex Tasks, Time Management, Excel, Linking Sheets, Accuracy
Age groups: All ages
Duration: 1 hour 35 minutes
21 Videos
4 Documents
1
Save
79
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.