Office 365: Advanced Excel Formulas, Functions & Short-Cut Keys.

111 Most Useful Functions like XLOOKUP, TEXT, Count, DATE, nestle formulas and many more...(MS excel 2013 to Office 365). 101 short cut keys with live example explanation.

Created by : Rated :4.1 68 views

Last Updated: 2024-11-28 04:11:24 English Course Type: Self Learning

Enable students to achieve more with less effort, less time, and less investment, maximizing productivity and efficiency in data management, and reporting task.
Advanced Formulas and Functions: Mastery of complex functions such as XLOOKUP, TEXT, INDEX-MATCH, IFERROR, VSTACK, COUNTIFS, and nested functions including shortcut keys and practical examples for efficient workflow.

Discover Excel's 111 most indispensable functions covering a wide spectrum, from logical and mathematical operations to text manipulation, statistical analysis, financial calculations, and nested formulas. Whether you're performing complex data analysis, financial modeling, or simply formatting text, this comprehensive collection equips you with the essential tools to tackle diverse tasks efficiently, making Excel an indispensable tool for professionals across industries.

Excel's text manipulation functions including LEFT, RIGHT, UPPER, LOWER, PROPER, SEARCH, and FIND empower users to efficiently extract, modify, and search for text within cells, facilitating precise data manipulation and analysis in spreadsheets. These functions streamline tasks such as text formatting, case conversion, and locating specific text strings, enhancing productivity and accuracy in Excel workflows.

udemy

Logical functions such as IF, AND, OR, and NOT facilitate decision-making and conditional logic operations, while Financial functions like PV, FV, NPV, and IRR aid in financial analysis, planning, and investment evaluation.

Statistical functions in Excel, including AVERAGE, MAX, MIN, and COUNT, provide essential tools for analyzing and summarizing data, enabling users to derive insights and make informed decisions based on numerical information.

Information functions such as ISNUMBER, ISBLANK, and ISTEXT help validate and analyze data types and properties, ensuring data accuracy and integrity. Compatibility functions like CONVERT and COMPLEX facilitate smooth data exchange across different systems and units, enhancing interoperability within spreadsheets.

Access to Excel Software: Access to Microsoft Excel software (preferably the latest version like from 2013,2016,2019 or Office 365) is essential.
Basic Excel Skills: Understanding of fundamental Excel concepts such as entering data, capy data, save file etc.
Consistency & willingness to Learn: Commitment to completing course all contents, assignments and actively participating in course activities, is crucial for maximizing the learning experience.

The advanced Excel course is designed for professionals, analysts, and students who already possess a foundational understanding of Excel and seek to enhance their skills to tackle more complex data analysis, manipulation, and reporting tasks.
It is ideal for individuals looking to streamline workflows, increase efficiency, and unlock the full potential of Excel for advanced data-driven decision-making in their respective fields. This course will further enhance your skills by introducing from basic excel knowledge to more advanced concepts like working with functions, data visualization, and basic data manipulation techniques.
It’s a great way to solidify your existing knowledge and expand your capabilities in using Excel effectively.

Section 1 : Introduction 1 Lectures
Lecture 1 :
Introduction Preview
Section 2 : Mathematics and trigonometric functions 7 Lectures
Lecture 1 :
Cells relative reference and absolute reference
Lecture 2 :
Cells relative reference and absolute reference2
Lecture 3 :
Use of relative and absolute reference in table.
Lecture 4 :
1 Functions_Product, ABS & RAND
Lecture 5 :
Randbetween, roman and round
Lecture 6 :
Subtotal, Sum, Sumif, Sumifs
Lecture 7 :
Sumproduct, Aggregate functions
Section 3 : Lookup & reference functions: 4 Lectures 00:18:32
Lecture 1 :
Address, Column, Columns, Row, Rows functions
Lecture 2 :
Offset, transpose, hyperlink functions
Lecture 3 :
Vlookup, Hlookup
Lecture 4 :
Xlookup, Match, Xmatch
Section 4 : Date and time 3 Lectures 00:12:55
Lecture 1 :
Date, day, days, month, year and weekdays
Lecture 2 :
Weeknum, time, hour, minute & second
Lecture 3 :
Edate, Eomonth, Networkdays & workday
Section 5 : Logical and Financial 3 Lectures
Lecture 1 :
And, or, not & if functions
Lecture 2 :
If and, if or, true, false and iferror
Lecture 3 :
Ifs function
Section 6 : Text functions 3 Lectures
Lecture 1 :
Left, right, upper, proper, lower search & find
Lecture 2 :
Mid, trim, fixed, & concatenate
Lecture 3 :
Text, t, clean, value & text split functions
Section 7 : Statistical functions 3 Lectures
Lecture 1 :
Average, averagea, averageif & averageifs
Lecture 2 :
Count, counta, countif & countifs
Lecture 3 :
Large, max, maxa, maxif, small & Min
Section 8 : Information and compatibility functions 4 Lectures
Lecture 1 :
Address, col, row, type & width
Lecture 2 :
Directory, numfile, origin & system
Lecture 3 :
Isblank, iserror, isodd, istext & type
Lecture 4 :
Forecast, sequence, torow, tocol, hstack & vstack
Section 9 : Excel Short-cut keys 3 Lectures
Lecture 1 :
Short cut keys - 1
Lecture 2 :
Short cut keys - 2
Lecture 3 :
Short cut keys - 3

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?