Discounted courses from just $13.99 USD and save an extra 20% with code RELAMPAGO20SEP | Ends today at 11:59 PM!

LIGHTNING20SEP

Excel 2019 for Finance

This online course will teach you how to master Excel to optimize your company's financial management. Learn how to create reports, automate tasks, and use advanced tools to make strategic decisions. Boost your career with this valuable certification!

By Nohelia Bastidas | Master in Administration | Bachelor in Business Administration

(71)
$13.99 USD $74.99 USD

15 day refund guarantee

This course includes:

▪️ 8h 25m duration on demand

▪️ 27 lessons

▪️ 18 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

✦ Bonus: Course Set of Guides and Templates

⚑ Certificate of completion

What you will learn

🟧 Excel Interface and Formats: Familiarize yourself with the Excel interface and learn how to use formats and properties to optimize your work.

🟧 Data Management: Master data sorting, filtering, and validation to accurately manage large volumes of information.

🟧 Essential Formulas and Functions: Learn how to use key formulas and functions like Sum, VLookup, Average, and IfError to perform complex calculations.

🟧 Scenario Tools: Use advanced tools like Solver and Goal Seek to perform scenario analysis and make informed decisions.

🟧 Financial and Business Intelligence Features: Build amortization tables, value projects, and create dynamic dashboards for advanced financial management.

🟧 Impress with your reports: We will teach you how to present impressive reports using different types of graphics, capturing everyone's attention and communicating your data effectively.

Course content

U1: Introduction
  • Excel interface
  • Formats and their properties
  • Working with names
  • Page layout and printing
  • How to Create a Dynamic Financial Dashboard
U2: Data management
  • Sorting data and subtotals
  • Autofilters and advanced filters
  • Data validation
U3: Essential formulas and functions
  • Sum, SumIf and VLOOKUP
  • Average, Count and If.Error
U4: Scenario tools
  • Scenario Tools - Finding Goals
  • Scenario Tools - Solver
U5: Financial functions
  • Construction of amortization tables
  • Project valuation (NPV - IRR) your profile
U6: Business Intelligence Tool in Excel
  • Pivot tables in Excel and pivot charts
  • Dashboard design and data segmentation
  • Automating Tasks with Excel Macros
U7: Financial Reports
  • Business management report
  • Business budget with mini charts
  • Discover little-known tools for precise and efficient financial control
U8: Macros and their codes
  • Recording macros and examining the macro code
U9: What's new in Excel 2019
  • Yes Set
  • Max Si Set
  • Change
  • Concat
  • Join chains
U10: The 10 Excel Functions Everyone Should Learn, According to Harvard University
  • The Ten Excel Functions Everyone Should Learn
Course evaluation
  • This course contains a final exam
G-Tools: For Students
  • Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Downloadable resources:

📎 Downloadable Guides:

▸ Excel Guide for Finance 2021


📎 Editable Templates:

▸ 0. Microsoft Excel Welcome Tour!
▸ G-Talent Complete Excel
▸ GTalent Management Report Template
▸ GTalent Budget Template
▸ Financial Statements Template
▸ Management Report Template for Indicators and Mini-Charts
▸ Project Valuation Template VPN and IRR
▸ Amortization Table Template for Bank Loans
▸ Pre-configured business management report template
▸ Pre-configured Financial Statements Template
▸ Pre-configured budget control template

Description

✔️ Do you want to become an Excel expert and use it as a powerful tool for financial management?

Master Excel and take your financial skills to the next level!

In our "Excel for Finance" course, you will learn how to use Excel in an advanced way to optimize data management, create accurate financial reports, and make strategic decisions. This course is designed for finance professionals, accountants, analysts, and anyone interested in improving their efficiency and accuracy in handling financial data.

Through instruction from finance and Excel experts, you will explore all of Excel’s essential and advanced features, from managing data and formulas to creating dynamic dashboards and automating tasks with macros. Each course module is detailed and practical, allowing you to immediately apply what you learn in your work environment.

