basic and advanced excel knowledge will be covered in this course, iam a working profession with 9 years of experiance in microsoft excel. iam here to share the excel skill by teaching people who are interested to learn excel in online with real time working profession experts.
course duration would be 1 month, daily 1 hour of session , and we wil be providing the practice tests even for good hands on.
topics will be covered as below, basics, conditional formatting, pivot charts, pivot graphs, alignments, data analysis, data visualization, removing duplicates, formulas like AND, IF OR, VLOOKUP, HLOOPKUP, CONCAT, ROUND, OFFSET, INDEX, MATCH, IF , IFERROR, SUM, COUNT, COUNTA, COUNT BLANK, COUNTIFS, SUMIF, SUMIFS, NESTED IF, COLOUR FORMATTINGS, WRAP TEXT, FORMAT PAINTERS, INSTERING SHAPES, INSERTING SHAPES, FORMATTING SHAPES, FORMATTING GRAPHS, PREPEARING DASHBOARDS, PREPARING BASIC CALCULATION , PREPARING SIMPLE TEMPLATES, BASIC SHORTCUT KEYS USING KEY BOARD, SHORTCUTS LIKE USING CTRL COMBINATION, SHIFT COMBINATION, CNTL AND SHIFT COMBINATION ETC.