When you want to graph 3 line series, but only want 2 in focus most of the time.Want to get more out of Excel? At Microsoft's inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016.
#Lynda excel for mac how to#
How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability.īuilding Combination Line and Area Charts Learn how to build an effective pie chart, and when you should and shouldn’t use them.
How to create an effective bar chart by reducing ink and noise that distract from the story. Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages. Learn to create custom conditional formatting rules based on formulas. Learn to create top/bottom and highlight cell rules, as well as to apply icon sets and data bars. Learn to build your own custom number formats to display dates, values and variances how you want to see them. Learn about adding and working with Excel’s outlining tools to quickly hide irrelevant sections of your worksheet. Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells. Note: this lesson uses Excel Tables, which are introduced in the next section. Learn to work with INDEX, MATCH and HLOOKUP, as alternatives to the VLOOKUP function.Īn introduction to the new XLOOKUP function in Microsoft 365. Bye, bye VLOOKUP, HLOOKUP and INDEX/MATCH! Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column. Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column. Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another. Learn about creating and updating external links, and about the potential dangers of external links in Excel. Learn to use SUMIF and COUNTIF to add cells only when certain conditions are met. Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation. Over 51,000 people like you have learned practical, actionable skills from these self-paced online Excel classes to help them work smarter every single day.Īre you ready to master Excel? Become a certified Excel ninja today. How to impress your boss and colleagues with your super sharp Excel skills.How to customize your page setup options for printing.How to use data validation to restrict data entry.How to record a basic Macro to automate repetitive tasks.How to work with charts to present clear insights from your data.
How to sort and filter your data to find exactly what you are looking for.How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH.How to use math, statistical, logic and text functions.How to save yourself hours of time and boost your productivity in Excel.How to be a better, faster, and stronger Excel user.Online Excel classes to help unlock your potentialīy the end of the course, you will be equipped with the real-world Excel knowledge you need to accomplish your daily tasks with ease.Īnd your sought-after Excel certification can help you impress your employer and advance your career prospects. GoSkills Basic and Advanced online Excel courses can quickly get you up to speed with Excel, taking you from complete novice to Excel ninja. Looking for Microsoft Excel training to improve your skills and save you time? Become a certified Excel ninja with our #1 online Excel training
0 kommentar(er)
