Excel 2019: Complete
By Nohelia Bastidas | Master in Administration | Bachelor in Business Administration
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: Dynamic Tables Tutorial
⚑ Certificate of completion
What you will learn
What you will learn
🟧 Create complete and dynamic reports using pivot tables.
🟧 Automate routine tasks with Macros and VBA.
🟧 Be able to prepare a Dashboard in Excel in simple steps.
🟧 Functions, data validation, advanced filters and recording Excel Macros.
🟧 Learn how to automate spreadsheets to speed up your analysis.
🟧 Add value to your Excel work and much more.
🟧 Professionally handle dynamic formulas.
🟧 Create impressive reports using different types of charts.
Course content
Course content
U1: Introduction
- Excel interface
- Formats and their properties
- Working with names
- Page layout and printing
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
- Master Excel for Data Analysis
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
U7: Financial Reports
- Business Management ReportCreate a LinkedIn Account/Full Tutorial
- Business budget with mini charts
U8: Macros and their codes
- Recording macros and examining the macro code
- Automate Repetitive Tasks and Expand Excel Functionality with Macros and VBA Codes
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
- Master Your Spreadsheets The 10 Excel Functions Harvard University Recommends
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 Guide Set
▸ Excel Guide for Finance
▸ Getting started with Power BI
▸ Complete guide to formulas and functions in Excel
📎 Editable Excel 2019 Templates
▸ Business management report template
▸ Financial Statement Template
▸ Budget control template
Description
Description
✔️ Do you want to save time in your daily tasks by taking advantage of the potential of EXCEL?
Excel allows companies to collect, analyze and generate reports, which improves and optimizes decision-making.
Mastering Excel has become one of the most highly valued skills by companies. In EXCEL you can manage large databases and summarize information very quickly by applying tools and functions that make your day easier.
You will learn everything you need to MASTER EXCEL 2019 from basic to advanced level, using a simplified, practical and step-by-step method, in no time!
Companies from all industries invest in the development of their teams with this course from G-Talent and Nohelia Bastidas
Aún en estudios, vamos bien.
Excelente curso
Pendiente continuar con el curso, me parece que está muy bien organizado es fácil de entender y seguir y el contenido va al grano
Muy didáctico y de fácil entendimiento
El contenido del curso es eminentemente práctico y está actualizado con las últimas funciones de Excel 2019. He aprendido habilidades que puedo aplicar de inmediato en mi trabajo diario, lo que ha impactado positivamente en mi desempeño
La plataforma online de G-talent es intuitiva y fácil de usar. Puedo acceder al contenido desde cualquier lugar y en cualquier momento, lo que me permite aprender a mi propio ritmo
Gracias al curso, he logrado mejorar significativamente mi eficiencia laboral al aprender a utilizar fórmulas avanzadas, tablas dinámicas y macros. Esto me ha permitido ahorrar tiempo y enfocarme en tareas más estratégicas
Ha sido una excelente experiencia me ha cambiado la forma en que antes hacía los trabajos, ahora se me hace mucho más fácil y práctico.
Los cursos de Excel Completo en G-Talent.Net han sido una revelación para mí. Gracias a ellos, he adquirido conocimientos esenciales para trabajar de manera eficiente con hojas de cálculo y optimizar mi tiempo. Estoy impresionado con la calidad de la formación y el apoyo constante que recibí durante todo el proceso. ¡Recomendaría estos cursos a cualquier persona que desee dominar Excel y destacarse en su trabajo
G-Talent.Net ha superado mis expectativas con sus cursos de Excel Completo. Los materiales de estudio son claros y fáciles de entender, y los instructores están siempre dispuestos a resolver cualquier duda. He aprendido a crear fórmulas avanzadas, a utilizar tablas dinámicas y a generar informes profesionales. ¡Estoy realmente agradecido por esta oportunidad de mejorar mis habilidades en Excel!
Nohelia Bastidas
Master in Administration | Bachelor in Business Administration
About Nohelia Bastidas
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.
Explore other courses from Nohelia Bastidas
Discover other courses and learn something new today. Learn from the best!
Best Selling Courses in Personal Development
-
Handling Difficult People at Work: Effective Strategies to Improve Your Work Environment
★★★★★(18)$15.99 USD$59.99Unit price /Unavailable -
-
-
-
-
Analytics and Artificial Intelligence with Power BI
★★★★★(10)$15.99 USD$75.00Unit price /Unavailable -
ChatGPT for Professional Tasks and Microsoft Office
★★★★★(13)$15.99 USD$67.00Unit price /Unavailable -
-
-
B2B Consultative Sales: Innovation and techniques for extraordinary results
★★★★★(9)$15.99 USD$97.00Unit price /Unavailable -
-
-
-
-
-
-
-
Training of Internal Auditors in Quality Management Systems
★★★★★(179)$15.99 USD$74.99Unit price /Unavailable
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.