Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New ASU ULC: CIS 308: Advanced Excel in Business
#61
(01-27-2022, 10:25 PM)bluebooger Wrote: 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
This was helpful. Thank you.
Reply
#62
This transferred to TESU as CIS-399 Special Topics in Computer Info Sys. They didn't classify it as a spreadsheet course as some people feared. It went into the CIS AoS electives in my BSBA-CIS on the 20-21 catalog
Done: TESU ASNSM-CS
Almost done: TESU BSBA-CIS+GM
In Progress: TESU BS-Cybersecurity + BTM Cybersecurity, ASNSM-Math
Earned credits from Sophia, ASU ULC, TEEX, Microsoft, Strayer, TESU, Saylor, DSST, CLEP, CompTIA, and others since starting in April 2020
[-] The following 3 users Like jch's post:
  • doom, MNomadic, rachel83az
Reply
#63
jch Wrote:This transferred to TESU as CIS-399 Special Topics in Computer Info Sys. They didn't classify it as a spreadsheet course as some people feared. It went into the CIS AoS electives in my BSBA-CIS on the 20-21 catalog

That's awesome, it's a great course to add into the CIS AOS and will count towards the RA requirements as well! If only they offered the $25 registration and the $99/course tuition fee again, I'll be all over those CIS and other offerings at ASU (EA) Universal Learner...
In Progress: Walden MBA | TESU BA Biology & Computer Science
The Basic Approach | Plans | DegreeForum Community Supported Wiki
~Note~ Read/Review forum posts & Wiki Links to Sample Degree Plans

Completed: TESU ASNSM Biology, BSBA (ACBSP Accredited 2017)
Universidad Isabel I: ENEB MBA, Big Data & BI, Digital Marketing & E-Commerce
Certs: 6Sigma/Lean/Scrum, ITIL | Cisco, CompTIA, MTA | Coursera & Udacity
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  ASU ULC MAT 210 - Brief Calculus: Calculus for Business and Economics jsd 16 402 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 583 05-01-2022, 10:35 PM
Last Post: bjcheung77
  Nichols College BS in Business Administration karehiro 11 689 01-18-2022, 05:20 PM
Last Post: dfrecore
  Fastest/Cheapest Way to get a Business Marketing Degree Kevmock 13 862 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 637 01-08-2021, 06:46 AM
Last Post: nomaduser
  Statistics and business statistics request for BSBA cecilgambe7 2 544 07-22-2020, 07:49 AM
Last Post: LongRoad
  COSC, TESU, Excelsior Business Capstone Comparison Acam10 0 703 05-12-2020, 07:18 PM
Last Post: Acam10
  Is a business degree "practical" from the Big 3? TonyaBay 2 735 03-08-2019, 09:59 PM
Last Post: ronaldemail1

Forum Jump:


Users browsing this thread: 1 Guest(s)