Wednesday, 20 September 2023

Video Editing AI

As of my last knowledge update in September 2021, there were several free online video editing websites available. However, the availability and features of these websites may change over time. Here are some popular options to consider for free online video editing:

Clipchamp: Clipchamp is an online video editor that offers a range of editing tools and templates. It's user-friendly and suitable for basic video editing needs.

Kapwing: Kapwing is a versatile online video editor that allows you to trim, add text, subtitles, and more to your videos. It also provides tools for creating GIFs and collages.

Online Video Cutter: This is a straightforward tool for cutting and trimming videos. It's handy for simple editing tasks like removing unwanted sections from a video.

Biteable: Biteable specializes in creating animated videos and video infographics. It offers a variety of templates and allows you to add text and music to your videos.

WeVideo: WeVideo has both free and paid plans. The free plan includes basic video editing features, cloud storage, and the ability to export videos up to 720p resolution.

HitFilm Express: While it's not entirely online, HitFilm Express is a powerful free video editing software for both Mac and Windows. It offers advanced features for video editing, compositing, and visual effects.

FlexClip: FlexClip is an online video editor with a simple interface. It allows you to trim videos, add text, music, and even stock footage to your projects.

ClipMyVideo: ClipMyVideo offers easy trimming and cutting of videos. It's a quick tool for simple edits.

Lightworks Free: Lightworks is professional-grade video editing software available for Windows, macOS, and Linux. It has a free version with advanced editing features but may have a learning curve.

Friday, 8 September 2023

नेपालको पृष्ठभुमि

मेरो देश नेपाल बारे निबन्ध

कान्छामान ब्लोन

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

नेपाल दक्षिण एसियामा सुन्दर जग्गाजस्तो देश हो यसको राजधानी शहर काठमाडौं हो। नेपाल भारत र चीन ले घेरिएको छ। नेपालमा एक राजा हुन्थ्यो तर अब राष्ट्रपति छ। नेपाललाई तराई, पहाड र हिमाल गरि तीन भागमा बाँडिएको छ।

नेपाल सगरमाथा, सुन्दरता र पशुपति मन्दिरको लागि प्रसिद्ध छ जुन हिन्दुहरूको लागि हो। माउन्ट एभरेष्ट विश्वको सबै भन्दा अग्लो पहाड हो जहाँ धेरै पर्यटकहरू आउँछन्। यी बाहेक, हामीले भ्रमण गर्नुपर्ने नेपालका तीन स्थानहरू लुम्बानी, चितवन र पोखरा पनि हुन।

लुम्बनी त्यो ठाउँ हो जहाँ भगवान बुद्ध जन्म भएको । चितवन जंगल सफारीको लागि प्रसिद्ध छ। पोखरा पर्यटकका लागी हेर्न धेरै सुन्दर ठाउ हो। गत बर्ष नेपालको भ्रमण गरियो र मलाई पानी पुरी र नेपालको मोमो मनपर्‍यो।

नेपालको राष्ट्रिय चाड़हरू दशै र तिहार हुन् र राष्ट्रिय जनावर गाई, राष्ट्रिय फूल लालिगुरास र राष्ट्रिय पक्षी डाफे हुन। नेपालमा धेरै अवसरहरू छन्। म चाहन्छु कि नेपालमा सबैको रोजगारी होस र नेपाल पर्यटकका लागि स्वच्छ र शान्तिमय रहनको लागि कुनै झगडा बिना नै रहोस्।

अन्तमा मलाई नेपाली भएकोमा गर्व छ र नेपालको संस्कृति मन पराउँछु। जब म ठूलो हुन्छु म नेपालका गरिब र दरिद्र मानिसहरूलाई सहयोग गर्न चाहन्छु।

Essay 2

मेरो देश को बारेमा निबन्ध 200 शब्दमा

म नेपाली हुँ । मेरो देश नेपाल हो । मलाई मेरो देश नेपालको धेरै माया लाग्छ । मेरो देश नेपाल एशिया महादेशमा रहेको सानो अनि विश्वकै एउटा अत्यन्त सुन्दर राष्ट्र हो । यहाँको हावापानी र प्राकृतिक वातावरण असाध्य रमणिय छ । नेपालमा धेरै हिमाल, पहाड र नदीनालाहरु छन । संसारको सबैभन्दा अग्लो हिमाल सगरमाथा पनि यही छ । हिमाल सगरमाथा पनि नेपालमै छ । यहाँ वन, जंगल, लेक, बेसी र रमणिय हरिया फाटहरू पनि छन् ।

मेरो देश नेपालमा धेरै जाति, धर्म, भाषा तथा विभिन्न रहनसहन भएका मानिसहरू बस्दछन् । यहाँ किसिम किसिमका कला, संस्कृति, चाडपर्व, परम्परा तथा रीतिरीवाजहरू छन । त्यसैले, मेरो देश नेपाललाई थरीथरीका फूलहरूको एउटा सुन्दर माला पनि भनिन्छ । मेरो देश नेपालको राष्ट्रिय भाषा नेपाली भाषा हो । यहाँ अन्य सयवटा भन्दा बढी भाषाहरू बोलिन्छ तर सबै नेपालीहरूले नेपाली भाषा बोल्दछन । नेपालमा बस्ने मानिसलाई नेपाली भनिन्छ ।

मेरो देश नेपालमा विभिन्न किसिमका जनावर, चराचुरुङ्गी तथा किराहरु पाइन्छ । यहाँ असाध्यै राम्रो फूलहरू पनि पाइन्छ ।

हामीले आफ्नो देशलाई माया गर्छौ तथा म आफुलाइ गर्वाबित ठन्छु किनकी यो देश नेपाल हाम्रो जन्म भुमि हो । हामी सबैले हाम्रो देश नेपाललाई सम्मान गर्नु पर्छ। नेपाल छन त हामी छौ।

Essay 3

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

मेरो देश नेपाल दुई देशहरु द्वारा घेरिएको छ। चीन उतरपट्टि अवस्थित छ र पश्चिम, पुर्व र दक्षिण भारतले ढाकेको छ। यो उत्तरी गोलार्द्धमा छ। हाम्रो देश तीन भौगोलिक क्षेत्रहरू छन्। हिमालय, पर्वतीय र तराई।हाम्रो देशमा जाडोमा धेरै चिसो र सुख्खा हुन्छ र गर्मीमा आँधीबेहरी,बर्षा र बाढिपहिरो हुनछन् ।यो प्राकृतिक सौन्दर्य र स्रोतहरु मा धनी छ। यसमा कोशी, गण्डकी र कर्णाली जस्ता लामो र चौंडा नदीहरू छन्। हामीसँग रुपा, बेगनास, र रारा जस्ता ठूला तालहरू छन्। हामीसँग हरियो उपत्यका, सुन्दर पानी, झरना आदि छ। यो धार्मिक र ऐतिहासिक सम्पदामा धनी छ। लुम्बिनी, गोरखा, जनकपुर, काठमाडौं प्रख्यात उदाहरणहरू हुन्।

