My name is Svetlana, and my main efforts are on the development components of Add-in Express . As an active Excel user, I have a good understanding of end-users' needs too. In my tutorials, I will share my knowledge, experiences and findings, which will hopefully prove helpful to you :)
Here is a list of Svetlana's recent articles:
How to convert column number to letter in Excel
Using ISERROR with VLOOKUP in Excel
Mail Merge formatting issues in Word: causes and fixes
Mail Merge in Outlook - send personalized bulk email
How to use ISERROR function in Excel
Excel split screen - view different parts of a sheet at once
How to open Excel files in separate windows and multiple instances
Excel IFNA function to handle #N/A errors
How to number columns in Excel and convert column letter to number
ISNA function in Excel with formula examples
How to change Excel CSV delimiter to comma or semicolon
How to highlight active row and column in Excel
VLOOKUP to compare two columns in Excel for common values and missing data
RegEx in Excel: using regular expressions in formulas
How to remove whitespace and empty lines in Excel with Regex
How to extract substrings in Excel using regular expressions (Regex)
Converting CSV to Excel: problems and solutions
How to merge multiple CSV files into one Excel workbook
Excel Regex to remove certain characters or text from strings
Excel Regex to find and replace strings using regular expressions
Excel Data Validation using regular expressions
Regex Match in Excel: regular expression matching with examples
CONCAT function in Excel to join text strings
How to add text or character to every cell in Excel
Convert Excel table to range and turn data range into table
How to remove characters/text from string in Excel
How to remove special (unwanted) characters from string in Excel
How to view shared files in OneDrive and stop sharing
How to delete text before or after a certain character in Excel
How to remove first (left) or last (right) characters in Excel
How to share files securely with OneDrive
How to share OneDrive files and folders
How to remove text and leave numbers in Excel or vice versa
How to remove table formatting in Excel
How to highlight duplicate text strings or words in Excel cell
How to find and replace multiple values at once in Excel (bulk replace)
Outlook email templates: 10 quick ways to create and use
How to write recursive LAMBDA function in Excel with examples
Excel LAMBDA function: how to write and use
How to create a meeting template in Outlook
Outlook Quick Steps: how to create and use
How to fix #SPILL! error with Excel VLOOKUP, INDEX MATCH and SUMIF
How to add a dropdown list to Outlook email template
How to find and remove duplicate cells in Excel
Spilling in Excel: what it means and how to use it
How to make Outlook email template with fillable fields, variables and dropdowns
How to remove duplicates in Excel cell
Excel spill range explained
Implicit intersection - meaning of @ sign in Excel formulas
Excel #SPILL! error - causes and fixes
Excel: prevent text from spilling over into next cells
Using NPER function in Excel with formula examples
How to use PV function in Excel to calculate present value
How to calculate present value of annuity in Excel: formula and calculator
How to make and use Excel data entry form
Using LET function in Excel with formula examples
How to find and fix broken links in Excel
How to find and remove external links in Excel
Set up dependent drop-down list for multiple rows in Excel
Excel FV function to calculate future value
5 ways to do VLOOKUP in Excel - which is fastest?
Excel RATE function: formula examples to calculate interest rate
LARGE IF formula in Excel: find highest values with criteria
How to highlight top or bottom 3, 5, 10 values in Excel
How to find top or bottom N values in Excel
Excel LARGE function with formula examples to get n-th highest value
Excel SMALL IF formula to find Nth lowest value with criteria
Excel SMALL function with examples to find and highlight bottom values
Excel IF statement for partial text match (wildcard)
Excel wildcard: find and replace, filter, use in formulas
Sum if between two dates in Excel: SUMIFS with date range as criteria
How to use SUMIF in Excel with multiple OR conditions
How to create, change and remove border in Excel
Excel XMATCH function with formula examples
How to make a dynamic dependent dropdown list in Excel an easy way
How to create a sequence of dates in Excel and auto fill date series
Excel SEQUENCE function - create a number series automatically
How to generate random numbers in Excel without duplicates
How to get random sample in Excel without duplicates
RANDARRAY function - quick way to generate random numbers in Excel
Excel dynamic arrays, functions and formulas
SORTBY function - custom sort in Excel 365 and 2021 with formula
Excel SORT function - automatically sort with formula
Excel FILTER function with formula examples
How to count unique values in Excel an easy way
UNIQUE function - quick way to find unique values in Excel
TEXTJOIN function in Excel to merge text from multiple cells into one
Excel COUNTBLANK and other functions to count empty cells
How to select and highlight blank cells in Excel
Excel ISBLANK function to check if cell is empty or not
How to sort by date in Excel: in chronological order, by month, auto sort
Excel ISTEXT and ISNONTEXT functions with formula examples
Thank you letter samples: after interview, for recommendation, for scholarship, and more
Excel ISNUMBER function with formula examples
How to group and ungroup worksheets in Excel
How to start a new line in Excel cell: 3 ways to insert a line break
Excel VBA macro tutorial: how to create, change, copy and delete macros
How to enable and disable macros in Excel
Personal Macro Workbook in Excel - make macros available in all workbooks
How to run macro in Excel and create your own macro button
How to record a macro in Excel
How to VLOOKUP across multiple sheets in Excel with examples
Excel formula to count cells with certain text (exact and partial match)
How to count cells with text in Excel: any, specific, filtered cells
How to export and import contacts between Outlook and Google Gmail
How to import contacts into Outlook from CSV and PST file
How to export contacts from Outlook to CSV and PST
Excel INDEX MATCH MATCH and other formulas for two-way lookup
Excel INDEX MATCH with multiple criteria - formula examples
XLOOKUP function in Excel with formula examples
How to share Outlook calendar with Google
How to add and view shared calendar in Outlook
How to share Outlook calendar
How to share and publish calendar in Outlook on the web and Outlook.com
MAX IF in Excel to get highest value with conditions
Excel MAXIFS function - get largest value based on multiple criteria
MAX function in Excel: formula examples to find and highlight highest value
How to create a table in Excel
Sparklines in Excel: how to create, use and change
Delay delivery and schedule email sending in Outlook
How to recall email message in Outlook: classic, new app and web
Excel print area: how to set, change and clear
How to print Excel spreadsheet: tips and guidelines for perfect printouts
How to calculate internal rate of return (IRR) in Excel
How to use MIRR function in Excel to calculate modified internal rate of return
Excel XIRR function to find internal rate of return for non-periodic cash flows
How to use Excel IRR function to calculate internal rate of return
How to calculate NPV in Excel - net present value formula examples
Excel ribbon: quick guide for beginners
Customize Excel ribbon with your own tabs, groups or commands
How to show, hide and restore missing ribbon in Excel
Quick Access Toolbar in Excel: how to customize, move, reset and share
Developer tab in Excel: how to add, use and remove
Calculating percent change (percentage increase / decrease) in Excel
How to calculate variance in Excel - VAR, VAR.S, VAR.P and other functions
How to add vertical line to Excel chart: scatter plot, bar chart and line graph
How to make a loan amortization schedule in Excel (with extra payments)
Excel IPMT function to calculate interest portion of a loan payment
Excel PPMT function with formula examples
How to use PMT function in Excel with formula examples
How to add error bars in Excel: standard and custom
Outlook Quick Parts and AutoText: how to create, edit and use
TREND function and other ways to do trend analysis in Excel
How to forecast in Excel: linear and non-linear forecasting methods
Excel FORECAST functions with formula examples
How to use Flash Fill in Excel 365 - 2013
Excel CELL function with formula examples
Excel ADDRESS function with formula examples
Excel cell reference: how to make and use
Structured reference in Excel tables
How to do Spearman correlation in Excel
Correlation in Excel: coefficient, matrix and graph
Excel trendline types, equations and formulas
How to add trendline in Excel chart
How to delete blank rows in Excel quickly and safely
How to copy and move sheets in Excel
How to duplicate sheet in Excel with VBA
How to remove blank cells in Excel
How to delete blank columns in Excel
How to join tables in Excel: Power Query vs. Merge Tables Wizard
How to combine first and last name in Excel
How to merge two or more tables in Excel
How to make and use a data table in Excel
IF AND formula in Excel
How to find, highlight and label a data point in Excel scatter plot
How to create a scatter plot in Excel
Excel IF OR function with formula examples
How to subtract in Excel: formula for numbers, percentages, dates and times
How to add a line in Excel graph (average line, benchmark, baseline, etc.)
How to use Goal Seek in Excel for What-If analysis
How to create a line graph in Excel
Excel AutoCorrect: how to customize or turn off
How to spell check in Excel
Excel TRANSPOSE function to change columns to rows
Linear regression analysis in Excel
How to use LINEST function in Excel - formula examples
How to convert text to number in Excel
Excel VALUE function to convert text to numbers
How to get absolute value in Excel: ABS function with formula examples
How to create Pareto chart in Excel
How to freeze rows and columns in Excel
Excel slicers for pivot tables and charts
Excel Nested IF statement: examples, best practices and alternatives
Excel CHOOSE function with formula examples
How to turn off Scroll Lock in Excel
How to do subscript and superscript in Excel for text and numbers
How to calculate days since or until date in Excel
How to alphabetize tabs in Excel
Calculate and highlight 90/60/30 days from or before today in Excel
How to strikethrough in Excel
How to alphabetize in Excel: sort columns and rows A-Z or Z-A
8 ways to add bullet points in Excel
Excel COUNTIF and COUNTIFS with OR logic
SUMIFS in Google Sheets to sum cells with multiple criteria (AND / OR logic)
SUMIF in Google Sheets with formula examples
How to unmerge cells in Excel
How to calculate days between dates in Excel
How to delete every other row or every Nth row in Excel
IFERROR with VLOOKUP in Excel - elegant way to trap errors
VLOOKUP with IF statement in Excel
How to select random sample in Excel
Random sort in Excel: shuffle cells, rows and columns
Header and footer in Excel: how to insert, edit and remove
Excel: split first and last names into separate columns
How to group rows in Excel to collapse and expand them
Very hidden sheets in Excel
How to hide sheets in Excel
Unhide sheets in Excel: show multiple or all sheets at once
How to hide and unhide rows in Excel
How to extract number from string in Excel
Excel substring: how to extract text from cell
How to merge multiple Excel files into one
How to divide in Excel and handle #DIV/0! error
Excel: If cell contains then count, sum, highlight, copy or delete
Excel: If cell contains formula examples
How to multiply columns in Excel
How to multiply cells in Excel with formula examples
Excel IFERROR function with formula examples
Excel TODAY function to insert today's date and more
Excel MOD function to get remainder and more
Excel RANK functions with formula examples
Excel Data Validation: custom formulas and rules
Data validation in Excel: how to add, use and remove
How to track changes in Excel
How to share Excel file for multiple users and co-author a shared workbook
How to flip data in Excel: reverse columns vertically and rows horizontally
How to create and use dynamic named range in Excel
Excel named range - how to define and use names in Excel
Google Sheets VLOOKUP with examples
Excel calculations: automatic, manual, iterative
How to do calculations in Excel
Basic Excel formulas & functions with examples
How to square root in Excel: SQRT function and other ways
How to calculate standard deviation in Excel
Mean, median and mode in Excel
How to calculate median in Excel - formula examples
How to insert picture in Excel cell, comment, header or footer
How to convert Excel to JPG, PNG or GIF image
How to align text in Excel
Lookup in Excel: functions and formula examples
Show time over 24 hours, 60 minutes, 60 seconds in Excel
Excel LOOKUP function with formula examples
Excel Hyperlink: how to create, change and remove
How to use Excel HYPERLINK function to create different link types
How to AutoFit in Excel: adjust columns and rows to match data size
How to change and AutoFit row height in Excel
How to change column width and AutoFit columns in Excel
How to Vlookup multiple values in Excel with criteria
How to wrap text in Excel
Excel MID function to extract text from the middle of a string
How to use Excel RIGHT function - formula examples
Excel LEFT function with formula examples
How to add leading zeros in Excel
Excel TEXT function with formula examples
How to use MATCH function in Excel - formula examples
How to use HLOOKUP in Excel with formula examples
Excel nested IF statement - multiple conditions in a single formula
How to compare two cells in Excel (string comparison)
How to remove spaces in Excel - leading, trailing, non-breaking
Excel TRIM function - quick way to remove extra spaces
How to archive in Outlook automatically or manually (emails, tasks, calendar and other items)
How to backup Outlook emails and other items (safe .pst backup)
Excel Paste Special: copy values, comments, column's width and more
How to calculate age in Excel: from date of birth, between two dates
How to create calendar in Excel (drop-down and printable)
6 ways to insert a tick symbol and cross mark in Excel
How to add, copy and delete multiple checkboxes in Excel
How to insert checkbox in Excel: interactive checklist, to-do list and report
Using Advanced Filter in Excel - criteria range examples with formulas
Excel Advanced Filter - how to create and use
How to filter in Excel
Excel SUMPRODUCT function with formula examples
Excel SUBTOTAL function with formula examples
How to add, use and remove Subtotals in Excel
How to calculate CAGR (compound annual growth rate) in Excel
Excel table styles and formatting: how to apply, change and remove
Excel table: end-to-end tutorial with examples
How to clear formatting in Excel
Format Painter and other ways to copy formatting in Excel
Custom Excel number format
How to format cells in Excel (number, text, scientific notation, etc.)
How to use Solver in Excel with examples
How to count words in Excel
How to use LEN function in Excel to count characters in a cell
How to split text string in Excel by comma, space, character or mask
Excel Cumulative Sum - easy way to calculate running total
How to use AutoSum in Excel
Excel SUM formula to total a column, rows or only visible cells
How to create a histogram chart in Excel
Outlook signature: how to make, add and change
How to get a list of unique and distinct values in Excel
Distinct and unique values in Excel: how to find, filter, select and highlight
How to count unique values in Excel
Excel COUNT and COUNTA functions to count cells
How to remove duplicates in Excel (duplicate rows, values and partial matches)
How to highlight duplicate cells and rows in Excel
How to find duplicates in Excel: identify, highlight, count, filter
How to compare two Excel files for differences
How to lock and unlock cells in Excel
How to protect and unprotect Excel sheet with or without password
Excel formulas not working, not updating, not calculating: fixes & solutions
How to edit, evaluate and debug formulas in Excel
Formula bar in Excel: how to show, hide, expand or collapse
How to copy formula in Excel: down a column, without changing references, etc.
How to hide and lock formulas in Excel
How to show formulas in Excel
How to make formulas in Excel
Microsoft Excel formulas with examples
Circular reference in Excel - how to check, find, enable, or remove
3-D reference in Excel: reference the same cell or range in multiple worksheets
How to create external reference in Excel to refer to another sheet or workbook
Why use dollar sign ($) in Excel formulas: absolute & relative cell references
How to create a bar graph in Excel
How to create a Pie chart in Excel
Make a chart in Excel from two or more different sheets
Customizing Excel charts: add chart title, axes, legend, data labels and more
How to create a chart (graph) in Excel and save it as template
Using REPLACE and SUBSTITUTE functions in Excel - formula examples
Excel FIND and SEARCH functions with formula examples
How to use Find and Replace in Excel most efficiently
Calculating moving average in Excel
How to calculate weighted average in Excel
Consolidate data in Excel and merge multiple sheets into one worksheet
How to calculate average (mean) in Excel with or without formulas
How to compare two columns in Excel for matches and differences
Most useful Excel functions with formula examples
How to round numbers in Excel: ROUND, ROUNDUP, ROUNDDOWN functions
How to merge cells in Excel without losing data
CONCATENATE in Excel: combine text strings, cells and columns
How to generate random numbers in Excel: RAND and RANDBETWEEN functions
How to convert time to decimal number, hours, minutes or seconds in Excel
How to calculate time in Excel - time difference, adding / subtracting times
Excel time format: 12/24 hour, custom, default
Excel date functions with formula examples
Using DATE function in Excel - formula examples to calculate dates
Excel DATEDIF to calculate date difference in days, weeks, months or years
Calculating weekdays in Excel - WORKDAY and NETWORKDAYS functions
How to add and subtract dates, days, weeks, months and years in Excel
YEAR function convert date to year in Excel
Calculating week number in Excel (WEEKNUM function)
Using MONTH and EOMONTH functions in Excel - formula examples
Excel WEEKDAY function: get day of week, weekends and workdays
How to convert date to text in Excel with TEXT function and without formulas
How to convert text to date and number to date in Excel
How to insert dates in Excel - add today's date, auto fill a column with dates
How to change date format in Excel and create custom formatting
Excel array formula examples for beginners and advanced users
Excel array formulas, functions and constants - examples and guidelines
How to count the number of characters in Excel cells
INDEX function in Excel - 6 most efficient uses
Using OFFSET function in Excel - formula examples
How to use INDIRECT function in Excel - formula examples
Excel templates: how to make and use
How to calculate compound interest in Excel: daily, monthly, yearly compounding
How to calculate percentage in Excel - formula examples
How to show percentages in Excel
Using logical functions in Excel: AND, OR, XOR and NOT
Excel logical operators: equal to, not equal to, greater than, less than
Excel IF statement with multiple conditions
How to use IF function in Excel: examples for text, numbers, dates, blanks
How to use Pivot Tables in Excel - tutorial for beginners
How to use Excel SUMIFS and SUMIF with multiple criteria
How to use SUMIF function in Excel with formula examples
Converting PDF files (text and image) to Excel
How to convert Excel files to PDF
Making a dependent (cascading) drop down list in Excel
Create drop down list in Excel: static, dynamic, editable, searchable
Excel VLOOKUP not working - solving #N/A and #VALUE errors
5 ways to do case-sensitive VLOOKUP in Excel
INDEX & MATCH in Excel - better alternative to VLOOKUP
Relative and absolute cell references in Excel conditional formatting
How to hide columns in Excel using shortcut, VBA or grouping
How to use VLOOKUP with SUM or SUMIF functions in Excel
Advanced VLOOKUP in Excel: multiple, double, nested
Excel VLOOKUP tutorial for beginners with formula examples
How to use Excel COUNTIFS and COUNTIF with multiple criteria
COUNTIF function in Excel - count if not blank, greater than, duplicate or unique
How to conditionally format dates and time in Excel with formulas and inbuilt rules
Excel conditional formatting formulas based on another cell
Excel Icon Sets conditional formatting: inbuilt and custom
Excel Conditional Formatting tutorial with examples
How to make a Gantt chart in Excel
How to mail merge and print address labels from Excel to Word
How to mail merge from Excel to Word
How to convert (open or import) CSV file to Excel
How to convert Excel files to CSV (comma delimited) and CSV UTF-8
Send secure email in Outlook using digital signature
Email encryption in Outlook: how to encrypt messages with digital ID
Writing persuasive request letters: tips and samples
Move Excel spreadsheets online, share and embed web app in your website
How to convert Excel tables to HTML
How to color alternate rows in Excel: highlight every other row
How to convert rows to columns in Excel (transpose data)
How to split cells in Excel: Text to Columns, Flash Fill and formulas
How to create and use Outlook email templates
How to add and view BCC (blind carbon copy) in Outlook
How to merge rows in Excel without losing data
Setting Outlook spam filter to stop junk email
How to swap columns by dragging and other ways to move columns in Excel
Hyperlinks not working in Outlook? How to make links open again
How to filter and sort by cell color, font color and icon in Excel
How to sum and count cells by color in Excel
How to fix "Cannot start Microsoft Outlook. Unable to open Outlook window" error
How to remove, merge and clean up duplicate contacts in Outlook
Sync Google Calendar with Outlook
Why an email gets stuck in Outlook and how to make it send
How to delete or resend an email message stuck in Outlook's Outbox
How to change the row color based on a cell value in Excel
Two ways to change background color in Excel based on cell value
View two or more Excel sheets side by side