Microsoft Training's

Microsoft Excel AND Function

<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
Microsoft Excel AND Function</h3>
<h3 style="text-align: left;">
<img alt="Excel AND function" height="365" src="https://exceljet.net/sites/default/files/styles/original_with_watermark/public/images/functions/main/exceljet_and.png?itok=6fGmyLus" width="640" /><br />Summary </h3>
The AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the OR function.<br />
<br />
<h3 style="text-align: left;">
Purpose </h3>
Test multiple conditions with AND<br />
<h3 style="text-align: left;">
Return value </h3>
TRUE if all arguments evaluate TRUE; FALSE if not<br />
<h3 style="text-align: left;">
Syntax </h3>
=AND (logical1, [logical2], ...)<br />
<h3 style="text-align: left;">
Arguments </h3>
logical1 - The first condition or logical value to evaluate.<br />
logical2 - [optional] The second condition or logical value to evaluate.<br />
<h3 style="text-align: left;">
Usage notes </h3>
Use the AND function to test multiple conditions at the same time, up to 255 conditions. Each logical condition (logical1, logical2, etc.) must evaluate to TRUE or FALSE, or be arrays or references that contain logical values.<br />
<br />
For example, to test if the value in A1 is greater than 0 and less than 5, use the following formula:<br />
<br />
=AND(A1>0,A1<5)<br />
<br />
It can be useful to extend the functionality of functions like IF with AND. Using the above example, you can supply AND as the logical_test for the IF function like so:<br />
<br />
=IF(AND(A1>0,A1<5), "Approved", "Denied")<br />
<br />
This formula will return "Approved" only if the value in A1 is greater than 0 and less than 5.<br />
<br />
<h3>
Notes:</h3>
<br />
<ul style="text-align: left;">
<li>Text values or empty cells supplied as arguments are ignored.</li>
<li>The AND function will return #VALUE if no logical values are found or created during evaluation.</li>
</ul>
</div>

Microsoft Excel AND Function

Microsoft Excel AND Function Summary The AND function is a logical function used to require more than one condition at the same time. ...

how to create a searchable drop down list in excel 2013

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="4855586312" style="display: inline-block; height: 250px; width: 300px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/Zo7nkr8-xWA" width="560"></iframe>
</div>
<div style="text-align: center;">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="8227855118" style="display: inline-block; height: 60px; width: 468px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
</div>

how to create a searchable drop down list in excel 2013

How to create dynamic chart in Microsoft Excel

</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/qMuSTtgv5ao" width="560"></iframe>
</div>
<div style="text-align: center;">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="8227855118" style="display: inline-block; height: 60px; width: 468px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
</div>

How to create dynamic chart in Microsoft Excel

