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!