What You'll Learn
- Introduction to the Excel Interface
- Move and Copy Data in Worksheet
- Working with Rand & Randbetween
- Working with ROUND, ROUNDUP and ROUNDDOWN
- Date and DATEDIF Function
- CHOOSE and SWITCH Function
- UPPER, LOWER, PROPER & TRIM
- LEFT, MID, RIGHT & LEN
- SORT and SORTBY Functions
- INDEX, MATCH, XMATCH and EXTACT Function
- Combining EXTACT & VLOOKUP
- Custom Data Validation
- XLOOKUP Function
- Creating a PivotTable from Scratch
- Applying PivotTable Styles
- Create a Bar, Column, Line and Pie Chat
- Inserting and Formatting Slicers
- Proetect Worksheet and Workbook
- Inserting Headers and Footers
- Printing a Workbook
Requirements
- No prior Excel experience is needed
Who This Course is For
- Anyone learn everything from Excel basics to advanced features.
- Business owners and entrepreneurs who need to manage their finances and data more efficiently.
- Anyone who uses Excel and wants to save time and automate repetitive tasks.
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.1 Instructor Rating
422 Reviews
20,408 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
The Complete System of Prompt Engineering
Unlock the full power of AI — learn to think, design, and build like an AI system architect
Free 100% Off
Today
Expires in 21 hours
Office Productivity
English
Primavera P6 for Civil Engineers – Masterclass in Planning
Learn Primavera P6 with Real Civil Projects – WBS, CPM, Gantt Charts, Resource & Cost Loading, BOQ,…
Free 100% Off
Today
Expires in 3 days
Office Productivity
Vietnamese
Accounts Receivable in SAP S/4HANA Cloud
SAP S/4HANA Cloud, Accounts Receivable
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
SAP UI5 & Fiori Essentials: Beginner's Complete Walkthrough
SAP UI5 & Fiori Walkthrough for Beginners | HTML, JS, XML, Controllers, BAS, Bindings, Apps, and Mo…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.