Excel Basic Skills And Power Tips - BUILD - Building Your Worksheet - Part II | Billy Wigley | Skillshare

Excel Basic Skills And Power Tips - BUILD - Building Your Worksheet - Part II

Billy Wigley, Microsoft Certified Trainer(MCT), MOS Excel Expert

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (25m)
    • 1. This Is BUILD Part II - Check It Out!

    • 2. Zip Through Your Worksheets - Navigation Shortcuts

    • 3. Here Is How You Select Cells And Ranges

    • 4. Ever Hear Of Universal Shortcuts?

    • 5. Insert, Rename, Move Worksheets

    • 6. Move to another workbook color sheets


About This Class

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

Prepare yourself to learn the often ignored Navigation shortcuts that will change your life.

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

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

Here, you will learn how to select your cells and ranges like a professional.

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.

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

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.

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

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

Step right into this class and let your path to Excel success continue. Keep on learning!





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

See full profile

Report class