Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - CodePilot V5.0 C6
P. 28

    FLASH FILL                                                                   SHORT SIGN
                      Flash Fill automatically fills data based on the pattern you start

                      typing, helping to split, combine or format text like names and              To apply Flash Fill:
                      phone numbers.                                                                    Ctrl + E
                      To use the Flash Fill feature, follow the given steps:

                         3    Click on the Data tab.

                                                                                4    Select the Flash Fill option
                                                                               in the Data Tools group.

                                                               2    Type the pattern
                                                               you want to apply and
                                                               press the Enter key.

                        1    Enter the data in the columns adjacent to the
                         one where you want the pattern to be applied.

                      Excel will automatically fill in the remaining cells based on the pattern you started.

                                                                 Ask
                                                                           AGENT
                                                            OrangeAI
                        Create an Excel workbook with the names of Indians who have received a Nobel Prize in any field,
                        including columns for Name, Field and Year.

                               Study

                             CREATING CUSTOM LISTS

                      A custom list allows you to define your own series of data that can be used to automatically
                      fill cells.
                                                                         1    Click on the File tab.
                      To create a custom list, follow the given steps:

                                Fungi networks communicate
                              through complex systems, much
                              like how Excel connects different
                               data points across sheets and
                                        workbooks.

                                                                                   2    Select Options in
                                                                                   the Backstage view.

                       26
                            CodePilot (V5.0)-VI

| 23 24 25 26 27 28 29 30 31 32 33 |