What You'll Learn
- Syntax of Excel Functions
- Relative & Absolute Cell References
- Most Common Excel Error
- Show Formula, Evaluate Formula & Error Checking
- Excel Shortcut Keys
- AND, OR, NOT & IF & IF Error Functions
- Nesting Multiple IF Statements
- SMALL, LARGE, Rank, Percentrank, Percentile, RAND & RANDBETWEEN Functions
- All of SUM, COUNT Functions
- LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP Functions
- Upper, Lower, Proper and Trim Function
- Find, Search, Substitute & Replace
- NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE & SECOND
- calculate Age using YEARFRAC
- Combining SORT, FILTER & UNIQUE
- Combine the SORT, UNIQUE, and COUNT functions
- Drop-Down Lists with SORT, UNIQUE & No Blanks
- Unique Drop Down Lists that Automatically Update with New Values
- RANDARRAY, FREQUENCY and TRANSPOSE Functions
- And More.......
Requirements
- No prior knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone dealing with business reports, data entry, or data organization
- Anyone who wants to master functions quickly and effectively
- Students, professionals, and Excel beginners looking to improve their formula skills
- Job seekers preparing for interviews that require Excel knowledge
Your Instructor
Experienced Instructor
Professional Educator
An experienced instructor with expertise in this field and a passion for teaching.
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Limited Time
Complete MS Office and Web Design Development Course
Unlock Your Digital Potential: Master MS Office, Web Development, and WordPress
Free 100% Off
Today
Limited Time
Advance MS Excel VBA for Beginner to Advanced
Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achi…
Free 100% Off
Yesterday
Limited Time
Crea Correos Corporativos con Dominio Propio en Gmail 2026
Aprende a como crear correos corporativos con dominio propio en Gmail, de forma fácil y simple.
11.99$ 20% Off
29 June 2026
Limited Time
Complete Notion AI Guide: Productivity, Prompts & Templates
Build smart workflows, prompts, and productivity systems with Notion AI
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.