Total Pageviews

Tuesday, 11 June 2013

Skills and Expertise: Excel 2010, Office 2010, Adobe Acrobat Pro

My skills for Excel 2010 includes:
  1. Copy & Paste Special
  2. Format
    • Basic Formatting
      • Decimal, Currency
      • Date
        • Date addition & subtraction
        • Workdays & Holidays
      • Percentage
    • Conditional Formatting
  3. Formulas and Relative Cell References
  4. Formulas and Absolute Cell References
  5. Sorting
    • Sorting by cell values
    • Sorting by cell colour 
  6. Filtering
  7. Pivot Tables
    • Slicer
  8. Charts  
    1. From Pivot Table
    2. No Pivot Table
    3. Line charts - 1 Number column
    4. Line charts - 2 Number column
    5. X-Y Scatter charts
  9. Populating data
  10. Removing duplicate values
  11. Basic Math
  12. Concatenating
  13. Styling
  14. Split data into multiple columns
    • Split the cells according to width
    • Split the cells by delimiter 
  15. Conditional Page break
  16. Extract email address from 
    • Email ready CSV file
    • Import CSV file into gmail account
  17. Miscellaneous
    • Wrap Text
    • Searching special character like ? sign
    • Removing front and trailing spaces, non printing BEL & DEL character, non breaking space character
      • Copy the trimmed cell text and paste as values as Paste Special-->Paste Values
    • Set the column width fixes the text scattered problem
    • Remove first few characters 
    • Delete empty rows
  18. Create custom list in Excel
  19. Create ODBC connection in Excel
  20. Create Drop Down List
  21. Building a basic PowerPivot 