Excel 2016 for Mac: Working with External Data

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 50px; font-weight: inherit; line-height: 1.2; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; word-break: break-word;">
<span style="font-weight: inherit;">Excel 2016 for Mac: </span>Working with External Data</h1>
<div>
<br /></div>
<div>
<span style="background-color: white; color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif; font-size: 18px;">These days we all live and work in a multi-device, multi-platform world, and so when building </span>Office 2016 for Mac<span style="background-color: white; color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif; font-size: 18px;">, one of our key objectives was to make it as easy as possible to transition from using Office for Windows to using Office for Mac and back again. That’s why you’ll notice an interface that’s consistent with what you’d expect when using Office 2016 for Windows, and why we added support for virtually all of the Windows Excel Ctrl keyboard shortcuts. So when it came to working with external data, we applied that same logic: how can we make the experience great and working cross platform easier than ever?</span></div>
<div>
<span style="background-color: white; color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif; font-size: 18px;"><br /></span></div>
<div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
External data in Excel 2016 for Mac</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
We examined how we could improve external data for Excel 2016 for Mac and made the following changes:</div>
<ul style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Excel 2016 for Mac comes with a pre-installed and integrated SQL Server ODBC driver, which we worked hand-in-hand with Simba Technologies to provide.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Excel 2016 for Mac has a brand new Microsoft Query (MSQuery) and Connection Manager to make creating and managing all of your data connections easier and more consistent with Windows.</li>
</ul>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Let’s take a deep dive into how each of these improvements can help you.</div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Native support for ODBC data connections</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Excel 2016 for Mac supports ODBC data connections with SQL Server and Azure SQL Database right out of the box. This means several great things for anyone who works with external data:</div>
<ul style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">When creating or refreshing data connections to SQL Server, there are no third-party drivers required—everything you need is included right in the app.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Connections made to SQL Server in Excel 2016 for Mac will work in Excel for Windows and vice versa. Have a workbook with ODBC data connections you’ve been using on Windows and never been able to use on your Mac? Well, now you can with cross-platform compatibility.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">If you want to connect to something other than SQL Server, we still have several great partners offering third-party drivers to connect to any data source you can imagine.</li>
</ul>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
In addition, all of the ways in which you interact with external data are now consistent between the platforms. Looking for that Refresh button? It’s on the Data tab just as you’d expect.</div>
<div align="center">
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="8227855118" style="display: inline-block; height: 60px; width: 468px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<img alt="Working with external data in Excel 2016 for Mac 1" height="212" src="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-1.png" width="640" /><br />
<br />
<br />
<h3 style="border: 0px; box-sizing: inherit; clear: both; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
A better way to work with external data connections</h3>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
One of the biggest improvements to working with external data connections in Excel for Windows in recent releases has been the Connection Manager. It provides a central place to see all of the data connections in a workbook, see where they are used, and modify, remove or refresh each one individually. With Excel 2016 for Mac, you now have that same Connection Manager you are familiar with from Windows. All of your connections are displayed, and you can click any of them to see where they are used in your workbook and to perform any action.</div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<a href="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-FI.png" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><img alt="Working with external data in Excel 2016 for Mac FI" class="aligncenter wp-image-163211" height="412" src="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-FI-1024x704.png" style="border: 0px; box-sizing: inherit; clear: both; display: block; height: auto; margin: 0px auto 1.7rem; max-width: 100%;" width="600" /></a></div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<div align="center">
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<br />
<div align="center">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="8227855118" style="display: inline-block; height: 60px; width: 468px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<br />
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
The Connection Properties dialog has been streamlined as well to match Excel for Windows, so that you now only see the properties that apply to your particular data connection.</div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<a href="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-3.png" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><img alt="Working with external data in Excel 2016 for Mac 3" class="aligncenter wp-image-163191" height="498" src="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-3-875x1024.png" style="border: 0px; box-sizing: inherit; clear: both; display: block; height: auto; margin: 0px auto 1.7rem; max-width: 100%;" width="425" /></a><br />
<br />
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
However, what good is easier management of your data connections if it’s too hard to create them to begin with? With Excel 2016 for Mac, creating a connection to SQL Server is easier than ever. On the Data tab, simply select <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">New Database Query </span>> <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">SQL Server ODBC</span>, and you are presented with a simple connection dialog. Once it’s filled out, the newly redesigned MSQuery launches.</div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<a href="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-4.png" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><img alt="Working with external data in Excel 2016 for Mac 4" class="aligncenter wp-image-163201" height="438" src="https://blogs.office.com/wp-content/uploads/2015/08/Working-with-external-data-in-Excel-2016-for-Mac-4-1024x701.png" style="border: 0px; box-sizing: inherit; clear: both; display: block; height: auto; margin: 0px auto 1.7rem; max-width: 100%;" width="640" /></a></div>
<div align="center">
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="5582113112" style="display: inline-block; height: 250px; width: 250px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
The new MSQuery experience is very similar to the SQL Query Analyzer that many of you have worked with. On the left is a listing of the databases and tables in your database that you can explore. At the top right is a color-coded SQL editor, and at the bottom right are the results of any query you run. Simply enter a SQL statement, click <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Run Query</span> to make sure it works. Once it does, click <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Return Data</span> to drop your data right back into your worksheet. And that’s it; your data is now in your Excel workbook, live and ready to use in Excel 2016 for Mac or Excel for Windows!</div>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Working with a third-party data provider works the exact same way. The only difference is that after installing the data provider, you select <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">New Database Query </span>><span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> From Database</span> and then select your data provider from the Apple iODBC manager.</div>
<h3 style="border: 0px; box-sizing: inherit; clear: both; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Now it’s your turn!</h3>
<div style="border: 0px; box-sizing: inherit; font-family: SegoeUI, "Segoe UI", sans-serif; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
We think we’ve made huge strides in making external data easier than ever in Excel 2016 for Mac and we hope you do too. Give it a try and let us know of any questions or feedback you have in the comments!</div>
</div>
</div>
</div>
</div>
</div>

