Learn Microsoft Excel at Advanced Level
Spreadsheet Fundamentals From linking workbooks to recording macros The Essential How to Do Guide Learn Microsoft Excel at Advanced Level is ideal for students studying a business / computer related course or for the aspiring administrator. It's also effective for individuals in business and commerce who may want to adopt a more efficient approach to how they send data to one another, specifically by the use of data forms and macros. This book is packed full of knowledge while at the same time being easy to understand. Learning is progressive, from linking workbooks effectively to creating your own spreadsheet system interface. The book caters for any recent Excel version and will provide you with a lot of fun while you learn some sought-after business IT skills.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Using a user form to enter data setting up a macro
absolute references ActiveX controls ActiveX option button Add a Command Assign macro Auto_open macro box enter button controls button is checked Caption Cell link checkbox choose claims bonus Clearscreen click on mouse Click on Tools Click on View column heading Combo box Command button control source Control toolbox Copy the spreadsheet Copy this formula cursor Customer table Customers worksheet decimal places double click edit it Share enter the following Excel to look Exercise Figure FileQuote following formulae Format cells formula bar Gridlines Highlight cells identical functions Insert and click Invoices List boxes Microsoft Microsoft Excel Middledare Sales Middledare Sales.xls namebox Namefile nested IF formula number of payments old form controls press Enter Prev Close Private Sub Commandbutton1_click properties window set quick access toolbar Quotes worksheet record a macro Right click Sales workbook scroll bar Share High Share Price Sheet tabs Stop recording Text boxes user form Visual Basic Editor Vlookup