General Details

Duration: 8 hours / 2 days

Day 1:
Saturday, 11th May 2019, 3:00pm to 7:00 pm

Day 2:
Sunday, 12th May 2019, 1:00 pm to 5:00 pm

Fee: ?1000/-

Course Curriculum

Creating Presentable & Easy to Manage Spreadsheets

• Managing data-sets
• Formatting worksheets
• Using format painter
• Using Format painter for a range of data
• Data formats
• Paste functions
• Printing excel sheets the right way

Using the Sort Feature

• Standard sorting
• Custom sorting

Using filters

• Filtering the entire spreadsheet
• Filter data from a specific cell range
• Using multilevel filters

Data Cleaning

• LEFT(), RIGHT(), MID(), LEN()
• TRIM(), SUBSTITUTE(), CONCATENATE()
• COUNTBLANK()
• UPPERCASE(), LOWERCASE(), PROPER(), TRIM()
• Data Validation(List)
• Removing duplicate values
• Insert a blank row after each row for 1000?s of rows

Working with numbers

• Basic arithmetic formulae (add, subtract, multiply, divide)
• Percentage calculation by formulae
• Relative and Absolute cell referencing
• Using ROUND(), ROUNDUP(), ROUNDDOWN()

Calculations

• SUM(), COUNT() & AVERAGE()
• SUMIF(), COUNTIF & AVERAGEIF()
• Working with multiple ranges
• Tracing dependents and precedents

Logical Functions

• IF() & nested IF?s
• Using AND() & OR() to reduce the no. of IFs
• Conditional formatting
• Conditional data highlighting

Date & Time functions

• DATE()
• NOW()
• NETWORKDAYS()
• Deadline highlights

Charts (Pie, Bar, Column, Line)

• Building charts (Pie, Bar, Column, Line)
• Converting charts form one format to another
• Changing the position of data within the chart & styling it

Reporting

• Linking multiple worksheets & workbooks
• Analyzing reports using 1?s and 0?s

Macros ? Application

• Enabling the developer Tab
• Enabling macros
• Recording a macros
• Running a macros
• Creating Automation using macros

Using google sheets

• Working with google sheets
• Sharing sheets with restrictive access
• Multi-currency management
• Auto update currency

Attendees Please Note:

• Attendees are expected to carry their own laptops
• Attendees are excepted to have Microsoft Excel 10 and above installed in their laptops

Venue

Infotech Academy, #613, 6th Floor, Pearl Plaza, Andheri Station (W), Mumbai 400058.
Landmark: Next To McDonald’s

Certification

A workshop completion certificate will be provided to you at the end of the workshop.

Frequently Asked Questions

I am using MacOS, can I also attend this workshop?
Yes you can, however you must install Microsoft excel for Mac on your laptop. Incase you don’t have Ms Excel installed on your MAC you can download it from the official Microsoft website and activate a one month free trail. Incase you face difficulties installing the same, just reach half an hour prior to the workshop time on Day 1 and our team will help you with the same.