Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New ASU ULC: CIS 308: Advanced Excel in Business
#51
(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
[-] The following 2 users Like jch's post:
  • MNomadic, Pikachu
Reply
#52
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)
Reply
#53
(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:
  • Pikachu
Reply
#54
(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
Reply
#55
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
Reply
#56
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
Reply
#57
(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:
  • jch
Reply
#58
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
Reply
#59
(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.
Reply
#60
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
[-] The following 1 user Likes bluebooger's post:
  • Pikachu
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  University of AZ: Are these 10-wk Business Analytics Cert Courses Worth the $? Claudia P 3 353 01-18-2024, 01:42 PM
Last Post: Tomas
  TAMUC - Sophia advanced hours telldomis 3 552 01-11-2024, 01:08 AM
Last Post: bjcheung77
  Completion of PUG IT Excel Track in One Term - Capstone Duration Inquiry AdamLunar 11 1,043 09-27-2023, 02:22 PM
Last Post: walruspanda
  Nichols College BS in Business Administration karehiro 25 3,349 04-02-2023, 02:27 PM
Last Post: JPN
  (Not free) ECTS in Business, Philosophy, and more rachel83az 1 1,016 09-21-2022, 12:18 PM
Last Post: bjcheung77
  ASU ULC MAT 210 - Brief Calculus: Calculus for Business and Economics jsd 16 2,192 05-23-2022, 03:12 PM
Last Post: jsd
Information ASU adds a new class: CIS 405 Business Intelligence(Bus. Cert now available) MNomadic 3 1,541 05-01-2022, 10:35 PM
Last Post: bjcheung77
  Fastest/Cheapest Way to get a Business Marketing Degree Kevmock 13 1,907 11-18-2021, 12:27 PM
Last Post: bjcheung77
Thumbs Up Teesside University - BA in Business and Enterprise (£4,620, 1 year, Online!) nomaduser 0 957 01-08-2021, 06:46 AM
Last Post: nomaduser
Lightbulb Purdue University Global - IT - Excel Track cyberjosh95 14 4,147 11-02-2020, 01:26 PM
Last Post: ss20ts

Forum Jump:


Users browsing this thread: 1 Guest(s)