Category |
Publish Date |
Blog Post Title |
EXCEL 09/12/2018 Run a formula directly through a macro
EXCEL 05/12/2018 COUNTIF with multiple criteria - with dynamic references
EXCEL 27/11/2018 Avoid getting #N/As and 0s in your VLOOKUP results
EXCEL 21/11/2018 COUNTIF with multiple criteria
EXCEL 12/11/2018 Create a carbon copy of a tab in MS Excel
EXCEL 04/11/2018 Remove duplicate entries but retain most recent occurrence
EXCEL 28/10/2018 Create a dual axis bar chart in MS Excel
EXCEL 21/10/2018 Create a dynamic pie chart
EXCEL 14/10/2018 Change cell movement after Enter
EXCEL 08/10/2018 Combine data from multiple workbooks into a single workbook
EXCEL 30/09/2018 Combine data from multiple worksheets into master worksheet
EXCEL 25/09/2018 Concatenate cells and remove commas (including spaced cells)
EXCEL 17/09/2018 Concatenate cells and remove commas between values (Using a Macro)
EXCEL 09/09/2018 Concatenate cells and remove unwanted commas between values in MS Excel
EXCEL 03/09/2018 Auto-fit alphabeth characters in MS Excel
EXCEL 27/08/2018 How to get rid of #N/A in VLOOKUP output
EXCEL 19/08/2018 Strikethrough feature in MS Excel
EXCEL 12/08/2018 Create last updated timestamp using a Macro
EXCEL 06/08/2018 Temporarily highlight the entire row when any cell in that row is selected
EXCEL 29/07/2018 Capture the name of a file using a formula
EXCEL 22/07/2018 Speed up your Macros
EXCEL 15/07/2018 Transfer data (including blanks) from multiple excel sheets into a single repository
EXCEL 08/07/2018 Ascertaining the folder path using a Macro
EXCEL 02/07/2018 Transfer data from multiple excel sheets into a single repository
EXCEL 23/06/2018 Sum alternate groupings of data in MS Excel
EXCEL 17/06/2018 Highlight alternating grouping of data in Excel - taking into account blanks (method#2)
EXCEL 10/06/2018 Highlight alternate data groupings in Ms Excel – Blank Cells Filtered
EXCEL 03/06/2018 Highlight alternate data groupings in Ms Excel
EXCEL 27/05/2018 Highlight the rows whenever cell values change in a data set
EXCEL 21/05/2018 Delete content of cells which cells have a specific background color
EXCEL 13/05/2018 Highlight only a part of the text within a cell in MS Excel
EXCEL 06/05/2018 Finding ranges that don’t have blank values in MS Excel
EXCEL 29/04/2018 Getting the maximum values in one column based on unique values
EXCEL 22/04/2018 Counting unique values in Excel
EXCEL 15/04/2018 Copy a data set from one range into a different range/tab
EXCEL 08/04/2018 How to summarize monthly data into quarters in MS Excel
EXCEL 01/04/2018 How to use the OFFSET Formula in Excel
EXCEL 24/03/2018 Inserting duplicate rows (from multiple columns) based on numeric column values
EXCEL 04/09/2017 Delete unwanted rows using Vlookup in MS Excel
BI 21/08/2017 Creating a Publication in SAP BusinessObjects LaunchPad
MISC 07/08/2017 How to highlight all repeating words in MS Word
EXCEL 23/07/2017 Two way lookup with VLOOKUP
EXCEL 09/07/2017 How to export all MS Excel tabs
BI 25/06/2017 Issue with leading zeros in webi
BI 18/06/2017 Resolving “No data to retrieve from query” error in Webi
MISC 11/06/2017 How to do a word wrap in Notepad
BI 04/06/2017 ForAll Formula in Webi
BI 28/05/2017 ForEach Formula in Webi
EXCEL 21/05/2017 Using Slicers in MS Excel
EXCEL 07/05/2017 How to convert a column into a comma-delimited list in MS Excel
BI 30/04/2017 Use of “In” and “Where” operators in Webi
BI 22/04/2017 HTML vs Applet mode in Webi
BI 16/04/2017 Replacing a predated MS Excel file with a new one in SAP BusinessObjects
BI 05/04/2017 ToNumber () Function in Webi
BI 26/03/2017 Merging dimensions in Webi and its benefits
BI 18/03/2017 Getting rid of Div/Zero problem in Webi
BI 11/03/2017 How to sort multiple fields in Webi
BI 05/03/2017 Invalid Identifier error in Webi
BI 26/02/2017 How to change the default landing page in SAP BI Launchpad
BI 18/02/2017 Creating a Cross Tab in Webi
BI 12/02/2017 How to add non-transparent filters in a Webi report
BI 05/02/2017 Adjusting the size of PDF output files for Webi reports
BI 29/01/2017 Creating table breaks and removing repeat headers in a Webi report
BI 22/01/2017 User response function in Webi
BI 15/01/2017 Syntax for counting unique values in Webi
BI 06/01/2017 Creating dynamic value filters for Webi reports
BI 31/12/2016 How to display table headers on all pages of a Webi report
BI 24/12/2016 How to add a table footer in a Webi report
BI 18/12/2016 How to get the top N values displayed in a Webi report
BI 11/12/2016 How to select multiple values from a filter in a Webi report
BI 04/12/2016 Essential report information for header and footer of a Webi report
BI 27/11/2016 How to create a header and footer in a Webi report
BI 20/11/2016 How to add data labels to select elements in a Webi graph
BI 03/11/2016 How to create a dual axis column and line graph in a Webi report
BI 02/11/2016 How to add an image (logo) to a Webi report
MISC 31/10/2016 How to find images that are free to share
EXCEL 21/10/2016 Assigning security rights to specific cells within a MS Excel worksheet
EXCEL 17/10/2016 How to capture the name of a MS Excel worksheet tab in any given cell
BI 11/10/2016 How to change the color of negative percentage values in WebI reports
EXCEL 06/10/2016 How to turn off auto-correct in MS Excel
EXCEL 26/09/2016 How to Email only one (of many) tabs/worksheets directly through MS Excel
EXCEL 22/09/2016 How to add the Developer toolbar to the ribbon
EXCEL 14/09/2016 How to create line breaks (or carriage returns) in MS Excel
EXCEL 05/09/2016 Creating Conditional SUM, MAX, and MIN formulas using Arrays
EXCEL 29/08/2016 How to transfer folder names within a windows folder into MS Excel
EXCEL 21/08/2016 How to find cells that contain all of many words
EXCEL 13/08/2016 How to create a dynamic VLOOKUP in MS EXCEL
EXCEL 07/08/2016 How to check if a cell matches specific text in MS Excel
EXCEL 31/07/2016 Creating a Gantt chart using Conditional Formatting in MS Excel
EXCEL 23/07/2016 How to count the number of records that match multiple criteria
EXCEL 17/07/2016 How to highlight non present values using conditional formatting
BI 04/07/2016 The Difference between a Dimension and a Measure in Data Management
MISC 28/06/2016 The “at” symbol on my keyboard Stopped working! How to fix it?
MISC 31/05/2016 How to Start Page Numbering at a Specific Page in MS Word
EXCEL 30/04/2016 Sum cells in MS Excel based on background color
MISC 31/03/2016 Searching for Whole Words in MS Word/Excel
MISC 07/02/2016 Receiving “Read Receipts” in MS Outlook
MISC 31/05/2015 Hot Keys in MS PowerPoint
EXCEL 30/04/2015 Creating Timestamps in MS Excel Using Keyboard Shortcut
EXCEL 31/03/2015 Using Conditional If Statements in MS Excel
EXCEL 28/02/2015 Using Wildcards in a VLOOKUP!
EXCEL 31/01/2015 Cracking Passwords on Protected MS Excel Tabs!
EXCEL 31/12/2014 Deleting all Rows which Contain a Certain Value Within Any Field of the Row
EXCEL 30/11/2014 Applying a Formula to Many Rows in Excel
SQL 26/10/2014 Using DDL Triggers in Microsoft SQL Server
EXCEL 28/09/2014 VLOOKUP Not Working!
EXCEL 05/09/2014 Keyboard Shortcut for Auto-fitting Column Width in MS Excel
EXCEL 22/08/2014 Using the ISTEXT Function of Excel in String Concatenations
EXCEL 19/08/2014 Inserting Duplicate Rows Based on Numeric Values in a column
EXCEL 11/08/2014 Preventing Hidden Cells From Being Pasted Into The Spreadsheet
SQL 29/04/2014 UNION Compatibility
SQL 14/03/2014 Using a Scalar Function to Calculate Employee Seniority
MISC 10/03/2014 Software Development Life Cycle (SDLC)
BI 05/03/2014 Creating a Simple Dashboard Using SAP BusinessObjects DashBoard Tool
SQL 17/02/2014 Creating Views Using the Graphical Explorer
SQL 13/02/2014 Using a View to Rename Columns
SQL 02/02/2014 Normalization Explained
EXCEL 16/01/2014 Deleting Blank Cells in MS Excel - Exclusively Using Your Keyboard!
EXCEL 25/12/2013 Counting the Number of Unique Values Displayed after Applying a Filter
EXCEL 20/12/2013 Replacing Duplicate Values in a Column with Blank Cells in MS Excel
MISC 02/12/2013 Running a JAVA Program from Command Prompt
MISC 25/11/2013 Commonly Used Directory Commands for Command Prompt
EXCEL 03/11/2013 Calculating Seniority of Active Employees Using MS Excel
EXCEL 03/11/2013 VLOOKUP in MS Excel