Excel 2016 for Mac: Working with External Data

Excel 2016 for Mac: Working with External Data These days we all live and work in a multi-device, multi-platform world, and so when b...

Top 8 Tips and Tricks You Should Know For Excel 2016 for Mac User!

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; clear: both; line-height: 1.2; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; word-break: break-word;">
<span style="color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif;"><span style="font-size: 50px; font-weight: normal;">Top 8 Tips and Tricks You Should Know For Excel 2016 for Mac User!</span></span></h1>
<div>
<span style="color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif;"><span style="font-size: 50px; font-weight: normal;"><br /></span></span></div>
<div>
<span style="background-color: white; color: #404040; font-family: "segoeui" , "segoe ui" , sans-serif; font-size: 18px;">Since the release of Excel 2016 for Mac, customers have given great feedback about its ease of use and the benefits of the new features. We want to highlight the Excel 2016 for Mac features that customers rave about and share some tips and tricks that could save you a ton of time using the most powerful spreadsheet and data analysis tool on the Mac platform.</span></div>
<div>
<img alt="8 tips and tricks you should know for Excel 2016 for Mac 1 - 1" height="393" src="https://blogs.office.com/wp-content/uploads/2015/10/8-tips-and-tricks-you-should-know-for-Excel-2016-for-Mac-1-1-1024x631.png" width="640" /></div>
<div>
<br /></div>
<div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
</h3>
<div>
<br /></div>
<div>
<div align="center">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4982248272317148" data-ad-slot="8227855118" style="display: inline-block; height: 60px; width: 468px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

