Perguntas frequentes

Basic Excel Crash Course


- Introduction to Excel Interface - Font Formatting & Alignment Tools - Number Formatting Options - Navigation Shortcuts - Lists in Excel & Creating Custom Lists - Sorting & Filtering - Conditional Formatting - Format Painter - Alt Key Custom Shortcut Creation - Table's & Importance of Tables




Dashboards with Power BI


- Creating a Coronavirus Dashboard for India from Scratch - Creating a Bank Dashboard from Scratch - Understanding visual interactivity - Understanding different filters available in Power BI - Analysing Dashboards to get key insights from your data




Pivot Tables


- Understanding the importance of PT - Inserting a Pivot Table - Understanding Field List Contents - Using Pivot Tables to Analyse Data - Formatting in Pivot Tables - Grouping of Data - Slicers - Timelines - Interactivity of Slicers




Data Visualization - Charts


- Selecting the correct chart for your data - Bar & Column Charts - Line Chart - Pie & Donut Chart - Scatter Plots - Histogram & Pareto Charts - Waterfall Chart - Heat Maps & Sparklines - Dynamic Dropdown Charts (Advanced) - Dynamic Spin Button Charts (Advanced)




Basic to Advanced Formulas


- Understanding when to use what formula - Mathematical Formulas (5 Formulas) - Logical Operators (7 Formulas) - Statistical Formulas (12 Formulas) - Conditional Formulas (6 Formulas) - Look Up Formulas (HLookUp & VLookUp) - Index Match - Financial Formulas (4 Formulas) - Types of common errors and their solutions





CONHEÇA A ADAMAS
VOCÊ PODE PAGAR COM
NOVIDADES ADAMAS
  • Black Facebook Icon
  • Black Pinterest Icon
  • Black Instagram Icon
ATENDIMENTO AO CLIENTE
ENTRE EM CONTATO