Excel Power Query IntroductionWhat is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […] October 2, 2022 in Excel tagged power / BI / business intelligence / ETL / query / Excel Power Query by Mike
Excel Dynamic Data ValidationWhat do we mean by dynamic data validation? Suppose we are asking users to enter a product (or […] October 1, 2022 in Excel tagged data / validation / dynamic by Mike
Excel Data ValidationData validation allows you to limit or restrict the values that a particular cell will accept. It allows […] October 1, 2022 in Excel tagged data / validation / valid by Mike
Excel Conditional FormattingConditional formatting is a spreadsheet tool that changes how cells appear when values meet specific conditions. Here we’ll […] September 30, 2022 in Excel tagged excel / format / if / conditional by Mike
Excel Workbook PropertiesYou can modify your Excel workbook (file) properties to better find, document, and describe your Excel files. For […] September 28, 2022 in Excel tagged excel / file / properties / workbook by Mike
Excel SparklinesSparklines were introduced in Excel 2010 to represent data in any tiny chart form without an axis and […] September 27, 2022 in Excel tagged sparkline / excel / chart by Mike
Pivot Table Data StructureFor your Excel pivot tables to be useful and easy to work with, you must first ensure that […] September 25, 2022 in Excel tagged data / clean / structure / Excel Pivot Tables by Mike
Excel Tables IntroductionWhat is an Excel table? Before answering that I will define the word tabular. If data is in […] September 5, 2022 in Excel tagged filter / table / sort / tables / Excel Tables by Mike
Excel Headers and FootersThis post is about a few suggestions and tips about setting up our headers and footers in your […] August 29, 2022 in Excel tagged excel / headers / footers by Mike
Excel IntroductionWikipedia says: “Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features […] May 24, 2022 in Excel tagged introduction / beginner / excel by Mike
Excel Table NamesWhat are some of the best practices for naming your tables in Microsoft Excel? The website Excel Campus […] December 10, 2021 in Excel tagged table / name / Excel Tables by Mike
Excel Pivot Tables IntroductionWhat are Pivot Tables in Microsoft Excel? First of all, let’s discuss tables. In Excel, a table is […] December 5, 2021 in Excel tagged table / tables / pivot / Excel Pivot Tables by Mike