->

Excel for the Real World: Gain the Basic Skills of Microsoft Excel
Excel for the Real World: Gain the Basic Skills of Microsoft Excel
English | 1hr 2m | Video: 720p

 

Microsoft Excel is an essential tool for organizing and understanding data about the world you live in! This is the first part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this first class, Excel I, we will walk through the interface to help you become familiar with Excel. You will learn to navigate your way through all necessary functions of the software, understand practical applications, and gain the confidence to use it for your information needs. Whether you are new to Excel or are looking for a refresher on how to use Excel to analyze data, this class is for you.


You'll follow along with me in the Excel for the Real World file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then, it's your turn to submit a project! Find some data from a project you are working on (or someone sent you some data in Excel) and filter/sort the data, write some formulas, and apply the techniques that data analysts use every day!

 

What You'll Learn

  • Using the Ribbon. Use the Ribbon to your advantage by clicking on different buttons and customizing the ribbon to fit your needs.
  • Structuring Your Workbook. We'll cover cells in a worksheet and how worksheets fit into a workbook.
  • Formatting. Get a little artsy in Excel!
  • Selecting Data. Select the data and smartly "autofill" data.
  • Writing Formulas. Write basic formulas and do a deep dive on the popular VLOOKUP formula.
  • Listing and Sorting. Organize your data so that it's easier to analyze.
  • Using Paste Special. We will see how the Paste Special menu lets you do things above and beyond copy-and-paste.

 

More info - https://skl.sh/2zPUpHb

 

Excel for the Real World: Gain the Basic Skills of Microsoft Excel


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss