7 Steps To Excel Success - Excel Skills And Power Tips

With only 86,400 seconds in a day, every step counts. Learn to apply the 7 Steps To Excel Success, and use Power Tips.
4.6 (61 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.
330 students enrolled
$19
$125
85% off
Take This Course
  • Lectures 58
  • Length 5 hours
  • Skill Level Intermediate Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English Closed captions available

Course Description

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

***Published on April 7, 2016***

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! 

***Course published on April 7, 2016***

What are the 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.

What am I going to get from this course?

  • 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!

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: ALOHA! -- CONGRATULATIONS! -- WELCOME!
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.


3 questions

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!

Section 2: Elements of the Excel Screen - Click This Do What?
03:26

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?”.

07:12

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!

03:41

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!

03:27

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! 

4 questions

Congratulations! You must be feeling smarter already!

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

Don't Get Mad...Get Skills!

Section 3: Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
05:58

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.

04:33

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.

4 questions

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

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

Section 4: Saving
06:41

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.

09:38

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.

3 questions

What Happened To The Sparklines? Save As What Version?

Section 5: QAT
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!

3 questions

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?

Section 6: Begin With The End In Mind - 7 Steps To Excel Success
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. 

Section 7: Step 1 - DESIGN - It's So Easy In The 21st Century
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.

Section 8: Step 2 - BUILD - Building Your Worksheet
05:52

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.

07:27

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…

05:31

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).

03:01

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.

03:25

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.

5 questions

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

04:08

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.

03:21

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.

04:33

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.

07:09

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.

04:33

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!

4 questions

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

Section 9: Step 3 - CALCULATIONS - Add Some Calculations
06:41

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.

08:33

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. 

07:45

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!

03:39

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. 

03:13

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.

07:32

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!

4 questions

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!

03:35

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.

02:44

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!

01:35

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!

02:08

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!

06:18

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.

03:09

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.


06:37

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.

2 questions

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

Wohooooooo! You keep getting smarter! 

Section 10: Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
02:56

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.

06:47

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.

05:11

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!

05:35

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.

05:49

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!

Let's Keep On Learning - FORMATTING
3 questions
Section 11: Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts?
07:46

The reason why so many people have problems with Excel is, that they are self-taught, and never learned the basics of Excel. Like something as simple as how to properly build a list, and set up your data.

In this lecture I share with you my 7 Habits of Effective Lists, so you never have many common problems I see like, why is my my data not sorting properly?

----------

La razón por la que tantas personas tienen problemas con Excel es que son autodidactas y nunca aprendieron los fundamentos. Por ejemplo, algo tan simple como crear una lista u organizar una serie de datos.

En esta charla les comparto mis 7 hábitos de las listas efectivas para que nunca tengan problemas tan comunes como : ¿Por qué mis datos no se clasifican correctamente?

4 questions

When I am asked to review spreadsheets that are problematic, I typically find that the problems are basic user errors. One common problem is that meany users never learned how to properly set up their data.

Enjoy this Skill Snack!

07:40

When you want to get a list of names, addresses, numbers, etc., in order it is a breeze to do it in Excel.

Learn why merged cells can cause you problems, and how to fix them.

----------

Cuando quieran hacer una lista de nombres, direcciones, cifras, etc., para que sea fácil, háganla en Excel.

Sepan por qué las celdas combinadas pueden causar problemas y cómo resolverlos.


03:04

There is more than one way to sort your data.

  1. A to Z
  2. Z to A
  3. Right Click

Those are just a few methods of sorting, and yes--all your data stays together.

----------

Hay más de una manera de ordenar datos.

  1. De la A a la Z
  2. De la Z a la A
  3. Clic derecho

Estos son ejemplos de clasificación y, sí, todos sus datos se mantienen juntos. 

02:47

What happens when you want to do a multi-level sort, for example, sort by last name, then by first name?

Easy! Use the BIG sort button--considered to be the safest way to sort.

----------

¿Cómo se hace una clasificación multinivel, por ejemplo, primero por apellido y luego por nombre?

¡Fácil! Usamos el GRAN botón de Ordenar. Esta se considera la manera más segura de ordenar.

