6 Ways to Make Excel Easier to Work With

[bhasan01854]

Microsoft Excel is the main tool of a Digital specialist. It can be used to simplify work with large amounts of data and automate work tasks: collecting semantics, preparing an advertising campaign or compiling a report on data from Yandex.Direct, Google Ads and other systems.

Valeria Fedotova, an online advertising specialist at E-Promo, shared life hacks that can help you reduce the time it takes to complete routine tasks when working with spreadsheets.

Hot keys
Let's start with the simplest and look at the most unusual hot keys and scenarios for their use.

Alt+=
Launch the "autosum" function. We calculate the sum of values ​​from a range of cells without entering a formula. Convenient if you need to quickly calculate the sum in a range of cells

Shift+F9
Recalculates all existing formulas on office 365 database the open sheet. This can be useful if calculations in your document are done manually rather than automatically. Speeds up work with large data.

CTRL + G


Find and select → Go

Selecting a range of visible cells — fill in data ranges in a table with a filter set without errors. A great way to make sure that data is not stretched into unnecessary cells. Use for grouping keywords.

Selecting empty cells - getting rid of empty cells or checking if all the necessary cells are filled. We use it to clean search queries, collect semantics.