5 Essential Excel Tips for Beginners 

Filtering data Adding dynamic header/footers Protect sheets and workbook Trace precedents Creating simple graphs

Filtering data

[{"selector":"#anim-0ede05ff-72f7-4d25-bcbe-750b263bee7d","keyframes":{"transform":["translate3d(-117.30104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-94338b94-c8a1-4666-bd9a-24359d425b7b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-42ef592a-a4be-4201-95b8-479fde0594a2","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b4094694-dfb6-450d-93ef-38ebd78a7a3a","keyframes":{"transform":["translate3d(-115.92356%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-46c25033-8c8a-4032-9dc3-908f9f7a815b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d384d00d-7138-46d7-8455-67b7ea6c2077","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Filtering allows users to view data based on criteria. Highlight data, click the funnel icon, and use dropdowns to filter or sort values.

Adding dynamic header/footers

[{"selector":"#anim-de3d52a3-7eb9-44ed-aa8f-e8d7892e3d1b","keyframes":{"transform":["translate3d(-113.62398%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1c934ba7-637f-4f67-b58c-b146ef965ce3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-40a9b0f3-b1cb-4284-bfaa-1fb07077174e","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-c2003786-bdb9-4d66-bd19-e87ff9481fa9","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-343170a9-6e1c-4f04-8104-600a993d8454","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8dd57cbd-50d5-446a-9a04-6c1ddcd21691","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Track printed Excel sheets by adding page numbers, timestamps, and file paths to header or footers with auto-update formulas. Use &[File], &[Tab], &[Page], &[Date].

Protect sheets and workbook

[{"selector":"#anim-e41a8c64-2e05-4b69-8019-13d1a03c73bb","keyframes":{"transform":["translate3d(-114.0056%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4bdeb70e-9244-4cad-94d9-ff7f0e66c891","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-487d476b-2e63-449f-85f8-2e2c54c91636","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-a4fc1745-c98b-4017-8e35-3560ef9d6c16","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4ef8347c-c1eb-45ae-84cd-032137c880cd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-78837057-beea-4014-80f6-ea62e7b1af61","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] To prevent users from editing a sheet, go to Review, click Protect Sheet, set a password, select allowed actions, and confirm.

Trace precedents

[{"selector":"#anim-4b0b893f-5943-413c-97a6-5497015702f4","keyframes":{"transform":["translate3d(-114.0056%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-418f1422-40a0-43d0-8d3f-c625036ab64f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-05c81031-bc19-4ba0-be83-a535e2df4098","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-ebffc4e6-c65d-49a1-a030-b2bb0c5fedec","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ba7d16ee-fb71-4d12-ba05-45addc45b961","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3704f081-dacd-465b-914a-7bbe26a5e82c","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Excel’s trace precedents and trace dependents tools show how cells are linked. They help track formulas, but work one cell at a time, with blue arrows indicating data flow.

Creating simple graphs

[{"selector":"#anim-06507903-dbec-41a9-a322-15c0cb9a12ac","keyframes":{"transform":["translate3d(-114.0056%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8abf52ee-91ec-42e6-903f-e7e01706c775","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-02a9d10d-10bf-4595-98b8-cba57804f88c","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-2ebb1d17-966f-463e-8f55-655a8de12fa1","keyframes":{"transform":["translate3d(-116.44736%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-61060732-e67b-431d-b60a-506b75fb0fb2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f2f66018-a760-4fc8-a15e-9b32125a2ef3","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Improve spreadsheet skills by using charts to simplify data. Select two sets, click Insert, choose a graph, and Excel does the rest.

Join our community on social media to stay informed about the latest news, engage in discussions, and connect with like-minded individuals.

[{"selector":"#anim-797a1223-5672-43b2-88b6-cce5d45c7053","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-4801f352-e1dc-43d8-998a-bc3bf2f714e4","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}]