Posts: 673
Threads: 35
Likes Received: 457 in 278 posts
Likes Given: 1,551
Joined: Jul 2020
(01-27-2022, 07:23 AM)MNomadic Wrote: Quick question for you "Excellerators," what kinds of grades did you get? Was an "A" achievable with the current state of the course and your pace?
Despite my fast pace, I ended up with a high A of 99.4% as my final grade. I typically got 1-2 wrong on my first attempt at the exercises and quizzes, then did a second attempt with a perfect score. I bombed the final excercise - that's why I suggest leaving that as the drop one. On the final exam I found myself very lost but managed to correctly deduce all but one of the answers anyway.
People without some programming experience and computer intuition are likely to get stuck in the last three units.
TESU Class of 2024 BSBA-CIS+GM, BSIT, ASNSM-CS+Math, AAS-GEN
Earned credits from Sophia, SDC, ASU ULC, TEEX, Microsoft, Strayer, TESU, Saylor, DSST, CLEP, CompTIA, StraighterLine, and others since starting in April 2020
Posts: 2,859
Threads: 143
Likes Received: 1,703 in 1,002 posts
Likes Given: 825
Joined: Jun 2017
Do you guys feel like you learned "advanced" excel skills? I took a spreadsheets class through WGU but would be interested to learn more the next time this course comes around.
WGU BSIT Complete January 2022
(77CU transferred in)(44/44CU )
RA(non WGU)(57cr)
JST/TESU Eval of NAVY Training(85/99cr)
The Institutes, TEEX, NFA(9cr): Ethics, Cyber 101/201/301, Safety
Sophia(60cr): 23 classes
Study.com(31cr): Eng105, Fin102, His108, LibSci101, Math104, Stat101, CS107, CS303, BUS107
CLEP(9cr): Intro Sociology 63 Intro Psych 61 US GOV 71
OD(12cr): Robotics, Cyber, Programming, Microecon
CSM(3cr)
Various IT/Cybersecurity Certifications from: CompTIA, Google, Microsoft, AWS, GIAC, LPI, IBM
CS Fund. MicroBachelor(3cr)
![[-]](https://www.degreeforum.net/mybb/images/collapse.png)
•
Posts: 673
Threads: 35
Likes Received: 457 in 278 posts
Likes Given: 1,551
Joined: Jul 2020
(01-27-2022, 02:21 PM)MNomadic Wrote: Do you guys feel like you learned "advanced" excel skills? I took a spreadsheets class through WGU but would be interested to learn more the next time this course comes around.
As I touched on in my review, I think the course is high on doing but light on learning. It exposes students to a good range of functions and situations, but often fails to build an understanding of them. The exercises merely instruct students to click on or type things, without explaining what is actually going on.
My grasp of Excel definitely improved, but I wouldn't recommend this course to anyone seriously wanting to learn Excel. Students with past spreadsheet instruction may find the earlier modules too basic and the later content too dense.
TESU Class of 2024 BSBA-CIS+GM, BSIT, ASNSM-CS+Math, AAS-GEN
Earned credits from Sophia, SDC, ASU ULC, TEEX, Microsoft, Strayer, TESU, Saylor, DSST, CLEP, CompTIA, StraighterLine, and others since starting in April 2020
The following 1 user Likes jch's post:1 user Likes jch's post
• Pikachu
Posts: 714
Threads: 18
Likes Received: 374 in 238 posts
Likes Given: 182
Joined: Jul 2016
(01-27-2022, 03:16 PM)jch Wrote: As I touched on in my review, I think the course is high on doing but light on learning. It exposes students to a good range of functions and situations, but often fails to build an understanding of them. The exercises merely instruct students to click on or type things, without explaining what is actually going on.
My grasp of Excel definitely improved, but I wouldn't recommend this course to anyone seriously wanting to learn Excel. Students with past spreadsheet instruction may find the earlier modules too basic and the later content too dense.
Would you be able to share the most "advanced" thing you learned? I'm an old hat at VLOOKUPs and Pivot Tables (not that I have a cert), but if there's something new to learn I'd pay $25 for something semi-official.
In Progress: MBA - HAUniv, Anticipated 2024
Completed: BSBA OpMgmt - TESU June 2021
UG - AP Tests: 20 credits | APICS: 12 Credits | CLEP: 6 credits | Saylor Academy: 6 credits | Sophia.org: 27 credits | Study.com: 12 credits | Davar Academy: 3 credits | TESU: 15 credits | Other College: 99.5 credits
GR - HAUniv: 9 credits
•
Posts: 673
Threads: 35
Likes Received: 457 in 278 posts
Likes Given: 1,551
Joined: Jul 2020
Beyond lookups and pivot tables, the course also touched on goal seek, solver, macros, visual basic, and file I/O.
TESU Class of 2024 BSBA-CIS+GM, BSIT, ASNSM-CS+Math, AAS-GEN
Earned credits from Sophia, SDC, ASU ULC, TEEX, Microsoft, Strayer, TESU, Saylor, DSST, CLEP, CompTIA, StraighterLine, and others since starting in April 2020
•
Posts: 11,060
Threads: 153
Likes Received: 6,010 in 4,001 posts
Likes Given: 4,215
Joined: Mar 2018
Reminder: you don't have to pay if you're doing it for personal knowledge and not credit.
In progress:
TESU - BA Computer Science; BSBA CIS; ASNSM Math & CS; ASBA
Completed:
Pierpont - AAS BOG
Sophia (so many), The Institutes (old), Study.com (5 courses)
ASU: Human Origins, Astronomy, Intro Health & Wellness, Western Civilization, Computer Appls & Info Technology, Intro Programming
Strayer: CIS175, CIS111, WRK100, MAT210
•
Posts: 13
Threads: 0
Likes Received: 10 in 5 posts
Likes Given: 5
Joined: Dec 2021
(01-27-2022, 02:21 PM)MNomadic Wrote: Do you guys feel like you learned "advanced" excel skills? I took a spreadsheets class through WGU but would be interested to learn more the next time this course comes around. I agree 100% with everything that jch said. I do not feel confident applying many of the Excel skills and topics on my own. The multiple choice questions are structured in such a way that a correct answer may not indicate understanding of the material. In that regard, the true/false questions were much better at assessing knowledge. The best would be having to type in our own responses.
I found the exercises to be mostly very easy. We were told which type of chart to make (and told where they appear in the choice menu, like first option, second row) with no explanation of how to analyze the type of data we have and when each type of chart works best.
The following 1 user Likes Ditto's post:1 user Likes Ditto's post
• jch
Posts: 1,846
Threads: 48
Likes Received: 467 in 310 posts
Likes Given: 291
Joined: Jun 2012
you can learn plenty of stuff from youtube
https://www.youtube.com/watch?v=kR6czKY4FEw
I'm pretty much an excel guru at work and i learned a lot from that video LOL
•
Posts: 13
Threads: 0
Likes Received: 10 in 5 posts
Likes Given: 5
Joined: Dec 2021
(01-27-2022, 07:04 PM)bluebooger Wrote: you can learn plenty of stuff from youtube
https://www.youtube.com/watch?v=kR6czKY4FEw
I'm pretty much an excel guru at work and i learned a lot from that video LOL I'm curious to know what you think of the course, as someone who uses Excel at work a lot.
•
Posts: 1,846
Threads: 48
Likes Received: 467 in 310 posts
Likes Given: 291
Joined: Jun 2012
if you're asking about the course on page one, thread one
the pdf says
● Calculate with advanced functions and formulas.
I'm guessing that's "if", "countif", sumif"
it is easy stuff
there are plenty of good websites for those
https://www.contextures.com/xlfunctions04.html
https://exceljet.net/formulas
● Organize worksheet, workbook and table data using a variety of techniques.
maybe that's dropdown lists and filters ?
https://www.contextures.com/exceldynamic...dlist.html
● Create and modify charts and graphs.
easy stuff
tons of videos on youtue
● Customize and enhance workbooks using graphic objects and data tools.
using charts and graphs with with filters, slicers and timelines ?
again, easy stuff
● Understand how businesses can utilize advanced spreadsheet analytical techniques using pivot tables, v-lookups, amortization and graphical data to better understand their business and customers.
do you know how make pivot tables do percentages and averages ?
do you know how to rearrange the rows and columns in a pivot so you can see the data you want in an ez to understand way ?
● Manipulate and analyze data to make appropriate recommendations for managerial decision making.
same as above, but maybe also give some ideas what to do with outliers and #N/A data (should you include those in your averages or not)
● Deploy advanced techniques to increase productivity and improve efficiency by streamlining workflow.
I can't deploy anything
ALL excel spreadhseets with vba code in them is locked out by the anti-virus software and hospital security settings
All ability to connect to SQL Server is locked out for the same reason
I can write my own stuff and make my charts and pivot tables, but then I have to save it to non-macro workbooks with all connections disabled
but that's what it probably means -- real time interactive dashboards that connect to one or more data sources and run vba code to update charts -- none of which I'm allowed to create and give to other people
I don't know how much this course costs, but you can figure out how to do almost anything on youtube
https://www.youtube.com/watch?v=UD9e-gQCQsE
https://www.youtube.com/watch?v=8g9DK5noi1s
https://www.youtube.com/watch?v=nOIEeUHyye0
https://www.youtube.com/watch?v=S9_COxQ-_8E
https://www.youtube.com/watch?v=m2C_-6PW6WE
https://www.youtube.com/watch?v=cnCvn6CmP2k
and on the mr excel forums https://www.mrexcel.com/board/forums/exc...stions.10/
and just try stuff out -- record a macro and then edit the vba by hand
step though it with the debugger and see what's going on
I am enrolled in wgu and did learn some stuff from the spreadsheets course, but i would never pay for an excel course - not even an inexpensive one on sale at udemy
i only did the excel course at wgu because its required
|