नेपाल अत्यधिक विविध र धनी भूगोल, संस्कृति र धर्महरूको देश हो। हिमाली उत्तरमा विश्वका १४ उच्चतम पहाडहरूमध्ये आठ छन्, सब भन्दा अग्लो, सगरमाथा, अंग्रेजीमा माउन्ट एभरेष्टको रूपमा चिनिन्छ। उर्वर र आर्द्र दक्षिणी क्षेत्र शहरी छ।

यहाँ धेरै जाति र धर्मका मानिस बस्छन्। लगभग सय भाषाहरु बोलिन्छन्। हाम्रो लोकप्रिय खानाहरू दाल भाट, डिन्डो, गुनर्दुक इत्यादि हुन्। दशैं, तिहार, लोसार, आदि सबैभन्दा लोकप्रिय चाडपर्वहरू हुन्।

नेपाल सानो छ तर प्राकृतिक स्रोतसाधनमा धनी छ तर आर्थिक अवस्थाले गर्दा गरीब छ। नेपाल विकासोन्मुख देश हो। चाँडै नै विकास गर्नका लागि आजदेखि हामीले देशको सबै नागरिकता बारे सचेत हुनुपर्दछ। पुरुष र महिला दुबै समान हुन र शिक्षा प्रदान गर्दछ, सरकारले अग्रिम कार्यक्रम ल्याउनु पर्दछ र नागरिक र सरकार दुबैलाई फाइदा पुर्‍याउने बिभिन्न सुविधा प्रदान गरी नागरिकलाई सहयोग गर्नुपर्दछ।

नेपाल एक सुन्दर देश हो। त्यसोभए, हामीले यसलाई विश्वभर प्रकाशित गर्नुपर्नेछ जुन प्रत्यक्ष वा अप्रत्यक्ष रूपमा पर्यटकलाई आकर्षित गर्न मद्दत गर्दछ र हामी आफ्नो आर्थिक अवस्था नियन्त्रण गर्न सक्छौं।सफलता हाम्रा बलहरू विकास गरेर प्राप्त हुन्छ, हाम्रा कमजोरीहरू हटाएर होइन।

Essay 4

मेरो देश को बारेमा निबन्ध 300 शब्दमा

नेपाल ! हाम्रो देश । हाम्रो मातृभूमि ! हाम्रो जन्मस्थान ! हामी नेपाली हुनुमा गौरवान्वित छौं । हामीलाई हाम्रो मातृभूमिको मुकुट विश्वको सर्वोच्च शिखर, पर्यटकहरू र पर्वतारोहीहरूको महा आकर्षण सगरमाथाको गौरव छ । हामीलाई गौरव छ कि प्रकृतिले हाम्रो मातृभूमिलाई पहाड, डाँडा, उपत्यका, बैंसी र मैदानले शृङगारेको छ । विभिन्न प्रकारका उपयोगी रूखहरू, औषधिका जडीबुटीहरू, मोहक फूलहरू, सामान्य र दुर्लभ जनावर र चराचुरुङ्गीहरू युक्त वनजङ्गल हाम्रो देशलाई सुन्दर र पर्यटन केन्द्र बनाउँछन् । प्रकृतिले हाम्रो देशलाई खनिज र ग्लेसियर, ताल, नदी, प्रसवण र झरनाको रूपमा विशाल जलसाधन दिएको छ । यिनीहरूले हाम्रो भूमिलाई संसारको दोस्रो सर्वाधिक जलसाधनमा धनी देश बनाएका छन् ।

हामीलाई गौरव छ कि हाम्रो माटो पवित्र छ । विष्णुप्रिया महादेवी लक्ष्मी यहाँ सीताको रूपमा अवतीर्ण हुनुभयो । यो त्यही पावन भूमि हो जहाँ विष्णुको दसौं अवतार, एसियाको प्रकाश, गौतम बुद्धको जन्म भएको थियो र उनको धर्मको प्रचार अनेक देशहरूमा भएको थियो । यो त्यही पवित्र स्थल हो जहाँ महान् ऋषि बाल्मीकि र व्यासले तपस्या गरेका थिए जहाँ महान् राजा जनकले राज्य गरेका थिए, जहाँ महान् विद्वान् याज्ञवल्क्य र मैत्रेय बस्दथे ।

हामी गौरवान्वित छौं कि हाम्रो देशले वीर सैनिकहरूलाई जन्म दिएको छ जसको नाम र यश संसारमा छ र जसले आफ्नो अद्वितीय वीरताले आफ्नो देशको स्वतन्त्रताको रक्षा गरे । हाम्रा विभिन्न जात, जाति, धर्म, परम्परा र रीतिरिवाजका जनताहरूले अद्वितीय उदाहरण प्रस्तुत गरेका छन् । हामी विश्व शान्तिको पक्षमा छौं । हामीलाई संयुक्त राष्ट्रसङ्घको वडापत्रमा विश्वास छ । हामी विश्वमा शान्ति कायम गर्न सधैं तत्पर रहन्छौं । हाम्रा शान्ति सैनिकहरू अशान्त देशमा शान्ति स्थापना गरिरहेका छन् । हामी “ बाँच र बाँच्नदेऊ " नीतिमा आस्था राख्दछौं । हामी हाम्रा चन्द्र सूर्य भएको राष्ट्रिय झन्डा सधैं आकाशमा फहराउन कृत सङ्कल्पित छौं ।

म आफ्न देशलाई धेरै माया गर्छु र म नेपाली हुनुमा धेरै गर्व महसुस गर्द्छु। हाम्रो देश नेपाल लाई सबैले सम्मान गर्नु पर्छ।

Essay 5

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

मेरो देश नेपाल दक्षिण एशियामा भारत र चीनको बीचमा अवस्थित छ। मेरो देशको कुल क्षेत्र १,४७,१८१ वर्गमीटर छ। यो एक जग्गायुक्त देश हो। नेपाल एउटा सानो देश हो तर त्यहाँ भौगोलिक विविधता छ। यो साधारण सम्पत्ति र संस्कृतिमा धनी छ। हामीलाई थाहा छ कि ब्राजिल पछि नेपाल जलस्रोतमा दोस्रो ठूलो देश हो। मुख्य नदीहरू कोशी, गण्डकी र कर्नाली हुन्। नेपालमा विभिन्न प्रकारका खनिजहरू र जङगलहरू पनि भेटिन्छन्।

हामीलाई हाम्रो मातृभूमिको मुकुट, विश्वको सर्वोच्च शिखर, पर्यटकहरू र पर्वतारोहीहरूको महा आकर्षण सगरमाथाको गौरव छ । हामीलाई गौरव छ कि प्रकृतिले हाम्रो मातृभूमिलाई पहाड, डाँडा, उपत्यका, बेंसी र मैदानले सिंगारेको छ । विभिन्न प्रकारका उपयोगी रुखहरू, औषधीका जडीबुटीहरू, मोहकफूलहरू, सामान्य र दुर्लभ जनावर र चराचुरुङ्गीहरू युक्त वनजंगल हाम्रो देशलाई सुन्दर र पर्यटन केन्द्र बनाउँछन् । प्रकृतिले हाम्रो देशलाई खनिज र ग्लेसियर, ताल, नदी, प्रसवण र झरनाको रुपमा विशाल जलसाधन दिएको छ ।

