Get 20% discount

Beginners to Intermediate on MS Excel

Introduction


The most widely used spreadsheet application in the world, Excel is a key part of the Microsoft Office suite of applications. You can use Excel for anything from a small spreadsheet of household finances to monster databases of all your company™s products, customers, and sales. You can use Excel either on its own or together with the other Office applications. This course will guide you to touch almost all the powerful tools of Excels.

How participants will benefit after the course:
It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program.

Methodology

This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

Contents of Training:


Lesson 1: SUMMARIZING DATA
1. Advanced Subtotals
2. Formatting the Subtotal Rows
3. Adding and Copying with Subtotals
4. Consolidating Data
5. Introducing the SUMIF Command
6. Working with the SUMIF Command
8. Looking at AutoSum Tricks
9. Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES
1. Creating a Pivot Table
2. Rearranging Fields in a Pivot Table
3. Explaining the Report Layout Options
4. Using the Report Filters Feature
5. Using Top 10 & Date Filters
6. Handling Blank Cells
7. Drilling Down in the Pivot Table
8. Sorting a Pivot Table
9. Formatting a Pivot Table
10. Creating Custom Formats
11. Explaining the Grouping Options
12. Adding Formulas to a Pivot Table
13. Changing a Calculation in a Pivot Table
14. Replicating a Pivot Table
15. Counting with a Pivot Table
16. Using Pivot Charts

Lesson 3: CHARTING IN EXCEL
1. Charts Refresher
2. Moving, Sizing & Copying Charts
3. Formatting Charts
4. Formatting a Series
5. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
7. Show a Time Series with Column or Line Charts
8. Using Combination Charts
9. Using Line Chart Accessories
10. Using Bar Charts to Show Comparisons
11. Using Component Charts
12. Using Correlation Charts
13. Exploring Other Charts
14. Chart Lies Revealed & Advanced Chart Types
15. Creating a Custom Layout

Lesson 4: GETTING VISUAL
1. Using Conditional Formatting
2. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
4. Using SmartArt Functions
5. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS
1. Using Goal Seek to Find an Answer
2. Auditing Formulas
3. Shrinking the Formula Bar
4. Understanding Errors
5. Joining Text Columns
6. Using Custom Formatting Codes
7. Pasting Values
8. Using Paste Special
9. Breaking Apart Text
10. Converting Text to Numbers
11. Using Date Functions
12. Using Bizarre Date Functions
13. Using Exponents
14. Using the VLOOKUP Function
15. Using Index Match
16. Using the Offset Function
17. Using the Convert Function
18. Looking at Interesting but Obscure Functions
19. Using the Rand Function
20. Working with Regression
21. Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS
1. Displaying the Developer Tab
2. Recording a Simple Macro
3. Simplifying the Macro
4. Recording Using Relative References

Final Touch and Tips and Tricks
1. Showing Off New Tips in Excel 2007
2. Tips for Handling Worksheets
3. Using Excel as a Word Processor
4. Miscellaneous Tips
5. Validating Data
6. Changing Text Entry Direction
8. Freeze Pane
9. Split Windows
10.Protecting Cells and Work Books
11. Password protecting a file
12. Showing list from a drop down
13. Random Tips for Preparing Dashboard

Related Courses

Price 18,000 Tk + VAT
Muhammad Rabiul
  • 30 May - 18 Jul 2017

IT
Abu Shams Mahmood Arif
  • Friday, June 2, 2017

Day to day HR and Admin data analysis, reporting, tools and ...

IT
Mostofa Monower
  • 2 - 3 Jun 2017 (2 Days Long)

This training program builds upon advanced level knowledge ...

IT
Md. Rabiul Islam
  • 2 Jun - 29 Jul 2017

There are many high-level languages. Python is one of ...

IT

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.