(Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter
Mar 25, 2016 Excel Advanced Formulas & Features
Get the full course: https://courses.xelplus.com
Build a strong foundation in Excel to solve complex problems fast.
- Use my top 10 tips to save time
- Learn the top 10 formulas for quick and dynamic analysis
The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.
Advanced Excel skills are highly relevant in business. No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in Finance, consulting, IT, in project management, your advanced Excel skills will set you apart from the competition.
What is the difference between an Advanced and Average Excel user?
An advanced Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation. Advanced users, always find the optimal solution for every task, and they find it fast!
What differentiates this Excel course from others?
The reason I created this course is because there are many advanced Excel users who are unaware key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.
Differentiation factor #1
Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel.
Differentiation factor #2
Learn by doing - The course is well structured and organized. You can download my Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.
Differentiation factor #3
Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.
Summary
My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.
Becoming advanced takes practice, readiness to learn new methods and willingness to apply these to practical cases.
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
43
views
3 Tips for Impressive Excel Charts
Feb 10, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com
Advanced Excel Charts: 3 Steps you need to follow to make good charts
Summary: Are you unsure how to improve the charts and tables in your Excel reports? How to visualize your data for a clear message? Not sure what is easy, effective and possible in Excel? Learn all of this and more at your own pace with my online training.
In this lecture I provide an overview of what makes a chart effective – by effective I mean the reader is able to clearly understand the message that you are trying to communicate - Charts should be "SCC" - Simple, Clear & consistent.
Detail: Now lets have a look at each parameter for Simple, Clear & Consistent
For Simple:
- Strip your Chart: take away components, colors, images and anything else that does not matter
a. Take away background color
b. Lighten the grid lines or take them away entirely
c. You can remove the Y axis if you show data labels or only show beginning & end values
- Stick to simple fonts. They shouldn’t be too small and difficult to read
- Stick to 2D
For clear:
As noted by Edward Tufte “Above all else show the data”. In his book the Visual Display of Quantitative information he talks about the concept of the data-ink ratio. Data-ink ratio is the amount of ink that shows the information as compared to the total amount of ink. Basically what it comes down to is don’t waste ink on things that don’t matter. Use your ink to show and highlight what matters. The way you highlight, is either you reduce the ink from the surroundings, or you increase the ink of the element you like to highlight. Simplified charts ensure your attention is driven to the data: to what matters.
- Have a title – Every chart should have a title. Your readers shouldn’t have to figure it out. The title should be on top of the Chart. Reports are read from top to bottom and in the western world from left to right. The top left corner has a great impact but up middle is also good.
- Tell the story – the truth and nothing but the truth. Don’t have breaks in the axis such as a gap between the values – i.e. have consistent scaling. Start form zero. Sometimes you want to concentrate attention to the pattern of a section of the graph and you might not do your story justice if you start from zero. In this case you can add a second graph where the y axis doesn’t start from zero. If you do start your axis other than zero, make sure you inform the readers. If you are using a column chart though, always start from zero.
-If you have more than one series you need legends. These are your series labels. Whenever you can – such as for line graphs, place the legends by the series. If you can't place it by the series, then place them either on top, below the title or on the right hand-side.
- Boost elements: do emphasize the most important part if there is a certain point you want to make and you want your readers to find it fast.
Consistent: Use the same colors throughout your reports. Actual series should always stand out and have a consistent color throughout the report. Keep consistent colors for Budget and Outlook series. The colors that work well are different shades of grey & blue. It also depends on the logo and color mix of your organization. If your organization has a brown logo, you might want to use a shade of Brown for Actual series, if it is blue, then blue might work better. Whatever color you choose, you should stick with it throughout your report.
That’s SCC - Simple, Clear & consistent. Every time you design a chart, make sure it’s as SCC as it can get. Then go beyond SCC and ensure it is as dynamic as it can get. If you have a chart that you need to update every month by dragging or updating the input range then implement the techniques that I will show you in the online excel training.
This is specially beneficial for controllers and financial analysts looking to enhance their corporate reports to include better & improved charts.
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
58
views
Excel Advanced Charts: Comparison to Budget, Previous Year and Forecast or Outlook
Jan 27, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com
Written instructions: http://www.xelplus.com/companion-charts/
Excel Advanced Charts: Measuring performance, doing comparisons and predicting the future - Comparison to Budget, Previous Year and Forecast or Outlook.
Not sure which charts & methods to use to show performance and variances? This lecture will provide you with some examples that are covered in my Excel online visualization course.
Summary: This lecture provides you with an overview of different methods used for visualizing performance comparisons, deviations, as well as future estimated performance. It introduces you to the topics and charts that you will learn in this section as well as the next two sections.
This is specially beneficial for controllers and financial analysts looking to enhance their corporate reports to include better & improved charts.
Detail: In every corporate report, you have sections where you make comparison of actual values to budget or target values. In this section I will show you the most effective ways of making these comparisons.
You will also compare your performance to PY to see if you did better or worse. There are different way of doing this. My favorites are using symbols and using what I call the pin chart. I will show you these in the next section.
Lastly you will also have reports where you show how you expect to be performing for the rest of the year. These are called your forecasts or outlooks. I will show you some methods of displaying these effectively in Excel in the section after next.
One point to emphasize is the consistent use of colors in your reports. Make sure your actuals have the same colour throughout your reports. They should be clearly in focus and visible. Basically stand out against budget, target, previous year, forecasts and any other series you have.
In the same manner, be consistent with the use of color for your other series.
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
9
views
Improve readability of Excel Line Charts: Dynamic Legends in Excel
Jan 18, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com
Written Instructions: http://www.xelplus.com/excel-charts-dynamic-line-series-labels/
Excel Advanced Charts & Graphs Tutorials: Dynamic Series Labels - Create Dynamic Legends in Microsoft Excel and SAVE TIME!
In this Video learn how to create dynamic series labels and avoid the default Excel Legend. Why? Because default legends are too much work. Not for you, because they are there by default so you don’t even have to click anything but they can be too much work for your readers. They need to think more than they should about which color or texture belongs to which category. Do them a favor and create dynamic legends whenever possible with perfect positioning so there is no work for them. Make it instantly crystal clear what series they are looking at. I’m not saying you should do this ALL the time, but you should do this whenever you think it will not only look better but make it easier to follow. Put yourself in your readers shoes.
In this Excel Tutorial you will learn how to perfectly positon your line series labels in a dynamic manner so that even if you add more data to your Excel table, your dynamic labels move with. This is specially beneficial for controllers and financial analysts.
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
22
views
1
comment
Microsoft Excel: How to Improve your Charts & Tables for Better Communication - Promo
Jan 13, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com
Microsoft Excel Tutorials: Learn Advanced Excel Chart Tricks & Techniques - Promo:
If you use Microsoft Excel to generate reports that include charts and graphs, my hands-on Excel training "Excel: Visualization Secrets for Impressive Charts" provides you with an extremely advanced toolkit worth of knowledge that will take the design of your charts and tables to the next level, and will also provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers.
You will be the Excel data Visualization star in your department.
This Advanced Excel Chart & Graph course is right for you if you’re:
• Controller or financial analyst responsible for creating monthly, quarterly or yearly reports
• Finance or department manager looking for new effective methods to communicate your message visually
• A student planning to work as a business or financial analyst or in any function that will require data visualization
• All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course.
Looking forward to having you in my course.
Watch the other preview videos related to the course here:
https://youtu.be/cYHOezDL8SQ
https://youtu.be/FPxCKs4OlWE
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
35
views