हामीलाई गौरव छ कि हाम्रो माटो पवित्र छ । विष्णु प्रिया महादेवी लक्ष्मी यहाँ सीताको रुपमा अवतीर्ण हुनुभयो । यो त्यही पावन भूमि हो जहाँ विष्णुको दसौं अवतार, एशियाको प्रकाश, गौतम बुद्धको जन्म भएको थियो र उनको धर्मको प्रचार अनेक देशहरूमा भएको थियो । यो त्यही पवित्र स्थल हो जहाँ महान ऋषि बाल्मीकि र व्यासले तपस्या गरेका थिए जहाँ महान राजा जनकले राज्य गरेका थिए, जहाँ महान विद्वान याज्ञवल्क्य र मैत्रेय बस्तथे ।

राष्ट्रिय गीत "सयौं थुँगा फूलका हामी, एउटै माला नेपाली"

हो र यो देश नेपालको प्रमुख बिन्दु मध्ये एक गौतम बुद्ध लुम्बिनीमा नेपाल मा जन्म भएको थियो र यसको प्राकृतिक सौन्दर्य हो।

धेरैजसो किसानहरू हुन्। तिनीहरूले धान, मकै, गहुँ, कोदो, जौ, आलु आदि उत्पादन गर्दछन् शहरका केही मानिसहरू व्यापारीहरू हुन्। केहि उद्योगीहरु छन् र तिनीहरू धेरै श्रम र शिष्ट छन्।

प्राकृतिक स्रोतहरूमा पुग्नको कारण, पर्यटकहरू तपाईंको देश भ्रमण गर्न मन पराउँछन्। तिनीहरू यहाँ लोपोन्मुख चराहरू र जनावरहरू हेर्न सक्छन्।तिनीहरूले प्राकृतिक सुन्दरता पनि देख्न सक्छन्।त्यसैले पर्यटन हाम्रो सम्भावित उद्योग हो।

नेपालमा बस्ने मानिसहरु बिभिन्न जाति र धर्मका हुन् जसले विभिन्न परम्परा र सांस्कृतिक मूल्यहरु पछ्याउँदछन्। जस्तो कि हामीलाई थाहा छ कि नेपाल एउटा हिन्दू देशको रूपमा चिनिन्छ, अन्य धर्महरू जस्तै बौद्ध, क्रिश्चियन, किराट, इस्लाम, इत्यादि द्वारा। तिनीहरू विभिन्न चाडहरू मनाउँछन् र उनीहरूको आफ्नै मातृभाषाको भाषा छ। हाम्रो मुख्य खाना दाल भात हो। 80% भन्दा बढि मानिसहरु कृषिमा संलग्न छन्। केवल थोरै व्यक्तिले कारखाना, कार्यालय, व्यवसाय, आदि मा काम गर्छन् काठमाण्डु हाम्रो राजधानी शहर हो जुन मन्दिरको शहरको रूपमा पनि चिनिन्छ।

हामी विश्व शान्तिको पक्षमा छौं । हामीलाई संयुक्त राष्ट्रसंघको बडापत्रमा विश्वास छ । हामी विश्वमा शान्ति कायम गर्न सधै तत्पर रहन्छौं । हाम्रा शान्ति सैनिकहरू अशान्त देशमा शान्ति स्थापना गरिरहेका छन् । हामी “ बाँच र बाँच्नदेऊ " नीतिमा आस्था राख्दछौं । हामी हाम्रा चन्द्र सूर्य भएको राष्ट्रिय झण्डा सधैं आकाशमा फहराउन कृत सङ्कल्पित छौं ।

हाम्रो देश नेपालका मुख्य समस्यामा वनविनास एक मुख्य हो जसले गर्दा बाढी, पहिरो, भूक्षय र परिस्थितिकीय प्रणाली विनास हुन्छ । संसारको सर्वोच्च शिखर सगरमाथा नेपाल र चीन को सीमानामा अवस्थित छ ।

Essay 6

मेरो देश नेपाल

हिमालको सेतो फेटा, पहाडको हरियो भोटा र तराईको पहेँलो कछाड फेरेर बसेको मेरो देश मेरो मुटुको टुक्रा हो । सिन्धुमा हराएको विन्दु जस्तै विश्वको भूमण्डलमा सानो देखिए पनि मेरो देश मेरो प्राकृतिक दृश्यले एकदमै सुन्दर र पवित्र छ । पूर्व मेची र पश्चिममा कालीको रेखा कोरेर उत्तरतर्फ हिमश्रृङ्खलाको प्राकृतिक पर्खाल लगाई स्वयम् प्रकृति नै मेरो देशको रक्षामा खटिएकी छिन् । यस देशको चार किल्लाभित्र प्रकृति रमाउँदै नाचेकी छिन् ।

सूर्यका सुनौलो र सुकुमोल किरणहरु जब हिमाललाई स्पर्श गर्दै आउँछन् । अनि मेरो देशमा उज्यालो देखिन्छ । रहस्यको सखर मेरो देश अनेकता भित्र एकता भएको देश हो विश्वभरिकै प्राकृतिक सौन्दर्यलाई जम्मा पारेर भगवान्ले यसै मुलुकमा खन्याएकी छिन् । “चार जात छतिस वर्णको फूलबारी” का रुपमा रहेको मेरो देशभित्र अनेक जातजाति छन् ।

शेर्पा नाच, गुरुङको रोदी, लिम्बुको धाननाच र नेवारको लाखेनाचले यहाँ अलग–अलग संस्कृति र जातिको परम्परा छन् । तर यहाँ ती प्रत्येक जातजातिरुपी रंगीबिरंगी फूलहरुका बीचबाट विभिन्न संस्कृतिहरुका माझबाट एउटा राम्री सौन्दर्य ज्योतिको प्रस्तुती भएको छ र नेपाली संस्कृतिको जन्म भएको छ । यहाँ बुद्धका भक्तहरु पशुपतिका दर्शनको लागि छट्पटिरहेका र पशुपतिका भक्तहरु गुम्बा दर्शनको लागि यति स्वच्छ भूमिभित्र पशुपतिनाथ र स्वयम्भूले रत्नपार्कको मस्जिदसँग डाह गर्दैनन् । गिरिजाघरको विरुद्ध लडाई गरेका छैनन् । यसरी धार्मिक सहिष्ण्ुताको मूल फुटेको देश हो मेरो देश । हाम्रो देश नेपालमा सबै बिच घनिष्ट सम्बन्ध रहेको छ । यसले हाम्रो देशलाई अरु भन्दा फरक र राम्रो बनाएको छ । सबैका बिचमा हुने सहिष्णुताको भावनाले हाम्रो देशमा एकअर्कालाई हेप्ने, इर्श्या र डाहा गर्ने, धर्म र संस्कृतिमा बेदभाव गर्ने जस्ता काम हुदैनन्।

