ADVANCED MICROSOFT EXCEL TRAINING COURSE

TechTrain Academy

New Member
Apr 4, 2017
2
1
clip_image002.png

4 - Days Training Course in Advanced Microsoft Excel: Dar es Salaam
TRAINING COURSE IN BIG DATA ANALYTICS USING EXCEL

TRAINING OVERVIEW
In this Big Data Analytics with Excel training course, you will learn how to manage and analyze multi-millions records of data with Excel.

You will start by learning advanced formatting techniques including data validation and conditional formatting. Then data cleansing, including removing duplicate records, replacing text, and merging and splitting data columns. From there, you will be taught about Excel tables, pivot tables, charts, and pivot charts. The trainer will then cover Excel built in Power Business Intelligence (Power BI) solutions including Power Query, Power Pivot, Power View and Power Map. Finally, you will learn how to automate some repetitive tasks by recording macros.

After completing this training course, you will have learned everything you need to know to effectively manage and analyze large quantities of data with Excel. Exercise files will be provided during training allowing you to follow along with the trainer throughout the lessons.

COURSE OUTLINE

Day 1: Advanced Data Cleaning and Formatting Techniques
(In this day, you'll learn how to perform advanced formatting using Excel)

o Data validation in excel - Preventing unwanted data and ensuring data quality

o Creating drop down lists

o Creating dependent/multi-tiered drop down list

o Built-in conditional formatting

o Conditional formatting using logical formulas

o Data cleansing skills - Removing duplicates, splitting columns etc.

Day 2: Advanced Formulas and Functions
(In this day, you'll learn how to utilize some of advanced functions available in Excel. This is a skeleton outline. More functions not listed here will be taught)

o Day 1 recap

o Logical functions - IF, OR, AND, IFERROR, SWITCH etc.

o Text functions - LEN, LEFT, RIGHT, UPPER, LOWER, TRIM, CLEAN, CONCATENATE, PROPER, MID, FIND/SEARCH, REPLACE/SUBSTITUTE, REPT, TEXT etc.

o Mathematical & statistical functions - COUNT, COUNTIF(S), AVERAGE, AVERAGEIF(S), SUM, SUMIF(S), MAX, MIN, LARGE, SMALL, MEAN, MEDIAN, MODE etc.

o Lookup functions - INDEX, MATCH, HLOOKUP, VLOOKUP, CHOOSE, OFFSET etc.

Day 3: Excel Built-in Power Business Intelligence Solutions
(In this day, you'll learn how to utilize advanced business intelligence tools that have been added in Excel starting version 2010 namely Power Query, Power Pivot, Power View and Power Map for analysis of BIG DATA)

o Day 2 recap

o Import data into Excel from almost any source using Power Query. You'll learn how to Import data from all modern Relational Database Management Systems such as MS Access, SQL Server, MySQL, Oracle, PostgreSQL and many other sources

o Import data from online sources such as World bank, Wikipedia, Facebook directly into Excel

o Import and analyze data from multiple sources such as multiple Excel workbooks using Power Query

o This is a fantastic time saver that eliminates a burden of copy and paste from multiple workbooks into a single workbook
Import multi-millions of data (more than 1048576 a normal excel can handle) and create data models using Power Pivot. Power Pivot can handle even 100M records/rows of data without a problem

o Create Pivot Tables and Pivot Charts using huge data imported into Power Pivot

Day 4: Creating Dynamic Dashboards for Visualization and Reporting
(In this final day, you'll learn how to connect skills covered since day 1 to create a dynamic reporting dashboard for your company or organization. We will also cover the basics of macro recording for automating repetitive tasks and introduce you to Power BI Desktop, a free, data visualization and tool from Microsoft)

o Day 3 recap

o Create Dynamic Dashboards using Excel - You'll learn how to create dynamic dashboard using a combination of Pivot tables and Charts connected to slicers and timelines

o Power View and Power Map - You'll learn how to improve your dashboard by adding powerful charts such as Drill-down charts and maps using recently added advanced tools, Power View and Power Map
Recording, saving, editing and running macros to automate boring recurring tasks

o Introduction to Power BI Desktop

o Course wrap-up, and presenting certificate of attendance to participants

COURSE FEE:
o TZS 350,000 covering training, lunch and two tea breaks

VENUE:
o TBD

TRAINING DATES:
o 2nd May 2017 - 5th May 2017 (4 Days)

PAYMENT METHOD:
Pay for this course through NMB Bank Account details below and send your payment alert by email through: info@techtraintz.com

o Account Name: TECHTRAIN ACADEMY

o Account Number: 22410019565

o Branch: NMB Mbagala

Call +255 629 610 039 for more information
 

Attachments

  • TRAINING COURSE IN ADVANCED MICROSOFT EXCEL.docx
    221.3 KB · Views: 117
  • Thanks
Reactions: DBA
1 Reactions
Reply
Back
Top Bottom