My skills for Office 2010 includes:
  1. Mail Merge
    • Choose letter
    • Select new list
      • Type a new list 
      • Type name, address and other details
      • Customize the address
      • Save the new list
    • Add the address block, greetings, continue writing letter, add more items
    • Preview the letter
    • Complete the merge
    • Edit the individual letters
    • Creating Mailing Labels using Mail Merge
    • Printing Envelops using Mail Merge
    • Mail Megering with Microsoft Excel and Word
  2. Protect document
    • Restrict editing
    • Mark as Final
    • Read only document
  3. Creating electronic form 
    • Use of tables as a space holder.
      • Underline the cell where you will insert text boxes
    • Use of developer tools - Rich text, Plain Text, check box, drop down list, picture, date time picker, text box
    • Set the control properties
      • Locking the control so that user cannot delete or edit the control
    • Restrict editing - Remember to choose form filling
    • Save the form as Word Template
  4. Charts
  5. Tracking changes
  6. Comment
  7. Building blocks
  8. Text boxes
  9. Equation
  10. Macro
    • Open a new document:
      • Create macros, assign a keyboard shortcut
      • Do all the formatting you want and stop the macros
      • Come back to the document you want to apply the macro. Select the text and press the keyboard shortcut.
      • If you want to keep any word or anything customized do that before recording macro
  11. Over typing
  12. Book Design
    • Formatting Documents for CreateSpace:
      • Insert Track Changes
      • Use Navigation pane
        • Use Header style that will map you to paragraph
      • Page Setup: Page number for Odd and Even pages
          • Margin Tab:
            • Margins Top = 1", Bottom = 1", Inside = 1" Outside = 1"
            • Gutter =.5", Gutter position = Left
            • Mutiple pages = Mirror margins
          • Layout Tab:
            • Header and Footer = Different odd and even
          • Format the page number
          • Click on the first page header insert page number on the right. Click on the second page header and insert page number on the left. 
          • In order to insert new series of page number you need to insert section break next page and in the header - turn off Link to previous.
        • Fonts That Work in Books
          Okay, so now you know how to recognize oldstyle fonts, how is that going to help you? Let’s take a look at some of my favorite fonts for interior book design, and you’ll see.
          • Garamond–There are many versions of typefaces known as Garamond, and this is one of the most popular families of fonts for use in books. A classic oldstyle font, Garamond is named for Claude Garamond, a publisher in 16thcentury France, and has given rise to many other similar typefaces like the also useful Sabon.
          • Caslon–This font originated with William Cason, one of England’s first printers and has been popular ever since. Caslon is one of the most widely-used typefaces for text and works very well in books.
          • Minion–A modern invention, Minion was designed by Robert Slimbach for Adobe Systems and has gone on to become one of the favorite fonts for book designers due to its regular color, interesting letterforms and the variety of weights and styles available.
          • Janson Text–Another Adobe font, Janson is based on a typeface created in the Netherlands in the 17th century, and our recent version was created by famed type designer Hermann Zapf in the 1950s.
          • Palatino–For a long time Palatino was the most popular oldstyle font of all, because it was included in the base set of fonts shipped with every new Macintosh, the original desktop publishing platform. Although it’s a beautiful font with some idiosyncrasies that designer Hermann Zapf included, I no longer use Palatino for books, exactly because it has been so over-exposed. But you might love it, so give it a try.
        • Create & save style format for:
          • Chapter Number Text
          • Text that will be starting text of any section
          • Body text
          • Book name text
          • Author Text
          • Contents Text
          • Create a format for later attention with a sign and save it as one of the header style so that you can easily recognize or navigate through
        • Paragraph:
          • Use widow/orphan control
          • Space after or before paragraph
          • Line spacing
        • Insert images for cover page
        • Paging
          • Use section break for cover page, contents and last few pages so that their paging numbers are different from rest of the book
          • For right page that will be on the right hand side - Use Page Number on the right hand side because then Page Number will be outside of the book and easily visible. Use Page Number on the left hand side for the pages that will be on the left side of the book.
          • Use section break - Next page
            • Remove link to previous
            • Format the page breaks and use start at:
            • Write the text for page header and footer
            • Insert page number
        • Use reveal formatting option
          • To check extra line break or a space has been put by mistake
        • Insert Table of Contents 
        • Creating Index
        • Insert Caption, Citation, Book Mark, EndNote FootNote
    • Flyer Design
      • Smart Art, Shapes, Picture, Screenshot
    • Creating Signature
      • Creating signature signed by yourself 
      • Creating signature digitally signed
    • Adding new menus and customized option
    • Group Shape and Text Box
    • Print outside page margin
    • Create Master and Subdocuments
    • Word to eBook conversion using Calibre (free software)
    • Co-authoring in Word 2010
    • Reduce File Size


    My skills for Adobe Acrobat X Pro includes:

    1. Creating signature
    2. Creating fillable form and user should be able to save the form
    3. Reading and writing Excel Data with PDF form
    4. Convert Multiple images into PDF file in order
    5. Distribute document via Email
    6. Submit document via Email Button
    7. Button - Print button, Submit button, visible but printing button option
    8. Calculate in Table cell 
    9. Email address validation
    10. Apply formatting into multiple fields
    11. Tab order of the Fields
    12. Remove password for pdf file 
    13. Embed Fonts into PDF 
      • Before converting to PDF from Word file
      • After converting to PDF
    My skills for Adobe Livecycle Designer includes:

    1. Create Dynamic Autopopulated DropDownList - Get Data From Excel File
    2. Auto Populate Text Fields based on DropDownList selection - Get Data From Excel File
    3. Calculated Fields
    4. Date/Time Field - Set default to Current Date



    Profile:
    I am expert in making form along with Java Script. I can make nice and distinctive fillable/writable/editable  PDF form for Mac, iPad, iPhone, Android.
    ________________________________________________________________

    Creating e-Book, epub, pdf design with Adobe InDesign
    ________________________________________________________________

    My Strength on fillable form:
    1. To submit data to website, online Database, send automatic mail with unique id.

    2. To create data populating from one page to another page with conditional script as well as from one file to another file.

    3. Populating data from MS Access database, MS Excel, SQL Server Database, online database.

    4. To create Multilingual form Just in One File.

    5. To make Visible and Invisible action which depends on value of DropDown, Check Box.....

    6. To make fillable form from MS word, Excel....

    7. To render savable with free reader.

    8. To control function with Adobe Acrobat and LiveCycle Java Script, Calculation.

    9. To secure file and break password (you must have copy right or permission).

    10. To set digital signature and validate.

    11. To design form.

    12. To Import data as XML, FDF, XFDF, XDP 

    .............................. 

    I confidently ensure you that my work is dapper & attractive and you will be fully satisfied.

    So you can hire me without any hesitation.
    ===============================
    With PDF Fillable forms I can do:-

    (a) To design form from Adobe LiveCycle, Acrobat X & XI
    (b) Auto calculation in forms.
    (c) Auto population of data from one page to other pages of form.
    (d) To make Visible and Invisible action which depends on value of DropDown, Check Box, etc...
    (e) Creating Fillable forms from other applications like MS Word/ Excel, scanned images, simple pdf.
    (f) To render savable with free reader.
    (g) To control function with Adobe Acrobat and LiveCycle Java Script, Calculation.
    (h) To secure file and break password (you must have copy right or permission).
    ============================================================================

    With PDF Editing I can do:-

    (a) Any content editing like Logo change, Text edit, Photo edit, Page resizing, Cropping, Page marge, Page Splits, Combine etc...
    (b) Data conversion from PDF/scanned pages to Word/MS Excel.
    ============================================================================

    With Graphics Design I can do:-
    (using Adobe Illustrator, Adobe InDesign, Adobe Photoshop)

    (a) Brochure Design, Business Magnet, Poster, Flyer etc...
    (b) Vector, Outline
    (c) Page Design
    ============================================================================

    With Word Processing I can do:-

    (a) 100% accurate word processing
    (b) 100% same design from Adobe InDesign, Adobe Illustrator and Adobe Photoshop
    (c) Any Shape and Art Designing
    (d) Fast Typing
    (e) Mail Merge (Labels, Letters)
    (f) Formatting of MS Word/Excel documents
    (g) Excel Data manipulation
    ============================================================================
    Profile:
    I confidently ensure you that my work is dapper & attractive and you will be fully satisfied.

    So you can hire me without any hesitation.
    I am one of the best ebook writers, editors, designers, and developers from Bangladesh. I can write both in conventional and unconventional way. I can design good cover page and layout and can convert ebooks in 15 popular formats (PDF, EPUB, MOBI, FB2, LIT, LRF, PDB, PMLZ, RB, ZIP, RTF, SNB, TCR, TXT, TXTZ).

    These ebook formats support most popular platforms including Amazon Kindle, Kobo eReader, Sony Reader, Google Nexus, Barnes & Noble Nook, Apple iPad & iOS Devices, Azbooka WISEreader, Pocketbook 301 Plus, 302, 360°, Bookeen Cybook Gen3, Opus, Foxit eSlick, Hanlin e-Reader V3, Hanvon WISEreader, iRex iLiad, Iriver Story, and other ereader devices.


    EBOOK SPECIALIST
    --------------------------------
    - Print Design, Book Cover Design, Book Layout Design, Desktop Publishing
    - Ebooks for Online Sales/Online Publishing/Printing
    - Ebook publishing, branding, and marketing
    - High quality ebooks (Compatible for PC, Kindle, Nook, Sony Reader, etc.)
    - PDF Interactive Form Designing
    - PDF/Ebook to MS Word, MS Excel Conversion and PDF/Ebook to Image Conversion
    - PDF/Ebook Editing
    - Ebook Conversion (15 Formats)
    - The best quality ebook with the smallest file size

    GUARANTEED
    - Maximum popular ebook formats offered (15 formats).
    - Compatible with most of the ebook readers (Includes all industry giants).
    - Metadata (Copyright, ISBN, Author & Publisher Info) editing for ebook
    - Maximum sales as metadata is editing in a search engine friendly way
    - Excellent security features (Protection, setting user control policy) for ebook etc.


    CREATIVE WRITING & ACADEMIC WRITER
    -----------------------------------------------------------------
    - Specialized in report writing
    - Customized Cover Design for Reports
    - Use of referencing (Harvard Method/APA Method)
    - Footnotes & Endnotes
    - Professional look report processing


    GLIMPSE
    --------------
    - I am available through E-mail/ Phone/ Skype/ Facebook/ GTalk
    - I like to offer my work samples through Dropbox
    - I have High level of Analytical & Quantitative Analysis Skill, Excellent Communication Skill
    - I am Pro-Active, Self-Motivating, and Extrovert

    No comments:

    Post a Comment