नेपालमा कलकल बग्ने खोला र छंगछंग गर्ने झरनाको आवाजमा चराचुरुङ्गी चिरबिर स्वरको मिश्रणले एउटा राम्रो ध्वनी निस्किन्छ अनि त्यसबाट नसोचेको आनन्दको प्राप्त हुन्छ । मानिस जब प्रकृतिको यस्तो रमणीय ठाउँमा आफु भएको देख्छ तब उसलाई केही कुराको मोह, स्वार्थ रहदैन ।

यहाँ जब खोलाको पवित्र पानीको स्पर्श हाम्रो जिउसंग हुन्छ तब एक प्रकारको आनन्द महसुस हुन्छ। त्यो आनन्द र त्यस्ता पलहरु हामी विश्वमा कतै पनि भेटाउन सक्दैनौ। त्यसैले त रम्घाको पाखामा भानु उदाउँछन् गोसाइकुण्डको यात्रामा देवकोटा गुनगुनाउँछन्, अर्घौ अर्चले लेखनाथ जन्माउँछ, औँसीका काली रातमा पनि भोसिको टोलमा मोती चम्कन्छन् । प्रकृतिको वातावरणले सिंगारिएका पहाडको स्वच्छ हावा र चिसो पानीले राता राता गाला भएका पहाडीहरु जब मुस्कुराउँछन् अनि त मोनालिसाको सौन्दर्य पनि पानी बन्छ ।

Essa

Saturday, 2 September 2023

50 Excel Shortcuts That You Should Know in 2023

Last updated on Jul 31, 20231996370

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Cell Formatting Shortcut Keys

Row and Column Formatting Shortcut Keys

Microsoft Excel is extensively used across the globe to store and analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data.

The shortcut keys in Excel help you work on your data in a jiffy. In this article, we’ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.

Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.

What is Microsoft Excel?

Although many of you are already aware of Excel, let’s have a small introduction anyways. Microsoft Excel is an application developed by Microsoft that is used to record, analyze, and visualize data. Excel, a spreadsheet application, was developed by Microsoft in 1985.

excel

Fig: Microsoft Excel Spreadsheet

Data in Excel is in the form of rows and columns. Excel is commonly used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs. Finally, another important application of Excel is that it helps in automating tasks through excel macros.

To perform the tasks mentioned above quickly, Excel has a set of shortcuts. Various operations can be achieved with a few simple keyboard strokes. Let’s dive deep into the Excel shortcuts that can help us work better on an Excel spreadsheet.

Need for Excel Shortcuts

Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions. Isn’t that easier and time-saving? Using Excel shortcuts drastically increases the speed, and thus reduces work-time.

Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to remember most of the common Excel shortcuts.

Let’s now look at the Excel shortcuts cheat sheet, which you should know when working on Microsoft Excel. In this article, we have categorized 50 Excel shortcuts based on their operations. First, we will look at the workbook shortcut keys.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Workbook Shortcut Keys

In this section, we will understand the basics of operating a workbook. We will learn how to create a new workbook, open an existing workbook, and save a spreadsheet so that you don’t lose any data or calculations that you have done. We will then go through how you can toggle between several different sheets in a workbook.

Description
Excel Shortcuts
1. To create a new workbook
Ctrl + N
2. To open an existing workbook
Ctrl + O
3. To save a workbook/spreadsheet
Ctrl + S
4. To close the current workbook
Ctrl + W
5. To close Excel
Ctrl + F4
6. To move to the next sheet
Ctrl + PageDown
7. To move to the previous sheet
Ctrl + PageUp
8. To go to the Data tab
Alt + A
9. To go to the View tab
Alt + W
10. To go the Formula tab
Alt + M

Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.

Cell Formatting Shortcut Keys

A cell in Excel holds all the data that you are working on. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more. Here is a sneak peek into these Excel shortcuts.

Description
Excel Shortcuts
11. To edit a cell
F2
12. To copy and paste cells
Ctrl + C, Ctrl + V
13. To italicize and make the font bold
Ctrl + I, Ctrl + B
14. To center align cell contents
Alt + H + A + C
15. To fill color
Alt + H + H
16. To add a border
Alt + H + B
17. To remove outline border
Ctrl + Shift + _
18. To add an outline to the select cells
Ctrl + Shift + &
19. To move to the next cell
Tab
20. To move to the previous cell
Shift + Tab
21. To select all the cells on the right
Ctrl + Shift + Right arrow
22. To select all the cells on the left
Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow

In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

We will learn how to add a comment to a cell. Comments are helpful when giving extra information about cell content. We will also learn how to find value and replace it with another value in the spreadsheet. After this, we will look into how to insert the current time, current date, activate a filter, and add a hyperlink to a cell. Finally, we will see how to apply a format to the data in a cell.

Description
Excel Shortcuts
26. To add a comment to a cell
Shift + F2
27. To delete a cell comment
Shift + F10 + D
28. To display find and replace
Ctrl + H
29. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
30. To insert the current date
Ctrl + ;
31. To insert current time
Ctrl + Shift + :
32. To insert a hyperlink
Ctrl + k
33. To apply the currency format
Ctrl + Shift + $
34. To apply the percent format
Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box
Alt + Q

After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel.

Row and Column Formatting Shortcut Keys

In this section, we’ll look at some critical row and column formatting shortcuts.

We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.

Description
Excel Shortcuts
36. To select the entire row
Shift + Space
37. To select the entire column
Ctrl + Space
38. To delete a column
Alt+H+D+C
39. To delete a row
Shift + Space, Ctrl + -
40. To hide selected row
Ctrl + 9
41. To unhide selected row
Ctrl + Shift + 9
42. To hide a selected column
Ctrl + 0
43. To unhide a selected column
Ctrl + Shift + 0
44. To group rows or columns
Alt + Shift + Right arrow
45. To ungroup rows or columns
Alt + Shift + Left arrow

Now that we have looked at the different shortcut keys for formatting cells, rows, and columns, it is time to jump into understanding an advanced topic in Excel, i.e. dealing with pivot tables. Let’s look at the different shortcuts to summarize your data using a pivot table.

Pivot Table Shortcut Keys

First, let’s create a pivot table using a sales dataset.

In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category.

pivot-table

Fig: Pivot table using sales data

46. To group pivot table items
Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

group1

47. To ungroup pivot table items
Alt + Shift + Left arrow
48. To hide pivot table items
Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

row

49. To create a pivot chart on the same sheet
Alt + F1
50. To create a pivot chart on a new worksheet
F11

same-sheet

Fig: Pivot chart on the same sheet

Choose the Right Program

With our courses, you'll learn to analyze data, create insightful reports, and make data-driven decisions that can help drive business success. Whether you're a beginner or an experienced professional, these courses will help you take your skills to the next level. So why wait? Sign up for Simplilearn's Data Analytics course today and start building the career of your dreams!

