Search results
Display the Save As dialog box. Shift + F11. Alt + H + I + S. Insert a new worksheet in the current workbook. Get immediate free access to PDF Cheat Sheet with more than 350 Excel keyboard shortcuts and hotkeys.
- Implement These Methods Using VBA
The sample macro (pdf_To_Excel_Able2Extract) that appears...
- Courses
Example Excel workbook(s) and/or PDF file(s) with the data...
- Books
Cheat sheet(s). The main Excel macro and VBA tools,...
- Contact
Thank you very much for your interest in Power...
- Easily Get Or Create Any Keyboard Shortcut
The list is also available for download as a free PDF file...
- Cheat Sheets
Save over 50% when you purchase the entire VBA Cheat Sheet...
- Convert PDF To Excel
At the same time, the ability to accurately and quickly...
- Archives
Power Spreadsheets is about Microsoft Excel and covers a...
- Implement These Methods Using VBA
Excel for Windows. Excel for Mac. Shortcut Description. Ctrl+Home. Fn+Ctrl+Left Arrow. Navigates to cell A1 of the given worksheet. Ctrl+Right Arrow. Ctrl+Right Arrow. Navigates to the right edge of the current row, in the current data region.
Download Excel Cheat Sheet PDF. Microsoft Excel is one of the top in-demand skills on the market. Whether you're starting to learn Excel or already an expert, having a cheat sheet in your pocket can help. An Excel cheat sheet gives you a brief overview of the functions, commands, formulas, and shortcuts in Excel—so you can focus on your work.
Jun 17, 2023 · Solutions for the printable brain teasers with answers sheet 1. 1- There are 2 solutions to this puzzle. Firstly, you can move the middle horizontal matchstick in the 6 to make it a zero (0+4=4). The second answer is to take the horizontal match off the addition sign and use it to make the 6 into an 8 (8-4=4). 2- The odd word is Grid.
- Section A – Is Functions
- Section B – Conditional Functions
- Section C – Mathematical Functions
- Section D – Find and Search Functions
- Section E – Lookup Functions
- Section F – Reference Functions
- Section G – Date and Time Functions
- Section H – Miscellaneous Functions
- Section I – Rank Functions
- Section J – Logical Functions
1. ISBLANK
=ISBLANK(value) If a cell is blank, it returns TRUE. If a cell is not blank, it returns FALSE.
2. ISERR
=ISERR(value) Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE.
3. ISERROR
=ISERROR(value) Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE.
13. AVERAGEIF
=AVERAGEIF(range, criteria, [average_range]) Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.
14. SUMIF
=SUMIF(range, criteria, [sum_range]) Adds the cells specified by a given condition or criteria.
15. COUNTIF
=COUNTIF(range, criteria) Counts the number of cells within a range that meet the given condition.
22. SUM
=SUM(number1, [number2], [number3], [number4], …) Adds all the numbers in a list or range of cells.
23. AVERAGE
=AVERAGE(number1, [number2], [number3], [number4], …) Returns the average (arithmetic means) of its arguments, which can be numbers or names, arrays, or references that contain numbers.
24. AVERAGEA
=AVERAGEA(value1, [value2], [value3], [value4], …) Returns the average (arithmetic means) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. Arguments can be numbers, names, arrays, or references.
43. FIND
=FIND(find_text, within_text, [start_num]) Returns the starting position of one text string within another text string. FIND is case-sensitive.
44. SEARCH
=SEARCH(find_text, within_text, [start_num]) Returns the number of the character at which a specific character or text string is first found, from left to right (not case-sensitive).
45. SUBSTITUTE
=SUBSTITUTE(text, old_text, new_text, [instance_num]) Replaces the old text with new text in a text string, with the optional value announcing what repetition of the old text to replace.
47. MATCH
=MATCH(lookup_value, lookup_array, [match_type]) Returns the relative position of an item in an array that matches a specified value in a specified order.
48. LOOKUP
=LOOKUP(lookup_value, lookup_vector, [result_vector]) Looks up a value either from a one-row or one-column range or from an array. Obsolete in new versions of Excel, provided for backward compatibility.
49. HLOOKUP
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Looks for a value in the top row of a table or array of values and return the value in the same column from a row you specify.
51. ADDRESS
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) Creates a cell reference as text, given the specified row and column numbers.
52. CHOOSE
=CHOOSE(index_num, value1, [value2], [value3], …) Chooses a value or action to perform from a list of values, based on an index number.
53. INDEX
Array Form: =INDEX(array, row_num, [column_num]) Return the value of a specified cell or array of cells. Reference Form: =INDEX(reference, row_num, [column_num], [area_num]) Returns a reference to specified cells.
56. DATE
=DATE(year, month, day) Returns the number that represents the date in Microsoft Excel date-time code.
57. DATEVALUE
=DATEVALUE(date_text) Converts a date in the form of text to a number that represents the date in the Microsoft Excel date-time code.
58. TIME
=TIME(hour, minute, second) Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format.
67. AREAS
=AREAS(reference) Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.
68. CHAR
=CHAR(number) Returns the character specified by the code number from the character set for your computer.
69. CODE
=CODE(text) Returns a numeric code for the first character in a text string, in the character set used by your computer.
84. RANK
=RANK(number, ref, [order]) This function is available for compatibility with Excel 2007 and earlier. Returns the rank of a number in a list of numbers: its size relative to other values in the list.
85. RANK.AVG
=RANK.AVG(number, ref, [order]) Returns the rank of a number in a list of numbers. If more than one value has the same rank, the average rank is returned.
86. RANK.EQ
=RANK.EQ(number, ref, [order]) Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the top rank of that set of values is returned.
87. AND
=AND(logical1, [logical2], [logical3], [logical4], …) Checks whether all arguments are TRUE, and returns TRUE when all arguments are TRUE.
88. NOT
=NOT(logical) Changes FALSE to TRUE, or TRUE to FALSE.
89. OR
=OR(logical1, [logical2], [logical3], [logical4], …) Returns FALSE only when all arguments are FALSE.
For this, follow the steps below: First, go to the “Data” ribbon and click the “Sort” button. In the “Sort” dialog box, under the “Column” drop-down, select the column containing the colored cells you want to sort by. And then, under the “Sort On” drop-down, select “Cell Color”.
Windows key + Semicolon (;) : Open the emoji panel. Windows key + PrtScn : Take a screenshot of the full screen and save it to the “Screenshots” folder. Windows key + Shift + S : Take a partial screenshot using Snip & Sketch tool. Windows key + V : Open the Clipboard bin. Windows Key Keyboard Shortcuts.