Posts Uncategorized D-functions in Excel December 5, 2025November 29, 2025 Business Intelligence Maven CRM Sales Opportunities, free data sets November 22, 2025November 5, 2025 Uncategorized SUMIF based on first digits November 4, 2025October 21, 2025 Functions Regression analysis for flat prices October 24, 2025October 14, 2025 Uncategorized Simple Office Script in Excel October 7, 2025September 25, 2025 Excel Substituting Scandinavian letters September 20, 2025September 10, 2025 Functions Pivot format September 6, 2025September 5, 2025 Graphics Copilot in Excel August 22, 2025August 1, 2025 Access Reporting with Access August 2, 2025July 4, 2025 Uncategorized TEXTSPLIT July 14, 2025July 2, 2025 Graphics Lowest point – economic order quantity June 28, 2025June 28, 2025 Access Pivot with database May 6, 2025May 6, 2025 Functions PROPER and NUMBERVALUE March 15, 2025March 15, 2025 Python Exchange rates with Excel Python January 31, 2025January 31, 2025 Excel Sum If Not December 31, 2024December 31, 2024 Business Intelligence Three dimensional Excel sheet November 12, 2024November 11, 2024 Functions Debit and credit balances October 14, 2024October 12, 2024 Functions Initial zeroes September 28, 2024September 14, 2024 Power BI Maven Video Game Sales September 14, 2024September 14, 2024 Business Intelligence Maven UK train rides August 24, 2024August 10, 2024 Graphics Correlation August 10, 2024August 3, 2024 Graphics Accumulation curve July 31, 2024July 31, 2024 Functions Quartile June 29, 2024June 29, 2024 Functions MODE June 19, 2024June 19, 2024 Uncategorized Analyze data May 29, 2024May 28, 2024 Graphics Histogram May 17, 2024May 17, 2024 Graphics One line with two colors April 29, 2024April 26, 2024 Functions TRIMMEAN April 13, 2024April 13, 2024 Functions DURATION function March 30, 2024March 29, 2024 Uncategorized Two security portfolio and solver March 14, 2024March 12, 2024 Excel Count playing cards February 28, 2024February 27, 2024 Excel Values above or below average February 10, 2024January 31, 2024 Excel Counting three million records January 30, 2024January 30, 2024 VBA Average with NULL values January 8, 2024December 22, 2023 Graphics Count and sum based on cell colours December 27, 2023December 8, 2023 Uncategorized Count finds in MS Access December 12, 2023December 4, 2023 Graphics Nearest dots in scatter graph November 30, 2023November 30, 2023 Functions SUM based on length October 24, 2023October 24, 2023 Functions INT function September 6, 2023September 5, 2023 Excel Moving average in Excel August 21, 2023August 19, 2023 Excel Dynamic SUM last five values August 4, 2023August 4, 2023 Excel Remove duplicates May 12, 2023May 6, 2023 Uncategorized Standard deviation in Excel April 29, 2023April 22, 2023 Excel Value added tax functions April 22, 2023 Functions Extracting XML March 6, 2023February 24, 2023 Graphics Simple deviation graph February 22, 2023February 22, 2023 VBA VLOOKUP and TRIM February 10, 2023February 10, 2023 Uncategorized SWITCH with conditions January 14, 2023January 13, 2023 Business Intelligence Maven Pizza place sales December 21, 2022December 21, 2022 Excel Dates in reporting December 5, 2022December 5, 2022 Business Intelligence Data in several tables November 19, 2022November 19, 2022 Excel SUM IF NOT October 31, 2022October 31, 2022 Functions TRIMMEAN function in reporting October 22, 2022October 22, 2022 Excel SWITCH function August 27, 2022August 27, 2022 Excel Consolidation July 31, 2022July 30, 2022 Uncategorized Automated SUM July 11, 2022July 7, 2022 Excel SUMIF with asterisk July 2, 2022July 2, 2022 VBA Running number June 10, 2022June 10, 2022 Business Intelligence XML data May 28, 2022May 25, 2022 Excel Scenario Manager May 14, 2022May 14, 2022 Excel Goal Seek April 30, 2022April 30, 2022 Excel OFFSET for transpose April 16, 2022April 16, 2022 Uncategorized Lambda: simple VAT calculation March 28, 2022March 26, 2022 Business Intelligence 5M rows in MS Access March 15, 2022March 14, 2022 VBA Dynamic SUM for data range February 25, 2022February 12, 2022 Graphics Cost volume analysis graph February 4, 2022January 15, 2022 Excel COUNTA in accounting January 26, 2022January 5, 2022 Business Intelligence Cubemember and cubevalue January 4, 2022 Excel Search and count December 23, 2021 Excel Flash fill December 7, 2021 Business Intelligence Accounting data in BI November 18, 2021November 13, 2021 Business Intelligence Unpivot in Power Query November 5, 2021October 22, 2021 Business Intelligence Geographic data in Tableau October 21, 2021October 6, 2021 Business Intelligence Accounting data in Tableau October 6, 2021October 1, 2021 Excel Vlookup in reporting September 29, 2021 Excel Date to month/year September 11, 2021 Excel Find a string August 20, 2021November 11, 2021 Functions TRANSPOSE function August 3, 2021July 21, 2021 Business Intelligence DAX “related” function and SQL July 22, 2021June 30, 2021 Functions INDEX application July 2, 2021June 8, 2021 Business Intelligence Maven Analytics 2015 New Year’s Eve resolutions tweets challenge June 19, 2021November 11, 2021 Business Intelligence Sales postings higher than 1000 in MySQL June 4, 2021April 23, 2021 Functions XLOOKUP May 24, 2021April 17, 2021 Excel Email generator May 4, 2021May 8, 2021 Excel Digits between two underscores April 23, 2021March 27, 2021 Business Intelligence Maven marketing challenge April 8, 2021March 6, 2021 Functions VALUE function March 26, 2021February 26, 2021 Functions Application of OFFSET in reporting March 5, 2021March 16, 2021 Business Intelligence BI reporting from MySQL database February 23, 2021February 13, 2021 Business Intelligence Accounting data in BI reporting 2 February 9, 2021February 1, 2021 Excel Months to years and months January 27, 2021March 11, 2021 VBA Adding a leading number January 12, 2021 Business Intelligence BI reporting from SQLite database December 19, 2020December 18, 2020 Functions sumproduct in payroll December 10, 2020November 14, 2020 Business Intelligence Weekday in BI reporting December 2, 2020November 28, 2020 Business Intelligence Accounting data in BI reporting November 18, 2020November 18, 2020 Business Intelligence MS Access as a source of data for Power Pivot and Power BI November 2, 2020November 2, 2020 Business Intelligence Geographic data with power pivot and power bi October 27, 2020October 27, 2020 Business Intelligence Graphs with power pivot October 14, 2020October 13, 2020 Excel Optimising the cost volume profit analysis with solver October 1, 2020October 2, 2020 Load more posts Something went wrong. Please refresh the page and/or try again.
Business Intelligence Maven CRM Sales Opportunities, free data sets November 22, 2025November 5, 2025
Business Intelligence Maven Analytics 2015 New Year’s Eve resolutions tweets challenge June 19, 2021November 11, 2021
Business Intelligence MS Access as a source of data for Power Pivot and Power BI November 2, 2020November 2, 2020
My Problem Solving Blog