Program Name
Data Analyst Post Graduate Program In Data Analytics
Data Analytics Bootcamp
Geo All Geos All Geos US
University Simplilearn Purdue Caltech
Course Duration 11 Months 8 Months 6 Months
Coding Experience Required No Basic No
Skills You Will Learn 10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional Benefits Applied Learning via Capstone and 20+ industry-relevant Data Analytics projects Purdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost $$ $$$$ $$$$
Explore Program Explore Program Explore Program

Conclusion

Excel shortcut keys will indeed help you build your reports and analysis faster and better. After reading this article, you would have understood the different types of Excel shortcuts related to the workbook, cell formatting, row and column formatting, and pivot tables.

To kick-start your fruitful career in Excel, enroll in Post Graduate Program In Data Analytics course today.

We hope you find these hacks useful and can easily master these shortcut keys by working on excel regularly. Do you have any questions related to this article? If so, then please put it in the comments section of the article and our experts will get back to you at the earliest.

FAQs

1. What are Excel shortcuts?

Excel shortcuts are keyboard combinations that allow you to perform tasks quickly and efficiently. They can save you a lot of time, especially if you work with large spreadsheets. For example, instead of clicking on the "Bold" button on the toolbar, you can press Ctrl+B to bold a cell.

2. Why are Excel shortcuts important?

Shortcuts are important in Excel because they can help you work more efficiently. By using shortcuts, you can save time and focus on other tasks. They can also help you avoid repetitive strain injuries, as you don't have to use the mouse as much.

3. What are some of the most common Excel shortcuts?

Here are some of the most common Excel shortcuts:

Ctrl+C - Copy
Ctrl+V - Paste
Ctrl+Z - Undo
Ctrl+Y - Redo
F2 - Edit cell
Ctrl+A - Select all
Home - Move to the beginning of the worksheet
End - Move to the end of the worksheet
PgUp - Scroll up one page
PgDn - Scroll down one page

Subscribe to: Posts (Atom)

Wednesday, 20 September 2023

Video Editing AI

Clipchamp: Clipchamp is an online video editor that offers a range of editing tools and templates. It's user-friendly and suitable for basic video editing needs.

Kapwing: Kapwing is a versatile online video editor that allows you to trim, add text, subtitles, and more to your videos. It also provides tools for creating GIFs and collages.

Online Video Cutter: This is a straightforward tool for cutting and trimming videos. It's handy for simple editing tasks like removing unwanted sections from a video.

Biteable: Biteable specializes in creating animated videos and video infographics. It offers a variety of templates and allows you to add text and music to your videos.

WeVideo: WeVideo has both free and paid plans. The free plan includes basic video editing features, cloud storage, and the ability to export videos up to 720p resolution.

HitFilm Express: While it's not entirely online, HitFilm Express is a powerful free video editing software for both Mac and Windows. It offers advanced features for video editing, compositing, and visual effects.

FlexClip: FlexClip is an online video editor with a simple interface. It allows you to trim videos, add text, music, and even stock footage to your projects.

ClipMyVideo: ClipMyVideo offers easy trimming and cutting of videos. It's a quick tool for simple edits.

Lightworks Free: Lightworks is professional-grade video editing software available for Windows, macOS, and Linux. It has a free version with advanced editing features but may have a learning curve.

Friday, 8 September 2023

नेपालको पृष्ठभुमि

मेरो देश नेपाल बारे निबन्ध

कान्छामान ब्लोन

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

Essay 2

मेरो देश को बारेमा निबन्ध 200 शब्दमा

Essay 3

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

Essay 4

मेरो देश को बारेमा निबन्ध 300 शब्दमा

Essay 5

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

राष्ट्रिय गीत "सयौं थुँगा फूलका हामी, एउटै माला नेपाली"

Essay 6

मेरो देश नेपाल

Essa

Saturday, 2 September 2023

50 Excel Shortcuts That You Should Know in 2023

Last updated on Jul 31, 20231996370

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Cell Formatting Shortcut Keys

Row and Column Formatting Shortcut Keys

Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.

What is Microsoft Excel?

excel

Fig: Microsoft Excel Spreadsheet

Need for Excel Shortcuts

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Workbook Shortcut Keys

Description
Excel Shortcuts
1. To create a new workbook
Ctrl + N
2. To open an existing workbook
Ctrl + O
3. To save a workbook/spreadsheet
Ctrl + S
4. To close the current workbook
Ctrl + W
5. To close Excel
Ctrl + F4
6. To move to the next sheet
Ctrl + PageDown
7. To move to the previous sheet
Ctrl + PageUp
8. To go to the Data tab
Alt + A
9. To go to the View tab
Alt + W
10. To go the Formula tab
Alt + M

Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.

Cell Formatting Shortcut Keys

Description
Excel Shortcuts
11. To edit a cell
F2
12. To copy and paste cells
Ctrl + C, Ctrl + V
13. To italicize and make the font bold
Ctrl + I, Ctrl + B
14. To center align cell contents
Alt + H + A + C
15. To fill color
Alt + H + H
16. To add a border
Alt + H + B
17. To remove outline border
Ctrl + Shift + _
18. To add an outline to the select cells
Ctrl + Shift + &
19. To move to the next cell
Tab
20. To move to the previous cell
Shift + Tab
21. To select all the cells on the right
Ctrl + Shift + Right arrow
22. To select all the cells on the left
Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow

In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Description
Excel Shortcuts
26. To add a comment to a cell
Shift + F2
27. To delete a cell comment
Shift + F10 + D
28. To display find and replace
Ctrl + H
29. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
30. To insert the current date
Ctrl + ;
31. To insert current time
Ctrl + Shift + :
32. To insert a hyperlink
Ctrl + k
33. To apply the currency format
Ctrl + Shift + $
34. To apply the percent format
Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box
Alt + Q

After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel.

Row and Column Formatting Shortcut Keys

In this section, we’ll look at some critical row and column formatting shortcuts.

We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.

Description
Excel Shortcuts
36. To select the entire row
Shift + Space
37. To select the entire column
Ctrl + Space
38. To delete a column
Alt+H+D+C
39. To delete a row
Shift + Space, Ctrl + -
40. To hide selected row
Ctrl + 9
41. To unhide selected row
Ctrl + Shift + 9
42. To hide a selected column
Ctrl + 0
43. To unhide a selected column
Ctrl + Shift + 0
44. To group rows or columns
Alt + Shift + Right arrow
45. To ungroup rows or columns
Alt + Shift + Left arrow

Pivot Table Shortcut Keys

First, let’s create a pivot table using a sales dataset.

In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category.

pivot-table

Fig: Pivot table using sales data

46. To group pivot table items
Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

group1

47. To ungroup pivot table items
Alt + Shift + Left arrow
48. To hide pivot table items
Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

row

49. To create a pivot chart on the same sheet
Alt + F1
50. To create a pivot chart on a new worksheet
F11

same-sheet

Fig: Pivot chart on the same sheet

Choose the Right Program

Program Name
Data Analyst Post Graduate Program In Data Analytics
Data Analytics Bootcamp
Geo All Geos All Geos US
University Simplilearn Purdue Caltech
Course Duration 11 Months 8 Months 6 Months
Coding Experience Required No Basic No
Skills You Will Learn 10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional Benefits Applied Learning via Capstone and 20+ industry-relevant Data Analytics projects Purdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost $$ $$$$ $$$$
Explore Program Explore Program Explore Program

