-1+1263 
Advanced Training on Microsoft Excel

The course covers a comprehensive range of excel concept starting with basic and fundamental excel functions and features to the advanced concepts and applications. Hence my request to the participants is not to just focus on understanding the examples covered but try and develop the thought process so that they can apply the learning in their day-to-day educational and career life.

The Target audience is anyone and everyone who falls in the below list

  1. Using or planning to use calculators or other calculating device
  2. Graduate or post-graduate students from any streams
  3. Working professionals from any department specially Finance, HR, Marketing, Operations, Supply Chain
  4. Business people or self-employed professionals especially CAs, Consultants or any other stream where data is inevitable

While all of the functions covered here might not be relevant for you immediately it is good to know these functions so that whenever need arises we know the best way to do it.

Course URL: http://www.elearnmarkets.com/packages/index/advanced-training-on-microsoft-excel

Lectures
    no lectures added
Prerequisites
Syllabus

Chapter 1: Introduction

1 Introduction to Excel

2 Error Type

Chapter 2: Basic Formating

1 Basic Formating

Chapter 3: Text Function

1 Text Function

Chapter 4: Numeric Function

1 Numeric Function

2 Numeric Function

Chapter 5: Logical Functions

1 Logical Function I

2 Logical Function II

3 Logical Function I

4 Logical Function II

Chapter 6: Lookup

1 Lookup I

2 Lookup II

3 Lookup Functions

Chapter 7: Array

1 Array I

2 Array II

3 Array Function

Chapter 8: Data Function

1 Data Function I

2 Data Function II

3 Data Function III

4 Data Function IV

5 Data Function

Chapter 9: Pivot Table

1 Pivot Table Preview

Chapter 10: Circ Ref & Conditional Formatting

1 Circ Ref & Conditional Formatting

2 Circ Ref & Conditional Formatting

Chapter 11: Naming Cell or Arrays

1 Naming Cell or Arrays

2 Name Function

Chapter 12: Paste Special

1 Paste Special

Chapter 13: Go To & Excel Linkage

1 Go To & Excel Linkage

2 Go To & Excel Linkage

3 Sample Data Edit Links I

4 Sample Data Edit Links II

Chapter 14: Custom Format

1 Custom Format I

2 Custom Format II

3 Custom Format Number

Chapter 15: Date Function

1 Date Function I

2 Date Function II

3 Date Function

Chapter 16: Finance Function

1 Finance Function

2 Finance

Chapter 17: Excel Protection

1 Excel Protection

2 Protecting Cells I

3 Protecting Cells II

Chapter 18: Chart

1 Chart I

2 Chart II

3 Chart

Additional information

10+ Hrs of videos 18 Worksheets

Teacher qualifications

Mr. Varun Gupta has acquired more than 7 years of experience. He is conducting trainings, workshops and Seminars with Clients and Internal teams for M&A solutions and offerings and having very good knowledge and hands on experience in Excel. He has done his Post Graduate Diploma in Management from Xavier Institute of Management, Bhubaneswar (XIMB) and is a chartered accountant all India 48th rank and passed CFA Level-3 in 2012.

Latest Update

none

