Learn Basic Excel with all essential features & protection!
Upgrade your Microsoft Excel skills and expertise to the next level with this course. Gain proficiency in all-important basic excel formulas & functions, type of charts, conditional formatting, data validation, workbook protection with lots of practical examples used across different industries. This course will empower not just students but teachers as well as employees/entrepreneurs.
Course Features:
-
5 hrs 45 min on-demand video
-
21 videos
-
Downloadable practice files
-
Full lifetime access
-
Explained in Hindi Language
-
Access on mobile and Computer
Course Modules:
-
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.
