Microsoft Excel Project - Simple Tabel

 Hello, welcome back!!




Last week, I finished Microsoft Office Basic Training organized by BLKIP Bali. I learned a lot about  Word, Excel, PowerPoint, and any other soft skills needed in the workplace. Starting now, I will upload some of my portfolios to show off my skills in Microsoft Office.

In this post, I will show you some simple Excel projects, regarding bills and invoices. This project does not include any formulas, just some simple Excel templates. Because the training was in Indonesian, some of the words and sentences in the portfolios might not be in English. Feel free to contact me if you have any suggestions or questions about it.
Thankyou 😁


Bills (Fraktur Tagihan)


Here are the conditions and functions that I use in this project : 

  • Paper size A4
  • Landscape orientation
  • Margin 2222
  • Custom Border and Shading
  • Merge and Center for some merge cells
  • Cells alignment
  • Accounting format number
  • Custom Header Footer

Invoices

Invoice

Here are the conditions and functions that I use in this project : 

  • Paper size A4
  • Portrait orientation
  • Margin 2222
  • Custom Border and Shading
  • Merge and Center for some merge cells
  • Cells alignment
  • Accounting format number
  • Short Date format number
  • Custom Header Footer

Comments

Post a Comment

Popular posts from this blog

Microsoft Excel Project - Vlookup and Hlookup

Image
  Hey, how are you? Welcome again!! So now we are moving to some complex functions and formulas, which are Vlookup and Hlookup. VLOOKUP & HLOOKUP VLOOKUP is a function to read or find data vertically. The function form is :     =Vlookup(lookup_value;  table_array; column_index_num; range_lookup)     "lookup_value": the value as the basic table reading     "table_array": the range of the reference table     "column_index_num": the number of the column position on the reference table     "range_lookup": TRUE for approximate results, or FALSE for accurate results. HLOOKUP is a function to read or find data horizontally. The function form is :     =Hlookup(lookup_value;  table_array; row_index_num; range_lookup)     "lookup_value": the value as the basic table reading     "table_array": the range of the reference table     "row_index_num": the number of the row position on the refe...
Read more

SQL Project #2 - Myanmar 3 Superstore

Image
  (photo credit:  https://unsplash.com/photos/kLwgUwv_m_g?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink ) In this post, I will show you my second SQL Project about data analysis of Superstores. These superstores are located in Myanmar and have 3 branches. Branch A located in Yangon City, Branch B is located in Mandalay City, and Branch C is located in Naypyitaw City. I got the data from AUNG PYAE on Kaggle : https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales I used the same tools as the previous project, MySQL Workbench and Tableau. You can see the SQL code on my GitHub account:  https://github.com/ratnaprasada/3Superstore So here's the analysis, feel free to contact me if you have  any suggestions or questions about it. Thankyou 😁
Read more