Roster
1. elearnmarkets
2. Zeapis
3. storeytime
4. Olliesmith90
5. Yvje
6. Jane
7. p0richa
8. hazemm
9. miruku-miruku
10. wangb
11. kaitmorano
12. tarisilalahi
13. Nicholasjiv
14. Dysana
15. sunnydong
16. Greg.Dablju
17. thuylinhpmt
18. thefunofit
19. technamix
20. f4string
21. cwenzinger
22. seanplive
23. nanacammie
24. gakaty
25. OfficialFluttershy
26. NavyNick
27. rembranded
28. Muhammad313
29. yomna
30. iaintnoforrestgump
31. sreedevi.vijaykumar
32. Mothership9
33. harryle
34. PDA
35. miriam_speidel
36. PGS707
37. YagamiLawliet
38. JessR
39. wewillsolvethesky
40. shnksahu
41. AndresSegovia
42. Agarwalshinchan
43. apocrypha13142
44. TLawrence0811
45. szimelis
46. muhammedumeir
47. rassie1982
48. anunez
49. pm043001
50. amytbusch
51. muzz_adaf
52. TLJ86
53. sfolger
54. _DK_
55. marinotchka
56. ginaroznovat
57. butts420streetlamp
58. adarsh_shukie12
59. pandoobus
60. gammy
61. RandyDouglas11
62. alihussaini.syedshah
63. mithwyn
64. dnenov
65. nguyentm99
66. nshapir1
67. Smalls32
68. tschi127
69. makell01
70. Phil64
71. maxekmek
72. Richard.Deckard
73. punslayer2
74. imnotthepanda
75. jjmolina3
76. kreigos
77. jsiu1248
78. mtanne86
79. ekaeth
80. amberk22
81. tbmonkey
82. rmane
83. Madoka
84. beach_gal
85. jiggu87
86. p3t3r.tnie
87. alabee
88. lovelylady1245
89. rafiulalam0777
90. timothy1egion
91. riderist
92. jraymay
93. shankar
94. mmathew
95. Tain33
96. Apeiron91
97. ajoliat
98. mtschill
99. gbadkid95
100. msonali
101. Donnual
102. breezeblocks
103. Alexandria.Doney
104. glurrgh
105. grobota
106. Shxxu0212
107. jithinjk
108. xetari
109. jshone
110. stonedsun
111. TheJennaverse
112. Jsmarcelin
113. acmmoore
114. irinadoro
115. Sharliemt
116. JonSnowStark
117. easyriderftw
118. blaaahmcblaahington
119. Roxana0474
120. en-fleigo
121. murrayhi
122. enicon
123. haWtonTatENdSon
124. neenaj
125. mhimai
126. Dnsteph-18
127. Drew502
128. Michel_MentheChocolat
129. LeQuebecer
130. ksimp126
131. top12gun
132. ErinF.
133. eveddin
134. the1theycallmonk
135. kmy1225
136. gmanb96
137. swechchha
138. bourbonfueld
139. rachau01
140. slpeach
141. Swaggertrains
142. alexb1373
143. R.W.G
144. rajatshrinet
145. aspt
146. euphorialive
147. Understandcarrot
148. Shan
149. Cjmclean17
150. joyofthelannisters
151. nelagrigorean
152. Tmrws_Ldrs
153. abcurtis13
154. SmallestGoon
155. AIMBoss
156. drkitty
157. Bambie10490
158. whittaker123
159. Susieqk04
160. shrutir58
161. Raghu
162. denizmartin
163. Bella-T
164. 0siris0
165. DasNasty
166. Nicoleweber2025
167. ashleyhicks1030
168. rsims123
169. sharkquakenadoo
170. Grghanna
171. caitread
172. berkkara34
173. mcpatton
174. pattycake29488
175. sodainmycereal
176. killerpasta
177. okehinde2013
178. HouseJug
179. NAZEERAERO
180. mchaidez
181. qpod
182. geoful
183. jfran97
184. Srikar
185. EJAZ123
186. News
187. xaxa0107
188. Farrazz
189. eulb42
190. jennifuretc
191. bresek
192. ginabrock12
193. dutzanu
194. brich90
195. Arjun271
196. rlogan27
197. bryanc86
198. groverinri
199. B3serrano
200. i_love_bearss
201. Sunilcam
202. mrroc
203. Jempress01
204. aimee.mohr
205. MandiF
206. ihsaga9
207. rhaverlock
208. Clarice30
209. sudhirbhat
210. dragoon_balloon
211. andrealval94
212. henryugbekile
213. fragmonk3y
214. RebeccaThompson
215. naomimfalila
216. baylor2016
217. cause
218. Bmaria
219. egb12b
220. Shantalle
221. sem
222. Aleeakadk
223. the_path_i_chose
224. Genaegon
225. jwa99
226. pmihaela11
227. seanlimjh
228. replogal
229. jcast56
230. Anneth
231. h.jehou
232. kristenality
233. juberjack
234. TBLIXXXY
235. diviniti
236. engkantadah
237. Abhinav_Agnihotri
238. saraesmaili
239. M.renegads
240. Marrexx
241. Ckdolan
242. arango_lucia
243. noela304
244. Azharsuni
245. Jadams0617
246. Cranberriesandpecans
247. carmen0851
248. Schizocosa3
249. bigbadblue
250. Lauramb95
251. PattyCakes
252. chancebd7
253. crabbington
254. makerwal
255. JMeara275
256. bizayansi
257. n78045
258. json492
259. tjrourke
260. wanastacio
261. mmurp36
262. jaidgossamer
263. SaloNeel
264. carternicola
265. tanjaks
266. Reecev
267. jessicals93
268. sh6
269. lexyg1721
270. deannad72
271. jaznajenyns
272. CristianAMironescu
273. lillystats
274. sorryitsari
275. dragonwulfe
276. bellexxfemme
277. Sschley
278. babybestbelieve
279. crowarrowinc
280. tara2389
281. manena
282. cuencorhea
283. bukar
284. bukar
285. Anj2017
286. sharmav996
287. kittymao02
288. ruleit
289. NewBromide
290. waterpolofred
291. Finlayallana
292. Nesrocko