Excel Intermediate - Data Filtering, Sorting, Searching

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 5 lectures (2h 16m) | Size: 942.6 MB

Excel is not going anywhere, and businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company picnics.

Data Filtering, Sorting, Searching, Editing And Extraction

Data Editing

Data Searching

VLookUps

CountIf formula

Beginner - Intermediate Excel Users

INTERMEDIATE - DATA FILTERING, SORTING, SEARCHING EDITING AND EXTRACTION



A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. It takes a savvy computer user to take advantage of everything Excel has to offer to provide the best results for their company.

Need to make informed decisions but feeling overwhelmed with too much information to get through Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.

The objective of this session is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information. To achieve this, we will cover the following topics:

· Data Editing

o Sorting

o Filtering

o Conditional formatting

o Data validation

o Subtotal formula

o Find and replace

· Data Searching

o Searching within filter

o Searching within sheet

o VLookUps

o CountIf formula

o If statements

o Basic Data Extraction

o Flash fill

o Text-to-Columns

o Concatenate.

Entry Level to Intermediate Level Users




DOWNLOAD
uploadgig.com

https://uploadgig.com/file/download/fbdbbf91D2b0Ce96/195p4Ctz__Excel_Inte.part1.rar
https://uploadgig.com/file/download/450e6c0c18651Ba7/195p4Ctz__Excel_Inte.part2.rar

rapidgator.net

https://rapidgator.net/file/d6e90fdddc49d53db3f86352abf8dbe5/195p4Ctz__Excel_Inte.part1.rar.html
https://rapidgator.net/file/4a54f22f3251e1e424eefb97f5e45ff4/195p4Ctz__Excel_Inte.part2.rar.html

nitro.download

https://nitro.download/view/711328E6B0EC53F/195p4Ctz__Excel_Inte.part1.rar
https://nitro.download/view/B2E64307B0CFD3E/195p4Ctz__Excel_Inte.part2.rar