How to format cells in excel 2010Pekerjaan

Filter

Pencarian saya terakhir
Filter menurut:
Anggaran
hingga
hingga
hingga
Jenis
Keahlian
Bahasa
    Pernyataan Pekerjaan
    2,000 how to format cells in excel 2010 pekerjaan ditemukan, seharga USD

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point 4. colum analisa dll

    $17 (Avg Bid)
    $17 Rata-rata
    11 penawaran

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point 4. colum analisa dll

    $16 (Avg Bid)
    $16 Rata-rata
    25 penawaran

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point 4. colum analisa dll

    $16 (Avg Bid)
    $16 Rata-rata
    19 penawaran

    Kami adalah sebuah online shop yang masih dalam tahap berkembang, dengan alamat www.myuniqstore.com. Selain pada website, kami juga menggelar lapak di Kaskus dengan id: uniqstore. Halaman pada website dan kaskus sudah lama tidak dibenahi, oleh karena itu saya memposting pekerjaan disini. Sco...Pembenahan lapak di kaskus (mulai dari entry data, buka lapak baru, dll) 2. Entry dan Edit data di Website (harga ongkir, fitur COD, entry data untuk item baru, design banner promo) 3. Email marketing dan listing email dari customer Uniqstore Skill dan syarat yang dibutuhkan tidak perlu mendalam, hanya mengerti soal: 1. Kaskus FJB 2. Photoshop 3. Sistem Website online shop (Opencart) 4. Excel 5. Email 6. Dropbox (untuk share data dan foto produk) 7. SMS marketing (masih perlu di...

    $66 (Avg Bid)
    $66 Rata-rata
    12 penawaran

    Kami adalah sebuah online shop yang masih dalam tahap berkembang, dengan alamat www.myuniqstore.com. Selain pada website, kami juga menggelar lapak di Kaskus dengan id: uniqstore. Halaman pada website dan kaskus sudah lama tidak dibenahi, oleh karena itu saya memposting pekerjaan disini. Sco...Pembenahan lapak di kaskus (mulai dari entry data, buka lapak baru, dll) 2. Entry dan Edit data di Website (harga ongkir, fitur COD, entry data untuk item baru, design banner promo) 3. Email marketing dan listing email dari customer Uniqstore Skill dan syarat yang dibutuhkan tidak perlu mendalam, hanya mengerti soal: 1. Kaskus FJB 2. Photoshop 3. Sistem Website online shop (Opencart) 4. Excel 5. Email 6. Dropbox (untuk share data dan foto produk) 7. SMS marketing (masih perlu di...

    $86 (Avg Bid)
    $86 Rata-rata
    5 penawaran

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point dll

    $9 (Avg Bid)
    $9 Rata-rata
    1 penawaran

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point dll

    $16 (Avg Bid)
    $16 Rata-rata
    38 penawaran

    Pengerjaan proyek cepat, akurat dan terjamin dengan rincian sbb : 1. input data 2. pengolahan data microsoft excel 3. desain power point dll

    $17 (Avg Bid)
    $17 Rata-rata
    4 penawaran

    Project ini akan mengambil informasi dari halaman website. Berguna bagi para pengumpul informasi yang mengandalkan informasi dari website lain sebagai menu utama maupun tambahan dalam websitenya. Tidak perlu membuka halaman website maupun copy paste lagi untuk mengambil informasi dari website lain, hanya definisikan url dari web tersebut yang akan di-grab halamannya. Secara...mengandalkan informasi dari website lain sebagai menu utama maupun tambahan dalam websitenya. Tidak perlu membuka halaman website maupun copy paste lagi untuk mengambil informasi dari website lain, hanya definisikan url dari web tersebut yang akan di-grab halamannya. Secara otomatis informasi keseluruhan dari web tersebut akan ter-capture, dan hasilnya akan dikirimkan melalui email dalam bentuk file (excel...

    $773 (Avg Bid)
    $773 Rata-rata
    1 penawaran

    bisa mengerjakan microsoft office

    $6 - $6
    $6 - $6
    0 penawaran

    saya ahli dalam pemasukan entri data,excel dan pengetikan salinan

    $156 (Avg Bid)
    $156 Rata-rata
    1 penawaran

    Saya perlu bantuan vba excel expert untuk salah satu proyek yang saya kerjakan. Proyek ini tentang menggabungkan dua Worksheets (Perusahaan dan Kontak) menjadi satu Report. Kunci pencocokan adalah nama Perusahaan Dalam satu nama company bisa ada 1 atau lebih nama kontak. Beberapa nama kontak yg terkorespondensi dalam 1 nama perusahaan perlu dipisahkan dengan line break. Jadi semuanya dalam 1 cell saja. Nama University dan tahu lulusan, alamat email, dan catatan juga perlu digabungkan per line. Tetap dalam 1 cell pada row yang matched. Begitupun no telp perusahaan digabungkan dengan no hp dari tab kontak (jika ada). Report harus dalam Format yang kami tentukan (warna, border, page break, orientation, dll) Proyek ini relative mudah, bagi yang expert mungkin hany...

    $92 (Avg Bid)
    $92 Rata-rata
    7 penawaran

    Memasukkan semua data baik excel, word maupun power point. Berpengalaman dalam entry data baik untuk data perusahaan maupun data pribadi.

    $324 (Avg Bid)
    $324 Rata-rata
    4 penawaran
    data entry Berakhir left

    input data di excel, word, power point dan lain lain dengan program office, .........................................................................................................................................................

    $141 (Avg Bid)
    $141 Rata-rata
    110 penawaran

    Memasukan dan memproses data ke format Excel. Mnegcopy dan mempaste data dalam format Exel. Pengolahan data dalam format Exel.

    $130 (Avg Bid)
    $130 Rata-rata
    2 penawaran

    Memasukan dan memproses data ke format Excel. Mengcopy dan mepaste data dalam format Exel. Pengolahan data dalam format Exel.

    $454 (Avg Bid)
    $454 Rata-rata
    183 penawaran

    Memasukan dan memproses data ke format Excel. Mnegcopy dan mempaste data dalam format Exel. Pengolahan data dalam format Exel.

    $427 (Avg Bid)
    $427 Rata-rata
    71 penawaran

    Memasukan dan memproses data ke format Excel. Mnegcopy dan mempaste data dalam format Exel. Pengolahan data dalam format Exel.

    $69 (Avg Bid)
    $69 Rata-rata
    40 penawaran
    Master Data Berakhir left

    Memasukkan semua data baik excel, word maupun power point. Berpengalaman dalam entry data baik untuk data perusahaan maupun data pribadi.

    $308 (Avg Bid)
    $308 Rata-rata
    32 penawaran

    ...have a CSV file with my Apple Music play history and I'm seeking a Python programmer to help reduce the redundancy within it. Specifically, I need: - Condensation of textual data: Whittle away superfluous data to Playlist ID, artist, play count (this is optional), and album (also optional). +not every song has a unique playlist ID in the same column, there are several different ways a unique playlist ID could populate, some data points will use more than one column's ID, some only have a unique ID in one column. Unfortunately each column has a different format for each ID. - Criteria for duplicates: Only one row of data for each song. I define "duplicates" based on both the artist and the song title. To avoid two songs...

    $133 (Avg Bid)
    $133 Rata-rata
    78 penawaran

    Hi Aisha, Thanks for your swift response. There are another 41 new companies to enter - the usual work at £2.75 per company = £112.75. I will send the Excel sheet showing the relevant page numbers and send the PDFs. Thanks again, Steve

    $142 (Avg Bid)
    $142 Rata-rata
    1 penawaran

    I need an experienced Excel developer who excels at spreadsheet automation and formula creation. The project will involve working with mixed data, both numerical and textual. Key tasks include: - Implementing automation solutions to existing procedures Day End Accounts Closing that includes revenues, expenses, commissions and stock level management - Crafting efficient formulas that meet the specific needs of the dataset While there's no specific Excel feature or function in mind yet, we're open to any that might generate the needed outcome. Therefore, a sound knowledge of Excel's advanced functionalities is ideal. Excited to collaborate with someone who enjoys problem-solving and creating seamless Excel workf...

    $448 (Avg Bid)
    $448 Rata-rata
    7 penawaran

    I'm seeking a skilled programmer to develop a credit card (cc) checker utilising Braintree API. This project primarily involves building a system that performs small transactions to verify the validity of a credit card and return results. Key Requirements: 1. Display Format: The results should be presented clearly in a list format. 2. Details Displayed: Upon successful checking, the system should show the card type and the card's expiry date. 3. Error Handling: It's crucial to show an error message if an invalid credit card is entered. If you have prior experience with payment gateway API's (especially Braintree API) and a keen attention to detail, you're potentially a good fit for this project. Do not hesitate ...

    $100 (Avg Bid)
    $100 Rata-rata
    85 penawaran

    I'm in search of a professional video editor, skilled in crafting compelling, high-quality wedding videos. My needs revolve around making our video look like a documentary/cinematic that perfectly captures behind-the-scenes and ceremony footage. Here's a snapshot of what's required: - Work on wedding video editing, primarily involving behind-the-scenes and ceremony footage. - Must excel in executing a documentary style, making the content immersive and real. - A keen eye towards telling a story through the footage; maintain continuity while also capturing the distinct moments. Ideal skills and experience: - Proven experience with wedding video editing, specifically documentary/cinematic style. - Profound understanding of video editing software a...

    $61 (Avg Bid)
    $61 Rata-rata
    41 penawaran

    I am in search of an expert in Excel to create a comprehensive dashboard from an already existing spreadsheet. The dashboard should be interactive and incorporate multiple filters. Key Characteristics: - Able to embed filters for Date range, Project name, Status, Size, and Material, with possibilities of extending to more which will be provided upon project award. - You should be able to creatively build an intuitive, user-friendly interface that allows for easy navigation through huge data sets. Ideal Candidate: - Has significant experience and skill in Excel and data management. - Can provide examples of other Excel dashboards they've created. - Communicates effectively regarding project status and any barriers...

    $414 (Avg Bid)
    $414 Rata-rata
    106 penawaran
    Excel 365 Data Entry Specialist 6 Hari left
    TERVERIFIKASI

    I am seeking an expert in Excel 365 who can highly perform simple data entry tasks. You should ideally have: - A deep understanding of Excel 365's functions and user interface - Precise attention to detail - Simply u have to enter issued number against received number - For example :- In department of DSC you have to 1st go to DSC sheet then 1st enter date like as per photo that was 28/01/2024 than 1st find number "574" by finding function than entry "147" in 28/01/2024 column. Please understand first approx. 5000 entry u have to enter as per above mentioned. After confirmation total entry detail will be send.

    $11 (Avg Bid)
    $11 Rata-rata
    25 penawaran
    Create Logo 6 Hari left

    I need a Cannabis domain logo. Logo must contain icon and text. It must be unique, not copied. Vector format. Budget $30. 24 hour deadline.

    $21 (Avg Bid)
    $21 Rata-rata
    63 penawaran

    I am seeking a freelancer with experience in automating tasks using the Make platform to create a solution that will automate posting across over 20 of my Google My Business (GMB) profiles. When I post on one GMB profile I would like that post (image and text) automatically copied and posted across all GMB platforms. • Platform: The chosen platform for developing this solution is Make, due to its cost-effectiveness. Therefore, proficiency in leveraging Make for automation tasks is critical. • Functionality: The software should have the ability to take a post created on one GMB profile - containing text and images - and duplicate it exactly across all GMB profiles I manage. • Requirements: There should be no limitations on the format...

    $13 (Avg Bid)
    $13 Rata-rata
    10 penawaran

    As I'm aiming to get approval for Google Merchant Center, I need a freelancer who can convert my logo into a transparent format. - You will need to be experienced in logo conversion tasks. - Detailed project proposals are vital, please include a step-by-step outline of how you plan to achieve this. - Although I've skipped the question on final resolution, I will require the final logo to be in high quality for professional use. - It's not clear at the moment what my current logo file format is, but I'll provide additional information during our discussions. ****I will provide you access to the homepage to get the logo off shopify! You must know shopify Please, having experience with Goog...

    $24 (Avg Bid)
    $24 Rata-rata
    73 penawaran

    I am in need of an experienced individual who is proficient in using Microsoft Word and Excel, particularly in areas of formatting, styling, creation and implementation of formulas and functions, as well as data analysis and visualization. Additionally, academic writing is crucial for the success of this project, therefore, the potential freelancer should have excellent research and writing skills to ensure content quality and sanity. The ideal candidate should possess the following skills and experience: - Expert knowledge in Microsoft Word and Excel - Ability to manipulate data, implement formulas and create visualization - Strong academic writing skills - Critical thinking and problem-solving abilities PLEASE READ AND UNDERST...

    $17 (Avg Bid)
    $17 Rata-rata
    38 penawaran

    As someone who requires an excel table with specific information - names and addresses, sales data, as well as inventory data, all neatly arranged into separate columns - I seek assistance from a freelancer with high expertise in data analysis and excel. A commendable skill level in organization and attention to detail will be necessary. Due to the urgency of this project, I'll need you to complete it as soon as possible, making efficiency and speed vital traits.

    $19 / hr (Avg Bid)
    $19 / hr Rata-rata
    74 penawaran

    I need a simple UIFlow program written based on the M5 Stamp Pico to receive thermal sensor readings from an M5 NCIR 2 (I2C). The readings are displayed on a M5 1.14" I2C Color LCD (ST7789V2) where active temp text is displayed over a static background image. The program establishes a temperature variable above which a (fan) control signal activates an M5 3A Relay Unit. Grove connectors are used throughout, except for power leads to the Stamp Pico. A M5 2 Unit can be used to manage I2C components if required. All M5 components have been sourced from m5stack.com. This program code is needed to utilize the referenced components for monitoring the temperature of a sensitive transistor in radio application. Skills Needed: - Knowledge of ESP32 microcont...

    $47 (Avg Bid)
    $47 Rata-rata
    8 penawaran

    I'm seeking a talented logo designer who excels in creating modern, 3D designs. The perfect individual for this project will: - Have prior experience with modern 3D logo design - Have a keen eye for color (primarily red and white) - Excel in creativity to incorporate abstract shapes into the design The finished logo needs to reflect the identity of my company and must incorporate abstract shapes to resonate with our ethos. Your design should favor a modern look that enhances our brand awareness. Please showcase your skills and experience with 3D designs when you bid.

    $13 (Avg Bid)
    $13 Rata-rata
    14 penawaran
    Data Extraction from Database 6 Hari left
    TERVERIFIKASI

    I got database in DB3 format. In contains many things like RGB images and LiDAR (point of cloud ) data and others. I attach metadata file. What I need is some who will connect to my PC via Anydesk and will remotely extract information from that database. RGB and LiDAR of same scene so that it is compatible with format

    $61 (Avg Bid)
    $61 Rata-rata
    31 penawaran

    I am in need of a freelancer who can proficiently handle my project. This project involves piecing together mixed PDFs (text and image-based) into a coherent, single scalable vector image. Since I have not requested any specific image enhancement features like color correction, sharpening or retouching services, the ideal freelancer for this work should be well-versed in handling mixed format PDFs and vector imaging. Furthermore, the timeline is pretty flexible with no tight deadlines. Your innate understanding of image composition will be a significant advantage throughout this task. Remember, your primary role will be the alignment and assembly of different PDF elements to deliver a high-quality vector image.

    $22 (Avg Bid)
    $22 Rata-rata
    44 penawaran

    I have 120 products on WooCommerce WordPress. They are all tires. I need you clean them up with the data that is provided on the Excel document but also cross reference online the proper descriptions and attributes. I need you to make sure the titles are proper and not through the SKU or long product description. I need you to make sure they are all properly categorized and tagged as well and that its respective image shows. There's also some that repeat themselves as they are the same tire, so it's just making sure the variants apply to the product rather than create separate products for a product that can house variants for different tire sizes. Need completed by Sunday.

    $84 (Avg Bid)
    $84 Rata-rata
    204 penawaran

    Θέλω να μου δημιουργήσεις ένα αρχείο excel με τις κατηγορίες επαφών για τις οποίες ενδιαφέρομαι και αφορούν στην περιοχή της Κρήτης. 0.ΦΡΟΝΤΙΣΤΗΡΙΑ ΞΕΝΩΝ ΓΛΩΣ&Sigm...

    $471 (Avg Bid)
    $471 Rata-rata
    20 penawaran

    As the owner of a taxi, limous...from themeforest, along with a domain, which I need to be set up. Additionally, I require several customizations to the theme: - Integrate our company logo to the platform. The file format will be provided later. - Alter the color scheme, although specifics will be finalized at the start of the project. - The theme's fonts should be customized to best represent our brand. - More payment gateways need to be added to our platform, ensuring our customers have various options to make payments. Ideal candidates for this job should have prior experience with HTML5, Bootstrap themes, and payment gateway integration. Familiarity with color psychology and font selection in web development would...

    $130 (Avg Bid)
    $130 Rata-rata
    226 penawaran

    I need a dedicated and detail-oriented virtual assistant proficient in both English and Spanish, who can carry out specific bookkeeping tasks. Tasks Include: - Data entry - Managing accounts payable/receivable - Bank reconciliations The ideal candidate must have extensive experience with Excel as it is our primary tool for bookkeeping. Please share your previous work experience in these areas, as well as proof of your bilingual proficiency (English and Spanish). This is essential for effective communication and smooth operation. Can't wait to work with you!

    $10 / hr (Avg Bid)
    $10 / hr Rata-rata
    45 penawaran

    ...there! Our agency is expanding and we're searching for a Collaboration Agent to join our journey. We're currently promoting brilliant tees for high-performing individuals, and aims to support the ambitious startup atmosphere. Our high-performer T-shirts are a must-have for every founder or entrepreneur, instantly boosting your status in any room and creating lasting impressions. Your mission: • Discover talents on Instagram and TikTok who will promote our T-shirts. • Engage internationally– London, Stockholm, and LA. You will face time zone challenge, can you catch-up? • Trigger interest by responding to DMs in a casual day-to-day talk format. Requirements: • Great sense of suitable influenc...

    $21 (Avg Bid)
    $21 Rata-rata
    8 penawaran
    SQL to Excel Data export 6 Hari left
    TERVERIFIKASI

    I have an SQL database and I need to export data sets into an Excel spreadsheet. I would need the following data exported into individual spreadsheets: - Customer information - Bill of materials - Materials inventory - Supplier details I have examples from previous exports of the required data that should be presented in each spreadsheet Ideal candidate should have the following skills: - Extensive experience with both SQL and Excel - Understanding of data extraction techniques - Excellent attention to detail to ensure that the data transfer is accurate. - Prompt communication and commitment to meet deadlines. You should be able to handle sensitive customer information responsibly and maintain strict professional discretion at...

    $725 (Avg Bid)
    $725 Rata-rata
    154 penawaran

    ...creation of functional Excel spreadsheets using data sourced from images. These images are primarily composed of numeric data and will need to be meticulously converted into a spreadsheet format. The key elements of this project are: - Converting data in image format to a neat, organized Excel spreadsheet. - The data to be converted is purely numeric. Furthermore, there are requirements around data validation rules. Primarily: - Date-specific data is included. Thus, knowledge of date formatting and validation protocols in Excel are essential. The ideal freelancer for this job should have: - Strong experience with Excel, particularly in the creation and management of spreadsheets. - Prior experienc...

    $20 (Avg Bid)
    $20 Rata-rata
    105 penawaran

    I am in need of an expert graphic designer who can transform my ideas into a unique and eye-catching symbol for a logo. It's a pure symbol design project - no text involved. Please see the attachment for the distinct symbol and color palette I would like. You can bring your own creative spin while adhering to the required scheme. Here's what makes you a good fit for this job: - Strong portfolio of previous logo design work, particularly with geometric symbols. - Good communication skills, willing to understand my vision and transform it into the design. - Proven experience in picking and combining colors effectively. Finally, it is important to note that the logo will be used across different platforms including social media, websites and pri...

    $21 (Avg Bid)
    $21 Rata-rata
    129 penawaran

    Overview In this challenge, you are tasked with the simulation of mining process of a block, which includes validating and including transactions from a given set of transactions. The repository contains a folder mempool which contains JSON files. These files represent individual transactions, some of which may be invalid. Your goal is to successfully mine a block by including only the valid transactions, following the specific requirements outlined below. Objective Your primary objective is to write a script that processes a series of transactions, validates them, and then mines them into a block. The output of your script should be a file named that follows a specific format. Requirements Input You are provided with a folder named mempool containing several...

    $10 / hr (Avg Bid)
    $10 / hr Rata-rata
    3 penawaran

    I'm seeking a senior-level bookkeeper with a knack for spreadsheets and modeling. On this project, your key responsibilities will include: - Conducting a thorough financial audit - Developing comprehensive financial reports Preferably, you should have a strong proficiency in Excel to accomplish these tasks. Demonstrated experience in managing audits and financial planning/reports is highly valuable. Let's ensure our financial health with your accounting expertise!

    $131 (Avg Bid)
    $131 Rata-rata
    42 penawaran

    ​Hi, I'm looking for someone to write a trading strategy for financial instruments. So the concept is very simple. I would like to backtest trades that will take place every day at the same entry time, for example, 08:00:00, and run until 10:00:00. Entry criteria: One trade in each direction only Long Entry If we assume the entry point as 08:00:00 on a 5-minute chart, this bar will be our "open range.". If the next bar moves above "open range high," that will trigger the long position, and accordingly, our SL will be below "open range low.". Sell Short If we assume the entry point as 08:00:00 on a 5-minute chart, this bar will be our "open range.". If the next bar moves below "open range low," that wi...

    $158 (Avg Bid)
    $158 Rata-rata
    93 penawaran

    ...ΠΡΟΩΘΗΣΗΣ ΕΠΙΣΤΗΜΟΝΙΚΩΝ ΒΙΒΛΙΩΝ 5. ΔΗΜΟΤΙΚΕΣ ΒΙΒΛΙΟΘΗΚΕΣ 6. ΠΟΛΙΤΙΣΤΙΚΟΙ ΣΥΛΛΟΓΟΙ - ΛΥΚΕΙΑ ΕΛΛΗΝΙΔΩΝ / ΝΟΜΟ 7. ΠΑΝΕΠΙΣΤΗΜΙΑ ΚΡΗΤΗΣ ( ΘΕΛΩ ΕΠΑΦΕΣ Σ&Ep...

    $138 (Avg Bid)
    $138 Rata-rata
    26 penawaran

    I am looking...WordPress and Elementor and has expertise in developing directory websites using the "MyListing" theme. Your fluency in English is vital as we will need to communicate effectively. Key tasks will include: - Updating the layout of the homepage - Adding new sections to the website - Updating current content - Ability to upload data from Excel into specific categories - Rectifying issues with the "copy and duplicate" store hours feature Having an understanding of how menu and site features work is essential. Ability to read the needs of the project is important. Previous experience working on similar tasks and knowledge of "MyListing" theme is greatly advantageous. In your applicatio...

    $421 (Avg Bid)
    $421 Rata-rata
    243 penawaran
    Customer Satisfaction Strategist 6 Hari left
    TERVERIFIKASI

    ...success manager to concentrate on developing strategies to bolster customer satisfaction. This is to go over data in a QBR I have a task. The task will tell you the company and the hypothetical situation to complete- almost as if you are an interview. There will be two parts. The first part do some research on the company and the competitor mentioned. The second is to look at the data I’ll provide on excel I need you to follow the steps in the task write the answers in a presentation. The task involved analysing data (only excel not code!) The price is fixed for this. 40 pound. If you are skilled in this it should take no longer than an hour to source information then basic presentation...

    $25 (Avg Bid)
    $25 Rata-rata
    23 penawaran

    I am currently in the process of verifying contact information of various businesses. Your primary responsibility is to fill in missing phone numbers of these companies through Google. There are 11,450 company name and address combinations with missing phone numbers that you will need to google. Responsibilities include: - Searching company names and addresses on Google - Finding the correct phone numbers - Ensuring the credibility of the information - Properly recording the data in the provided format Ideal candidate should have: - Excellent Google search skills - An eye for detail to ensure that the phone numbers match with the company names and addresses - Reliability to produce accurate and comprehensive results - Prior experien...

    $1896 (Avg Bid)
    $1896 Rata-rata
    71 penawaran