![]() ![]() The goal of this course is to provide you with a foundation on which you can build more advanced skills in the future. Creating your own Functions: Learn how to create your own functions for use within Excel.If you’re seeking to grow your knowledge of spreadsheets from zero to basic comfort and competence in Excel, then this is a perfect course for you.Tidying up Code: Learn how to understand elements of code understand the difference between recording code and writing it from scratch learn the structure of objects and procedures within VBA.Combining Macros using ‘Call’: Learn how to combine macros that you have already created through the Call command see how the code is run.Overview of the Microsoft Visual Basic for Applications Environment: Learn why VBA utilises a different screen learn how to navigate through the UI learn how to set preferences learn about some of the important tools available.Playing Macros using Buttons: Learn how to play your macros using – the Ribbon, the Quick Access Toolbar and shortcuts learn how to apply macros to images learn how to use a button from the form control group learn how to add commands to the ribbon for later use.Recording Macros: Learn how to record macros understand the difference between absolute and relative referencing within macros understand macro security and understand the importance of where you store your macros.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.Workbooks: Opening multiple workbooks and switching between them split and freeze worksheet windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |