free microsoft excel certification training

#Free microsoft excel certification training how to#
#Free microsoft excel certification training pro#
#Free microsoft excel certification training professional#

Number, Date & Time Validation, Text, and List Validation, Custom Validations Based on Formula for a Cell, Dynamic Dropdown List Creation using Data Validation – Dependency List

#Free microsoft excel certification training how to#

IF Function, How to fix errors – IFERROR, Nested IF, Complex IF, AND, OR functions Scenario Analysis, Data Tables (PMT Function), Solver Tool Setting up Print Area, Customizing Headers & Footers, Designing the Structure of a Template, Print Titles –Repeat Rows/Columns Sparklines -Line, Column & Win/ Loss, Using 3D Map, New Controls in Pivot Table – Field, Items and Sets, Various Time Lines in Pivot Table, Autocomplete a Data Range and List, Quick Analysis Tool, Smart Lookup and Manage Storeįilter on Text, Numbers & Colors, Sorting Options, and Advanced Filters on 15-20 different criteria(s) New Charts – Tree Map & Waterfall, Sunburst, Box and Whisker Charts, Combo Charts – Secondary Axis, Adding Slicers Tool in Pivot & Tables, Using Power Map and Power View, Forecast Sheet

Paste Formulas, Paste Formats, Paste Validations, Transpose Tables Today, Now, Day, Month, Year, Date, Date IF, DateAdd, Month, Weekday Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate, Find, Substitute SUMIF, COUNTIF, AVERAGEIF, Nested IF, IFERROR Statement, AND, OR, NOTįile Level Protection, Workbook, Worksheet Protection Using Functions – Sum, Average, Max, Min Count, CountA, Absolute, Mixed, and Relative ReferencingĬurrency Format, Format Painter, Formatting Dates, Custom and Special Formats, Formatting Cells with Number Formats, Font Formats, Alignment, Borders, Basic Conditional Formatting Following are the available free Excel courses with certificates on the Simplilearn e-learning platform.Ĭustomizing the Ribbon, Using and Customizing Autocorrect, Changing Excel’s Default Options

#Free microsoft excel certification training professional#

These free Excel certification courses can be used to showcase professional knowledge and expertise in MS Excel, Excel basics, or advanced Excel. SkillUp by Simplilearn offers skill enhancement courses on various topics like Excel for free. They can be completed within 1 month, 3 months, or 6 months and the cost also varies according to the study pace.įree Excel Certification Course by Simplilearn

All of the Excel courses on Coursera are self-paced. Coursera Excel courses are created by industry experts. Zero to Hero in Microsoft Excel: Complete Excel Guide 2023Įxcel Essentials for the Real World (Complete Excel Course)Įxcel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!Ĭoursera is known for its’ course quality and instructor recognition. Microsoft Excel: From Beginner to Expert in 6 Hours Microsoft Excel: Data Visualization, Excel Charts, and GraphsĮxcel Essentials: The Complete Excel Series - Levels 1,2 & 3 Microsoft Excel: Data Analysis with Excel Pivot Tables

#Free microsoft excel certification training pro#

Microsoft Excel: Excel from Beginner to Advancedīeginner to Pro in Excel: Financial Modeling and Valuation