Excel Lessons for Dummies and Beginners
There are lessons and examples of work for «dummies». Practical exercises, tasks and exercises with detailed descriptions and pictures. Step-by-step self-instruction manual for working with examples online.
Training for Dummies
Getting Started
Acquaintance with the Excel window and tabs panel.The toolbars on the strip.
Creating copying and moving sheets in Excel workbooks.
Quick Access Toolbar in Excel.
Changing the color scheme of the Excel interface Office Theme.
Managing sheets and populating cells with data
How to quickly move the cursor to the Excel sheet cells.
Range of cells adjacent and non-adjacent
Selecting the range of cells in Excel.Filling Nonadjacent Range of cells in Excel simultaneously.
Editing sheet data
Changing the format of cells to display data and creating tables.Editing of a cell in Excel and splitting text into multiple lines.
How to insert a row or a column in Excel.
How to add cells in an Excel spreadsheet.
Copying of sheet data with standard Excel tools.
Excel Clipboard extends copy capabilities.
Copying cell ranges with mouse cursor.
Formatting table cells
Changing and aligning of fonts in cells.Change the color of the table in Excel.
Automatic creation and formatting tables in Excel.
How to calculate the date in Excel.
Taking into account time in Excel: addition and subtraction inequality between hours and minutes.
Format Painter in Excel for table layout.
How to hide or display rows and columns in Excel.
Formulas and functions
How to enter the formula in the Excel program with the mouse.Function of SUM in Excel and examples of its use.
Influence of the cell format on working of the SUM function.
Calculating the formula of volume and area in Excel.
Absolute link in Excel fixes the cell in the formula.
Llink to a cell in another Excel sheet.
Working with functions in Excel on examples.
Charts and diagrams
Drawing of charts and diagrams in Excel.How to change the chart in Excel with the settings of the axes and colors.
View and print documents
Review data in Excel in many ways: the examples.Preview in Excel before of printing documents.
Printing Excel spreadsheet with the settings.
Printing of a table header on each page of the Excel sheet.