05:21

When preparing your reports, there may be times when you want to hide some data to keep it from being printed, or perhaps you just want to hide it from view in your spreadsheet.

Let's start learning some effective techniques for hiding your data, and displaying only what you wish to display.

----------

A veces, cuando preparan sus informes, tal vez quieran ocultar parte de los datos para no imprimirlos o simplemente para que no se vean en pantalla.

Comenzaremos a aprender técnicas efectivas para ocultar información y solo mostrar aquellos datos que queremos presentar. 

3 questions

This is a big section in this course. It's recommended that you take breaks often. So take a quick break, then come back and do this Skill Snack.

You will be happy at how much you learn when you take breaks often. 

09:00

There are many ways to hide data in Excel. In other words, display what you are looking for only, and have Excel automatically hide the data that does not meet your criteria.

Step into this lecture, and learn how to use the most basic filter in Excel--the AutoFilter.

----------

Hay muchas formas de ocultar datos en Excel. En otras palabras, mostrar solo lo que queremos ver y dejar que Excel esconda automáticamente los datos que no cumplen nuestro criterio.

En esta charla, aprenderán a utilizar el filtro más básico de Excel: el Autofiltro.

01:00

Here is a brief introduction to charts in this section, and I am reminding you to start a discussion at any time.

There is so much to know about Excel, the only way we are are going to truly learn Excel is to synergize--help each other out--and share knowledge.

Abundance is the rule here - no scarcity!

----------

En esta breve descripción de la sección, quiero recordarles que pueden plantear sus dudas o compartir conocimientos en el foro de discusión cuando quieran.

Es tanto lo que hay que conocer de Excel que la única manera de aprender de verdad es sinergizar –ayudarnos los unos a los otros– y compartir lo que sabemos.

¡La regla aquí es la abundancia, nunca la escasez!

07:37

Did you know that there are several methods for inserting charts? Methods like:

  1. F11
  2. Alt+F1
  3. Alt+Q
  4. Ctrl+Q

There are other ways of inserting charts, and it also varies depending on the version of Excel you are working with.

----------

¿Sabían que existen diversos métodos para insertar gráficos? Por ejemplo:

  1. F11
  2. Alt+F1
  3. Alt+Q
  4. Ctrl+Q

Hay más maneras de insertarlos, y dependen de la versión de Excel en la que estén trabajando.

02:30

Not all charts are used for the same purpose. That is why there are many different types of charts like the Clustered Column, Pie, Line, Histogram, just to name a few.

Learn how to change your chart types with ease. Did you know Excel will even recommend a chart based on your data? 

-------------

No todos los gráficos se usan con el mismo propósito. Por eso, hay tipos diferentes, como Columna agrupada, Circular, Línea, Histograma, para nombrar unos cuantos.

Aprendan a cambiar sus tipos de gráfico con facilidad. ¿Sabían que Excel hasta les recomienda un gráfico con base en sus datos? 

04:34

Did you know that you can place miniature charts into individual cells? That's right--Sparklines are miniature graphical representations of selected data.

You can customize Sparklines to add more impact to your spreadsheet presentations.

----------

¿Sabían que pueden incorporar gráficos en miniatura en celdas individuales? Así es: son los Sparklines o minigráficos que representan una selección de datos.

Los minigráficos se pueden personalizar para añadirles impacto a sus presentaciones.

3 questions

You have reached the end of the REPORTING Section.

Now finish strong, take this quick quiz, and keep on learning!

Section 12: Step 6 - Printing - Learn Where The "Fit-to-One-Page" Button Is Located
05:50

Ever press Print, and what gets printed is not what you are looking at on your computer screen?

Before pressing Print, it is advisable to preview how your spreadsheet is going to print. So let's learn how to use the Print Preview Full Screen, and the Print Preview and Print.

----------

¿Les ha ocurrido que oprimen Imprimir pero el impreso no es lo que están viendo en pantalla?

Antes de presionar Imprimir es aconsejable una vista previa. Por eso, vamos a aprender a usar la Vista previa de impresión en pantalla completa y la Vista previa e imprimir.

02:22

