# Automating Excel Tasks Where You Will Learn About One Another Valuable And Powerful Excel Tool Macros

### Question Description

This week we look at Chapter 10 Level 3: Automating Excel Tasks where you will learn about one another valuable and powerful Excel tool – Macros.

Macros are tools to automate Excel processes to help ensure error-free and efficient worksheets.

Use the Chapter # 10 – Videos presentation to see the videos if you prefer.

Assignment

Part A:

Read the Chapter Introduction and Case Scenario on page 606. Read it very carefully. It is important that you clearly understand what the Chapter material is all about – otherwise you will just be putting numbers in cells.

Part B:

1. Study (LEARN) the material covered in Level 3: Automating Excel Tasks on pages 647 to 661. The CH10 Level 3 Figures.xlsx file in Blackboard Lectures (Student Data Files Chapter 10) replicates all the Figures in this section so you can easily follow along with the textbook discussions.

2. PRACTICE what you learned in the first part by completing the Steps to Success: Level 3 exercise starting on page 662. The starting workbook: DailyList.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 10).

The result file Name should be 7-1- DailyList_Monday.xlsm

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

3. APPLY what you have learned to a new business marketing situation by completing the Level 3 Case Problem: Projected Sales and Commissions for CKG Auto on page 667 of your textbook. The starting workbook Sales.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 10)

The result file Name should be 7-2- July Sales.xlsm.xlsm

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

4. Write a short essay on what you have learned and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR RVIEW AND GRADING (10 POINTS).

A Power Point review of Chapter 10 is posted in Lectures

==================================================================

Let me know if there is anything you don’t understand — the earlier the better.

The solution files that you need to attach are:

7-1-DailyList-Monday.xlsx

7-2- July Sales.xlsm.xlsm

7-Essay-Week7-YourName.docx (With the short essays on what you learned in each Level)

Get 20% Discount on The assignment
Pages (550 words)
Approximate price: -

Try it now!

## Get 20% Discount on The Assignment

We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

EssayBrill has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

## Essay Writing Services

At EssayBrill, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.