Doing More with Excel Navigate to the Doing More with Excel Tutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.). Follow the directions next to each tutorial title....

1 answer below »
Doing More with Excel

Navigate to theDoing More with ExcelTutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.).Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well.Do not submit the assignment until the two files are attached. The documents you submit should look like the documents shown at the end of each Challenge.


25. Track Changes and Comments – Review the tutorial.


26. Inspecting and Protecting Workbooks -Review the tutorial.


27. Intro to PivotTables- Save the Challenge! Practice Document as YourUsername_PivotTable and attach to assignment. (10 points)


28. Doing More with PivotTables - Save the Challenge! Practice Document as YourUsername_PivotTable2 and attach to assignment. (10 points)


29. What-If Analysis - Review the tutorial.





Answered Same DaySep 15, 2021

Answer To: Doing More with Excel Navigate to the Doing More with Excel Tutorials using this...

Angel K answered on Sep 15 2021
147 Votes
excel_inspectprotect_practice.xlsx
Agenda Planner
                        Event:        Team-Building Retreat
                        Location:        Waverly Point Nature Preserve
                        Date:        August
                                        AGENDA PLANNER
        Start        End        Length        Item        Facilitator
        8:00 AM        9:00 AM        1:00        Breakfas
t, welcome        Exec team
        9:00 AM        9:30 AM        0:30        Introduction        Garth
        9:30 AM        10:30 AM        1:00        Work relationships exercise        Garth, Dean, Liz
        10:30 AM        10:45 AM        0:15        Break
        10:45 AM        12:45 PM        2:00        Cady Falls hike (strategy game?)        Liz, Julia
        12:45 PM        1:45 PM        1:00        Lunch (with strategy game team)
        1:45 PM        2:00 PM        0:15        Strategy debrief        Julia
        2:00 PM        3:00 PM        1:00        Getting to know your team        See Liz for info
        3:00 PM        4:00 PM        1:00        Strengths exercise        Garth
        4:00 PM        4:30 PM        0:30        Break/snack        Wayne
        4:00 PM        5:00 PM        1:00        Redwoods hike
        5:00 PM        6:00 PM        1:00        Team-building exercise        Garth, exec team
        7:00 PM        8:00 PM        1:00        Dinner
        Total                11:30
Challenge
        Order #        Customer Name        Item Description        Order Total        Phone Number
        139        Seferian Wilkes        6" Double Layer Chocolate Cake        $15.45        555-248-1756
        394        Marla Gaston        10" White Cake with Chocolate Icing        $17.25        555-122-9875
        219        Juan Ricardo        15" Dutch Apple Pie        $9.56        555-398-2839
        150        Andrejz Gorecki        6" Double Layer Chocolate Cake        $15.45        555-486-5387
        265        Sing Lu        10" French Silk Pie        $8.87        555-336-2576
        123        Devesh Assaf        15" Dutch Apple Pie        $9.56        555-765-9874
        108        Jerry Cranston        10" Chocolate Cake with Espresso Icing        $19.87        555-132-1472
        298        Mariela Lopes        6" Double Layer Chocolate Cake        $15.45        555-987-2315
        304        Linda Steinwater        12" Spice Cake with Maple Icing        $16.75        555-423-3572
        203        Archibald Grant        10" French Silk Pie        $8.87        555-865-2834
excel_intropivottables_practice.xlsx
1st Quarter Sales
        Salesperson        Region        Account        Order Amount        Month
        Albertson, Kathy        East        29386        $925.00        January
        Albertson, Kathy        East        74830        $875.00        February
        Albertson, Kathy        East        90099        $500.00        February
        Albertson, Kathy        East        74830        $350.00        March
        Brennan, Michael        West        82853        $400.00        January
        Brennan, Michael        West        72949        $850.00        January
        Brennan, Michael        West        90044        $1,500.00        January
        Brennan, Michael        West        82853        $550.00        February
        Brennan, Michael        West        72949        $400.00        March
        Davis, William        South        55223        $235.00        February
        Davis, William        South        10354        $850.00        January
        Davis, William        South        50192        $600.00        March
        Davis, William        South        27589        $250.00        January
        Dumlao, Richard        West        67275        $400.00        January
        Dumlao,...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here