Need some examples of sales or Marketing data, I am not in finance and I found some challenges to understand some examples in the videos. Other than this point it is a fantastic structured course
This course will teach you in-demand Excel techniques for more sophisticated data manipulation in Excel. Some of these include building nested functions, using new Excel keyboard shortcuts for more efficiency, formatting sheets and charts professionally, and more. You will also learn several hidden Excel tips and tricks that you usually don’t find in textbooks.
The Advanced Microsoft Excel course will provide you with the necessary skills to implement more sophisticated data manipulation. With our help, you will:
Professional formatting is one of the most important elements of data analysis, financial modeling and working in Excel in general. In these lessons, you’ll learn how to format spreadsheets in several different ways. And, more importantly, after these lessons, your work will look great!Let's Start from Scratch and Create a P&L Sheet Free Cell Styles Allow You to Be Faster Free Pasting Values, Formulas, and Formats with Paste Special Free Formatting Cells Part I - Working with Data in Excel Free Formatting Cells Part II - Customize Numbers the Way You Like Free Highlight Key Data with Excel Conditional Formatting Free Filter by Color Free
It is time to focus on Excel navigation: how to be fast when selecting cells, rows, columns, and how to work with shortcuts. We will study a number of different techniques that will allow you to be super efficient in Excel.Use Multiple Screens Simultaneously F1 to F12 - Using Excel's Function Keys How to Select Visible Cells Only Grouping Excel Rows and Columns - The Correct Way to Do It! Working on Multiple Sheets at the Same Time
Here, we will introduce some indispensable tools, such as find and replace, circular references, and trace precedents. Not only that, but we will also study their practical application.Find & Replace - Our Favourite Excel Tool A Great Way to Apply Find & Replace What Are Circular References in Excel Circular References - An Example Trace Precedents - Display the Relationship Between Formulas and Cells
Very often the difference between intermediate and advanced Excel users is the number of functions in their arsenal. In this part of the course, we will work with advanced functions that will help you boost your productivity significantly.What is a Nested Function? Advanced Excel Functions Index; Match; Index & Match Advanced Excel Functions Index, Match, Match Advanced Excel Functions Indirect; Vlookup & Indirect Advanced Excel Functions Rows; Columns; Vlookup & Columns Advanced Excel Functions Vlookup & Match Advanced Excel Functions Choose; Vlookup & Choose Advanced Excel Functions Offset; Offset & Match Date Functions
with Ned Krastev and Martin Ganchev