- Personalizando un Icono
- Mostrando Todos los Elementos al Escoger de un Menú
- Utilizando Paneles de Tareas
- Reduciendo el Área Utilizada en una Hoja
- Ocultando las Líneas de División en el Monitor y al Imprimir
- Dando Color a las Líneas de División
- Permitiendo a Múltiples Usuarios Editar Rangos Predeterminados
- Protegiendo Datos Ocultando una Fila(s) y Columna(s)
- Ocultando/Desocultando una Fila(s) o Columna(s)
- Haciendo que una Celda sea la Primera en la Ventana Activa
- Aumentando/Disminuyendo el Porcentaje de Aumento de la Pantalla
- Viendo Datos Seleccionados en una Hoja
- Imprimiendo Comentarios de Celda
- Borrando Todos los Comentarios de Celda en una Hoja
- Copiando un Comentario de Celda
- Cambiando el Formato Predeterminado del Comentario de Celda
- Cambiando el Nombre del Autor del Comentario de Celda
- Quitando el Indicador de Etiqueta Inteligente
- Vinculando una Celda a un Cuadro de Texto
- Usando la Validación de Mensaje Entrante como un Comentario de Celda
- Usando una Imagen para Ver Valores de Celda en Otras Hojas
- Agregando Datos, Tablas, u Otra Información al Comentario de una Celda
- Ver Información de la Celda a la Distancia
- Símbolos Utilizados para Crear un Formato Personalizado
- Mostrando Cifras Redondeadas a Miles en un Reporte Financiero
- Copiando Estilos de un Libro a Otro
- Creando y Guardando Estilos Predeterminados
- Cambiando el Estilo Predeterminado
- Redondeando Números a Millones con Miles como Decimal
- Redondeando Números a Millones
- Redondeando Números a Miles con Centésimas como Decimales
- Usando la Función Redondear para Redondear Números a Miles
- Redondeando números en miles
- Reemplazando Ceros con signos “-“ en el Formato Numérico
- Símbolos Utilizados para Crear un Formato Personalizado
- Automatizando la Inserción del Símbolo Euro
- Insertando Símbolos Especiales en Formatos Personalizados
- Colorear las Filas Pares Numeradas en una Lista
- Coloreando un Registro en Cada Grupo en un Rango
- Coloreando Números Según un Criterio Específico
- ”Desprender” Paletas desde la Barra de Herramientas
- Cambiando un Encabezado Numérico a Texto
- Coloreando Números Según un Criterio Específico Utilizando Formato Condicional
- Cambiar el Formato de la Celda de Fecha a Número
- Dividiendo el Primer Título Superior Izquierdo
- Previniendo el Desborde de Texto
- Agregando un Método Abreviado para Ajuste de Texto
- Ajustando Manualmente el Texto en una Celda
- Ajustando Automáticamente el Texto en una Celda
- Cambiar la Sangría en una Celda
- Combinar y Centrar con un Botón de Cambio en Excel 2002 y Excel 2003
- Ocultando la Visualización de los Valores Cero
- Cambiando la Fuente Estándar
- Copiando el Formato
- Mostrando el Cuadro de Diálogo de Formato de Celdas
- Buscando/Buscando y Reemplazando en una Hoja o en Todas las Hojas
- Transponiendo Celdas
- Validando Datos de Texto
- Validando Datos Numéricos
- Previniendo Duplicados Mientras se Ingresan Datos
- Entrada Rápida de Texto en Celdas desde una Lista Previa de Entradas o Lista de Validación
- Prevenir Moverse a la Siguiente Celda Después de Escribir
- Copiando/Moviendo una Celda (o Celdas) entre Hojas/Libros de Trabajo
- Copiando el Contenido de Celdas a través de Hojas
- Copiando y Pegando el Contenido de Celdas Conservando el Formato
- Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
- Insertando una Celda(s) sin Sobrescribir Datos Existentes
- Pegando Múltiples Rangos Copiados Utilizando el Porta Papeles
- Copiando y Pegando el Contenido de una Celda en Miles de Celdas
- Copiando y Pegando Rápido a la Derecha o Debajo en una Lista
- Copiando y Pegando Rápido en Celdas Adyacentes
- Copiando, Cortando y Pegando (Mover)
- Agregando un Método Abreviado Personalizado
- Moviéndose Entre Libros de Trabajo Abiertos
- Seleccionar una Hoja de una Lista de Hojas Ordenadas
- Seleccionar una Hoja en el Libro
- Seleccionando Rápido un Rango en un Libro
- Seleccionando Todas las Celdas de la Hoja
- Moviéndose entre Celdas no Protegidas en una Hoja Protegida
- Seleccionando Celdas desde Cualquier Celda hasta la Última del Rango Utilizado de la Hoja
- Seleccionando una Columna(s) o Fila(s) Utilizando Métodos Abreviados
- Seleccionando celdas especiales
- Escribiendo Rápido en un Área Seleccionada
- Seleccionando la Lista/Región Actual
- Seleccionando un Rango de Celdas No Adyacentes
- Seleccionando Rápidamente un Rango de Celdas
- Seleccionando Celdas en Rangos Horizontales o Verticales
- Moviéndose a la Última (o a la Primera) Celda en un Rango
- Deje que Excel lea el texto por usted
- Qué hay de Nuevo en Excel 2002/2003: Menú, menú contextual de celdas y nuevos métodos abreviados
- ¿Qué hay de Nuevo en Excel 2003?
- Calculating Total Income Tax
- Converting Decimal Fractions to Fractions of a Specified Number
- Multiplying Values from Two Matrixes that Occupy Corresponding Addresses
- Determining Divisibility
- Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
- Restricting the Automatic Recalculation of Volatile Functions
- Placing the Previous Payment Date beside Each Pay Date in a List
- Calculating Total Annual Payment Based on Cumulative Monthly Payments
- Calculating the Remaining Credit after Each Purchase
- Calculating the Proportion of Characters from One String that Appears in another String
- Calculating Net Sale Price According to Text Criteria
- Creating a Dynamic Inventory List Based on Daily Sales
- Randomly Selecting a Value from a Range
- Adjusting Values Returned by the RAND Function
- Selecting a Set of Random Numbers, Avoiding Duplicates
- Calculating Commissions Based on Sales Rank
- Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar
- Returning the Nth Largest / Smallest Values in a Range
- Calculating the Lowest Common Multiple (LCM)
- Calculating the Average of a Range of Numbers, Excluding the Minimal Value
- Averaging Values that Correspond with the X Largest Values in a Dynamic Range
- Excluding Exceptional Values when Calculating an Average
- Finding Specified Items in a List and Averaging their Associated Values
- Calculating the Average Growth of a Child
- Transposing Values from Columns into Rows, and Vice Versa
- Transposing a Range in Ascending Order
- Transposing a Column into Successive Rows of a Specified Length
- Transposing an Entire Range of Data into a Single Column
- Determining and Indicating the Number of Times Each Value Has Been Entered in a List
- Checking for Duplicate Values within a Range
- Checking for Sequences within a Sorted List
- Retrieving Values from a List that are Greater than a Specified Number
- Retrieving Values that are Common to Two Lists
- Shuffling a List of Values
- Reversing the Order of Values in a List
- Sorting Numbers Based on Their Frequency within a List
- Sorting Numbers in Ascending or Descending Order
- Creating a List in which Each Number is the Sum of the Previous N Numbers
- Summing the N Largest Values in a Range
- Summing the Last N Values in a Column
- Summing Groups of Every N Values in a Row
- Calculating Monthly and Accumulated Income, Based on Specified Month
- Summing Expenses Accumulated to a Specified Month
- Summing How Many Points Scored by a Specified Team in Specified Games
- Summing Total Sales, Based on Quantity & Price
- Summing Sales Amounts According to Product Category and Customer Name
- Summing Corresponding Values in Multiple Columns
- Summing from Closed Workbooks
- Summing Values Using Indirect Cell References
- Summing Numerical Substrings
- Summing Values Based on Text Criteria
- Summing Rounded Numbers
- Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
- Summing Subtotals Only from Range
- Creating a Summing Formula that Automatically Adjusts to a Dynamic Range
- Summing Values from Different Sheets for the Same Cell Address
- Summing the Values of Cells Occurring at the Intersection of Ranges
- Creating a Counting Grid
- Counting Unique \"X\" and \"O\" Occurrences in a Matrix
- Counting the Number of YES Responses in a Student Questionnaire
- Creating a Summary Table of a Student Questionnaire
- Counting the Values that Match Criteria in a Filtered List
- Counting the Number of Times Any of the Numbers in First List Appears within Second List
- Using Date & Time Criteria to Count Entries in a Combined Date & Time List
- Counting the Number of Unique Items Sold by Each Salesperson
- Counting the Number of Values from Multiple Worksheets that Match Criteria
- Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
- Counting Time Values in Terms of Hourly Increments
- Counting the Number of Dates with Matching Month Criteria
- Counting Date Values by Specified Date Criteria
- Counting the Number of Strings which Contain Numbers Meeting Criteria
- Counting the Number of Times a Substring Appears Within a String
- Counting the Number of Cells Containing
- Counting the Number of Cells Containing
- Counting the Number of Times a Specified Substring Appears within a Range of Strings
- Counting Values that Appear Only Once in
- Counting the Number of Values Below or Above Average
- Using the COUNT Functions
- Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
- Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
- Avoiding Errors when Subtracting Times
- Avoiding Errors when Counting Date Values that Meet Specified Criteria
- Ignoring #DIV/0! Errors when Performing Calculations
- Avoiding #DIV/0! Errors when Dividing by Zero
- Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
- Ignoring Blank Cells when Performing Calculations
- Checking for the Presence of Specified Values within a Range
- Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
- Retrieving the Column Header of the Largest Value in a Row
- Retrieving the Column Header that Corresponds with a Matched Value
- Finding the First Value in a Row and Retrieving the Header for That Column
- Retrieving the Column Header of the Next Non-Blank Cell in a Row
- Retrieving a Price Value by Looking at Two Difference Data Tables
- Returning the Entire Contents of the Row Containing the Highest Math Grade
- Retrieving a Price from a List that Matches both Category and Item Criteria
- Retrieving Sale Price Based on Item and Color Criteria
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving Matching Values from Not
- Retrieve the Distance between Any Two Cities from Distance Table
- Retrieving Every Nth Value in a Range
- Retrieving the Nth Value in a Row / Column
- Finding Every Third Number and Returning the Largest of Them
- Retrieving Smallest Nth Value Match within
- Retrieving the Minimal / Maximal Values from a Filtered List
- Retrieve Value Using Case-Sensitive Lookups
- Finding the Maximal / Minimal String, Based on Alphabetic Order
- Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
- Retrieving the Last Value in a Dynamic List
- Retrieving the Last Value and the Last Character in a Row
- Retrieving the Most Frequent Occurrence for Each Category
- Retrieving Grade Value for Corresponding Mark
- Retrieving File Name by Matching a Given Page Number in a Book
- Ranking Salespeople According to Sales Figure
- Retrieving from List by Position
- Retrieving the Price for a Specified Item and a Specified Brand
- Retrieving Values Using Range Names as References
- Retrieving Values Using Range Names as References
- Retrieving Each Second Number from Two Lists
- Retrieving Values Using References Based on Row and Column Numbers
- Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
- Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
- Determining Whether a Worked Shift Was Morning, Afternoon or Night
- Determining Whether a Person Worked a Full or Partial Shift
- Calculating Daily Pay, Incorporating Variable Hourly Rates
- Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
- Calculating the Number of Hours Worked Based on a System of Letter Codes
- Calculating Total Time Worked on a
- Finding the First Login and Last Logout Times of Employees
- Separating Dates and Times
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Combining Data from Separate Columns into a Single Date and Time Value
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Calculating a Building\'s Occupancy Rate at Specified Times
- Rounding Time Intervals to the Nearest Specified Time Increment
- Rounding Hours Up
- Rounding Times Down to a Specified Time Increment
- Rounding Times Down to the Nearest 30 Seconds
- Creating a World Time Converter
- Converting Time Values from One Time Zone to Another
- Calculating Military Time Intervals
- Converting Times to Decimal Values
- Converting Text Representing Minutes and Seconds into Numerical Values
- Adding a Number to a Formatted Time Value
- Adding Text Values Representing Time
- Entering Times Quickly
- Converting Older Dates to the Current Year
- Determining Which Quarter a Specified Date Corresponds With
- Converting a Date into a String, Indicating the Quarter Number and Year
- Calculating the Quarter Number for Calendar and Fiscal Year
- Adding a Specified Number of Months to a Date
- Finding the Serial Number of the Last Day of the Month
- Finding the Number of Days in a Given Month
- Determining whether Two Given Dates Occur within the Same Week
- Avoiding False Results when Counting Dates Matching Specified Criteria
- Avoiding Negative Values when Calculating the Number of Days between Two Dates
- Calculating a Required Date According to Two Criteria
- Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
- Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up