Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - logicode 2609 C6
P. 31

    ADVANCED FEATURES                                                                        CHAPTER

                     OF EXCEL 2021                                                                              3

                                                                                Topics Covered                      95%

                                                                                   Charts
                                                                                   Advantages of Charts
                                   Dear Aadya,  you  have performed                Components of a Chart
                                   calculations  using  functions  and             Types of Charts
                                   formulas pretty well.                           Creating a Chart
                                                                                   Changing Chart Type
                                                                                   Setting the Data Range
                                                                                   Moving and Resizing the Chart
                                                                                   Changing Background of the Chart
                                                                                   SUM()
                          Yes, Techie! I really enjoyed                            IF()
                                                                                   Sorting Data in Excel
                       learning to apply formulas and                              Filtering Data in Excel
                                    functions in Excel.                            Conditional Formatting

                                    Now you will learn about a topic that will help you arrange data in the form of
                                    charts.

                                               But Techie, what is the use of creating charts in Excel?

                                    Dear Aadya, data can be arranged in form of charts so that we can view and
                                    analyse it from various perspectives.  What are we waiting for! Let’s learn to create
                                    charts in Excel.

                                                                                        Advanced Features of Excel 2021   29

| 26 27 28 29 30 31 32 33 34 35 36 |