0(0)

Advance Excel

  • Categories Advance Excel
  • Duration 36h
  • Total Enrolled 0
  • Last Update July 31, 2021

What Will I Learn?

  • Part 1 Beginners Excel
  • Session 1
  • Chapter 1: Getting Familiar with the Excel Interface
  • Chapter 2 Handling Text with Formulas and Built in Tools
  • ession 2
  • Chapter 3 Sorting & Filtering
  • Chapter 4 Formulas Begins
  • Part 2 Intermediate Excel
  • Session 3
  • Chapter 5 Advance Formulas
  • Session 4
  • Part 8 Charting and SmartArt
  • Part 9 Visual Impact
  • Part 3 Advance Excel
  • Session 5
  • Part 6 Pivot Tables
  • Session 6
  • Part 10 Recording Macros
  • Part 11 Solver

About the instructor

5.00 (8 ratings)

21 Courses

43 students

৳ 299.00

Material Includes

  • # Ribbon, QAT, Mini Toolbar, Live Preview, Finding Icons
  • # Customizing the Ribbon
  • # Backstage View, Recent Documents
  • # Zoom Slider and Page Layout
  • # Drag the Fill Handle
  • # Create Your Own Series
  • # Joining Text
  • # Rapid Formula Copy
  • # Convert to Proper Case
  • # Formulas to Values
  • # Breaking Apart Text
  • # Parsing Fixed Width
  • # Navigate Fast through Range workbooks and Worksheets
  • # Removing Duplicates
  • # Number Format Shortcut
  • # Data Preparation
  • # One-Click Sorting
  • # Sorting by Color
  • # Sorting by Weekday
  • # Rearranging Columns
  • # Filter by Selection
  • # Other ways to Filter
  • # Remove Duplicates
  • # AutoSum Tricks
  • # Formula Auditing
  • # Three Ways of Entering Formulas
  • # Relative Versus Absolute Formulas
  • # Tables and Table Formulas
  • # Discovering Functions
  • # Goal Seek
  • # Shrink Text
  • # Transposing Tricks
  • # Hide Data
  • # Important Sheet
  • # IF Formulas
  • # Sumifs
  • # VLOOKUP
  • # Date and Time
  • # Data Validation
  • # Fill up in the sideways
  • # Switch Column Trick
  • # Fill Blank Trick
  • # Creating and Formatting a Chart
  • # Adding or Removing Chart Data
  • # Saving Favorite Chart Settings
  • # Charting Differing Orders of Magnitude
  • # Pie Chart Tricks
  • # Sparkline
  • # Creating SmartArt
  • # Smart Art Formulas
  • # Color Scales, Icon Sets, Data Bars
  • # Icons for Only a Subset
  • # Paired Bar Charts with Negative Data Bars
  • # Formula to Value
  • # F4 trick
  • # Format Part of Cell
  • # Copying Sheets
  • # Creating a Pivot Table
  • # Changing a Pivot Table
  • # Pivot Gotchas
  • # Pivot Formatting
  • # Drill Down
  • # Pivot Calculations
  • # Summarizing Dates
  • # Pivot Sorting
  • # Filtering Row Fields
  • # Top 10 Report
  • # Filtering a Pivot Table with Slicers
  • # Slicers on Two Pivot Tables
  • # 50 Reports in 5 Seconds
  • # Insert Blank Rows
  • # Text Box Trick
  • # Pick from List
  • # Working In Group Mode
  • # Displaying the Developer Tab
  • # Recording a Simple Macro
  • # Simplifying the Macro
  • # Keys to Successful Recording
  • # Understand Solver
  • # Using Solver to Solve your Business Problem
  • # Print Small Selection
  • # Fit to One Page Trick
  • # Speak Cells
  • # Excel as word processor

Requirements

  • Our aim is to improve outsourcing training in Dhaka. We will not only make you realize that yes, freelancing can be a career option, but will also help you to learn the basics of it. Everything like creating freelancer profile, techniques of bidding online, handling project professionally and technically and many more things will be covered by us.

Target Audience

  • All Levels