Have you ever asked this, Why does Excel always print out one page that looks good, then 3 blank pages, then a piece of one, and then another blank page, etc?

The answer is - you have to tell Excel exactly what it is you want printed. In other words, Set Print Area.

----------

¿Alguna vez se han preguntado por qué Excel imprime una página que parece estar bien, luego tres páginas en blanco, después otra a medias?

La respuesta es:  debemos decirle a Excel con exactitud qué es lo que queremos imprimir. En otras palabras, Establecer área de impresión.

07:33

Now that you have Set Print Area, that does not necessarily mean that your selection is going to all print on one page.

Learn how to Fit to One Page, and fine tune your settings so that your printout is clearly legible.

----------

Establecer el área de impresión no asegura que la selección se vaya a imprimir en una sola página.

Aprenderemos a Ajustar a una página y afinar la configuración para que el impreso se pueda leer con claridad.

03:22

What if you wanted to have specific details like page number, file name, date, time, etc., printed on the top, or bottom of your printout?

Learn hoe to apply custom headers, as well as preset headers, and footers.

----------

¿Desean incluir detalles específicos, como número de página, nombre del archivo, fecha, hora u otros arriba o  abajo de su impreso?

Aprendan a aplicar títulos personalizados, así como encabezados y pies de página predeterminados.

3 questions

Printing is one of the things about Excel that I notice upsets people the most. Now that you can Fit-to one page. You are not going to let printing ever upset you.

Be happy, and have fun with this quiz!

Section 13: Step 7 - Macros - Delegate to Excel
03:20

Can you think of any repetitive tasks that you must perform on a regular basis. Perhaps every Monday, when you come in to work, your first task is to format a report that you receive. Every Monday you format this report by applying the same steps, every single time. So you are wondering, I wish Excel had a button, or a shortcut that I could press, and all of these steps get done for me. 

Good news, there is a solution, that magic button/shortcut exists, and you create it. It's called a --Macro!

----------

¿Se les ocurre alguna tarea repetitiva que deban realizar frecuentemente? Quizá los lunes, cuando llegan a la oficina, lo primero que deben hacer es formatear un informe. Todos los lunes tienen que formatear ese informe, siguiendo los mismos pasos cada vez.  Y piensan: “Ojalá Excel tuviera un botón o un atajo que pudiera oprimir para que hiciera todo el trabajo por mí… “.

Les tengo una buena noticia: ese botón mágico o atajo existe y ustedes mismos lo crean. Su nombre es ¡Macro!

06:45

Prepare to be SHOCKED! Yes, you may have to hold on to your chair when you realize how easy it is to record a macro.

Check it out!

----------

¿Preparados para una supersorpresa? Sí, van a tener que agarrarse de la silla cuando sepan lo fácil que es grabar una macro.

¡Compruébenlo por ustedes mismos!

02:23

OK, so you have recorded your first macro. Now what? 

It's time to use it!

In this lecture learn how to launch (run) your macro, and be happy.

----------

Muy bien: ya grabaron su primera macro. ¿Ahora, qué? 

Pues, ¡a usarla!

En esta charla aprenderán a iniciar (ejecutar) su macro, y cero estrés.

01:25

This is the final lecture in this course, and it is the begging of your success.

As this course evolves, I will continue adding lectures, and recommending solutions, all while keeping you updated on additional techniques that will ensure the achievement of your dreams/goals! 

Let's synergize, and keep on learning!

Don't Get Mad...Get Skills!

----------

Hemos llegado a la última charla del curso y al comienzo de su éxito.

A medida que este curso evoluciona, seguiré añadiendo conferencias y recomendando soluciones, mientras se mantienen informados sobre las técnicas adicionales que les asegurarán el logro de sus sueños o metas.

¡Vamos a crear sinergia y seguir aprendiendo!

¡No desesperes! ¡Entrénate!

3 questions

Macros are recordings of steps, and actions that Excel saves using Visual Basic for Applications. You are just getting started with Macros. 

Reinforce your knowledge here, and move on to the the next level of Excel proficiency.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Billy Wigley, 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!"

Ready to start learning?
Take This Course