Your cart is empty.
Keep shopping
The Complete Excel Training: Basic to Advanced Skills
7 students
The Complete Excel Training: Basic to Advanced Skills
Become an Excel Pro from Scratch
Created bySarfaraz Mohammed
Last updated 5/2024
English
What you'll learn
- Master Excel Basics: Learn to navigate Excel, use basic functions, formulas, and formatting efficiently.
- Analyze & Visualize Data: Use VLOOKUP, PivotTables, charts, and graphs to analyze and present data.
- Advanced Excel Formulas: Master complex formulas like nested IF, INDEX & MATCH, and array formulas.
- Automate with Macros & VBA: Create macros and get started with VBA to automate repetitive Excel tasks.
- Manage & Secure Data: Handle large datasets, use data validation, and protect data with Excel's security features.
Explore related topics
Course content
18 sections • 57 lectures • 15h 30m total length
Requirements
- Basic Computer Skills: Familiarity with using a computer and basic software applications.
- Access to Microsoft Excel: A working version of Microsoft Excel installed on your computer (Excel 2013 or later recommended).
- Internet Connection: Stable internet connection for accessing course materials and resources.
- Willingness to Learn: Eagerness to learn and practice Excel skills from basic to advanced levels.
- No Prior Excel Experience Required: This course is designed for beginners, so no prior Excel knowledge is necessary.
Description
Become a Pro at Microsoft Excel with "The Complete Excel Training: Basic to Advanced Skills". Whether you are a complete novice or a seasoned pro, this one-stop shop course will take you from basic Excel functions to advanced data analysis and automation in Microsoft Excel.
Master Microsoft Excel, use simple formulas, plot graphs, and easily handle thousands of rows of data! Learn about advanced features such as PivotTables, macros, and VBA for increased productivity.
This course will equip you with Excel skills that can be used across industries, whether you are a student, job seeker, business professional, or entrepreneur.
Course Features:
15 hours 12 mins of on-demand video
18 sections with 57 videos
Downloadable practice files
Full lifetime access
Explained in English Language
Access on mobile and Computer
Course Modules:
Introduction – Importance of MS Excel and course details (About advanced level functions, special problem solver, interactive dashboards & Macro for automation).
Overview Of Excel Interface - Quick access toolbar, Ribbon, Name Box, Formula Bar, Cells, Sheet Tabs, Status Bar.
Basic formatting & Editing – Insert Row, Insert Column, Merge, Wrap Text, Alignment, Border, Bold, Italic, Underline, Cut, Copy, Paste, Percentage, Currency, Comma, Decimal, Font Style, Font Size, Fill Color, Undo, Redo, Text Orientation, Naming Cell Range, Ribbon customization.
Basic excel formula – ADD, SUBTRACT, MULTIPLY, DIVIDE, INDICES.
Type of cell references – Relative Reference, Absolute Reference & Mixed Reference.
Basic Excel functions – ROUND, INT, SUM, SUMIF, COUNT, COUNTA, COUNTIF, AVERAGE, AVERAGEIF, MIN & MAX, RANK, MATCH, INDEX, RAND & RANDBETWEEN
Types of Chart – Column, Bar, Pie, Line, Combo, etc.
Essential features of Excel – Paste Special, Freeze & Split Panes, Sort & Filter, Page Setup & Print Settings, Conditional Formatting, Data validation, Dependable dynamic Dropdown list.
Sheet & Workbook Protection – Lock Cells, Hide Formulas, Protect Sheet, Protect Workbook, Allow specific access, Allow specific users to edit ranges & Password protect the Excel file, Create Excel file backup.
Advanced Excel Functions – SUMIFS, COUNTIFS, AVERAGEIFS, DATE & TIME, IF, NESTED IF, IF WITH AND/OR, VLOOKUP, HLOOKUP, XLOOKUP, IFERROR, MATCH, INDEX, INDIRECT, VLOOKUP WITH MATCH, INDEX WITH MATCH, FUZZY LOOKUP, VLOOKUP WITH INDIRECT.
Miscellaneous Text Function – LEN, LEFT, RIGHT, MID, LOWER, UPPER, PROPER, VALUE, TRIM, CONCATENATE, FIND, SEARCH, SUBSTITUTE, REPLACE.
Formula Auditing in Excel – Show Formulas, Trace Dependents, Trace Precedents, Remove Arrows, and Evaluate Formula.
What if Analysis – Goal Seek & Solver.
Merge Data From Multiple Workbooks – Add Compare & Merge Workbook command, Share Workbook, Merge or Combine Data from Multiple Files to Single File.
Create Pivot Table & charts – Pivot, Chart, Formatting Chart, Types of Charts, Slicer, Timeline, and Use of shapes & SmartArt Graphics in Presentation.
Create Power Pivot Table – Create Pivot Table from multiple worksheets, Add to Data Model, Create Relationship & Manage.
Create Interactive Dashboard -1.
Create Interactive Dashboard -2.
Learn Macro with VBA code – Macro Basics: Preparation, record, create button, editing, debugging, Dynamic Selection, Use relative reference, Create Macro Data Entry Form & Protect coding of Macro.
Enroll now to become proficient in Excel and boost your career opportunities.
Who this course is for:
- Beginners: If you are new to Excel and looking to gain a solid foundation, this course starts with the basics and builds up to advanced skills.
- Professionals: Business analysts, data managers, accountants, and office professionals who want to enhance their Excel proficiency and streamline their workflows.
- Students: College and university students who need to use Excel for their coursework and projects will find this course invaluable.
- Job Seekers: Individuals looking to improve their resume and job prospects with a comprehensive knowledge of Excel, a highly sought-after skill in many industries.
- Entrepreneurs and Small Business Owners: Those who need to manage finances, analyze data, and make informed business decisions using Excel.
- Anyone Looking to Improve Productivity: Whether you use Excel daily or occasionally, mastering its features will save you time and improve your productivity.