Last updated: 2023, April 3 13:52:36
Total pages: 95 www.affordsol.be Homepage

• https://affordsol.be/95 pages
• • About Us- Affordable Solutions - Excel & VBA Consulting Training & Support -
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • Learning Excel & VBA for Excel
    Save time and money with an automated version of YOUR worksheets
  • Affordable Solutions - The Ribbons in Excel 2007
    We create Excel applications and solutions.
  • Excel databases
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • Sorting the Data in Excel
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • Excel - INDEX/MATCH functions
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • Excel - SUMPRODUCT function
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • EVALUATE from Affordable Solutions - Excel & VBA Consulting Training & Support
    Affordable Solutions is an Excel expert and Consultant. We create Excel applications and solutions and empower our customers.
  • Circle | Affordsol Excel & VBA for Excel Made Simple Site
    Save time and money with an automated version of YOUR worksheets
  • Sitemap: Excel functions
    There are 329 functions to develop powerful formulas in Excel. Only 52 (15.6%) are regularly used and the most useful one is SUMPRODUCT.
  • EXTERNAL & CLOSED WORKBOOKS
  • Reporting with Excel | Gipsy at your service for more than 50years
  • Excel Dialog Boxes
    Save time and money with an automated version of YOUR worksheets
  • Roam around the VBE
    Save time and money with an automated version of YOUR worksheets
  • LINKS | Affordsol Excel & VBA for Excel Made Simple Site
    Save time and money with an automated version of YOUR worksheets
  • Home | Affordsol Excel & VBA for Excel Made Simple Site
    Save time and money with an automated version of YOUR worksheets
  • Affordable Solutions - Meet Your Host
    We create Excel applications and solutions.
  • Email Disclaimer
  • Download TeamViewer
    Save time and money with an automated version of YOUR worksheets
  • Privacy - Protection de la vie privee
  • Section 1: Programming in Excel (Macros)
    Presenting the 10 lessons of section 1 on the programming environment of VBA for Excel: Visual Basic Editor and its 3 Windows, Macro Recorder, Events and Security
  • Excel VBA Vocabulary for Macros
    Presenting the 13 lessons of section 2 on the programming vocabulary for macros (VBA for Excel): Working with Application, Workbooks, Worksheets, Databases, Variables, Functions and other programs.
  • Excel Forms (Userforms)
    10 lessons on developing and programming userforms in Excel: Userforms, labels, command buttons, text boxes, combo boxes, list boxes and other controls.
  • SUMPRODUCT in Excel spreadsheets
    SUMPRODUCT is the most important and powerful function in Excel. You can automate most of your reports with it. It transforms data into information
  • Excel Index/Match Formulas
  • Microsoft Excel Database Functions
    Excel offers you 12 functions in the database category. When you discover SUMPRODUCT none of these functions are useful.
  • Microsoft Excel Date and Time Functions
    Microsoft Excel offers you 21 date and time functions and 12 of them are interesting. But beware of the format of your cells.
  • Excel Engineering Functions
    Excel Engineering Functions
  • Microsoft Excel Financial Functions
    Microsoft Excel Financial Functions
  • Microsoft Excel Information Functions
    Microsoft Excel Information Functions
  • Microsoft Excel Logical Functions
    Microsoft Excel Logical Functions
  • Microsoft Excel Lookup and Reference Functions
    Microsoft Excel offers you 18 lookup and reference functions. The two most important are INDEX and MATCH. Forget about VLOOKUP and HLOOKUP.
  • Microsoft Excel Mathematical Functions
    Microsoft Excel Mathematical Functions
  • Excel Statistical Functions
    Excel Statistical Functions
  • Excel Text Functions
    Excel offers you 24 functions in the text category. Ten of these functions are interesting including TRIM, REPT, CONCATENATE, MID and FIND
  • Excel function SUBTOTAL
  • Excel ISERROR function
  • New Excel Functions added in 2007
    In 2007 Microsoft has added 5 new functions to Excel. Here they are
  • Microsoft excel spreadsheets
  • Microsoft Excel Signs
    Microsoft Excel offers you 21 date and time functions and 13 of them are interesting. But beware of the format of your cells.
  • Excel Countif Function
    The COUNTIF function in Excel allows the user to count a series of cells based on a criteria. SUMPRODUCT does the same thing and much more.
  • Microsoft excel toolpack
  • Microsoft Excel Database Functions
    Excel offers you 12 functions in the database category. When you discover SUMPRODUCT none of these functions are useful.
  • Microsoft Excel Date and Time Functions
    Microsoft Excel offers you 21 date and time functions and 12 of them are interesting. But beware of the format of your cells.
  • Excel Engineering Functions
    Excel Engineering Functions
  • Microsoft Excel Financial Functions
    Microsoft Excel Financial Functions
  • Microsoft Excel Information Functions
    Microsoft Excel Information Functions
  • Excel Logical
    Microsoft Excel Logical Functions
  • Microsoft Excel Lookup and Reference Functions
    Microsoft Excel offers you 18 lookup and reference functions. The two most important are INDEX and MATCH. Forget about VLOOKUP and HLOOKUP.
  • Microsoft Excel Mathematical Functions
    Microsoft Excel Mathematical Functions
  • Excel Statistical Functions
    Excel Statistical Functions
  • Excel Text Functions
    Excel offers you 24 functions in the text category. Ten of these functions are interesting including TRIM, REPT, CONCATENATE, MID and FIND
  • VLOOKUP and other old lookup Functions in Excel
    VLOOKUP and other old lookup Functions in Excel
  • meethost.docx
  • Excel Visual Basic Editor
    Working with the Visual Basic Editor in Excel
  • Project Window in Excel
    The Project Window in the Visual Basic Editor of Excel
  • Properties Window in Excel
    The Properties Window in the Visual Basic Editor of Excel
  • Code Window in Excel
    The Code Window in the Visual Basic Editor of Excel
  • Creating Excel macros
    Excel Visual Basic Editor: Creating a new macro
  • Testing macros in Excel
    Excel Visual Basic Editor Testing a macro
  • Excel Macro Recorder
    The Macro Recorder in Excel is the best teacher and a great assistant. Here is an exercise to record your first macro in Excel and run it.
  • Modifying Macros in Excel
    Modifying a macro with the Excel Visual Basic Editor
  • Events in VBA Excel Macros
    Section 9 on VBA Excel Macros and procedures: The Events
  • Security and protection in Excel
    Excel Security and Protection
  • VBA for Excel macros language
    Introduction to VBA Code, words and sentences
  • Error Handler in VBA for Excel
    Lesson 18: Using Exit Sub and an address to handle errors. Use a message like
  • VBA Excel Application Screenupdating
    VBA Objects, Methods and Properties for the Application
  • VBA for Excel workbooks and Windows
    VBA for Excel: Working with Workbooks and Windows
  • Worksheets in VBA for Excel
    VBA for Excel (macros): working with the sheets
  • VBA Excel Range Cells and Offset
    The three words in VBA Excel that you will use the most to move around the worksheet are: Range, Offset and Select. Always use Range rather than Cells
  • Message and Input Boxes in Excel
    Message boxes and input boxes are the basic tools to communicate with the user. You alert him of a potential problem or you ask him for his advice.
  • VBA for Excel with Databases
    Working databases with VBA for Excel
  • Variables in VBA for Excel
    Lesson 19: When you start using variables in your macros sky is the limit. With the VARIANT you can even execute 1,000,000 calculations in less than 3 seconds.
  • VBA Excel IF Statements
    Lesson 20: VBA Excel IF Statements and other Statements
  • VBA Excel Macros Functions
    Lesson 21: Develop new Excel Functions with VBA or discover the many functions that exist in VBA for Excel like Date, LCase, MonthName, Now, WorksheetFunction
  • SQL and VBA for Excel
    You can query data from an outside database using SQL in VBA for Excel. It is simple and extremely powerful. You can even submit dynamic criteria from the worksheet.
  • VBA Excel and Other Microsoft Programs
    Lesson 23: With VBA for Excel you can develop macros that will run in Word, Access or any other Microsoft program. You can even work with Windows using API's.
  • VBA for Excel Userforms
    Lesson 24: You will create userforms to require input from the user. On it you will add controls and then set the tab order. On controls see lessons 26 to 33.
  • Userforms in VBA for Excel
    Lesson 25: Developing Userforms in VBA for Excel
  • Labels in VBA for Excel
    Lesson 26: Using The Labels in VBA for Excel
  • Text Boxes in VBA Excel
    Lesson 27: Using Text Boxes in VBA for Excel. They carry text but they can also be formatted to show and carry values like currencies, dates and more.
  • Command Buttons in Excel
    Lesson 28: Using the Command Buttons. Not too many properties but a lot of VBA procedures. Most of what has to happen happens when you click on it.
  • Combo boxes (ComboBox) in Excel
    Lesson 29: Feeding the drop-down list doesn't require any programming. Cascading combo boxes when the choice in the second one depends on the value of the first one.
  • List Boxes (ListBox) in Excel
    Lesson 30: VBA for Excel list boxes (listbox). One or many columns to show and choose from. Single choice or multiple choices.
  • Radio Buttons, Check Boxes and Frames in VBA for Excel
    Lesson 31: Using the option buttons, check boxes and frames on userforms in Excel. It can be one OR the other or one AND the other when you use a frame.
  • Excel Spin Buttons and Image Controls
    Lesson 33: The image control on Excel VBA Userforms. The shoppinf cart or order completion control. The control that brings life to the userform.
  • VBA Excel Forms and Controls
    Lesson 32: The spin button control. When you want to offer your users an easier way than the text box to submit values you start working with the spin button.
  • Excel HLOOKUP function
    HLOOKUP is an old function inherited from Lotus-123. There is a more powerful way to do whaterver HLOOKUP does; the INDEX/MATCH formula.
  • Excel VLOOKUP function
    VLOOKUP is an old function inherited from Lotus-123. There is a more powerful way to do whaterver VLOOKUP does; the INDEX/MATCH formula.
  • Excel VBA VB MS Office by Affordable Solutions IT consultants.
    Affordable Solutions is an independent consultancy for Excel and Microsoft Office development.
  • excel-online.xls
  • Excel 2007 Install VBA
    No thanks to Microsoft in Excel 2007 you now need to install VBA for Excel from the Office CD to be able to develop macros. Here is how to do it.
  • Excel as a Database
    program,development,vb,vba,Office,Office,html,web,consulting,software
  • Excel COUNTIF function
    HLOOKUP is an old function inherited from Lotus-123. There is a more powerful way to do whaterver HLOOKUP does; the INDEX/MATCH formula.
  • Excel VBA VB MS Office by Affordable Solutions IT consultants.
    Affordable Solutions is an independent consultancy for Excel and Microsoft Office development.

Page created with PRO-Sitemaps.com - PRO Sitemap Service