- VISUAL BASIC FOR EXCEL COURSES ONLINE FREE HOW TO
- VISUAL BASIC FOR EXCEL COURSES ONLINE FREE PASSWORD
- VISUAL BASIC FOR EXCEL COURSES ONLINE FREE WINDOWS
VISUAL BASIC FOR EXCEL COURSES ONLINE FREE PASSWORD
Preparing your workbook for sharing with others: learn how to spell check your workbook protect formulae from accidental changes add Comments to worksheet cells add Headers and Footers to a worksheet worksheet and workbook protection: adding a password.Data: search for text or other content in a worksheet and learn how to replace it with alternative text e.g.AutoFill: create lists of headings or dates quickly using this fantastic feature, you can even create your own custom lists for use again and again learn how to use Flash fill.Conditional formatting: apply basic conditional formatting to text or data that meets your set conditions.Rows and columns: learn how to insert/delete cells, rows and columns in a worksheet resize rows and columns.Worksheets: add, move, copy, rename and remove worksheets move a worksheet to a new workbook change tab colour grouping worksheets and formatting as a group.
VISUAL BASIC FOR EXCEL COURSES ONLINE FREE WINDOWS
Workbooks: Opening multiple workbooks and switching between them split and freeze worksheet windows.
File tab: what are all those other options for, and do I need to use them? Your trainer will tell you a little about the other options, but we will focus on the essentials i.e.Help: browse Excel Help to find out more about the program, or search for a specific topic.Printing: explore the options in the Print backstage view.Useful tips: mouse pointer - learn what the different shapes are used for learn how to select cells, rows and columns use the scroll bars, mouse and keyboard to navigate a large workbook learn how to undo an action.Sorting and filtering: sort data effectively use AutoFilter tools.Moving and copying data in cells: Use the mouse, keyboard and clipboard to move and copy data within worksheets and between cells.Formatting cells: apply background fills to cells and add borders to make the worksheet easier to read.Formatting text and figures: use options on the Home tab to add basic formatting to enhance the appearance of your worksheet use format painter.Adding text and data: add some simple text and figures and then use a simple calculation to total the figures change some of the data and see the total change automatically!.Workbook structure: investigate the essential elements of a workbook worksheet tabs, columns, rows, cells, the active cell and the name box.Understanding the screen: learn about the most important features on-screen the ribbon, worksheet, scroll bars.NEW: Information Communications Technician.