محتوى الدورة
Excel ActiveX Combo Box to Select Worksheets with VBA How to Create & Use Excel Macros (Real world example) How to create barcodes in Excel that WORK! Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!) VBA to BROWSE & COPY Data from SELECTED File in Excel How to Sum Cells by Color in Excel (Get it to update automatically) Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide) 3 Methods to Unhide All Sheets in Excel (& how to hide) Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Excel VBA: How to Check if File or Folder Exists (Dir Function) How to Insert Cell Values into Footers and Headers in Excel Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording) Excel VBA FIND Function (& how to handle if value NOT found) Create Excel Workbooks Worksheets Automatically with Excel VBA Arrays How to use the Message Box in Excel VBA (syntax you'll need for msgbox) Loop Through Cells Inside the Used Range with Excel VBA (For Each Collection Loop) Excel VBA IF THEN Statement (with ELSEIF & Looping in cells) How to Declare (Dim) and Set VBA Variables (use data types correctly) Easiest Ways to Copy and Paste Cells with Excel VBA (copy, pastespecial, resize & offset) Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names) Learn How to Use Properties and Methods in Excel VBA Effectively Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك