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

Excel 2019: Basic - Intermediate

Microsoft Excel is the most widely used spreadsheet in the world. In our course we will help you get the most out of the main functions of this tool so you can create powerful reports for data analysis and reporting. Unlock the potential of Excel 2019 and take your productivity to the next level with our Excel 2019: Basic - Intermediate online course.

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

👥13.254
(180)
$13.99 USD $54.00 USD

15 day refund guarantee

This course includes:

▪️ 6h 25m duration on demand

▪️ 26 lessons

▪️ 38 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

✦ Bonus: Downloadable Guide Set and Template Set

⚑ Certificate of completion

What you will learn

🟧 You will create impressive reports using different types of charts.

🟧 You will master filters and techniques for sorting large databases.

🟧 You will learn every mathematical and statistical formula and function.

🟧 You will work with conditional formats and apply traffic light type formats.

🟧 Master logical, conditional, and text functions.

Course content
U1: Your first steps in Excel
  • What is Excel? – Versions and how to install the program
  • Excel Interface – Ribbon and Tabs
  • Functionalities of a book and its pages - What they are and how to manage them
U2: Essential tools in Excel
  • Open - Create - Save an Excel workbook
  • Insert values ​​in Excel
  • Absolute and relative values ​​in a formula
  • Naming ranges and performing operations
  • Insert a function in Excel
  • Absolute and relative values ​​in a formula
U3: Formatting in Excel
  • Highlight a text
  • Number format
  • Format of a table
  • Conditional formats and the traffic light format
U4: Basic Functions in Excel
  • SUM, SUMIF, and VLOOKUP Functions
  • IF, AVERAGE and COUNT functions
  • CONCAT and SWITCH function
U5: Sort and filter a table
  • Sort a table
  • Filters in a profile table
  • Master your data like an expert Sort and filter tables in Excel, from intermediate to advanced
U6: Charts in Excel
  • Line and Column Charts
  • Pie Charts and Maps
  • Create a mini chart
U7: Create your first report in Excel
  • Sales Report Example, Page Layout and Print
  • Turn your data into powerful stories Complete guide to creating reports
U8: Tricks to speed up your work in Excel
  • Tips to speed up your work in Excel
  • 10 Tricks to speed up your work in Excel Become a spreadsheet ninja
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:

▸ Complete Guide to Excel Essential Formulas and Functions


📎 More than 30 Editable templates and practical files essential for your daily life

Description

In today's ever-changing world, it is a priority to know techniques to streamline any repetitive process.

It is vital to be able to use databases, calculations and Excel templates, both in our professional and personal spheres. With this, we can obtain greater skills to be able to analyze data, process it and present it in a summarized and professional way to support any decision-making process.

We've designed this course so you can quickly learn and create reports after applying each lesson.

Boost your knowledge and master Excel, the most widely used spreadsheet in the world!

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

Customer Reviews

Based on 180 reviews
66%
(119)
34%
(61)
0%
(0)
0%
(0)
0%
(0)
F
Fernanda Contreras
EXCELENTE

Enseñan muy bien todo, paso a paso

A
Antonia Bravo
La experiencia de aprendizaje ha sido accesible y efectiva

La experiencia de aprendizaje ha sido accesible y efectiva. La plataforma online es fácil de usar, los materiales de estudio son claros y concisos, y he valorado la posibilidad de aprender a mi propio ritmo

J
Julián Zúñiga
El contenido del curso es práctico y útil para el día a día.

El contenido del curso es práctico y útil para el día a día. Los ejemplos y ejercicios me han permitido poner en práctica lo aprendido y resolver problemas cotidianos de forma eficiente

Ver más reseñas

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.

View all

Explore other courses from Nohelia Bastidas

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

Best Selling Courses in Personal Development

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.