Spend less time formatting and manipulating data, and more time presenting insights.
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 <a href="http://www.thekeycuts.com/" rel="nofollow noreferrer noopener" target="_blank">KeyCuts</a>. 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. 
Learn by doing.
You'll follow along with me in the <a href="http://www.skillshare.com/classes/entrepreneurship/Excel-for-the-Real-World-I-Gain-the-Basic-Skills-in-1-Hour/599396565/project-guide" rel="nofollow noreferrer noopener" target="_blank">Excel for the Real World file</a> I have provided under the "Projects &amp; Resources" tab (in this tab see the "Resources" 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
<ul><li>Using the Ribbon. Use the Ribbon to your advantage by clicking on different buttons and customizing the ribbon to fit your needs.</li>
<li>Structuring Your Workbook. We'll cover cells in a worksheet and how worksheets fit into a workbook.</li>
<li>Formatting. Get a little artsy in Excel!</li>
<li>Selecting Data. Select the data and smartly "autofill" data.</li>
<li>Writing Formulas. Write basic formulas and do a deep dive on the popular VLOOKUP formula.</li>
<li>Listing and Sorting. Organize your data so that it's easier to analyze.</li>
<li>Using Paste Special. We will see how the Paste Special menu lets you do things above and beyond copy-and-paste.</li>
</ul>The next 2 classes in this series: 
<ul><li><a href="http://www.skillshare.com/classes/business/Introduction-to-Excel-II-Keyboard-Shortcuts/1191458218" rel="nofollow noreferrer noopener" target="_blank">Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts</a></li>
<li><a href="http://www.skillshare.com/classes/business/Introduction-to-Excel-III-Analyzing-Real-Data/1352795192" rel="nofollow noreferrer noopener" target="_blank">Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint</a></li>
</ul>Ready to go to the Intermediate Excel class?
<ul><li><a href="https://skl.sh/33d0fju" rel="nofollow noreferrer noopener" target="_blank">Intermediate Excel for the Real World: Cleaning Data for Analysis and Forecasting</a></li>
</ul><img src="https://static.skillshare.com/uploads/parentClasses/257bd84d405cdf18ead299bb9ef3bd6e/425be957" class="zoomable rounded-image-wrapper" alt="425be957">
Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.
Note: The version of Excel used in this class is Max Excel 2011, but the concepts apply to both PC and Mac.

Trailer

Using the Ribbon

Workbook Structure

Formatting

Formatting Continued

Selecting Data

Writing Formulas

Writing Formulas Continued

Lists & Sorting

Paste Special

ExcelForTheRealWorld_I_Workbook_Skillshare.xls

tvshows_on_dvd.xls

personal_budget.xls

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

Francesco D'Alessio gave you 1 free month of Skillshare

Get 1 free month of Skillshare

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

Creative Learning Made Easy

Company

Community

Teaching

Mobile

English

English