"
EXCEL - 2
Importing data and converting into table :-
Excel :-
Importing data
Converting into table
Ctrl + t or insert select table
There you get the table
Google Sheets :-
Upload file
File tab → import
In Google sheets you cannot do it at once you need to follow some steps
Select the whole page and go to the DATA tab and create a filter.
Alternate colouring for different shades of colour .
Freeze the column row.
Why convert data into a TABLE FORMAT ?
Creating tables in Excel offers several advantages and can significantly enhance your data management and analysis capabilities. Here are some key reasons why making tables in
Excel is important:
Structured Data:
Automatic Formatting:.
Dynamic Range:
Column Headers and Total Row:
Filtering and Sorting:.
Structured References:
Table Names:
Data Validation:
Slicers for PivotTables:
Data Relationships:
Built-in Formulas and Features:
In summary, creating tables in Excel offers a structured, dynamic, and user-friendly way to manage and analyse your data. Tables provide numerous features that enhance data organisation, readability, and analysis capabilities, ultimately improving your overall efficiency and accuracy when working with Excel datasets.
Table format ( colourful design of a table )
Excel ::- table formatting → ( use different design for the table )
Google Sheets :- format → Alternate colours ( use different colour design for the table )
Conditional formatting
Excel ::- Table Design tab → conditional formatting conditional formatting ( create your own condition as your want with your custom design)
Google Sheets :- FORMAT → conditional formatting ( create your own condition as your want with your custom design)
.
LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.
Follow me on this where every day will be added if i learn
something new about it :- https://dev.to/nitinbhatt46
THANK YOU
Top comments (0)