Do you want to learn more about Excel functions? How about learning how to use them in your work? Microsoft Excel contains so many functions that even experienced users will not always be able to clearly navigate all this diversity. Well 30 Excel functions in 30 days will become a powerful impetus for self-development for you and will teach you how to create amazing things in Excel books.
If you are a novice Excel user and came to this site to learn everything from the very basics, I suggest you first refer to our Excel Tutorial for Beginners. In it you will find a lot of high-quality and useful information.
What is this course?
All 30 lessons are a translation of a marathon of articles by a Canadian Excel guru – Debrie Dalgleish. Every day from January 2, 2011 to January 31, 2011, there was an article on the Contextures blog describing one of these features. All functions are categorized: text, information, and search and links. The Feature List section provides links to translations of all of these articles.
Each article contains the following:
- A description that details how each individual feature works.
- All 30 lessons are accompanied by screenshots that allow you to clearly convey important information (the pictures were taken in Excel 2010).
- Practical examples of applying Excel formulas both alone and with other functions.
- Pitfalls that may arise when working with functions.
- As well as a lot of other equally useful information.
What will I get?
With the help of this marathon, you will be able to expand your knowledge of the functions of Microsoft Excel and make your workbooks more efficient. Learn which features work best in certain situations, and which features to avoid altogether.
This guide will help you to use familiar functions more effectively. Even those Excel functions that you work with every day may contain hidden features and pitfalls that you did not know about. You can safely apply all the examples presented in your own work.
List of features:
Day 01 – EXACT – can check two text strings for an exact match, and, moreover, case sensitive.
Day 02 – AREAS – Returns the number of areas in the link.
Day 03 – TRIM – Removes all spaces from a text string, except for single spaces between words.
Day 04 – INFO – Shows information about the current operating environment.
Day 05 – CHOOSE – Returns a value from a list, selecting it according to the numeric index.
Day 06 – FIXED – Rounds a number to a certain number of decimal places and returns the result in text format with or without thousands separators.
Day 07 – CODE – Returns the numeric code of the first character of a text string.
Day 08 – CHAR – Returns a specific character whose code matches the entered number, based on your computer’s character table.
Day 09 – VLOOKUP – Looks up a value in the first column of a table and returns another value from the same row in the table.
Day 10 – HLOOKUP – Looks for a value in the first row of a table and returns another value from the same column in the table.
Day 11 – CELL (CELL) – shows information about the formatting, content and location of the cell at the given link.
Day 12 – COLUMNS – Returns the number of columns in an array or reference.
Day 13 – TRANSPOSE – Returns a horizontal range of cells as a vertical range or vice versa.
Day 14 – T (T) – Returns text if the value in the cell is text, or an empty string if not text.
Day 15 – REPEAT (REPT) – repeats a text string a specified number of times.
Day 16 – LOOKUP – Returns a value from one row, one column, or an array.
Day 17 – ERROR.TYPE – Identifies the type of error by number or returns #N/A if no error was found.
Day 18 – SEARCH – Looks for a text string inside another text string, and if found, reports its position.
Day 19 – MATCH – Returns the position of the value in the array, or a #N/A error if it’s not found.
Day 20 – ADDRESS – Returns the cell reference as text based on the row and column number.
Day 21 – TYPE – Returns a number that specifies the data type.
Day 22 – N (N) – Returns the value converted to a number.
Day 23 – FIND – Finds a text string inside another text string, case sensitive.
Day 24 – INDEX – Returns a value or a reference to a value.
Day 25 – REPLACE – Replaces characters within text based on the specified number of characters and starting position.
Day 26 – OFFSET – Returns the link offset from the given link by a certain number of rows and columns.
Day 27 – SUBSTITUTE – Replaces old text with new text within a text string.
Day 28 – HYPERLINK – creates a link that opens a document stored on a computer, network server, local network or Internet.
Day 29 – CLEAN – Removes some non-printing characters from text.
Day 30 – INDIRECT – Returns the link given by the text string.