</div>
<br /></div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
5. Data Analysis ToolPak</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Still looking for the Data Analysis ToolPak in Mac Excel? It’s finally here! Data Analysis ToolPak is an Excel add-in that helps develop complex statistical or engineering analyses. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. Some tools generate charts in addition to output tables.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<img alt="8 tips and tricks you should know for Excel 2016 for Mac 7 - 1" height="371" src="https://blogs.office.com/wp-content/uploads/2015/10/8-tips-and-tricks-you-should-know-for-Excel-2016-for-Mac-7-1.png" width="640" /></div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
To enable this add-in, under the <span style="border: 0px; box-sizing: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Tools</span> menu, click <span style="border: 0px; box-sizing: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Add-Ins</span>, select <span style="border: 0px; box-sizing: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Data Analysis ToolPak</span> and then click <span style="border: 0px; box-sizing: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">OK</span>. The Data Analysis ToolPak is now on the ribbon under the <span style="border: 0px; box-sizing: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Data</span> tab.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<br /></div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
6. More (or new) keyboard shortcuts</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
When building Office 2016 for Mac, one of our key objectives was to make it as easy as possible to transition from using Office for Windows to using Office for Mac and back again. That’s why you’ll notice an interface consistent with Office 2016 for Windows and why we added support for virtually all of the Windows Excel keyboard shortcuts. Windows users will rejoice that Windows key assignments like Ctrl+O for Open, Ctrl+F for Find and Ctrl+C for Copy now also work in the Mac version—no need to remember to press Cmd instead of Ctrl. If you want to clear the content of the selected cell or range, just press the <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">delete</span> key. This even works on your Mac laptops, where delete is actually the backspace key. Some popular shortcut keys are listed below; a complete list can be found <a href="https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="_blank">here</a>.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<img alt="8 tips and tricks you should know for Excel 2016 for Mac 8" height="640" src="https://blogs.office.com/wp-content/uploads/2015/10/8-tips-and-tricks-you-should-know-for-Excel-2016-for-Mac-8.png" width="561" /></div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Note that if a function key doesn’t work as you expect, then press the <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">fn</span> key in addition to the function key. If you don’t want to press the fn key each time, you can change your Apple system preferences:</div>
<ol style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Go to <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Apple</span> > <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">System Preferences</span> > <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Keyboard</span>.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">On the <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Keyboard</span> tab, select the <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Use all F1, F2, etc. as standard function keys</span></li>
</ol>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
If you want to customize a keyboard shortcut, you can refer to the steps in this article: <a href="https://support.office.com/en-us/article/Create-a-custom-keyboard-shortcut-for-Office-2016-for-Mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321?ui=en-US&rs=en-US&ad=US" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="_blank">Create a custom keyboard shortcut for Office 2016 for Mac</a>.</div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
7. New functions in Excel 2016 for Mac</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
We worked hard to ensure your workbook is compatible and works seamlessly across platforms as often as possible. In Excel 2016 for Mac, we’ve added almost all <a href="https://support.office.com/en-us/article/New-functions-in-Excel-2013-075C82BD-15B9-4AD6-AF31-55BB6B011CB9" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="_blank">new formula functions in Excel 2013</a> from the Windows platform. Why not have a try on the Arabic function (for example, try <span style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">=ARABIC(“LVII”)</span>) and see what you get.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Note that the WebService, EncodeURL and FilterXML functions are not available yet in Excel 2016 for Mac.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<br /></div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
8. Get data using SQL Server ODBC</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
Say goodbye to having to use third party drivers before connecting to external data in Excel for Mac. Excel 2016 for Mac comes with a pre-installed and integrated SQL Server ODBC driver that supports ODBC data connections with SQL Server and Azure SQL Database right out of the box. It also has a brand new Microsoft Query (MSQuery) and Connection Manager to make creating and managing all of your data connections easier and more consistent with Windows. For more details, check out this blog post: <a href="http://www.microsoftexceltrainings.com/2017/03/excel-2016-for-mac-working-with.html" style="border: 0px; box-sizing: inherit; color: #0044cc; cursor: pointer; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="_blank">Working with external data in Excel 2016 for Mac</a>.</div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
<br /></div>
<h3 style="background-color: white; border: 0px; box-sizing: inherit; clear: both; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 24px; font-weight: inherit; line-height: 1.5; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
What do you think?</h3>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
We just went through the basics of the new features available in Excel 2016 for Mac. Try them out for yourself and share your ideas for other features and improvements you’d like us to change or improve in Excel 2016 for Mac.</div>
</div>
</div>

Top 8 Tips and Tricks You Should Know For Excel 2016 for Mac User!

Top 8 Tips and Tricks You Should Know For Excel 2016 for Mac User! Since the release of Excel 2016 for Mac, customers have given great...

Top 05 Microsoft Excel 2017 tips

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-outline-level: 1; text-align: justify; vertical-align: baseline;">
<span style="color: #222222;">Top 10 Microsoft Excel 2017 tips</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-outline-level: 1; text-align: justify; vertical-align: baseline;">
<span style="color: #222222;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">The numbers don't lie, so master your spreadsheets with these tweaks</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://cdn.mos.cms.futurecdn.net/de9728e2a2f251845b9c975d45c49dfb-650-80.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://cdn.mos.cms.futurecdn.net/de9728e2a2f251845b9c975d45c49dfb-650-80.jpg" /></a></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><b>Introduction</b><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Many of us spend a vast portion of our time banging our heads against
Excel. Unfortunately we can't help you make those specific figures line up in
Office 2016's spreadsheet app – that one's on you – but we can show you a few
things which will make your life easier.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">We're looking at tricks you can pull off inside the cells and out,
improving Excel's interface while making your calculations more powerful and
versatile. You'll be able to speed up data entry, change values worksheet-wide,
and much more.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">These tips are geared towards Excel 2016 users, and we've used Windows
to pull them off, but they should all work on versions of Excel from 2010
onwards and, with the appropriate shortcut substitutions, will do the job on
the Mac as well.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">

</span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Also check out our top Word 2016 tips, along with our PowerPoint 2016
tips and Outlook 2016 tips</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"></span></div>
<h3 style="background: rgb(255, 255, 255); border: 0px; color: #333333; font-family: "Open Sans", sans-serif; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; line-height: 30px; margin: 0px 0px 1em; padding: 0px; vertical-align: baseline; width: 602px;">
1. Automatic data</h3>
<div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">If you're preparing a spreadsheet but don't yet know what's going to go
into it, you can populate its fields with random sample data before the fact to
make sure your formulas are all working correctly. Click in the top left cell
of the area you'd like to fill and enter the formula =RANDBETWEEN(50,100) to
generate a number between 50 and 100. Change the values to suit the kind of
data you'll be working with.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Now just drag the fill handle of the cell over the area you want to
fill with data – it'll generate a new random number for each cell.</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"></span></div>
<h3 style="background: rgb(255, 255, 255); border: 0px; color: #333333; font-family: "Open Sans", sans-serif; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; line-height: 30px; margin: 0px 0px 1em; padding: 0px; vertical-align: baseline; width: 602px;">
2. No formula fumbling</h3>
</div>
<div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Writing your own formulas can be an arduous task, but modern versions
of Excel make it far easier than it once was. Head to the Formulas tab to find
the Function Library, a vast collection of all of Excel's formulas.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Click the cell in which you'd like to insert your formula, then dive in
– they're all categorised, each includes a description of its function if you
hover over it, and a straightforward interface in which to enter the values you
want calculated.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">The AutoSum function, in the same place, is a quick way to tot up
figures without any typing.</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"></span></div>
<h3 style="background: rgb(255, 255, 255); border: 0px; color: #333333; font-family: "Open Sans", sans-serif; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; line-height: 30px; margin: 0px 0px 1em; padding: 0px; vertical-align: baseline; width: 602px;">
3. Pasting up</h3>
</div>
<div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Certain formulas, like the random number generator described in our
first tip, will tend to make your numbers jump around somewhat. If you'd rather
keep them static, you can copy the data and, using the right click menu, paste
only the generated values without the formulas. This is also a good way to
distribute spreadsheets for reading without revealing your workings.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Explore the Paste Special menu to see what other kinds of paste
operations you can perform: try using Paste Link to quickly create linked cells
between sheets, or Transpose to paste a grid of data with the columns and rows
swapped around.</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"></span></div>
<h3 style="background: rgb(255, 255, 255); border: 0px; color: #333333; font-family: "Open Sans", sans-serif; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; line-height: 30px; margin: 0px 0px 1em; padding: 0px; vertical-align: baseline; width: 602px;">
4. See formulas</h3>
</div>
<div>
<span style="color: #222222; font-size: 12pt;">Clicking through a sheet full of numbers to find out how they've come
to be is not a task many would relish. It's slow and laborious, and easy to lose
track. Better, then, to use the shortcut [Ctrl]+[ ] (that's the key at the
top-left of your keyboard – just below the Escape key) to show all of the
formulas on your sheet instead of their result. Hit the shortcut again to
switch them back.</span></div>
<div>

<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">If, for some reason, you want the sheet to show the text of a formula
rather than the result of it – perhaps you're creating a demonstration sheet to
show how things are meant to work – just right click the cell it's in and
select Format Cells > Text.</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;"></span></div>
<h3 style="background: rgb(255, 255, 255); border: 0px; color: #333333; font-family: "Open Sans", sans-serif; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; line-height: 30px; margin: 0px 0px 1em; padding: 0px; vertical-align: baseline; width: 602px;">
5. Quick formatting</h3>
</div>
<div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">Drag to select a group of data, and look out for an icon appearing at
the bottom-right hand corner of your selection area. This could be Excel's
coolest feature: the quick analysis tool.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #222222; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman"; mso-font-kerning: 18.0pt;">It gives you instant access to a bunch of useful formatting features,
all the way from colouring up your cells based on their range to implementing
sparklines, sums and charts. Hover over each option to see a preview and click
it to lock it down. Use the same tool to clear formatting if it gets too much –
you'll find the clear option listed under the Formatting heading.</span><o:p></o:p></div>
</div>
</div>

Top 05 Microsoft Excel 2017 tips

Top 10 Microsoft Excel 2017 tips The numbers don't lie, so master your spreadsheets with these tweaks ...

Microsoft Excel - 20 Tricks That Can Make Anyone An Excel Expert

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/spreadsheet2-1024x545.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="spreadsheet2" border="0" height="340" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/spreadsheet2-1024x545.jpg" width="640" /></a></div>
<div class="MsoNormal" style="margin-left: 1em; margin-right: 1em;">
<br /></div>
<br />
<br />
<div class="MsoNormal">
After Microsoft developed Excel to the 2010 version, it
offered more surprises than ever. In order to deal with tons of big data, you
can’t ignore the important role Excel plays in daily work. However, both for
beginners and advanced users, there are still many useful tips and tricks that
are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may
not know. Please note that all these functions are based on Microsoft Excel
2010.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="text-align: center;">
</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>1. One Click to
Select All<o:p></o:p></b></div>
<div class="MsoNormal">
You might know how to select all by using the Ctrl + A
shortcut, but few know that with only one click of the corner button, as shown
in the screenshot below, all data will be selected in seconds.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<img alt="One Click to Select All" height="640" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-1.jpg" style="text-align: center;" width="528" /></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>2. Open Excel Files
in Bulk<o:p></o:p></b></div>
<div class="MsoNormal">
Rather than open files one by one when you have multiple
files you need to handle, there is a handy way to open them all with one click.
Select the files you would like to open then press the Enter key on the
keyboard, all files will open simultaneously.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Open Excel Files in Bulk" height="318" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-2.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>3. Shift Between
Different Excel Files<o:p></o:p></b></div>
<div class="MsoNormal">
When you have different spreadsheets open, it’s really
annoying shifting between different files because sometimes working on the
wrong sheet can ruin the whole project. Using Ctrl + Tab you can shift between
different files freely. This function is also applicable to other files like
different Windows tabs in Firefox when opened using Windows 7.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Shift Different Excel Files" height="195" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-3.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>4. Create a New
Shortcut Menu<o:p></o:p></b></div>
<div class="MsoNormal">
Generally there are three shortcuts in the top menu, which
are Save, Undo Typing and Repeat Typing. However, if you want to use more
shortcuts, like Copy and Cut, you can set them up as follows:<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Create New Shortcut Menu" height="138" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-4.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>5. Add a Diagonal
Line to a Cell<o:p></o:p></b></div>
<div class="MsoNormal">
When creating a classmate address list, for example, you may
need a diagonal link in the first cell to separate different attributes of rows
and columns. How to make it? Everyone knows that Home->Font-> Borders can
change different borders for a cell, and even add different colors. However, if
you click More Borders, you will get more surprises, like a diagonal line.
Click it and save—you can now make it immediately.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Add Diagonal Line for a Cell" height="581" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-5.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>6. Add More Than One
New Row or Column<o:p></o:p></b></div>
<div class="MsoNormal">
You may know the way to add one new row or column, but it
really wastes a lot of time if you need to insert more than one of these by
repeating this action X number of times. The best way is to drag and select X
rows or columns (X is two or more) if you want to add X rows or columns above
or left. Right click the highlighted rows or columns and choose Insert from the
drop down menu. New rows will be inserted above the row or to the left of the
column you first selected.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Add More Than One New Row/Column" height="222" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-6.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>7. Speedily Move and
Copy Data in Cells<o:p></o:p></b></div>
<div class="MsoNormal">
If you want to move one column of data in a spreadsheet, the
fast way is to choose it and move the pointer to the border, after it turns to
a crossed arrow icon, drag to move the column freely. What if you want to copy
the data? You can press the Ctrl button before you drag to move; the new column
will copy all the selected data.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Speedy Move and Copy Data in Cells" height="511" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-19.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>8. Speedily Delete
Blank Cells<o:p></o:p></b></div>
<div class="MsoNormal">
Some default data will be blank, for various reasons. If you
need to delete these to maintain accuracy, especially when calculating the
average value, the speedy way is to filter out all blank cells and delete them
with one click. Choose the column you want to filter, go to Data->Filter,
after the downward button shows, undo Select All and then pick up the last
option, Blanks. All blank cells will show immediately. Go back to Home and
click Delete directly, all of them will be removed.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Speedy Delete Blank Cells" height="640" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-8.jpg" width="480" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>9. Vague Search with
Wild Card<o:p></o:p></b></div>
<div class="MsoNormal">
You may know how to activate the speedy search by using the
shortcut Ctrl + F, but there are two main wild cards—Question Mark and
Asterisk—used in Excel spreadsheets to activate a vague search. This is used
when you are not sure about the target result. Question Mark stands for one
character and Asterisk represents one or more characters. What if you need to
search Question Mark and Asterisk as a target result? Don’t forget add a Wave
Line in front.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Vague Search with Wild-card" height="224" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-9.jpg" width="640" /></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>10. Generate a Unique
Value in a Column<o:p></o:p></b></div>
<div class="MsoNormal">
You are aware of the key function of Filter, but few people
use the Advanced Filter, which will be repeatedly applied when you need to
filter a unique value from data in a column. Click to choose the column and go
to Data->Advanced. A pop-up window will show up. As the screenshot shows,
click Copy to another location, which should be in accord with the second red
rectangular area. Then specify the target location by typing the value or
clicking the area-choosing button. In this example, the unique age can be
generated from Column C and show in Column E. Don’t forget to choose Unique
records only, then click OK. The unique value showing in column E can be the
contrast of the original data in C, that’s the reason why it is recommended to
copy to another location.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Generate Unique Value in Column" height="272" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-10.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>11. Input Restriction
with Data Validation Function<o:p></o:p></b></div>
<div class="MsoNormal">
In order to retain the validity of data, sometimes you need
to restrict the input value and offer some tips for further steps. For example,
age in this sheet should be whole numbers and all people participating in this
survey should be between 18 and 60 years old. To ensure that data outside of
this age range isn’t entered, go to Data->Data Validation->Setting, input
the conditions and shift to Input Message to give prompts like, “Please input
your age with whole number, which should range from 18 to 60.” Users will get
this prompt when hanging the pointer in this area and get a warning message if
the inputted information is unqualified.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Input Restriction with Data Validation Function" height="493" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-11.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>12. Fast Navigation
with Ctrl + Arrow Button<o:p></o:p></b></div>
<div class="MsoNormal">
When you click Ctrl + any arrow button on the keyboard, you
can jump to the edge of the sheet in different directions. If you want to jump
to the bottom line of the data, just try to click Ctrl + downward button.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Fast Navigation with Ctrl + Arrow Button" height="640" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-21.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>13. Transpose Data
from a Row to a Column<o:p></o:p></b></div>
<div class="MsoNormal">
You would use this feature if you want to transpose data to
get a better display; however, retyping all data would be the last thing you
would need to do if you know how to use the Transpose function in Paste. Here’s
how: copy the area you want to transpose, move the pointer to another blank
location. Go to Home->Paste->Transpose, please note that this function
won’t activate until you copy the data first.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Transpose Data from Row to Column" height="132" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-12.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>14. Hide Data Thoroughly<o:p></o:p></b></div>
<div class="MsoNormal">
Almost all users know how to hide data by right clicking to
select the Hide function, but this can be easily noticed if there is only a
little bit of data. The best and easiest way to hide data thoroughly is to use
the Format Cells function. Choose the area and go to Home->Font->Open
Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all
the values in the area will be invisible, and can only be found in the preview
area next to the Function button.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Hide Data Thoroughly" height="386" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-13.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>15. Compose Text with
&<o:p></o:p></b></div>
<div class="MsoNormal">
Complicated formulation is unnecessary, as long as you know
how to use &. You can compose any text freely with this symbol. Below I
have four columns with different texts, but what if I want to compose them to
one value in one cell? First, locate the cell that is to show the composed
result, use the formulation with & as shown in the screenshot below. Click
Enter: all texts in A2, B2, C2 and D2 will be composed together to become
LizaUSA25@ in F2.<o:p></o:p></div>
<div class="MsoNormal">
<img alt="Compose Text with &" height="246" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-14.jpg" width="640" /><b> </b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b>16. Transforming the
Case of Text<o:p></o:p></b></div>
<div class="MsoNormal">
With all the tricks shared here, I’ve tried my best to avoid
complicated formulation. But there are still some simple and easy to use
formulations to show you, like UPPER, LOWER and PROPER, which can transform
texts for different purposes. UPPER will capitalize all characters, LOWER can
change text to all lower case and PROPER will only capitalize the first
character of a word.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Text Transform" height="282" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-15.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>17. Input Values
Starting with 0<o:p></o:p></b></div>
<div class="MsoNormal">
When an input value starts with zero, Excel will delete the
zero by default. Rather than reset the Format Cells, this problem can be easily
solved by adding a single quote mark ahead of the first zero, as shown.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Input Value Starts with 0" height="392" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-16.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>18. Speed up
Inputting Complicated Terms with AutoCorrect<o:p></o:p></b></div>
<div class="MsoNormal">
If you need to repeat the same value and it is complicated
to input, the best way is to use the AutoCorrect function, which will replace
your text with the correct text. Take my name, Liza Brown, for example, which
can be replaced by LZ. Therefore, every time I input LZ, it can autocorrect to
Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and
input Replace text with correct text in the red rectangular area, as below.<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="Speed up Inputting Complicate Terms with AutoCorrect" height="620" src="http://cdn-media-2.lifehack.org/wp-content/files/2014/05/1-17.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>19. One Click to Get
More Status<o:p></o:p></b></div>
<div class="MsoNormal">
Most users know how to check the data status in the bottom
of an Excel sheet, like Average and Sum Value. However, do you know you can
move the pointer to the bottom tab and right click to get more status, as shown
below?<o:p></o:p></div>
<div class="MsoNormal">
<o:p><img alt="One Click to Get More Status" height="334" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-18-1024x535.jpg" width="640" /> </o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<b>20. Rename a Sheet
Using Double Click<o:p></o:p></b></div>
<div class="MsoNormal">
There are multiple ways to rename sheets, and most users
will right click to choose Rename, which actually wastes a lot of time. The
best way is to just click twice, then you can rename it directly.<o:p></o:p></div>
<div class="MsoNormal">
<o:p> </o:p><img alt="Rename Sheet by Double Click" height="130" src="http://cdn-media-1.lifehack.org/wp-content/files/2014/05/1-20.jpg" width="640" /></div>
<div class="MsoNormal">

</div>
<div class="MsoNormal">
<br /></div>
</div>

Microsoft Excel - 20 Tricks That Can Make Anyone An Excel Expert

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, ...

Latest Post