7 Steps To Excel Success - Excel Skills And Power Tips
4.5 (92 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
478 students enrolled
Wishlisted Wishlist

Please confirm that you want to add 7 Steps To Excel Success - Excel Skills And Power Tips to your Wishlist.

Add to Wishlist

7 Steps To Excel Success - Excel Skills And Power Tips

In Excel every step counts. Learn to apply the 7 Steps To Excel Success. Excel 2007,Excel 2010,Excel 2013, Excel 2016.
4.5 (92 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
478 students enrolled
Created by Billy Wigley
Last updated 4/2016
English
English, ...
  • English
  • Spanish
Current price: $10 Original price: $125 Discount: 92% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Always have access to you instructor- - Billy Wigley -- a Microsoft Certified Trainer (MCT), and MOS Excel Expert!
  • You will Get Some New Skills that will multiply your Excel proficiency.
  • You may learn how to speak Excel in Spanish, because this course has Spanish subtitles, and the instructor is fluent in Spanish.
  • Look at a formula and be able to know what it is referring to.
  • Understand 3D Referencing, and linking.
  • Your confidence in reporting, and using Filters will be apparent.
  • You will have a rock solid launching pad for advanced features like Pivottables, and Vlookups.
  • You may develop a Positive Mental Attitude from minimizing errors, because you will understand how to set up your lists with ease!
  • When you hear "Click on the Format Painter," you will know exactly what to do.
  • You will begin a transformation, and learn to Begin With The End In Mind.
  • Apply what you learn in this course to your real life, and not just Excel.
  • Instead of always using your mouse, you will begin to use Excel hacks like a pro!
  • Become more confident!
  • You will learn Excel terminology in Spanish just by watching the Spanish captions.
  • You will Rock at Excel!
View Curriculum
Requirements
  • In this course you will become skilled in using Excel 2007, 2010, 2013, 2016. All the concepts you will learn are compatible with Excel 2007 to 2016.
  • You just need to know how to find Excel on your computer.
  • You are committed to life long learning.
Description

***¡Con subtítulos en español!***

What is this course about?

Learning 7 Steps To Excel Success - Excel Skills And Power Tips, is a sure way to build a rock solid foundation that will catapult you into the next level of Excel proficiency.

You will learn how to write basic formulas, and understand how they work. Even a 3D Referencing formula will seem simple. Learn how to make a Macro with just your mouse.

Ever wondered how to Sort and Filter (just right click)?

What would it be like to dominate keyboard shortcuts (Power Tips)? Learn Power Tips from Printing, Universal Shortcuts to Navigation Shortcuts, and more. Never again wonder what the AutoSum does. 

Be confident building error free spreadsheets using thousands of built-in templates.

Want to become a Microsoft Office Specialist (MOS), and watch your earning potential explode? It’s easy, just ask your instructor--Billy Wigley (MCT, MOS Expert, MCP)--how to do it!

What kinds of materials are included?

This course is skillfully designed to be followed along with a pre-formatted Excel workbook. Download the Don’t Get Mad..Get Skills! Excel Skills workbook in the very first lecture.

How long will the course take to complete?

You can learn at your own pace, and ask your instructor for help when you are ready. You will always be on track, the course is continually being improved, and you have access to it for life!

How is the course structured?

Each lecture can be viewed as a standalone video, so you can skip around most videos in the course, and focus only on the skills you want to strengthen.

Why take this course?

I wisely prepared this course for you, based on feedback from thousands of students.

It is a result of my experience from 5 years of travelling to cities across the U.S.A., Canada, and Mexico, presenting two-day Excel seminars to over 45,000 professionals; including on-line students in over 105 countries.  

I am a Microsoft Certified Trainer (MCT) with over 5 years of experience teaching Excel. This is all I do, and I am committed to helping you achieve beyond what you believe you are capable. 

Think of me as your Excel coach! 

I love to know you are making your dreams come true, so I make sure to maintain regular office hours to serve you, and all my students worldwide. 

Take this course, and let’s keep on learning! 

Who is the target audience?
  • You have been using Excel for less that a year.
  • Take this course when you are tired of struggling with Excel because you know there is a better way to work with Rows, and columns, and Formulas, and Formats, and all that stuff!
  • Even if you have used Excel for years, you will be amazed at what is available to you.
  • Take this course to rebuild your foundation, and turn it into an Excel Expert Launching pad.
  • If you like to work too much, and complain all the time, do not take this course.
  • Take this course when you are "self-taught" in Excel because you did not get training at work, and just had to "figure it out!"
  • Take this course when you want to soar with other Eagles (High Achievers) around you.
  • Take this course if you are an achiever.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
58 Lectures
04:56:52
+
ALOHA! -- CONGRATULATIONS! -- WELCOME!
1 Lecture 00:45

Aloha! congratulations! I know you are eager to take your Excel Skills to the next level.

This course is designed so that you can follow along in the same Excel workbook that I am using. So make sure you download it from the resources in this lecture.


Preview 00:45

Hungry for some skills? Now that you have downloaded the workbook, warm up your positive attitude with the World's Easiest Quiz!

Have fun with it!

Aloha!

IMPORTANT - Please Start Here! -- This Is The Worlds Easiest Quiz!
3 questions
+
Elements of the Excel Screen - Click This Do What?
4 Lectures 17:46

What is the number one reason that people fail at Excel? - FEAR!

When you get comfortable with your surroundings fear begins to dissipate. Once you are familiar with the proper terminology you will know what to do when somebody says: "Can you please go to the Home Tab, and in the Clipboard Group use the Format Painter to copy the formats in that Range?"

----------

¿Cuál es la razón principal por la que las personas fallan en Excel?  ¡El miedo!

Cuando uno se siente cómodo en su entorno, el miedo comienza a disiparse. Una vez familiarizados con la terminología adecuada, sabremos qué hacer cuando alguien nos pregunte: "¿Puedes ir a la pestaña Inicio y en el grupo Portapapeles utilizar la herramienta Copiar formato para usarlos en ese Rango?”.

Preview 03:26

Did anybody ever teach you about the Marquee? Did you know that the marquee should always be in the data? Most tool work better, and some tools do not work at all, when your marquee is not in the data. What about the QAT? You will be happy to know to use the Status Bar to simplify some tasks.

In this lecture you keep on building a rock-solid Excel foundation!

----------

¿Saben qué es el marco de selección? ¿Sabían que siempre debe ubicarse en los datos? Muchas herramientas funcionan mejor así, y algunas no funcionan en absoluto cuando el marco no está en los datos. ¿Y ya saben qué es la barra de Acceso rápido? Será genial cuando aprendan a utilizar la barra de estado para simplificar algunas tareas.

En esta charla, ¡seguirán cimentando sus conocimientos de Excel!

Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
07:12

Remember that we are laying a solid foundation from which to launch off. Learning the Elements of the Excel screen will put you light years ahead of the "self-taught" users.

Get introduced to the Zoom Slider, and learn the Ctrl+Mouse wheel shortcut. Ever wonder what that little arrow in the corner of some Groups is called, or what it does?

Let's keep on learning!

----------

Recuerden que estamos construyendo la pista desde la cual despegaremos. Conocer los Elementos de la pantalla de Excel los pondrá a años luz de los usuarios autodidactas.

Les enseñaré el control deslizante del Zoom y el atajo Ctrl+rueda de desplazamiento del ratón. ¿Se han preguntado qué significa esa flechita en la esquina de los Grupos y para qué sirve?

¡Sigamos aprendiendo!

Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
03:41

There are 1,048,576 rows in Excel, and 16,384 columns. How would you know that your marquee in on cell DX8110, and what the contents of that cell are? Do you have to scroll all the way over to column DX and down to Row 8110?

The answer is NO! There is always a better way.

Use the Name Box, and the Formula Bar - check it out!

----------

Excel tiene 1,048,576 filas y 16,384 columnas. ¿Cómo saben que su marco está en la celda DX8110 y qué contiene dicha celda? ¿Habrá que ir manualmente hasta la columna  DX y la fila 8110? La respuesta es: ¡NO! Siempre hay un método mejor.

Usen el Cuadro de nombres y la fórmula. ¡Compruébenlo! 

The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
03:27

Congratulations! You must be feeling smarter already!

Feels good to have Skills - now test them out real quick.

Don't Get Mad...Get Skills!

Got Skills?
4 questions
+
Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
2 Lectures 10:31

I am sure you have heard of Excel 2007, 2010, 2013, 2016, and you may be wondering about that.

Microsoft Office is frequently getting updated, and new version are regularly released. You may have one version at home, and another version at work or school. It is important to know the version you are working in, and ensure you are compatible.

Here is how you can tell what version you are working in.

----------

Seguro que han oído hablar de Excel 2007, 2010, 2013, 2016, y quizá se preguntan qué es eso.

Microsoft Office se actualiza permanentemente y saca versiones nuevas con regularidad. No es raro que tengan una versión en casa y otra en la escuela u oficina. Es importante  saber en qué versiones trabajan y verificar la compatibilidad.

Aquí van a aprender a reconocer la versión que están usando.

Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.
05:58

Have you ever wanted to go Backstage?

The File Tab is your key to the Backstage View where you will enjoy a wealth of information. Like, the name of the author, quick access to the file location, manage versions, printing, saving, and many more options.

Get a quick overview of the File Tab, and the Backstage View.

----------

¿No les gusta a veces ver lo que sucede tras bastidores?

La pestaña Archivo es la entrada a la vista Backstage, donde encontrarán montones de información, como, por ejemplo, nombre de autor, acceso rápido a la ubicación del archivo, manejo de versiones, imprimir, guardar y muchas otras opciones.

Echaremos un vistazo general a la pestaña Archivo y la vista Backstage.

Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.
04:33

By now you can tell the difference between Excel versions 2007 through 2016.

Let's build up our confidence just a little more.

So What's The Difference?
4 questions
+
Saving
2 Lectures 16:19

So, you've opened up Excel, and you started doing some work. Now what you really want do is you want to save your work.

There's nothing worse than spending hours on your work, and suddenly, something happens and you lose your data because you didn't save it. In this lecture, let me show you how to Save.

What's the shortcut to "Save?" That question is answered in this lecture.

----------

Bien: digamos que abren Excel y comienzan a trabajar. Ahora, quieren saber cómo guardar su trabajo.

Nada puede ser peor que pasar horas trabajando y, de pronto, sucede un accidente y perdemos los datos porque no los guardamos. En esta charla, les mostraré cómo salvar.

¿Cuál es el atajo para “Guardar”? Ya mismo lo sabrán.

F12 - Save As - I Prefer The "Old School" Save As.
06:41

Have you ever sent an Excel file to somebody, and they tell you that they can't open it? You send it to them again, and they still can't open it? You ask them for a different e-mail to send it to, and when you send it, they still can't open your workbook! What's the problem?

What does Read-only mean?

How come your colleague can't see the Sparklines in the report that you sent them?

Join this lecture, and learn about saving, and compatibility so that you can answer these questions.

----------

¿Alguna vez enviaron un archivo de Excel y quien lo recibió no pudo abrirlo? ¿Vuelven a enviarlo y nada? ¿Piden una nueva dirección electrónica y tampoco sirve? ¿Cuál es el problema?

¿Qué significa Solo lectura?

¿Por qué sus colegas no puede ver los minigráficos en el informe que les enviaron?

Participen en esta charla para que aprendan sobre guardar y la compatibilidad,  y puedan responder estas preguntas.

Saving and Compatibility. What Happened To The Sparklines? Save As What Version?
09:38

What Happened To The Sparklines? Save As What Version?

Saving and Compatibility
3 questions
+
QAT
1 Lecture 08:03

Have you ever heard of hidden features in Excel? 

The Quick Access Toolbar (QAT) is jam-packed with hidden secret features, and is easily customizable to suit your needs. Step into this lecture, and begin your discovery!

----------

¿Han oído hablar de las propiedades ocultas de Excel? 

La barra de herramientas de Acceso rápido (QAT) está repleta de características secretas, que pueden personalizar a la medida de sus necesidades. ¡En esta lección lo descubrirán!

The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
08:03

Now that you are familiar with this feature, affirm your ability with a quick Skill Snack!

Wow! What a nice tool. Easily customizable, and jam-packed with "secret" features.

So how much did you learn?

The Secret Features - QAT
3 questions
+
Begin With The End In Mind - 7 Steps To Excel Success
1 Lecture 09:10

When using Excel, you must begin with the end in mind.

Learn the 7 Steps To Excel Success, and unlock the secrets to accurate, and profitable spreadsheets.

----------

Cuando usen Excel, empiecen con el fin en mente.

Aprendan los 7 pasos para triunfar en Excel y descubran los secretos para lograr hojas precisas y rentables. 

Begin With the End in Mind - 7 Steps To Excel Success
09:10
+
Step 1 - DESIGN - It's So Easy In The 21st Century
1 Lecture 11:12

Excel is considered by some to be "The world's most dangerous program." There are too many user worldwide that are asked to use Excel for work, and given the proper training. The result is spreadsheets with costly errors.

To aid in minimizing spreadsheet errors, Microsoft has made thousands of prepackage files, including all necessary formulas and functions - Templates. For FREE!

In this lesson you will learn where to find your Templates.

----------

Hay quienes consideran a Excel “el programa más peligroso del mundo": a muchos usuarios se les exige trabajar con Excel, pero sin la capacitación apropiada los errores pueden resultar demasiado costosos.

Para minimizar dichos errores, Microsoft tiene miles de archivos preestablecidos, que incluyen las fórmulas y funciones necesarias: las plantillas… ¡y gratis!

En esta lección, aprenderán dónde encontrar sus plantillas.

Templates - Learn how to to tame the "World's Most Dangerous Program."
11:12
+
Step 2 - BUILD - Building Your Worksheet
10 Lectures 49:00

Learn five things that can go into and Excel worksheet, and be on your way to Entering and Editing Data like a professional.

Always remember, when editing, F2 Is Your Friend.

Plus other methods of entering, and editing data in Excel.

----------

Les hablaré de cinco cosas que pueden ir en una hoja de Excel, y aprenderán a introducir y editar datos como verdaderos profesionales.

Nunca olviden: cuando editan, F2 es su amigo.

Además, otros métodos para introducir y editar datos en Excel.

Preview 05:52

Ever wished there was a faster way of typing a list, like a series of names, numbers, dates, etc.?

There is, it is called the Auto Fill Handle, and it is amazingly easy to use with its preset lists, and ability to create your own custom lists.

You will say to yourself - "I never noticed that little dot, hmmm?

----------

¿Se han preguntado si hay una manera más rápida de digitar una lista, como una serie de nombres, números, fechas, etc.?

Sí la hay: es el control de Autorrelleno, increíblemente fácil de usar con sus listas predeterminadas y que nos brinda la posibilidad de crear nuestras propias listas.  

Desde ahora, se preguntarán por qué no habían notado ese puntito…

Minimize Repetition - Learn The Auto Fill Handle.
07:27

Now that you have learned what the Auto Fill handle can do, it is time to unlock the secrets of this handy little tool.

Create your own customized lists known as, Custom Fill Series.

Here the goal is to learn the easiest, and fastest way to use this handy (some consider Advanced) feature.

----------

Ahora que ya aprendieron a usar el control de Autorrelleno, ha llegado el momento de revelar los secretos de esta útil herramienta.

Podrán crear sus propias listas, llamadas Series de relleno personalizadas.

Nuestro objetivo es aprender la manera más fácil y rápida de usar esta práctica característica (que algunos consideran de avanzada).

Learn How To Create A Create Custom Fill Series - No More Typing That List!
05:31

Ever wonder how many rows are in Excel 2007, and beyond? Before 2007 there were 65,000 rows, and 255 columns.

Find out how many are available now, and a quick way to see it.

----------

¿Se han preguntado cuántas filas tienen las versiones de Excel 2007 y posteriores? Antes de 2007, había 65,000 filas y 255 columnas.

Averigüemos cuántas hay ahora, y una forma rápida de hacerlo.

How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
03:01

With 1,048,576 rows, and 16,384 columns in a spreadsheet, it is important to skillfully navigate your from cell A1 to cell XFD1048576 like an Excel ninja.

Learn the often ignored Navigation shortcuts that will change your life.

----------

Con 1,048,576 filas y 16,384 columnas en una hoja de cálculo, es importante ser tan diestros como un ninja de Excel para ir de la celda A1 a la celda XFD1048576.

Aprenderán los casi siempre ignorados atajos de Navegación que les cambiarán la vida.

Navigation Shortcuts
03:25

Keep reinforcing your skills,and let's have fun with a few questions.

Skill Snack - BUILD
5 questions

As you have noticed, Excel is made up of Rows and Columns. So you will need to now how to insert rows and columns when you need them.

There are many ways to do this, and in this lecture we learn my favorite ways of inserting rows and columns into your Excel worksheets.

----------

Como pueden ver, Excel está formado por filas y columnas, y debemos aprender a insertarlas cuando se necesiten.

Hay muchos modos de hacerlo, y en esta charla les enseñaré mis favoritos para insertar filas y columnas en las hojas de trabajo de Excel.

Insert Rows and Columns Like A Professional
04:08

With all of the tools that you have available in Excel, you are going to be eager to use them. Well, how do we select where to apply these tools?

What if you what to Bold a range of multiple non-adjacent cells?

Learn how to select your cells, and ranges.

----------

Con todas esas herramientas que les ofrece Excel, me imagino que están ansiosos por utilizarlas. ¿Cómo seleccionamos el lugar donde queremos aplicarlas?

¿Qué sucede si quieren poner en negrita un rango de celdas no adyacentes?

Hoy aprenderemos a seleccionar celdas y rangos.

Preview 03:21

Did you know that Ctrl+C is the shortcut to "copy?" What's the shortcut to Paste? Ctrl+P! No, that's the keyboard shortcut to Print. The shortcut to Paste is Ctrl+V.

Have you used these shortcuts? Can you think of any shortcuts that you use in many different software programs? Shortcuts like Ctrl+C, and Ctrl+V, are called "Universal Shortcuts" because they can be used in may different applications.

In this lecture you will learn these, and a few more Universal Shortcuts that are commonly used.

----------

¿Sabían que Ctrl+C es el atajo para copiar? ¿Y cuál es el atajo para pegar?  ¿Ctrl+P? ¡No!, ese es el atajo para imprimir. El atajo para pegar es Ctrl+V.

¿Han utilizado estos atajos? ¿Se les ocurren algunos atajos que hayan usado en otros programas de software? Ctrl+C y Ctrl+V son "atajos universales" porque se utilizan en diferentes aplicaciones.

En esta charla aprenderán estos y unos cuantos atajos universales más, de uso común.

Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.
04:33

Just like you must work with Rows and Columns in your worksheets, you work with worksheets in your workbooks. It is easy to quickly insert, name, and rename worksheets.

You may even need to quickly move a copy of a worksheet from one workbook to another while keeping the original in the source workbook.

Learn how to make your worksheets stand out by coloring the worksheet tabs.

----------

Así como trabajan con filas y columnas en sus hojas, trabajan con hojas en sus libros. Es fácil insertar, nombrar y cambiar rápidamente de nombres.

Tal vez tengan que trasladar con afán la copia de una hoja de un libro a otro, dejando la original en el libro fuente.

Aprendan a hacer que las hojas se destaquen, coloreando sus pestañas.

Insert A Worksheet, Name It, Rename It, Move It
07:09

Sometimes you need to have the same data in multiple workbooks. Instead of copying, and pasting the data, there's an even better way. You can Move or Copy entire worksheets, and Move or Copy them to other workbooks!

Perhaps you want to send just a worksheet containing a chart, and not the entire workbook? Easy, move a copy of the worksheet to a new workbook.

What if you have many worksheets, and you want to easily identify specific ones? Just color the worksheet tabs, and you are done!

----------

En ocasiones, necesitarán los mismos datos en varios libros. En lugar de copiarlos y pegarlos, hay un método mucho mejor: ¡pueden Mover o Copiar hojas enteras a otros libros!

Tal vez quieran enviar solo una hoja con un gráfico y no el libro completo… Fácil: pueden trasladar una copia de la hoja al nuevo libro.

¿Y qué tal si tienen varias hojas y quieren identificar rápidamente algunas de ellas? Solo tienen que colorear las pestañas que las identifican, ¡y listo!

Move Worksheets To Another Workbook - Make Worksheet Names Standout With Color
04:33

The best way to learn anything is, just do it! So keep strengthening your Excel skills foundation.

You Are Getting Good At This!
4 questions
+
Step 3 - CALCULATIONS - Add Some Calculations
13 Lectures 01:03:29

What do you think is the answer to this formula =5+6*10?

Is it 65 or 110?

Before we can learn how to build formulas in Excel, we better remember some basic math.

Let's learn the Order of Operations.

----------

¿Cuál creen que es la respuesta a la fórmula =5+6*10?

¿Es 65 o 110?

Antes de construir fórmulas en Excel, debemos recordar algo de matemáticas básicas.

En esta charla, recordaremos el Orden de las operaciones.

Please Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math.
06:41

When you are building formulas in Excel, you must remember that you are adding, dividing, multiplying, cells. It's the contents of the cells that changes, the formula remains the same.

Learn how formulas work, and start building formulas by just pointing, and clicking.

----------

Cuando crean fórmulas en Excel, no deben perder de vista que están sumando, dividiendo y multiplicando celdas. La fórmula es la misma; lo que cambia es el contenido de las celdas.

Sepan cómo funcionan las fórmulas y empiecen a crearlas solo apuntando y haciendo clic. 

Formulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..?
08:33

It's time to practice what you have been learning, and write your first formula. As you succeed at writing your first formula, you will notice something odd happening in your results.

Oh no! How can you solve this! Simple--Absolute Referencing.

How do you keep a ship from drifting? Anchor it! What does anchoring have to do with formulas?

Step into this lesson, and let's make your Relative References--Absolute!

----------

Ha llegado el momento de practicar lo aprendido y crear su primera fórmula, pero cuando la aplican, algo raro ocurre con los resultados.

¡No puede ser! ¿Qué podemos hacer? Sencillo: la referencia absoluta.

¿Qué debemos hacer para que un barco no vaya a la deriva? ¡Anclarlo! ¿Y qué tiene que ver el anclaje con las fórmulas?

Entremos en materia ¡y hagamos absolutas nuestras referencias relativas!

You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend
07:45

Once you learn the basics of formulas, you are going to run into situations where you begin to realize, "There's got to be a better way?"

Here is an example of using a basic formula, and realizing that it is time look into learning some Functions.

----------

Una vez han aprendido los fundamentos de las fórmulas, seguro enfrentarán situaciones en las que se darán cuenta de que debe haber una mejor manera de hacer las cosas.

Aprenderemos a usar una fórmula básica y, más adelante, algunas funciones. 

Example Of The Moment You Realize - It's Time To Start Thinking About Functions
03:39

You can manually do the math, or you can have Excel do the math. Which would you prefer?

Ever hear of the SUM? What about the DATE? You must have heard of the VLOOKUP?

What are they? These are functions in Excel. Think functions as pre-programmed formulas.

----------

Ustedes pueden hacer cálculos manualmente o dejar que Excel los haga. ¿Qué prefieren?

¿Han oído hablar de SUMA? ¿De la FECHA? ¿Seguro habrán oído de BUSCARV?

¿Qué son? Son funciones de Excel. Piensen en las funciones como en fórmulas preprogramadas.

What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!
03:13

The most commonly used function in Excel is the AutoSum (Alt+=).

No more =E1+E2+E3+E4+E5+E6+E7+E8+E9.

With the AutoSum you change that formula to SUM(E1:E9) - that's it!

And there is so much more! Let Excel do the math!

----------

La función más comúnmente utilizada en Excel es la Autosuma (Alt+=).¡No más 

=E1+E2+E3+E4+E5+E6+E7+E8+E9!

Con la Autosuma, la fórmula cambia a SUMA(E1:E9) ¡y listo!

¡Son tantas cosas más! ¡Dejemos que Excel haga los cálculos!

The Most Basic Function - The AutoSum - So Much More Than Just Sum!
07:32

Feel like strengthening your formulation skills? Step into this little Skill Snack, and keep letting the good times roll!

Don't Get Mad...Get Skills!

Skill Snack - CALCULATIONS
4 questions

Have you ever heard that you can get a lot more done when you have effective delegation skills?

Get more done in Excel! Delegate the SUM of multiple non-adjacent ranges to the AutoSum.

Don't be mouse dependant - keep learning shortcuts.

----------

¿Sabían que el trabajo nos rinde mucho más cuando tenemos la capacidad de delegar?

¡Aprovechen a Excel! Deleguen la SUMA de varios rangos no adyacentes a la Autosuma.

No se vuelvan dependientes del ratón y sigan aprendiendo atajos.

Preview 03:35

There are hundreds of functions in Excel, are you supposed to know them all?

Watch how Excel can help you learn the functions.

Check of the Insert Function tool--your search engine for functions!

----------

Excel tiene cientos de funciones… ¿debemos aprendérnoslas todas?

Sepan cómo Excel puede ayudarles a aprenderse las funciones.

Revisen la herramienta Insertar función… ¡es el motor de búsqueda de las funciones!

Quick Overview Of The Insert Function Tool - Your Search Engine For Functions
02:44

Ever have trouble re-sizing a worksheet? Trying to get it to fit just right within a window so you can easily work with it?

Tired of using the Zoom Slider, and wish you could just perfectly Zoom to Selection in just a couple of steps?

Step into this lecture View how it's done!

----------

¿Alguna vez han tenido problemas para cambiarle el tamaño a una hoja? ¿Para hacer que quepa en una ventana y poder trabajar fácilmente?

¿Cansados de usar el control deslizante del Zoom? ¿Les gustaría poder hacer Zoom a la selección en unos pocos pasos?

¡En esta charla lo aprenderán!

Preview 01:35

It's time to learn how to link. Enter data in one cell, and have it appear in another cell?

It's as easy as saying, I want this cell to = this cell!

----------

Es hora de aprender a vincular. ¿Saben cómo introducir datos en una celda y hacer que aparezcan en otra?

Es tan sencillo como decir: ¡Quiero que esta celda sea = a esta otra!

Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another
02:08

Ever had to do a Year End Sumary from data in multiple worksheets? In other words, you want the various totals to be summarized into one worksheet.

You will be so happy after you learn 3D Referencing! Just saying it makes you feel smarter.

----------

¿Alguna vez han tenido que hacer un resumen anual de los datos de varias hojas? Es decir, ¿un resumen de diversos totales en una sola hoja?

¡Pues se sentirán felices cuando aprendan a hacer Referencia 3D! Con solo decirlo nos sentimos más listos.

3D Referencing In Action
06:18

In this lecture you will understand what =SUM('Q1:Q4'!F3) means.

Once you understand what that formula means you will realize the meaning of an, Aha moment!

----------

En esta charla aprenderán el significado de =SUMA('Q1:Q4'!F3).

Cuando comprendan el significado de esta fórmula, sabrán lo que es un momento eureka.


3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!
03:09

Practice your linking techniques, and learn how to link data between workbooks.

----------

Practiquen sus técnicas de vinculación y aprendan a enlazar datos de libros diferentes.

Practice More 3D Referencing - Did You Know You Can Link Your Workbooks?
06:37

Congratulations! You are moving right along. Let' do another "mental push-up," and keep strengthening your Excel Skills!

Wohooooooo! You keep getting smarter! 

Let's Keep On Learning - CALCULATIONS
2 questions
+
Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
5 Lectures 26:18

Never let the end user assume anything. Your spreadsheets must be easy to understand.

Formatting helps you ensure your spreadsheet success.

Check out a handy shortcut I use every day in Excel.

----------

Nunca permitan que el usuario final tenga que asumir nada: sus hojas de cálculo deben ser fáciles de interpretar.

Un buen formato asegura el éxito de sus hojas.

Comprueben este práctico atajo que uso todos los días en Excel.

Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
02:56

Wow! 4.6 billion color variations! With so many colors, and formatting groups like Font, Alignment, Numbers, you can ensure that your spreadsheet will attract attention to the right places.

----------

¡Vaya! 4,600 millones de matices! Con tantos colores y grupos de formato como Fuente, Alineación, Números, tienen la certeza de que su hoja atraerá la atención a los lugares correctos.

Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
06:47

What are those numbers? If they are currency, what kind of currency is it?

Is it Dollars, CH Francs, Chinese (PRC), Euros? Make it clear with the proper currency formatting. It's easy!

----------

Esos números, ¿qué son? Si se trata de moneda, ¿qué tipo es?

¿Dólares, francos suizos, yuanes, euros? Aclarémoslo con el formato para monedas. ¡Es muy fácil!

Formatting Money - Should You Pick The Currency Method Or The Accounting Method?
05:11

Have you ever wanted to angle the headers, or titles in your worksheets? In other words, have you ever wondered how to adjust the orientation of values in Excel spreadsheets?

It's all in the Alignment, and while we're at it let's apply some Styles.

-----------

¿Alguna vez les ha dado por inclinar los encabezados o títulos de sus hojas? En otras palabras, ¿se han preguntado cómo podrían cambiar la orientación de los valores en las hojas de Excel?

Todo se reduce a la Alineación y, ya que estamos en esto, apliquemos algunos Estilos.

Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
05:35

Do you like the look of a particular selection of data? You can easily apply that look to other content in your workbook. Just use the Format Painter!

----------

¿Les gusta cómo se ve una selección particular de datos? Es fácil aplicar esa apariencia a otro contenido de su libro. ¡Para eso está Copiar formato!

Format_Painter
05:49

Let's Keep On Learning - FORMATTING
3 questions
3 More Sections
About the Instructor
Billy Wigley
4.6 Average rating
208 Reviews
3,046 Students
3 Courses
Microsoft Certified Trainer (MCT), MOS Excel Expert

As a Microsoft Certified Trainer, Billy Wigley is a Microsoft Office Expert in Excel. He actively travels throughout the USA, and other countries leading public seminars teaching Excel skills. In just five years, he has personally trained more than 45,000 professionals in over 100 cities. Wigley also consults with emergent business owners on their plans and projects to ensure success. With over 25 years of leadership experience, and from having resided in various cities worldwide, Wigley is well-known around the world. With his strong USA and Colombian heritage, Wigley takes pride in his multi-cultural background, and being able to reach English, and Spanish speakers around the globe.

Billy Wigley always says: "Don't Get Mad…Get Skills!"