Course Start Date
Credits
Learning Format
Duration
Course fee
Overview
This course is part of the Applied Business Analytics Certificate. Learn more about the certificate here.
This course covers advanced Excel skills using an applied focus on different types of decisions one may analyze using spreadsheet capabilities; graphs and charts to communicate complex analytics; pivot tables to slice and dice data for reporting; what-if analysis for forecasting and predictive analysis. Students will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets and leverage Excel’s advanced functionalities
CIS 105 Computer Applications and Information Technology is strongly suggested as a prerequisite for success in this course.
To be successful in this course, we recommend English language fluency and computer literacy. Knowledge of basic mathematical & problem-solving skills is recommended.
Microsoft Excel is required for this course and not provided by ASU.
What you'll learn
- Calculate with advanced functions and formulas
- Organize worksheet, workbook and table data using a variety of techniques
- Create and modify charts and graphs
- Customize and enhance workbooks using graphic objects and data tools
- 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
- Manipulate and analyze data to make appropriate recommendations for managerial decision making
- Deploy advanced techniques to increase productivity and improve efficiency by streamlining workflow
Exams and grading
58%
Interactive Assignments
13%
Quizzes
29%
Exams
Talk To Our Admissions Counselors Now!
REGISTRATION DETAILS
REGISTRATION PROCESS WITH LEXTORAH
The application process consists of four simple steps. An offer of admission will be made to the selected candidates and accepted by the candidates by paying the admission fee.
Step 1
Register to begin the process
Step 2
Once eligible, make payment and receive access
Step 3
Enrol & start your course
Step 4
Receive credits & transcript
Step 5
Earn admission into ASU
LEXTORAH ADVANTAGE
Discount
Get further discounts when you apply through Lextorah
Self-paced
Start anytime and learn at your pace
Transfer Request
We assist with transferring credits to other university if you chose not to apply to ASU
Dedicated Student Success team,
academic support from experts in all courses, plus unlimited on-demand tutoring in all math + writing courses.
FREQUENTLY ASKED QUESTIONS
Accelerated College Courses (ACC) are freshman-level courses developed by ASU faculty and can count towards a variety of majors from engineering to business. Through this program, students can earn transferable ASU credit from anywhere in the world. All credits earned will apply to ASU and any accepting university. Courses are taken online and open to everyone, from High school leaners to high school leavers to adult leaners. No application fee, transcript or SAT, TOEFL, IELTS required to start the program.
Lecture walkthroughs that help you create files to complete assignments, videos, quizzes, and examsn
This course appears on your transcript identically to how it appears on the transcript of an enrolled ASU student who has taken the course on one of ASU’s campuses. Course attendance dates will be listed on your transcript. A self paced course will appear on your transcript in the session you complete the course.
This course satisfies 3 credit hours at Arizona State University. It is strongly encouraged that you consult with your institution of choice to determine how these credits will be applied to their degree requirements prior to transferring your credit.
Typically you can take this from the 11th grade or after completing your 12th. No SAT, TOEFL or IELTS is required to take this course.
Unlike most things that sound too good to be true, this is for real. Students can save more than 50% on their college education with Lextorah. For students enrolled in the accelerated courses, courses start at $125 per credit. With tuition over 50% less than the the average US school, AC maximizes students’ financial aid and education benefits.
Students can transfer their credits to the school of their choice and save over $20,000 on their way to a bachelor’s degree vs. the national average 4-year tuition. (Source: IES/NCES Digest 2021 Table 330.10)
Or students can opt to take one course at a time at $125 per college credit
Our team has been working tirelessly to build a product that will make world-class education more equitable and more accessible, and change the way people define excellent education.
For AC, all students age 14 or older with at least a high school diploma, SSCE, or equivalent are eligible to apply.
For our courses and certificates, you must be 14 or older and willing to commit yourself academically to enroll.
Students in any of our programs should be ready for the academic rigor of college-level coursework. Be sure to pick the right program for your ability, time commitment, and long-term goals.
Yes, you’ll be able to complete courses anywhere in the universe with Wi-Fi and a laptop or desktop computer. Check the technical requirement page for what you will need to be able to participate in any of our courses.
We work with trusted partners to ensure you get real, accredited credit for the courses and degree programs you take with us. Plus, we offer support in transferring credits to your next institution if you’d like. Lextorah-earned college credits have successfully transferred to hundreds of institutions, including Harvard, NYU, and many more.
For courses taken as part of the accelerated program, you’ll receive 3 credits per course from Arizona State University, among the top 10% highest quality colleges in the US and accredited by the Western Association of Schools and Colleges (Source: College Factual).
The cost is $375 per course, for now. We’re committed to keeping costs low for students, but can’t guarantee this introductory price forever. Don’t miss this chance to learn the world’s best online courses for 80% less than the average college course
We recommend that you dedicate 15-20 hours a week to complete the course with flying colours.
Required credit hours: Learners under 22 complete 24 credit hours, and those 22 or older only need to complete 12 credit hours with a 2.75 GPA or higher.
Click the Register Now button on the course page and fill out the form. Our Admissions Counselor will get in touch as soon as possible.
You’ll meet the aptitude requirements for general university admission when you complete your required courses with a 2.75 GPA or higher. If you’re under 22, you’ll need to complete 24 credit hours, if you’re 22 or older you’ll only need to complete 12 credit hours. If you have submitted an application and all required materials to ASU, you’ll be eligible for admission.
Please note, learners cannot earn admission while still enrolled in high school
If you are not interested in pursuing your studies at ASU, no problem! You’ll have a transcript you can provide to any university that accepts ASU credits.