What You'll Learn
- Introduction to Microsoft Excel
- Ribbon, Tabs, and Toolbars
- Quick Access Toolbar and Status Bar
- Workbook vs. Worksheet
- Text, Numbers, Dates, and Formulas
- Alignment, Font Styles, and Borders
- Highlighting Cells Based on Rules
- Using cell references (relative vs. absolute)
- IF, AND, OR
- Creating and Formatting Tables
- Sorting and Filtering Data
- VLOOKUP, HLOOKUP, XLOOKUP
- CONCATENATE, TEXTJOIN
- LEFT, RIGHT, MID, LEN, FIND
- Using IFERROR and ISERROR
- Creating and Customizing PivotTables
- Grouping and Filtering Data
- Calculated Fields and Items
- Interactive data filtering
- Importing and Transforming Data
- Merging and Appending Queries
- And More
Requirements
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
Who This Course is For
- Anyone who wants to save time and get the most out of Microsoft Excel.
- Anyone who wants learn Microsoft Excel.
- Students and professionals who want to improve their excel skills.
- Entrepreneurs and office workers who prepare financial report regularly.
Your Instructor
Logic Labs
Instructor at Udemy | Programming | Data Analytics | AI Tool
4.3 Instructor Rating
72 Reviews
10,533 Students
38 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Microsoft Excel - Excel Course For Beginners
Learn The Excel Essentials - Drop Down Lists, Charts & Graphs, Pivot Tables, Sorting, Filtering, LO…
Free 100% Off
Today
Expires in 3 days
Learn Microsoft Office with ChatGPT Gemini and Copilot
Microsoft Word, Excel and PowerPoint skills enhanced with AI tools like ChatGPT, Gemini and Micoros…
Free 100% Off
Today
Expires in 3 days
MS Office With Canva Word Excel PowerPoint Canva All in One
All-in-One Microsoft Office and Canva Course – Learn to Use Word, Excel, PowerPoint, and Canva for …
Free 100% Off
Today
Expires in 3 days
Microsoft Office and Google Workspace Masterclass
Microsoft Word Excel PowerPoint and Google Docs Sheets Slides Ideal for Beginners Professionals Stu…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.