1 / 9

Certometer Excel Course

Join now one of the top online excel course

cerometer
Download Presentation

Certometer Excel Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Excel Basic to Advanced

  2. CONTENTS: • Definition • Basics • More Functions • Advance Charts • Basics of VBA (Macro) • Other Resources

  3. What is Excel ? Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

  4. Step 0: Basics Here, we are suggesting to go through the excel tutorial on many online education platforms like CertoMeter. This tutorial has both video and text based content and it is designed for beginners only. This tutorial has following content: • Basics of Excel (Open, Save, New, Cell Basic, Formatting, Layouts) • Formula & Functions • Working with Data (Sort, Filter, Data Validation, Group/ Sub-total, Table) • Charts & Sparklines • Conditional Formatting, What-if Analysis

  5. Step 1: More Functions Excel has various functions to perform different operations like Financial, Text, Date & Time, Mathematical, Statistical, LookUp & Reference & More advanced functions. Excel Easy has explained these functions with examples and in a very simple manner. • Text • Lookup & Reference (Dynamic Range Definition) • Financial • Statistical • Count & Sum Functions • Logical • Arrays Formula

  6. Step 2: Advance Charts Apart from these basic excel charts (Bar, Column, Line, Pie ..), we can plot more advanced charts also by playing with different chart metrics. Below is the list of advance excel charts with resources: • Waterfall Chart (Resource) • Box-plot (Resource) • Thermometer Chart (Resource) • Gauge Chart (Resource) Additionally, you can also refer article written by Chandoo, “Select right chart for data representation“.

  7. Step 3: Basics of VBA (Macro) Here, I suggest you to have a basic understanding about VBA. It will help you to perform various tasks, those can not be performed directly by excel inbuilt functions. Excel-Pratique has designed a free Excel-VBA course for the beginners.

  8. Step 4: Other Resources Along with above-discussed resources, you can also follow below resources (Blogs/ Discussions) to get updated with industry experts: • Blogs • Mr. Excel • Excelguru • Forum/ Discussion • Chandoo Excel Forum • Excel Forum • AV Discussion

More Related