Working with Cells and Sheets

Introduction to working with cells and sheets

1. Introduction to working with cells and sheets.mp4

Write data in a cell

2. Write data in a cell.mp4

Change the format of a cell

3. Change the format of a cell.mp4

Setup automatic formatting of cells

4. Set up automatic formatting of cells.mp4

Insert new rows

5. Insert new rows.mp4

Insert new columns

6. Insert new columns.mp4

Freeze or unfreeze rows and columns

7. Freeze or unfreeze rows and columns.mp4

Insert and delete individual cells

8. Insert and delete individual cells.mp4

Sort your data

9. Sort your data.mp4

Filter your data

10. Filter your data.mp4

Insert a new sheet

11. Insert a new sheet.mp4

Rename a specific sheet

12. Rename a specific sheet.mp4

Hide or unhide a sheet

13. Hide or unhide a sheet.mp4

Protect sheets and ranges from being edited

14. Protect sheets and ranges from being edited.mp4

Remove gridlines in sheets, charts and graphs

15. Remove gridlines in sheets, charts, and graphs.mp4

Prevent invalid data entry

16. Prevent invalid data entry.mp4

Import data and spreadsheets

17. Import data and spreadsheets.mp4

Split pasted text into separate columns

18. Split pasted text into separate columns.mp4

Save, reuse, and share filters

19. Save, reuse, and share filters.mp4

Filter data by condition

20. Filter data by condition.mp4

Create an in-cell dropdown list

21. Create an In-cell Dropdown List.mp4

Automate tasks with macros

22. Automate tasks with macros.mp4

Edit your macros

23. Edit your macros.mp4