
Discover why Excel remains popular and how learning core features—workbooks, worksheets, charts, formulas, functions, pivot tables, data cleaning, and visualization—empowers you to analyze and transform data efficiently.
Build a solid foundation in Excel with essential basics for beginners preparing for an interview, and progress toward more advanced functionalities for real-world work.
Learn to build a line chart comparing 2021 to 2020 results, with monthly points, then refine the title and vertical axis to highlight year-over-year performance.
Learn to remove duplicates in a single column outside a table to identify unique entries, and understand risks to adjacent data when shortcuts ignore nearby fields.
Lock cells in excel by surrounding references with dollar signs to keep them fixed when copying formulas, as shown in a 2.4 percent inflation calculation and dragging down.
Master locking rows and columns with dollar signs to create a universal Excel formula that stays anchored to the correct CPI and category as you drag across months.
Explore Excel's view side by side to compare two workbooks at once with synchronized scrolling, rearrange panes, and analyze 2020 versus 2021 income and operating expenses.
Explore part V introduction to Excel formulas, including ifs, and learn conditional formatting techniques for practical finance and data analysis tasks.
Apply the sumifs formula to calculate gross profit with multiple criteria, filtering revenue over 100000 and costs under 20000, and evaluate if gp meets the 50% threshold.
Demonstrate how the and formula tests multiple conditions—such as gender, age, and work experience—and returns true only when all criteria are met.
Apply conditional formatting in Excel by setting rules such as greater than, less than, or between to highlight salaries, then filter results by color to show values above 40k.
Apply text-based conditional formatting to highlight cells with specific text (for example, Germany or Bulgaria) and to flag top salary rows with a yellow fill.
Advance through Excel fundamentals by exploring len and trim, left and right formulas, vlookup and xlookup, and combining index and match for powerful lookups.
Learn how the index match formula combines the index and match functions to search and return values using vertical and horizontal criteria, with a basic revenue report demonstration.
Excel 101! The easiest way to learn Microsoft Excel available!!
Start using Excel flawlessly and combine functions, graphs and formatting to create your best work ever.
As a certified expert and practitioner who's worked with Excel for more than four years, I can tell you that many people think they understand how to work with Excel, while their skills are delimited by the repetitive every-day tasks and have no motivation or time to learn something new. After work most of us feel as if we don't want to even start that 20+ hours long course, as we are very well-aware we most probably won't finish it.
Excel 101 has been built and designed to make it as easy as possible for you to become the better, more knowledgeable, version of Excel user in almost no-time.
Prepare yourself for a fast-paced, a dynamic, no time-waster type of a course, where everything is demonstrated on the go and presentations are used as little as possible. Every lecture has been recorded in a way to be short, concise, but at the same time not to skip over important information. The practical examples, although simple at times, will give you a better understanding of the every-day usage of the functionalities I present to you.