Conclusion

To kick-start your fruitful career in Excel, enroll in Post Graduate Program In Data Analytics course today.

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?

Here are some of the most common Excel shortcuts:

Ctrl+C - Copy
Ctrl+V - Paste
Ctrl+Z - Undo
Ctrl+Y - Redo
F2 - Edit cell
Ctrl+A - Select all
Home - Move to the beginning of the worksheet
End - Move to the end of the worksheet
PgUp - Scroll up one page
PgDn - Scroll down one page

Subscribe to: Posts (Atom)

Wednesday, 20 September 2023

Video Editing AI

Clipchamp: Clipchamp is an online video editor that offers a range of editing tools and templates. It's user-friendly and suitable for basic video editing needs.

Kapwing: Kapwing is a versatile online video editor that allows you to trim, add text, subtitles, and more to your videos. It also provides tools for creating GIFs and collages.

Online Video Cutter: This is a straightforward tool for cutting and trimming videos. It's handy for simple editing tasks like removing unwanted sections from a video.

Biteable: Biteable specializes in creating animated videos and video infographics. It offers a variety of templates and allows you to add text and music to your videos.

WeVideo: WeVideo has both free and paid plans. The free plan includes basic video editing features, cloud storage, and the ability to export videos up to 720p resolution.

HitFilm Express: While it's not entirely online, HitFilm Express is a powerful free video editing software for both Mac and Windows. It offers advanced features for video editing, compositing, and visual effects.

FlexClip: FlexClip is an online video editor with a simple interface. It allows you to trim videos, add text, music, and even stock footage to your projects.

ClipMyVideo: ClipMyVideo offers easy trimming and cutting of videos. It's a quick tool for simple edits.

Lightworks Free: Lightworks is professional-grade video editing software available for Windows, macOS, and Linux. It has a free version with advanced editing features but may have a learning curve.

Friday, 8 September 2023

नेपालको पृष्ठभुमि

मेरो देश नेपाल बारे निबन्ध

कान्छामान ब्लोन

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

Essay 2

मेरो देश को बारेमा निबन्ध 200 शब्दमा

Essay 3

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

Essay 4

मेरो देश को बारेमा निबन्ध 300 शब्दमा

Essay 5

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

राष्ट्रिय गीत "सयौं थुँगा फूलका हामी, एउटै माला नेपाली"

Essay 6

मेरो देश नेपाल

Essa

Saturday, 2 September 2023

50 Excel Shortcuts That You Should Know in 2023

Last updated on Jul 31, 20231996370

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Cell Formatting Shortcut Keys

Row and Column Formatting Shortcut Keys

Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.

What is Microsoft Excel?

excel

Fig: Microsoft Excel Spreadsheet

Need for Excel Shortcuts

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Workbook Shortcut Keys

Description
Excel Shortcuts
1. To create a new workbook
Ctrl + N
2. To open an existing workbook
Ctrl + O
3. To save a workbook/spreadsheet
Ctrl + S
4. To close the current workbook
Ctrl + W
5. To close Excel
Ctrl + F4
6. To move to the next sheet
Ctrl + PageDown
7. To move to the previous sheet
Ctrl + PageUp
8. To go to the Data tab
Alt + A
9. To go to the View tab
Alt + W
10. To go the Formula tab
Alt + M

Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.

Cell Formatting Shortcut Keys

Description
Excel Shortcuts
11. To edit a cell
F2
12. To copy and paste cells
Ctrl + C, Ctrl + V
13. To italicize and make the font bold
Ctrl + I, Ctrl + B
14. To center align cell contents
Alt + H + A + C
15. To fill color
Alt + H + H
16. To add a border
Alt + H + B
17. To remove outline border
Ctrl + Shift + _
18. To add an outline to the select cells
Ctrl + Shift + &
19. To move to the next cell
Tab
20. To move to the previous cell
Shift + Tab
21. To select all the cells on the right
Ctrl + Shift + Right arrow
22. To select all the cells on the left
Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow

In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Description
Excel Shortcuts
26. To add a comment to a cell
Shift + F2
27. To delete a cell comment
Shift + F10 + D
28. To display find and replace
Ctrl + H
29. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
30. To insert the current date
Ctrl + ;
31. To insert current time
Ctrl + Shift + :
32. To insert a hyperlink
Ctrl + k
33. To apply the currency format
Ctrl + Shift + $
34. To apply the percent format
Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box
Alt + Q

After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel.

Row and Column Formatting Shortcut Keys

In this section, we’ll look at some critical row and column formatting shortcuts.

We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.

Description
Excel Shortcuts
36. To select the entire row
Shift + Space
37. To select the entire column
Ctrl + Space
38. To delete a column
Alt+H+D+C
39. To delete a row
Shift + Space, Ctrl + -
40. To hide selected row
Ctrl + 9
41. To unhide selected row
Ctrl + Shift + 9
42. To hide a selected column
Ctrl + 0
43. To unhide a selected column
Ctrl + Shift + 0
44. To group rows or columns
Alt + Shift + Right arrow
45. To ungroup rows or columns
Alt + Shift + Left arrow

Pivot Table Shortcut Keys

First, let’s create a pivot table using a sales dataset.

In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category.

pivot-table

Fig: Pivot table using sales data

46. To group pivot table items
Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

group1

47. To ungroup pivot table items
Alt + Shift + Left arrow
48. To hide pivot table items
Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

row

49. To create a pivot chart on the same sheet
Alt + F1
50. To create a pivot chart on a new worksheet
F11

same-sheet

Fig: Pivot chart on the same sheet

Choose the Right Program

Program Name
Data Analyst Post Graduate Program In Data Analytics
Data Analytics Bootcamp
Geo All Geos All Geos US
University Simplilearn Purdue Caltech
Course Duration 11 Months 8 Months 6 Months
Coding Experience Required No Basic No
Skills You Will Learn 10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional Benefits Applied Learning via Capstone and 20+ industry-relevant Data Analytics projects Purdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost $$ $$$$ $$$$
Explore Program Explore Program Explore Program

Conclusion

To kick-start your fruitful career in Excel, enroll in Post Graduate Program In Data Analytics course today.

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?

Here are some of the most common Excel shortcuts:

Ctrl+C - Copy
Ctrl+V - Paste
Ctrl+Z - Undo
Ctrl+Y - Redo
F2 - Edit cell
Ctrl+A - Select all
Home - Move to the beginning of the worksheet
End - Move to the end of the worksheet
PgUp - Scroll up one page
PgDn - Scroll down one page

Subscribe to: Posts (Atom)

Wednesday, 20 September 2023

Video Editing AI

Clipchamp: Clipchamp is an online video editor that offers a range of editing tools and templates. It's user-friendly and suitable for basic video editing needs.

Kapwing: Kapwing is a versatile online video editor that allows you to trim, add text, subtitles, and more to your videos. It also provides tools for creating GIFs and collages.

