-1+1292 
Power Pivot for the Excel user

Powerpivot for the Excel user is an online Microsoft Power Pivot tutor, written by an Accountant, focusing on beginner to advanced Power pivot skills tailored to suit the needs of both individuals (business owners, professionals, employees) and businesses (corporate).

Lectures
  1. Power Pivot for the Excel user

    Get a free Demo of this course and all our other courses by registering with The Professional Training Academy

Prerequisites

Excel knowledge

Syllabus

Time required to complete course and CPD hours/credits allocated - 6 hours

Chapter 1 Installing Powerpivot Import Data From Access Import Data From Custom Query Import Data From Excel Import Data From Txt File Saving Your File Chapter 1 Review 2 Working With Tables Relationships Calculated Columns Insert Pivot Table Insert Pivot Charts Slicers Chapter 2 Review 3 Understand Measures Creating Measures Chapter 3 Review 4 Dax An Introduction X Functions And Countrows Related And Related Tables Filter & Distince Calculate Function Chapter 4 Review 5 Time Intelligence Functions 1 Time Intelligence Functions 2 Chapter 5 Review

Additional information

Online course can be accessed any where any time - use the contact us form and request a discount

Teacher qualifications

CPA

Latest Update

none

Roster
1. proftraining
2. def30
3. gartac
4. thisismygame
5. ivers17872
6. Marionfrey
7. jwhathaway
8. kevinchoi
9. abrushing
10. jamalson
11. aamirazeem
12. asholic
13. pseaguy
14. My0hMy
15. penischarles
16. g0bananas
17. lioness818
18. Tongya_Kupana
19. gomezjrs
20. burninho
21. gscharanraju
22. Alixxr
23. donramses
24. Joshthejumperman
25. shwets
26. nrosie
27. TawnyPigeon
28. mmmarshawnlynch
29. officiallyme
30. smack
31. omniv
32. Mak
33. pvtfawkes
34. dhudzin
35. likevenice
36. WarmBro
37. fongkongtsoi
38. NMBobblehead
39. beansjr
40. ChaoticHavok
41. EXICON
42. elevenidiots
43. liamjmc
44. azzarel3
45. doongbuggy
46. ncastell77
47. Hapes
48. ryustreetfighter
49. ohh_no
50. viper1092
51. hundredacrewood
52. johnbak
53. BlueJadeLei
54. silly_lion
55. casemath21
56. frenken
57. lionheart21
58. sabazio
59. rebol2n
60. spurned1
61. obi_juan_shinobi
62. luttappi
63. phantazmadroidz
64. ravi4chahal
65. shahsali
66. alizonkiel
67. dylanb
68. Axlrize
69. cdasilva
70. nveed23
71. treeson
72. GeauxldenPP7
73. thanhthong
74. missy8995
75. thepurplesky
76. murphymj
77. sheikhbarabas
78. bluebox44
79. Cest_La_v
80. flemindk
81. corycruse
82. icameforthemusic
83. Rutski71
84. captmkg
85. Yossarian0022
86. bontist
87. Skender
88. rtadoyle
89. jnnfrdickson
90. DeDodgingEse
91. Tony116
92. MXVII
93. flannelbananna
94. buddia
95. ckj06
96. asaxena11
97. bhope3
98. pokAtok
99. jaendress
100. nglrossi
101. Fuzzybeard
102. navinuttam
103. lookingforsome
104. Hopeless-Wanderer
105. MaturaiX
106. ericqespiritu
107. SteveB526
108. joeeb22
109. Tapetfjes
110. chaitanya26
111. sidhrth
112. georgeman007
113. deapolis
114. Shazam4991
115. tdmckee
116. mixedrice
117. bamboocrush
118. alanaim
119. dougal6
120. aGrainOfSalt
121. lildre
122. blasphemerr
123. Rakinbade
124. williska
125. vm5valerie
126. Hbizzle
127. ctrengove
128. admiralgeneral
129. Chicabonita8
130. jamibacker
131. ecNate
132. tricolored_mantaray
133. jamesglen25
134. jatkins7629
135. renegadegenius
136. jillian
137. chishokl
138. royarmstrongmustang
139. kazekami13
140. bs01395n
141. poolsaregreatforholdingwater
142. mattellio
143. jecri
144. beaubc
145. Outlandish_Minn
146. prototype7live
147. cindyvincent
148. eliegirl
149. namangus
150. Fdjaynes
151. wogboy101
152. ficar
153. ineptsage
154. Groblox
155. Teddypost
156. makeitwain
157. NF11
158. myreprise
159. jpage1989
160. tikiman6
161. up678050
162. nathanseitz
163. majortennis
164. vau43
165. auszooker
166. mistuhg
167. suwatsuwat
168. longgoodknight
169. THEADMININTHEDARK
170. olds0ul
171. TangoDestroyer
172. mnqcbrrs
173. mad5675
174. rs332602
175. midnyght219
176. guillefras
177. meadammatthews
178. wblxcskier
179. tereeves
180. ringob82
181. mightyblackstar
182. jone7up
183. araose
184. NerdyNella
185. scottsen
186. pookeye
187. fluxium
188. kateroo
189. Alsbet
190. VeniVidiDimmitui
191. athenstiger
192. shord143
193. Shankspony
194. brentshermana
195. NicoJuicy
196. probst.jon
197. bamadude66
198. DamnyouMongarians
199. vlad82
200. tpkalman
201. timlovelock
202. Chromaburn
203. jjjvanloon
204. chanheelee
205. Melkotnia
206. smallbusinesspage
207. xhulja
208. rifche
209. linkz
210. needlearn
211. Bloodrazor
212. lisak67
213. avuman
214. L2BSmart
215. jlarez
216. brucemilus
217. californiagrapin
218. eliams
219. happybanana
220. somethiax
221. thirstin4more
222. harukaze1337
223. MACROS
224. rony_995
225. Peroviendo
226. ayush1018
227. johnnl4
228. remington
229. Skidie
230. pegasusx47a
231. ConradKilroy
232. givesyoulink
233. battlebug
234. Janette
235. Ahmedjaber
236. jessiechew
237. rhodes_54
238. dirtdart504
239. ilovelampalot
240. typopsi
241. xiaoqbighunny
242. Joklom
243. thephotograph
244. intro_VERT13
245. nawalster
246. lihab
247. danyalamriben
248. ssd532
249. iamsurbhi
250. vansmend
251. andy2ndlife
252. redbrigadier
253. bbmacarthur
254. crichm03
255. Sergeivlasov47
256. RicoSpartan
257. Djohnnok
258. Swu4us
259. lakshmij441
260. jesparzachau
261. buguoruci
262. mb4113593
263. tmascia
264. ucfgavin
265. Bnealis
266. MACROS14
267. crewguy35
268. thecrazyboyftw
269. da.amaya483
270. vineetverma
271. -dOuOb-
272. MrEtherBunny
273. The3rdIcon
274. renamshah
275. freeallbeings
276. naveen988
277. jbabs
278. samannay
279. Joka999
280. pendragon03
281. AfricanLandcruiser
282. ilhanca
283. lionvan
284. neibrewer
285. megadarkfriend
286. Antoaneta
287. wolfieCK
288. blt24
289. mickthemaniac
290. Theguybehindthescreen
291. hallac
292. sagyourjeans
293. fauxhemian5
294. burtgervis
295. dirtysmalls
296. vincentmakreel
297. thethirdtrappist
298. parrotchutes
299. sunfisches
300. Ozziemedes
301. stronggarya
302. Usagi
303. MatthewBailey
304. blake_simons
305. Alisher
306. Ishwari
307. dreadman86
308. Ajnanin
309. asingh21
310. kohilak
311. Bohemiandan
312. joemegill2
313. dipep
314. skapetis
315. alyss228
316. djk4800
317. sidhant.nayak
318. geezusfreak
319. g4r7h
320. Jelica
321. roarora
322. startupankur
323. gitsebas
324. mrmack00
325. smilingodessa
326. add
327. mherndon
328. kdlynch12
329. mozturk
330. mantrasuser
331. fezspinkguitar
332. mlebot
333. mattmottola
334. slangdon
335. sersdf
336. NX25
337. elijah10
338. _hondaaccord1996
339. Demented30
340. ddruger
341. aphodite
342. dguerrero1
343. Jody-Husky