In this video we talked about how we can use Excel Tables and what are the important things you need to know about Excel tables
Data: Using Excel tables
Tag: Learn Excel
What it means by cleaning data
In this video we talk about how we can clean data. For example, when you gather the data from a database or some other places, then you need to make sure there are structured in good shape (meaning that have a table shape), and if its not, you need to reshape your data into the good structure. Here, we will talk about this good structure and how we can reform data into table format.
Excel data: Data
Function definition in Excel
In this video we define the concepts of Excel functions and the way of writing functions in Excel. Functions, which we can call them formulas in Excel are predefined algorithms in Excel software that allow us do some manipulation and operations on data (or cells value or range of cells)
Excel Presentation of values in cells
Based on the values we provide in Excel cells, we can choose to show them in different formats, for examples, dates are all stored as numbers in Excel, however, we can present dates in different formats (for example, showing the year at the first or at the last position of date, or showing based on month names and not the numbers). In this video we talk about this presentations in Excel cells, and also we talk about how Excel can understands the Date values.
This Excel is part of invoice software which is developed by deyako company in Microsoft Excel: https://deyako.co.uk/product/invoicing-invoice-management-software/
Different types of values in Excel cells
In this video we talked about what different kind of values we can have in Microsoft Excel cells, and describe meaning of each of these values, these values include: Number , Text ( string ), logical, Error and Array.
This Excel is part of invoice software which is developed by deyako company in Microsoft Excel:
https://deyako.co.uk/product/invoicing-invoice-management-software/
Modifying and formatting cells to create Invoice in Excel
In this video we show how to use spreadsheet to create an invoice in Microsoft Excel, for making invoice you do not need anything special to know about Excel and just need to customize the size and formats of cells in Excel (Also watch the page setup video in our previous video in Excel)
This Excel is part of invoice software which is developed by deyako company in Microsoft Excel: https://deyako.co.uk/product/invoicing-invoice-management-software/
Setting the layout of page in Excel for printing
In this video we talk about page view and how to set page properties of sheet to have good printable page in Microsoft Excel. Setting up a pages in Excel is what you have to learn in the first place of using Microsoft Excel.