Online Video Cutter: This is a straightforward tool for cutting and trimming videos. It's handy for simple editing tasks like removing unwanted sections from a video.

Biteable: Biteable specializes in creating animated videos and video infographics. It offers a variety of templates and allows you to add text and music to your videos.

WeVideo: WeVideo has both free and paid plans. The free plan includes basic video editing features, cloud storage, and the ability to export videos up to 720p resolution.

HitFilm Express: While it's not entirely online, HitFilm Express is a powerful free video editing software for both Mac and Windows. It offers advanced features for video editing, compositing, and visual effects.

FlexClip: FlexClip is an online video editor with a simple interface. It allows you to trim videos, add text, music, and even stock footage to your projects.

ClipMyVideo: ClipMyVideo offers easy trimming and cutting of videos. It's a quick tool for simple edits.

Lightworks Free: Lightworks is professional-grade video editing software available for Windows, macOS, and Linux. It has a free version with advanced editing features but may have a learning curve.

Friday, 8 September 2023

नेपालको पृष्ठभुमि

मेरो देश नेपाल बारे निबन्ध

कान्छामान ब्लोन

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

Essay 2

मेरो देश को बारेमा निबन्ध 200 शब्दमा

Essay 3

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

Essay 4

मेरो देश को बारेमा निबन्ध 300 शब्दमा

Essay 5

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

राष्ट्रिय गीत "सयौं थुँगा फूलका हामी, एउटै माला नेपाली"

Essay 6

मेरो देश नेपाल

Essa

Saturday, 2 September 2023

50 Excel Shortcuts That You Should Know in 2023

Last updated on Jul 31, 20231996370

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Cell Formatting Shortcut Keys

Row and Column Formatting Shortcut Keys

Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.

What is Microsoft Excel?

excel

Fig: Microsoft Excel Spreadsheet

Need for Excel Shortcuts

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Workbook Shortcut Keys

Description
Excel Shortcuts
1. To create a new workbook
Ctrl + N
2. To open an existing workbook
Ctrl + O
3. To save a workbook/spreadsheet
Ctrl + S
4. To close the current workbook
Ctrl + W
5. To close Excel
Ctrl + F4
6. To move to the next sheet
Ctrl + PageDown
7. To move to the previous sheet
Ctrl + PageUp
8. To go to the Data tab
Alt + A
9. To go to the View tab
Alt + W
10. To go the Formula tab
Alt + M

Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.

Cell Formatting Shortcut Keys

Description
Excel Shortcuts
11. To edit a cell
F2
12. To copy and paste cells
Ctrl + C, Ctrl + V
13. To italicize and make the font bold
Ctrl + I, Ctrl + B
14. To center align cell contents
Alt + H + A + C
15. To fill color
Alt + H + H
16. To add a border
Alt + H + B
17. To remove outline border
Ctrl + Shift + _
18. To add an outline to the select cells
Ctrl + Shift + &
19. To move to the next cell
Tab
20. To move to the previous cell
Shift + Tab
21. To select all the cells on the right
Ctrl + Shift + Right arrow
22. To select all the cells on the left
Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow

In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Description
Excel Shortcuts
26. To add a comment to a cell
Shift + F2
27. To delete a cell comment
Shift + F10 + D
28. To display find and replace
Ctrl + H
29. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
30. To insert the current date
Ctrl + ;
31. To insert current time
Ctrl + Shift + :
32. To insert a hyperlink
Ctrl + k
33. To apply the currency format
Ctrl + Shift + $
34. To apply the percent format
Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box
Alt + Q

After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel.

Row and Column Formatting Shortcut Keys

In this section, we’ll look at some critical row and column formatting shortcuts.

We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.

Description
Excel Shortcuts
36. To select the entire row
Shift + Space
37. To select the entire column
Ctrl + Space
38. To delete a column
Alt+H+D+C
39. To delete a row
Shift + Space, Ctrl + -
40. To hide selected row
Ctrl + 9
41. To unhide selected row
Ctrl + Shift + 9
42. To hide a selected column
Ctrl + 0
43. To unhide a selected column
Ctrl + Shift + 0
44. To group rows or columns
Alt + Shift + Right arrow
45. To ungroup rows or columns
Alt + Shift + Left arrow

Pivot Table Shortcut Keys

First, let’s create a pivot table using a sales dataset.

In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category.

pivot-table

Fig: Pivot table using sales data

46. To group pivot table items
Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

group1

47. To ungroup pivot table items
Alt + Shift + Left arrow
48. To hide pivot table items
Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

row

49. To create a pivot chart on the same sheet
Alt + F1
50. To create a pivot chart on a new worksheet
F11

same-sheet

Fig: Pivot chart on the same sheet

Choose the Right Program

Program Name
Data Analyst Post Graduate Program In Data Analytics
Data Analytics Bootcamp
Geo All Geos All Geos US
University Simplilearn Purdue Caltech
Course Duration 11 Months 8 Months 6 Months
Coding Experience Required No Basic No
Skills You Will Learn 10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional Benefits Applied Learning via Capstone and 20+ industry-relevant Data Analytics projects Purdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost $$ $$$$ $$$$
Explore Program Explore Program Explore Program

Conclusion

To kick-start your fruitful career in Excel, enroll in Post Graduate Program In Data Analytics course today.

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?

Here are some of the most common Excel shortcuts:

Ctrl+C - Copy
Ctrl+V - Paste
Ctrl+Z - Undo
Ctrl+Y - Redo
F2 - Edit cell
Ctrl+A - Select all
Home - Move to the beginning of the worksheet
End - Move to the end of the worksheet
PgUp - Scroll up one page
PgDn - Scroll down one page

Wednesday, 20 September 2023

Video Editing AI

Clipchamp: Clipchamp is an online video editor that offers a range of editing tools and templates. It's user-friendly and suitable for basic video editing needs.

Kapwing: Kapwing is a versatile online video editor that allows you to trim, add text, subtitles, and more to your videos. It also provides tools for creating GIFs and collages.

Online Video Cutter: This is a straightforward tool for cutting and trimming videos. It's handy for simple editing tasks like removing unwanted sections from a video.

Biteable: Biteable specializes in creating animated videos and video infographics. It offers a variety of templates and allows you to add text and music to your videos.

WeVideo: WeVideo has both free and paid plans. The free plan includes basic video editing features, cloud storage, and the ability to export videos up to 720p resolution.

HitFilm Express: While it's not entirely online, HitFilm Express is a powerful free video editing software for both Mac and Windows. It offers advanced features for video editing, compositing, and visual effects.

FlexClip: FlexClip is an online video editor with a simple interface. It allows you to trim videos, add text, music, and even stock footage to your projects.

ClipMyVideo: ClipMyVideo offers easy trimming and cutting of videos. It's a quick tool for simple edits.

Lightworks Free: Lightworks is professional-grade video editing software available for Windows, macOS, and Linux. It has a free version with advanced editing features but may have a learning curve.

Friday, 8 September 2023

नेपालको पृष्ठभुमि

