+- Online Degrees and CLEP and DSST Exam Prep Discussion (https://www.degreeforum.net/mybb)
+-- Forum: Specific College Discussion (https://www.degreeforum.net/mybb/Forum-Specific-College-Discussion)
+--- Forum: General "Big 3", B&M colleges, and other colleges (https://www.degreeforum.net/mybb/Forum-General-Big-3-B-M-colleges-and-other-colleges)
+--- Thread: New ASU ULC: CIS 308: Advanced Excel in Business (/Thread-New-ASU-ULC-CIS-308-Advanced-Excel-in-Business)
New ASU ULC: CIS 308: Advanced Excel in Business - jch - 01-27-2022
(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.
RE: New ASU ULC: CIS 308: Advanced Excel in Business - MNomadic - 01-27-2022
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.
New ASU ULC: CIS 308: Advanced Excel in Business - jch - 01-27-2022
(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.
RE: New ASU ULC: CIS 308: Advanced Excel in Business - Flelm - 01-27-2022
(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.
New ASU ULC: CIS 308: Advanced Excel in Business - jch - 01-27-2022
Beyond lookups and pivot tables, the course also touched on goal seek, solver, macros, visual basic, and file I/O.
RE: New ASU ULC: CIS 308: Advanced Excel in Business - rachel83az - 01-27-2022
Reminder: you don't have to pay if you're doing it for personal knowledge and not credit.
RE: New ASU ULC: CIS 308: Advanced Excel in Business - Ditto - 01-27-2022
(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.
RE: New ASU ULC: CIS 308: Advanced Excel in Business - bluebooger - 01-27-2022
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
RE: New ASU ULC: CIS 308: Advanced Excel in Business - Ditto - 01-27-2022
(01-27-2022, 07:04 PM)bluebooger Wrote: you can learn plenty of stuff from youtubeI'm curious to know what you think of the course, as someone who uses Excel at work a lot.
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
RE: New ASU ULC: CIS 308: Advanced Excel in Business - bluebooger - 01-27-2022
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/exceldynamicfilteredlist.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/excel-questions.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