Courses from $13.99 USD plus 20% extra with the code BLACK | We bring you closer to your goals

BLACK

Excel 2019: Intermediate - Advanced

Learn how to transform your Excel reports and spreadsheets into dynamic reports, applying advanced tools quickly and easily like an expert. Save time and be more productive!

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

👥 12.924
(163)
$13.99 USD $67.00

30-day money back guarantee

This course includes:

▪️ 6h 25m duration on demand

▪️ 28 lessons

▪️ 33 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

✦ Bonus: Set of Downloadable Guides and Editable Templates

⚑ Certificate of completion

What you will learn

🟧 We will teach you all the functions to validate data, implement advanced filters and record Excel macros.

🟧 Learn how to automate spreadsheets to speed up your analysis.

🟧 You will know how to add value to all your Excel work.

🟧 You will professionally handle dynamic formulas to present information accurately.

Course content
U1: Data management
  • Sort data and Subtotals.
  • Autofilters and Advanced Filters.
  • Drop-down lists and Data Validation.
  • Remove duplicate data.
  • Jobs with names.
U2: Scenario Tools
  • Scenario Tools - Finding Goals
  • Scenario Tools - Solver
  • Unlocking the Power of Excel Scenario Tools
U3: Business Intelligence Tools in Excel
  • Pivot tables.
  • Dynamic charts.
  • Data segmentation.
  • Dashboard Design.
U4: Macros and their code
  • Recording Macros - Examining Macro Code.
  • Automating Tasks in Excel Master the Power of Macros and Their Codes
U5: Advanced Functions
  • SearchV
  • Add.if
  • Average.yes
  • Count.if
  • Yes.error
  • Index and Match
U6: What's new in Excel 2019
  • Yes Set
  • Max Si Set
  • Change
  • Concat
U7: Create reports in a few steps
  • Payroll payment receipt.
  • Indicator management report.
  • Billing Report.
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:

▸ Intermediate Advanced Excel Guide


📎 Editable Templates and Practical Files:

▸ Sort data and Subtotals
▸ Autofilters and Advanced Filters
▸ Drop-down lists
▸ Remove duplicate data
▸ Jobs with names
▸ Scenario Tools - Goal Seek
▸ Scenario Tools - Solver
▸ Pivot tables
▸ Dynamic charts
▸ Data Segmenters
▸ Dashboard Control Panel
▸ Recording Macros - Examining Macro Code
▸ SearchV
▸ Add.if
▸ Index and Match
▸ If Set
▸ Payroll payment receipt
▸ Indicator management report
▸ Billing Report

Description

Do you want to reach a PRO level in Excel and master new tools to make your administrative tasks much faster?

Did you know that more than 88% of companies prefer a certified Excel professional over one who has little experience with this tool?

Excel is the most widely used spreadsheet in the world, and by learning to master its advanced functions you can save time and increase your productivity.

Increase the efficiency of your data analysis by understanding how to organize data better and faster in Microsoft Excel.

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

Pack de 3 cursos

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.

Customer Reviews

Based on 163 reviews
81%
(132)
17%
(28)
1%
(2)
1%
(1)
0%
(0)
K
Kevyn Duque
Buena

Siento que el curso debería tener otro titulo porque explica muy bien pero las herramientas de Excel, no explica muchas otras formulas y funciones que tiene.

C
Carla León
Excel para quien desee llevar sus habilidades al siguiente nivel.

Recomiendo este curso a usuarios que buscan un aprendizaje profundo de las funcionalidades de Excel y que quieren llevar sus habilidades al siguiente nivel.

R
Renato Valdez
Los ejercicios me permite poner en práctica lo aprendido

El contenido del curso es profundo y está actualizado con las últimas funcionalidades de Excel. Los ejercicios y casos de estudio me han permitido poner en práctica lo aprendido y resolver problemas desafiantes

D
Diego Mendoz
Me encato este curso

He notado una mejora notable en mi productividad gracias a las habilidades que he adquirido en el curso. Ahora puedo realizar mis tareas de forma más eficiente y con mayor precisión

D
David Alejandro
Muy Bueno

El curso está diseñado para proporcionar a los alumnos las habilidades y conocimientos necesarios para dominar Excel. Los contenidos son actualizados y relevantes para el mercado laboral actual.

L
Luis Camacaro
Excelente

El curso online Microsoft Excel Intermedio - Avanzado de G-talent es un curso completo y actualizado que me ha proporcionado las habilidades necesarias para dominar Excel. En general, estoy muy satisfecho con el curso lo recomiendo encarecidamente

I
Isabel María
Estoy muy satisfecho con el curso Microsoft Excl

El curso me ha ayudado a aprender a utilizar Excel de forma eficaz para realizar tareas complejas, como el análisis de datos, la creación de informes y la automatización de procesos. Esto me ha permitido ser más eficiente en mi trabajo y a tomar mejores decisiones. En general, estoy muy satisfecho con el curso Microsoft Excel Intermedio - Avanzado de G-talent

A
Allan Geovani Pavon Valezuela
Buen contenido

Buen contenido, pero debería de ser un poco más largo o extender el contenido.

J
Jose luis Urbina verdugo
Lo recomiendo

Curso que me ha enseñado mucho, lo recomiendo

M
Marian
El curso ha sido estupendo

El curso ha sido estupendo, el material facilitado es muy completo para el contenido que se imparte en el mismo.

Ver más reseñas
View all

Explore other courses from Nohelia Bastidas

Discover other courses and learn something new today. Learn from the best!

Best selling courses

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 30-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.