Excelforum.com; Exceltip.com, 2015. — 37 p.
(Автор не указан).What are we going to learn in this book:
What is Microsoft Excel?
What is Ribbon in MS-Excel?
How many rows and columns are there in Microsoft Excel 2003 and later versions?
Which option do we use to adjust the text within a cell and what is the procedure to do it?
What is the shortcut to put the filter on data in Microsoft Excel 2013?
How many report formats are available in Excel and what are their names?
What is the difference between function and formula in MS-Excel?
What is the process of making a chart and why is it important to make it right?
Is it possible to make Pivot Table using multiple sources of data? How?
How we can split a column into 2 or more columns?
What is a Dashboard and what are the important things we should keep in mind while creating a dashboard?
What is the easiest solution to reduce the file size?
What is Syntax of Vlookup?
How to select all the objects in the sheet?
What is IF function in Microsoft Excel?
What is the use of Name box?
What is the use of Vlookup and how do we use it?
How can we view the values in the right most column in Excel?
How can we merge multiple cells text strings in a cell?
What is Sumif function and how to use it?
What is Countif function and how to use it?
What is Nested IF function?
What is Pivot table and why we use it?
How to use advanced filter?
How we can change the cell formatting?
What is conditional formatting and how to use it?
How to make drop down list?
How to make dynamic drop down list?
How can we determine the day of the week for a particular date?
What is chart and how can we use it?
