Have a question?
Message sent Close
5 out of 5
5
1 review on Udemy

Learn Microsoft Excel – Advanced

Essentials for the Real World
Instructor:
Nimalan Tharmalingam
946 students enrolled
English [Auto]
Fully familiarize with the new features and functions of Microsoft Excel
Know how to navigate the Excel user interface and use Excel commands
Get step-by-step guidance on how to create worksheet formulas and manage workbook properties
Understand how to insert, delete, and adjust cells, column and rows
Learn how to apply conditional formatting and work with ranges and charts
Discover how to sort, filter and query data with database functions
Understand how to create and modify tables, use lookup functions and apply data validation
Preview and print worksheets.

Advanced Microsoft Excel empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, pivot tables and printing.

Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data.
This course empowers you to:

  • Write a range of fundamental Excel commands
  • Perform worksheet calculations
  • Build custom formulas
  • Amend elements in a worksheet
  • Apply formatting changes to cells
  • Manage workbook properties

In this Microsoft Excel training, you will learn to:

  • Efficiently navigate and manipulate worksheets and workbooks.
  • Implement an income and expense statement with formulas, functions, and names.
  • Design a reusable data entry template that protects formulas.
  • Implement conditional formatting to analyze sales information.
  • Connect, prepare, and validate data employing editing tools, formulas, and Flash Fill.
  • Identify, sort, and select detailed data with tables and slicers.
  • Present and analyze data with conditional formatting, charting, sparklines, and printing parameters.
  • Construct IF functions that make decisions – present results visually.
  • Analyze summary data with PivotTables and implement a quick dashboard.
  • How print

Anyone who wants to increase their digital literacy and start using Microsoft Excel to perform basic tasks in the workplace.

 

 

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
5
5 out of 5
1 Ratings

Detailed Rating

Stars 5
1
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
e69deba6dfc2ee7ddf8606aee2cffafc
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW