Summary
Highlights
Data has become an invaluable asset for businesses, driving decision-making and transforming the job market. Business intelligence, especially data analysis, is a growing trend. Despite its demand, many professionals lack these skills. Microsoft Excel is the leading data processing program globally, used by over 500 million people and highly sought after in job vacancies across various sectors.
The instructor, Carolina de Andrade, a civil engineer and CEO of SM Smart Pro Academy, aims to demystify Excel, which many find difficult. She highlights her extensive experience, over 30,000 students in 75+ countries, and her recognition by Microsoft as an MVP in Excel. She encourages participants to engage in the 'Excel Marathon,' a free four-class event, to unlock their potential.
Carolina emphasizes persistence in learning, noting that not everyone completes what they start. She advises viewers to take the Excel test to accurately assess their skill level, as many overestimate their proficiency, missing out on powerful tools.
To optimize the learning experience, Carolina recommends minimizing distractions and watching the session on a larger screen like a Smart TV or computer. She reminds unregistered participants to sign up via QR code or link to receive practice files and access to a WhatsApp group for resources. She also mentions that attendance is required for a certificate, which will be distributed a few days after the marathon concludes.
The first step in creating an interactive dashboard is to list key performance indicators (KPIs). Carolina explains that a dashboard, like a car's dashboard, should only display the most essential alerts, with further details available if needed. She suggests identifying KPIs by observing frequently asked questions in work meetings or consulting with team leaders. Google Images can also provide inspiration for dashboard layouts and indicators.
After selecting the indicators, a visual draft or sketch of the dashboard layout is crucial. For this demonstration, indicators like monthly sales filtered by vendor and brand, and a vendor ranking, are chosen for an electronics store scenario. A common issue with dynamic charts, which rely on dynamic tables, is incorrectly formatted dates. Carolina explains how AI tools like ChatGPT can identify and correct these date formatting errors, which are often overlooked in traditional Excel courses.
Carolina demonstrates how to use ChatGPT to correct misformatted dates in an Excel sheet. She emphasizes that while AI is powerful, understanding Excel fundamentals is crucial to asking the right questions and verifying the AI's output. She also shows how AI can help implement data validation rules in Excel, preventing future errors by restricting cell input to correct date formats.
With the data now clean and validated, Carolina proceeds to create the first dynamic chart: monthly sales. She guides through inserting a pivot table from the corrected data, dragging the 'Date' field to rows to automatically group by month, and the 'Amount' field to values. A key practice for dashboards is to create pivot tables in a separate sheet, keeping the dashboard clean and organized.
The monthly sales chart is customized to enhance readability and visual appeal. Carolina advises hiding unnecessary buttons, removing legends for single-series charts, and clearly naming the chart with units (e.g., 'Sales in $'). She also demonstrates how to remove decimal places and gridlines, and how to apply predefined styles or manually format chart elements for a cleaner look. Instructions are provided for both Windows and Mac users.
Next, a dynamic bar chart for vendor ranking is created. Carolina shows a more efficient way to create pivot tables by naming the source data table, eliminating the need to navigate back and forth between sheets. She applies similar customization steps as before: removing buttons and gridlines, adjusting number formats, and adding a title. To make it a true 'ranking', the chart is sorted by sales, demonstrating the interactive nature of dynamic charts.
The two customized charts are cut and pasted into the dedicated dashboard sheet. Carolina then introduces 'slicers' (segmentación de datos) to make the dashboard interactive. Slicers allow users to filter data across multiple charts simultaneously with simple clicks. She adds slicers for 'Vendor' and 'Brand,' demonstrating how to format them into multiple columns for better space utilization and visual alignment with the dashboard's design sketch.
To enable slicers to control both charts, Carolina uses the 'Report Connections' feature within the pivot chart analysis tools, linking the slicers to the pivot tables that feed both charts. She also applies color coordination to the slicers to match the visual design, emphasizing the importance of thoughtful presentation. She explains that effective dashboards clearly highlight trends, making data insights easily digestible, unlike static tables.
For a professional and minimalist look, Carolina shows how to remove gridlines, hide row and column headers, and collapse unused rows and columns on the dashboard sheet. This creates a clean, focused display that enhances readability and avoids clutter. She warns against common mistakes like filling entire sheets with white, which can unnecessarily increase file size, and advocates for efficient design practices.
Carolina opens registration for her comprehensive Smart Excel training, which offers over 600 recorded classes structured across basic, intermediate, and advanced levels. She highlights benefits such as flexible learning, 'Smart Challenges' for practical application, 'Smart Experiences' for live problem-solving sessions, direct instructor support, a vibrant student community, and a recognized certification.
For a limited time (2 hours remaining from video recording), enrollees receive exclusive bonuses: a 'Smart Productivity' course (valued at $70), a masterclass on Excel with Artificial Intelligence, and preparation for Microsoft certification. The entire package, valued higher, is offered at $247. Carolina stresses the 7-day unconditional money-back guarantee as an incentive to take action, emphasizing the long-term value of investing in these skills.
Students share testimonials illustrating the profound impact of the Smart Excel training. Examples include significant time savings on reports (reducing tasks from two weeks to two hours), career advancements, and even personal lifestyle improvements like weight loss due to increased free time. These stories underscore how Excel proficiency, combined with logical thinking, can transform professional and personal lives, offering opportunities for remote work and increased income.
Carolina argues that the cost of her 'Mastery' program, $247, is a small investment compared to the potential returns: higher salaries, career advancement, remote work opportunities, and substantial time savings. She reiterates that data is the 'new gold' and that professionals with strong data analysis skills are in high demand across all industries. The training not only builds Excel expertise but also enhances communication and logical reasoning, making individuals invaluable in the job market.
Carolina extends a final call to action to enroll in the Smart Excel program, reminding viewers of the expiring bonuses and the imminent closing of registrations (within 7 days of video recording). She encourages them to overcome hesitation, citing the 7-day money-back guarantee as a risk-free opportunity to experience the training. She concludes by expressing gratitude to her students and team, emphasizing the belief in God-given potential and the importance of taking action to achieve dreams.