Webinar: How to Select and Search Effectively in Excel

Entrada núm: 19 of 21 de la serie Análisis de datos

Date: Friday 28th, March 2014; Time:18:30 Madrid (Spain); Duration: 35′

Contents

  • Basic techniques and keyboard shortcuts for selecting cells and areas in an Excel spreadsheet.
  • In-depth examination of Find and select: options and possibilities.
  • VBA code examples for selecting cells and areas on a spreadsheet.

Although Excel is natively well suited for most selection and search tasks, there are still some areas where improvement is possible. For instance when we have to select non-contiguous cells or areas, based on cell content. The SelectEX Add-In can come in very handy for such tasks, and save a lot of labour that would include extensive use of sheet formulas and conditional formatting. Also, we don’t want our Excel file to grow unnecessarily in size.

elect effectively in Excel

Download SelectEx Demo

SelectEX V001 ESP Webinar
SelectEX V001 ESP Webinar
20140322_SelectEX_V001_ESP_Webinar.zip
Version: 001
146.6 KiB
72 Downloads
Details

Exploring The Limits of Excel

Exploring The Limits of Excel

Exploring the limits of Excel is a survey trip to the boundaries of the most widely used spreadsheet software: Microsoft Excel. The book deals with the differences between actual Excel limits and claimed Excel errors, studying and analyzing Excel’s performance in extreme cases according to three complementary points of view: structural limits, operational limits and VBA limits.

 

Series Navigation<< Seminario sobre selecciones, búsquedas y desplazamientos en ExcelSeminario sobre auditoría de fórmulas >>

Comments

So empty here ... leave a comment!

Deja tu comentario aquí:

Sidebar



A %d blogueros les gusta esto: