9 Steps to Automate Multiple Profiling Reports in Microsoft Excel | Excel Sifu
Many trainers, speakers and consultants are using their own profiling tool to understand their customers. So that, they can craft a specific solution.
This video shows you 9 steps to automate such profiling reports. Thus, these experts can churn out such reports easily, and able to help more people.
TIMELINE
0:00 The Final Result
0:20 Intro
0:24 The Scenario & Requirements
2:00 Step 1: Create Data Worksheet
2:27 Step 2: Add new row in "Calculation" sheet
3:51 Step 3: Create a Column in "Data" worksheet
4:05 Step 4: Create an Excel Table in "Data" worksheet
4:38 Step 5: Use Formulas to Retrieve Data from "Data" worksheet
8:43 Step 6: Save file as a Macro-enabled workbook
8:58 Step 7: Record macro to save a worksheet as a PDF file
11:04 Step 8: Edit the automation code
25:52 Step 9: Fine tune the automation
30:23 Testing the automated Excel file
31:31 Closing
Downloadable Practice File
👉 https://docs.google.com/spreadsheets/...
Follow Me in Odyess
👉 https://odysee.com/@ExcelSifu
Join Me in Odyess
👉 https://odysee.com/$/invite/HuxeoXKaU...
Connect to me in LinkedIn
👉 / excelsifu
Like our Facebook
👉 / whyexcel
Hash Tag
#ExcelSifu #microsoftexcel #Excel
Music by: bensound.com
License code: Z7OZN2P95PLKYM8T