• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
    • Power BI
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


Best Excel Power BI Course for 2025: Learn from the Experts

May 8, 2025 by Mark Leave a Comment

Excel Power BI course

Are you looking to bridge the gap between Excel and Power BI? Whether you're a seasoned Excel user or just starting your data journey, mastering Power BI is a game-changer. Today, data-driven decisions are no longer optional—they're essential. That’s why we’ve sourced the Best Excel Power BI course to help you level up your skills, fast. Why Combine Excel and Power … [Read more...]

What are MS Excel Tables – Tips and Tricks

April 5, 2018 by Mark Leave a Comment

Introduction There are two ways of organizing your data in Excel, either it could be a list or it could be a excel table. Both has its advantages and disadvantages. In today’s post, we will try to learn about the later and see how to get most out of it – i.e. excel tables. Tables are identified by a header row and a column, where is for list, there is only a header row. … [Read more...]

Creating Project Timeline or Gantt Chart with MS Excel

March 12, 2018 by Mark Leave a Comment

Creating a Project Timeline in Excel A project is a onetime activity that can span over varying length of time. A project could be an activity that can finish in a day or it could cover months and years. Project management is the process of managing this activity. As the complexity of the project increases, it becomes more and more difficult to manage it, hence require more … [Read more...]

A how-to guide to conditional formatting based on another cell

November 8, 2017 by Mark Leave a Comment

first_name

Introduction The conditional formatting is used for highlighting cells that meet certain criteria. These cells can be duplicate values or they may fall within certain limits or a similar criteria. In today’s tutorial we will be explaining how to highlight a cell’s value when it meets criteria in a cell. Most often we use cell referencing to set criteria for conditional … [Read more...]

Getting Most Out of COUNTIF() and COUNTIFS() function in Excel

October 16, 2017 by Mark Leave a Comment

warehouse_2_countifs

Introduction: There are instances when we are interested in counting things. This is true for accountants, engineers, managers and so on. To count, we usually record quantities, either on paper on spread – or if we record on paper, we eventually transfer it to a spreadsheet to make calculations more manageable. COUNTIF() or COUNTIFS() is the function that we use when doing … [Read more...]

Next Page »
Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Power BI Webinar
Power BI Course
Free Excel Dashboard Webinar

Copyright © 2025 · Magazine Pro Theme on Genesis Framework

Login Form