मेरो देश नेपाल बारे निबन्ध

कान्छामान ब्लोन

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

Essay 2

मेरो देश को बारेमा निबन्ध 200 शब्दमा

Essay 3

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

Essay 4

मेरो देश को बारेमा निबन्ध 300 शब्दमा

Essay 5

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

राष्ट्रिय गीत "सयौं थुँगा फूलका हामी, एउटै माला नेपाली"

Essay 6

मेरो देश नेपाल

Essa

Saturday, 2 September 2023

50 Excel Shortcuts That You Should Know in 2023

Last updated on Jul 31, 20231996370

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Cell Formatting Shortcut Keys

Row and Column Formatting Shortcut Keys

Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.

What is Microsoft Excel?

excel

Fig: Microsoft Excel Spreadsheet

Need for Excel Shortcuts

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Workbook Shortcut Keys

Description
Excel Shortcuts
1. To create a new workbook
Ctrl + N
2. To open an existing workbook
Ctrl + O
3. To save a workbook/spreadsheet
Ctrl + S
4. To close the current workbook
Ctrl + W
5. To close Excel
Ctrl + F4
6. To move to the next sheet
Ctrl + PageDown
7. To move to the previous sheet
Ctrl + PageUp
8. To go to the Data tab
Alt + A
9. To go to the View tab
Alt + W
10. To go the Formula tab
Alt + M

Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.

Cell Formatting Shortcut Keys

Description
Excel Shortcuts
11. To edit a cell
F2
12. To copy and paste cells
Ctrl + C, Ctrl + V
13. To italicize and make the font bold
Ctrl + I, Ctrl + B
14. To center align cell contents
Alt + H + A + C
15. To fill color
Alt + H + H
16. To add a border
Alt + H + B
17. To remove outline border
Ctrl + Shift + _
18. To add an outline to the select cells
Ctrl + Shift + &
19. To move to the next cell
Tab
20. To move to the previous cell
Shift + Tab
21. To select all the cells on the right
Ctrl + Shift + Right arrow
22. To select all the cells on the left
Ctrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow

In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy.

Our Data Analyst Master's Program will help you learn analytics tools and techniques to become a Data Analyst expert! It's the pefect course for you to jumpstart your career. Enroll now!

Description
Excel Shortcuts
26. To add a comment to a cell
Shift + F2
27. To delete a cell comment
Shift + F10 + D
28. To display find and replace
Ctrl + H
29. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
30. To insert the current date
Ctrl + ;
31. To insert current time
Ctrl + Shift + :
32. To insert a hyperlink
Ctrl + k
33. To apply the currency format
Ctrl + Shift + $
34. To apply the percent format
Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box
Alt + Q

After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel.

Row and Column Formatting Shortcut Keys

In this section, we’ll look at some critical row and column formatting shortcuts.

We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.

Description
Excel Shortcuts
36. To select the entire row
Shift + Space
37. To select the entire column
Ctrl + Space
38. To delete a column
Alt+H+D+C
39. To delete a row
Shift + Space, Ctrl + -
40. To hide selected row
Ctrl + 9
41. To unhide selected row
Ctrl + Shift + 9
42. To hide a selected column
Ctrl + 0
43. To unhide a selected column
Ctrl + Shift + 0
44. To group rows or columns
Alt + Shift + Right arrow
45. To ungroup rows or columns
Alt + Shift + Left arrow

Pivot Table Shortcut Keys

First, let’s create a pivot table using a sales dataset.

In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category.

pivot-table

Fig: Pivot table using sales data

46. To group pivot table items
Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

group1

47. To ungroup pivot table items
Alt + Shift + Left arrow
48. To hide pivot table items
Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

row

49. To create a pivot chart on the same sheet
Alt + F1
50. To create a pivot chart on a new worksheet
F11

same-sheet

Fig: Pivot chart on the same sheet

Choose the Right Program

Program Name
Data Analyst Post Graduate Program In Data Analytics
Data Analytics Bootcamp
Geo All Geos All Geos US
University Simplilearn Purdue Caltech
Course Duration 11 Months 8 Months 6 Months
Coding Experience Required No Basic No
Skills You Will Learn 10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional Benefits Applied Learning via Capstone and 20+ industry-relevant Data Analytics projects Purdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost $$ $$$$ $$$$
Explore Program Explore Program Explore Program

Conclusion

To kick-start your fruitful career in Excel, enroll in Post Graduate Program In Data Analytics course today.

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?

Here are some of the most common Excel shortcuts:

Ctrl+C - Copy
Ctrl+V - Paste
Ctrl+Z - Undo
Ctrl+Y - Redo
F2 - Edit cell
Ctrl+A - Select all
Home - Move to the beginning of the worksheet
End - Move to the end of the worksheet
PgUp - Scroll up one page
PgDn - Scroll down one page

blon's Associate Pvt.Ltd

I'm के.एम.बि.

Developer and computer operator

Skilss & Info

What Do We Offer

Web Designing

App Development

Web Application

Web Designing

App Development

Web Application

3000

50

324

1234

Our Portfolio.

Popular

Tags

Labels

Popular Posts

Tags 4

Contributors

Tags 3

Wednesday, 20 September 2023

Friday, 8 September 2023

मेरो देश नेपाल बारे निबन्ध

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

मेरो देश को बारेमा निबन्ध 200 शब्दमा

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

मेरो देश को बारेमा निबन्ध 300 शब्दमा

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

मेरो देश नेपाल

Saturday, 2 September 2023

Table of Contents

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Become The Highest-Paid Business Analysis Expert

Cell Formatting Shortcut Keys

Become a Data Scientist With Real-World Experience

Row and Column Formatting Shortcut Keys

Build Your Own Spotify-like Recommendation Engine

Pivot Table Shortcut Keys

Learn The Latest Trends in Data Analytics!

Choose the Right Program

Program Name

Conclusion

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?

categories

Wednesday, 20 September 2023

Friday, 8 September 2023

मेरो देश नेपाल बारे निबन्ध

मेरो देश नेपाल बारे निबन्ध (१५० शब्दहरु )

मेरो देश को बारेमा निबन्ध 200 शब्दमा

मेरो देश नेपाल बारे निबन्ध (२५० शब्दहरु )

मेरो देश को बारेमा निबन्ध 300 शब्दमा

मेरो देश नेपाल बारे निबन्ध ( ५०० शब्दहरु)

मेरो देश नेपाल

Saturday, 2 September 2023

Table of Contents

What is Microsoft Excel?

Need for Excel Shortcuts

Workbook Shortcut Keys

Become The Highest-Paid Business Analysis Expert

Cell Formatting Shortcut Keys

Become a Data Scientist With Real-World Experience

Row and Column Formatting Shortcut Keys

Build Your Own Spotify-like Recommendation Engine

Pivot Table Shortcut Keys

Learn The Latest Trends in Data Analytics!

Choose the Right Program

Program Name

Conclusion

FAQs

1. What are Excel shortcuts?

2. Why are Excel shortcuts important?

3. What are some of the most common Excel shortcuts?