Ibnalkadi H., Ibnalkadi M. Automate The Boring Tasks Using Microsoft Office VBA

Independently published, 2021. — 218 p. – (The Complete MBA Coursework Series). — ASIN B08RYJQCHW.The book is part of a series that include MBA Core & Elective coursework taught at prestigious universities like Harvard and Wharton. The series consists of Core & Elective courses that stemmed from more than ten years of professional experience in Wall Street and Startups. The elective courses introduce Machine Learning, Python, Blockchain and Cryptocurrencies, Communications skills, R language, Excel advanced features, PowerPoint advanced features, interview questions, and more.Empty Row Removal (RemoveEmptyRows)
Range Swap (RangeSwap)
Generate Index [Table of Contents] Worksheet (WorkbookIndex)
Fill Blank Cells (FillBlankCellsWithValue)
Change Worksheet Formulas to Values (FormulasToValues)
Export Visible Worksheets as PDF (ExportAllVisibleSheetsPDF)
Group All Shapes In Active Worksheet (GroupAllShapes)
Duplicate Rows Removal (RemoveDuplicateRows)
Shape Chain Creation (CreateChainOfShapes)
Value Split (SplitValue)
Formula Protection (ProtectAllFormulas)
Worksheets Hide/Unhide (HideUnhideWorksheets)
Selection Range Painting (PaintSelectionColor)
Selection Row and Column Painting (PaintColumnAndRow)
Filtered Cells Export (FileteredCellsToNewWorksheet)
Text Splitting / Joining (SplitJoinTexts)
Multiple Range Insertion (InsertSelectedRangeMultipleTimes)
Pick File or Folder (GetFileOrFolderPath)
Worksheet Copy (CopyWorksheetsWorkbook)
Multi-Range Copy (CopyMultipleRange)