Why is this course crucial for you and your career? Mastering Excel can be the difference between efficiency and inefficiency in financial management. With strong skills in this area, you will be able to accurately analyze data, create detailed reports, and make informed decisions that drive growth for your company.

Why choose G-Talent's "Excel for Finance" course?

We offer a comprehensive and practical learning experience:

◾️ Detailed and Applied Content: Enjoy more than 8 hours of high-definition video that will guide you step by step through the advanced use of Excel in finance.

◾️ Practical Exercises: Participate in exercises and practical cases that will teach you how to apply Excel tools in real-life situations.

◾️ Additional Tools and Resources: Access customizable templates and spreadsheets that will facilitate your daily management of financial data.

◾️ Professional Network: Connect with a community of finance and Excel experts to exchange ideas, strategies, and tips.

◾️ Continuous Support: Our team of experts will be available to answer your questions and provide you with personalized guidance throughout your learning.

◾️ Unlimited Access: Learn at your own pace and access course material whenever you need it, with guaranteed lifetime access.

◾️ Recognized Certification: Complete the course and obtain a certificate that validates your skills in the advanced use of Excel for finance, improving your professional profile and opening new career opportunities.

Ensure efficiency and accuracy in your company's financial management by learning to use Excel like an expert.

Sign up now and take control of your financial future!


Companies from all industries invest in the development of their teams with this course from G-Talent and Nohelia Bastidas


Customer Reviews

Based on 71 reviews
94%
(67)
6%
(4)
0%
(0)
0%
(0)
0%
(0)
J
Johana Zarramera
Excelente curso

Me gusta que explican con mucho detalle cada función, cada tema es tratado con claridad y el aprendizaje se hace ameno.

A
Alejandro Frias
Lo que buscaba

Es justo lo que buscaba

N
Natalia Mendoza
Excelente

Gracias al curso, he logrado mejorar significativamente mi eficiencia laboral al automatizar tareas repetitivas con macros y fórmulas. Esto me ha permitido ahorrar tiempo y enfocarme en tareas más estratégicas.

Nohelia Bastidas

Master in Administration | Bachelor in Business Administration

About Nohelia Bastidas

Master in Administration | Bachelor in Business Administration

Financial sector expert with over 20 years of experience in finance and business development. Throughout her career, Nohelia has demonstrated a deep understanding of cash flow management and optimization, making her a leading professional in her field. Her focus on improving administrative and technical functions has led her to develop innovative Business Intelligence solutions that automate and present financial information intelligently.

Since 2001, Nohelia has worked in various engineering and consulting firms, always with the aim of optimizing processes and providing strategic value. Her passion for the management and presentation of financial information has been the driving force behind the creation of tools that facilitate strategic decision-making based on relevant and automated data.

Why choose to learn with Nohelia Bastidas?

▪️ Proven experience: Over 20 years in the financial sector, developing a deep understanding of cash flow management and optimization.
▪️ Innovative solutions: Co-creator of Business Intelligence tools that automate the presentation of financial information to facilitate strategic decisions.
▪️ Practical approach: Nohelia shares her real, practical experience in improving administrative and technical functions, providing learning applicable to your career.
▪️ Guaranteed results: Your course is designed to transform your financial management, teaching you to master cash flow and improve the efficiency of your business.

Take advantage of the opportunity to learn with Nohelia Bastidas and transform your financial management! Enroll now in her Cash Flow course and master the tools you need to take your business to the next level.

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

What to expect from G-Talent courses?

  • Study at your own pace

    Get video courses, taught by top instructors, to study at your own pace

  • Learn from the best

    Provides high quality courses developed by carefully selected experts

  • Quality guaranteed

    Not sure? All our courses offer a 15-day success guarantee

  • Permanent accompaniment

    Learn at your own pace, with lifelong updates, access and support.

  • Personalized certificate

    Get a world-class certificate, with international validity and a unique encrypted QR code

  • G-Tools: For Students

    Find all the tools you need for your employability in one place.